Back

The PATS mappings are split into text and numeric fields.

Text Fields

Text fields are mapped to the i2b2 Observation Fact table like this

i2b2 Field	Source
Encounter_Num	i2b2 Patient ID
Patient_Num	i2b2 PatientID
Concept_Cd	Enum lookup value (see below)
Provider_Id	"@"
Start_Date	The source table observation date field (see below)
Modifier_Cd	"@"
ValType_Cd	"T" (text)
Units_Cd	"@"
Location_Cd	"@"
Update_Date	The current date using the GETDATE() Function
SourceSystem_Cd	"BRICCS"
Upload_Id	"1"

SOMETIME (RB): Convert Update_Date to use a date parameter. It's just a little quicker.

SOMETIME (RB): Should the SourceSystem_Cd not be "PATS"? Or maybe "MINAP" or whatever.

SOMETIME (RB): The Upload_Id is presumably always one because everything is reloaded each time. Might be nice to change this to something more meaningful.

Enum Lookup Value

The Concept Code to use is found in the table DATA_DICTIONARY_ENUM_VALUES in the DWBRICCS database on UHLDWH server. This table contains records for concept code keyed on source table name, column name and column value. NULL column values may be mapped to the field '(empty)'.

ACTION (RB): Check if all possible values of column value contain a mapping in the DATA_DICTIONARY_ENUM_VALUES table.

Source Table Observation Date Field

For each source table in the there is a single field that is used as the start date for all columns from that field. The observation date field to use for each table is stored in the pats_tables table in the DWBRICS on the UHLDWH server.

Numeric Fields

Numeric fields are mapped to the i2b2 Observation Fact table like this

i2b2 Field	Source
Encounter_Num	i2b2 Patient ID
Patient_Num	i2b2 PatientID
Concept_Cd	"PTS:{TABLE_NAME}_{COLUMN_ID}"
Provider_Id	"@"
Start_Date	The source table observation date field (see above)
Modifier_Cd	"@"
ValType_Cd	"N" (numeric)
TVal_Char	"E" (see below)
Units_Cd	Value calculated by ufn_get_units function (see below)
Location_Cd	"@"
Update_Date	The current date using the GETDATE() Function
SourceSystem_Cd	"BRICCS"
Upload_Id	"1"

TVal_Char

The TVal_Char describes the meaning of the value contained in the NVal_Num field.

For all values currently the value of TVal_Char is set to "E", which means equals. That is, the value in the NVal_Num field is the result of the test. All possible values of TVal_Char are:

Value	Meaning
E	Equals
NE	Not Equal
L	Less Than
LE	Less Than or Equals
G	Greater Than
GE	Greater Than or Equals

From a casual look at the data, I think that a value of less than X, or greater than Y is sometimes used for Pathology data.

ufn_get_units Function

The function ufn_get_units in the DWBRICCS database is called with parameters of table_name and field_name to determine the units.

ACTION (RB): Work out what this function actually does and then move the logic into a join if possible. This should be clearer and also quicker.

Tables

CATH_CATHINITIALVW

Field Name	Column ID	Type	Comments
EntryId	1	int
PatientId	2	int
DateofCatheter	3	date
TimeofCatheter	4	time
EntryStatus	5	varchar
PreviousEntry	6	int
NextEntry	7	int
DateOfAdmission	8	date
AgeAtCatheter	9	int
DoneInMobileLab	10	varchar
Consultant	11	varchar
Operator	12	varchar
SecondOperator	13	varchar
Technician	14	varchar
PatientType	15	varchar
WasThePatientCatheterised	16	varchar
ProcedureType	17	varchar
GeneralAnaesthetics	18	varchar
ProcedureSite	19	varchar
BiopsyTaken	20	varchar
BiopsySite	21	varchar
OtherProcedure	22	varchar
Arterial_1	23	varchar
Vessel_1_Arterial	24	varchar
Complicated_1_Arterial	25	varchar
Arterial_2	26	varchar
Vessel_2_Arterial	27	varchar
Complicated2Arterial	28	varchar
Arterial_3	29	varchar
Vessel_3_Arterial	30	varchar
Complicated_3_Arterial	31	varchar
Venous_1	32	varchar
Vessel_1_Venous	33	varchar
Complicated_1_Venous	34	varchar
Venous_2	35	varchar
Vessel_2_Venous	36	varchar
Complicated_2_Venous	37	varchar
Venous_3	38	varchar
Vessel_3_Venous	39	varchar
Complicated_3_Venous	40	varchar
Vessels	41	varchar
ReturnedTo	42	varchar
FurtherProcedure	43	varchar
ImmediateComplications	44	varchar
ProcedureAbandoned	45	varchar
ReasonForAbandoningProcedure	46	varchar
OtherComplications	47	varchar
DiedInCathLab	48	varchar
CoronaryDisease	49	varchar
SignificantValveDisease	50	varchar
SignificantLvDisease	51	varchar
Outcome	52	varchar
ReturnToCathLab	53	varchar
EmbolicSequelae	54	varchar
NonEmergencySurgery	55	varchar
GroinComplication	56	varchar
Death	57	varchar
DischargeComplications	58	varchar
OutcomeOfCatheter	59	varchar
DateOfDischarge	60	date
DateOfDeath	61	date
DischargeTo	62	varchar
PreopStay_days	63	int
PostOpStay_days	64	int
TotalHospitalStay	65	int
IhdScore_cardwl	66	int
NihdScore_cardwl	67	int
OtherComplicationsPreDischarge	68	varchar
DateOfDeathPostDischarge	69	date
PostProcedureDeathInterval_days	70	int
FormsVerified	71	varchar
Contract	72	varchar
Pcg	73	varchar
AuditLoopClosed	74	varchar
DateAuditLoopClosed	75	date
ReasonAuditLoopClosed	76	varchar
IntervalBetweenProc_LoopClosed_days	77	int
DateOnWaitingList	78	date
DaysOnList	79	int
GpPracticeCode	80	varchar
Pct	81	varchar
MedicalRecordNumber	82	varchar
AdministrativeCategory	83	varchar
AuditTrail	84	text
DateAndTimeOfProcedure	85	varchar
IsThisAcs	86	varchar
Sub_Xiphoid	87	varchar
PreDischargeComplications	88	varchar
IfOtherPreDischargeComplicationsPleaseState	89	varchar
Height	90	float
Weight	91	float
Bmi	92	float
ScreeningTime	93	float
ScreeningDose	94	float
ExceededDrl	95	varchar
Radiographer	96	varchar
ReasonForExceedingDrl	97	varchar
CatheterProcedureReport	98	varchar
ConsultantCode	99	varchar
OperatorCode	100	varchar
SecondOperatorCode	101	varchar
TroponinPositive	102	varchar
DateOfCurrentStatus	103	date
DateOfEndStatus	104	date
DateTimeRecordCreated	105	varchar
DateTimeRecordLastChanged	106	varchar
EnteredByTag	107	varchar
EntryCurrentStatus	108	varchar
EntryEndStatus	109	varchar
HospitalTag	110	varchar
ImportLinkId	111	int

CS2003F_PostProcedure

Field Name	Column ID	Type	Comments
EntryId	1	int
PatientId	2	int
Pre_OperativeStayInDays	3	int
Post_OperativeStayInDays	4	int
TotalStayInDays	5	int
ParsonnetScoreFromHardData	6	int
CardiopulmonaryBypass	7	varchar
ParsonnetScoreWithCatastrophicStatesAndRareConditi	8	int
PredominantMyocardialProtection	9	varchar
Parsonnet_AdditionsForCatastrophicStates	10	int
Parsonnet_AdditionsForRareConditions	11	int
Euroscore	12	int
Cs1999ComplexCabgBayesScore	13	float
LogisticEuroscore	14	float
Cardioplegia_Solution	15	varchar
Cardioplegia_Temperature	16	varchar
Cardioplegia_Timing	17	varchar
Non_CardioplegiaMyocardialProtection	18	varchar
Intra_AorticBalloonPumpUsed	19	varchar
ReaonForIabpUse	20	varchar
HeightInCm	21	int
WeightInKg	22	float
CumulativeBypassTimeInMin	23	int
CumulativeCrossClampTimeInMin	24	int
TotalCirculatoryArrestTimeInMin	25	int
Re_Operation	26	varchar
NewPost_OperativeStroke	27	varchar
NewHaemofiltration_DialysisPost_Operatively	28	varchar
DischargeDestination_FromCardiothoracicWard	29	varchar
DateOfDischargeOrDeath	30	datetime
BodySurfaceArea	31	float
BodyMassIndex	32	float
Cardioplegia_Infusion	33	varchar
EuroscoreMinumumDatasetCheck	34	varchar
ParsonnetMinumumDatasetCheck	35	varchar
NameOfGpAtTimeOfSurgery	36	varchar
GpPracticeCodeAtTimeOfSurgery	37	varchar
PctAtTimeOfSurgery	38	varchar
NameOfReferringGpAtTimeOfSurgeryType8	39	varchar
ToePerformed	40	varchar
Sonographer	41	varchar
Sonographist	42	varchar
PrimaryPerfusionist	43	varchar
PcuPatient_pcu	44	varchar
DoesPatientMeetInterOperativeCriteria_pcu	45	varchar
AreaPatientAdmittedTo_pcu	46	varchar
AdmissionTimeToRecovery_cicu_pcu	47	varchar
ExtubationDateAndTime_pcu	48	varchar
WhatO2SystemWasUsed_pcu	49	varchar
TotalBloodLostOnDischargeFromRecovery_pcu	50	varchar
WereClottingProductsUsed_pcu	51	varchar
WhatProductsWereUsed_pcu	52	varchar
HowMuchColloidUsedInRecovery_pcu	53	varchar
TypeOfColloidUsed_pcu	54	varchar
PainScoreOnWaking_pcu	55	varchar
AnalgesiaUsedPcu	56	varchar
TotalMorphineDoseUsedIncludingBolus_pcu	57	varchar
InotropesUsed_pcu	58	varchar
Dosage_pcu	59	varchar
WereThereAnyArrhythmias_pcu	60	varchar
PleaseStateArrhythmias_pcu	61	varchar
TreatmentOfArrhythmias_pcu	62	varchar
PotassiumUsed_pcu	63	varchar
PotassiumDoseInMmols_pcu	64	varchar
TemperatureOnAdmission_pcu	65	float
BairhuggerWithPatient_pcu	66	varchar
TimeOfDischarge_pcu	67	varchar
PlaceOfDischarge_pcu	68	varchar
DoesPatientMeetDischargeCriteria_pcu	69	varchar
WasPatientDischargedFromPcuToHdu_pcu	70	varchar
LowUrineOutput_pcu	71	varchar
IfNoStateWhy_pcu	72	varchar
IfNoWhy_pcu	73	varchar
AmountOfTimeIntubated_pcu	74	float
AmountOfTimeInRecovery_cicu_pcu	75	float
OverallComments_sa	76	varchar
TeachingOfOtherStaffComments_sa	77	varchar
TeachingOfOtherStaffCommentsMade_sa	78	varchar
TeachingOfOtherStaffBySa_sa	79	varchar
IabpRemovalComments_sa	80	varchar
IabpRemovalCommentsMade_sa	81	varchar
IabpRemovalBySa_sa	82	varchar
IabpInsertionComments_sa	83	varchar
IabpInsertionCommentsMade_sa	84	varchar
IabpInsertionBySa_sa	85	varchar
SternotomyClosureComments_sa	86	varchar
SternotomyClosureCommentsMade_sa	87	varchar
SternotomyClosureBySa_sa	88	varchar
SternotomyComments_sa	89	varchar
SternotomyCommentsMade_sa	90	varchar
SternotomyPerformedBySa_sa	91	varchar
ThirdSiteComments_sa	92	varchar
ThirdSiteCommentsMade_sa	93	varchar
ThirdSiteConduit_location_sa	94	varchar
SecondSiteComments_sa	95	varchar
SecondSiteCommentsMade_sa	96	varchar
SecondSiteConduit_location_sa	97	varchar
FirstSiteComments_sa	98	varchar
FirstSiteCommentsMade_sa	99	varchar
FirstSiteConduei_location_sa	100	varchar
ThirdAssistant_sa	101	varchar
SecondAssistant_sa	102	varchar
FirstAssistant_sa	103	varchar
SurgicalAssistant_sa	104	varchar
ReferralToOperation_days	105	float
Arrhythmia_S	106	varchar
LowCardiacOutput	107	varchar
Ventilation	108	varchar
PulmonaryComplications	109	varchar
RenalComplications	110	varchar
GastrointestinalComplications	111	varchar
InfectiveComplications	112	varchar
CauseOfDeath	113	varchar
AdmittedFrom_hospitalNameOrWard	114	varchar
AdmittedToCardiacSurgery	115	datetime
DischargedFromCardiacSurgery	116	datetime
TotalCardiacSurgeryLosDays	117	float
DateOfFollowUp	118	datetime
BloodUsed	119	varchar
MutisystemFailure	120	varchar
DateFirstAdmittedToCicu	121	datetime
DateFirstDischargedFromCicu	122	datetime
TotalFirstStayOnCicu	123	float
ReAdmittedToCicu	124	varchar
DateOfSecondAdmissionToCicu	125	datetime
DateOfSecondDischargeFromCicu	126	datetime
SecondAdmissionTotalStay_nignts	127	float
DateOfThirdAdmissionToCicu	128	datetime
DateOfThirdDischargeFromCicu	129	datetime
ThirdAdmissionToCicuTotalStay_nights	130	float
InsertionOfPacemakerWiresViaVatsProcedure	131	varchar
IntubationTimeInHours	132	int
AuditTrail	133	varchar
NameOfDoctorCompletingBooklet	134	varchar
SecondPrimaryPerfusionist	135	varchar
SecondBypass	136	varchar
SecondMyocardialProtection	137	varchar
SecondCardioplegiaSolution	138	varchar
SecondCardioplegiaInfusion	139	varchar
SecondCardioplegiaTemperature	140	varchar
SecondCardioplegiaTiming	141	varchar
SecondNon_CardioplegiaMyocardialProtection	142	varchar
DoesPatientNeedAFollowUpAppiontment	143	varchar
Comments	144	varchar
MedicalRecordNumber	145	varchar
DateAddedToW_l	146	datetime
AddedToW_l	147	varchar
DateOfFourthAdmissionToCicu	148	datetime
DateOfFourthDischargeFromCicu	149	datetime
DateOfFifthAdmissionToCicu	150	datetime
DateOfFifthDischargeFromCicu	151	datetime
CumulativeStayFirstAndSecondAdmissionToCicu	152	float
Cumulative1st2ndAnd3rdStayInCicu	153	float
FourthAdmissionToCicuTotalStay_nights	154	float
Cumulative1st2nd3rd4thStayInCicu	155	float
FifthAdmissionToCicuTotalStay_nights	156	float
Cumulative1sr2nd3rd4th5thStayInCicu	157	float
PatientIdentifiedForSamedayAdmission	158	varchar
ProposedDateOfAdmission	159	datetime
IfNotOperatedOnSamedayGiveReason	160	varchar
SecondBypassTotal	161	int
SecondCrossClampTotal	162	int
SecondCiculatoryArrestTotal	163	int
CouncilCase	164	varchar
InitialConsultantInJointCase	165	varchar
ArrhythmiaOtherComplicationFreeText	166	varchar
LowCardiacOutputOtherComplicationFreeText	167	varchar
PulmonaryOtherComplicationFreeText	168	varchar
RenalOtherComplicationFreeText	169	varchar
GastrointestinalOtherComplicationFreeText	170	varchar
InfectiveOtherComplicationFreeText	171	varchar
SickNoteOffered	172	varchar
IfSickNoteOfferedDurationInDays	173	int
AdviceToGpAndAnyMedicationChangedOrStopped	174	varchar
NameOfDischargingDoctor	175	varchar
GradeOfDischargingDoctor	176	varchar
PagerNumber	177	varchar
DrugSensitivity	178	varchar
Drug1	179	varchar
DrugRoute1	180	varchar
NumberOfDays1	181	int
Continue1	182	varchar
Drug2	183	varchar
DrugRoute2	184	varchar
NumberOfDays2	185	int
Continue2	186	varchar
Drug3	187	varchar
DrugRoute3	188	varchar
NumberOfDays3	189	int
Continue3	190	varchar
Drug4	191	varchar
DrugRoute4	192	varchar
NumberOfDays4	193	int
Continue4	194	varchar
Drug5	195	varchar
DrugRoute5	196	varchar
NumberOfDays5	197	int
Continue5	198	varchar
Drug6	199	varchar
DrugRoute6	200	varchar
NumberOfDays6	201	int
Continue6	202	varchar
Drug7	203	varchar
DrugRoute7	204	varchar
NumberOfDays7	205	int
Continue7	206	varchar
Drug8	207	varchar
DrugRoute8	208	varchar
NumberOfDays8	209	int
Continue8	210	varchar
Drug9	211	varchar
DrugRoute9	212	varchar
NumberOfDays9	213	int
Continue9	214	varchar
Drug10	215	varchar
DrugRoute10	216	varchar
NumberOfDays10	217	int
Continue10	218	varchar
Drug11	219	varchar
DrugRoute11	220	varchar
NumberOfDays11	221	int
Continue11	222	varchar
Drug12	223	varchar
DrugRoute12	224	varchar
NumberOfDays12	225	int
Continue12	226	varchar
Drug13	227	varchar
DrugRoute13	228	varchar
NumberOfDays13	229	int
Continue13	230	varchar
Drug14	231	varchar
DrugRoute14	232	varchar
NumberOfDays14	233	int
Continue14	234	varchar
Drug15	235	varchar
DrugRoute15	236	varchar
NumberOfDays15	237	int
Continue15	238	varchar
Drug16	239	varchar
DrugRoute16	240	varchar
NumberOfDays16	241	int
Continue16	242	varchar
Drug17	243	varchar
DrugRoute17	244	varchar
NumberOfDays17	245	int
Continue17	246	varchar
Drug18	247	varchar
DrugRoute18	248	varchar
NumberOfDays18	249	int
Continue18	250	varchar
DrugNameAndStrength19	251	varchar
DrugForm19	252	varchar
DrugDose19	253	varchar
DrugRoute19	254	varchar
DrugFrequency19	255	varchar
NumberOfDays19	256	int
Continue19	257	varchar
DrugNameAndStrength20	258	varchar
DrugForm20	259	varchar
DrugDose20	260	varchar
DrugRoute20	261	varchar
DrugFrequency20	262	varchar
NumberOfDays20	263	int
Continue20	264	varchar
DrugNameAndStrength21	265	varchar
DrugForm21	266	varchar
DrugDose21	267	varchar
DrugRoute21	268	varchar
DrugFrequency21	269	varchar
NumberOfDays21	270	int
Continue21	271	varchar
DrugNameAndStrength22	272	varchar
DrugForm22	273	varchar
DrugDose22	274	varchar
DrugRoute22	275	varchar
DrugFrequency22	276	varchar
NumberOfDays22	277	int
Continue22	278	varchar
DrugNameAndStrength23	279	varchar
DrugForm23	280	varchar
DrugDose23	281	varchar
DrugRoute23	282	varchar
DrugFrequency23	283	varchar
NumberOfDays23	284	int
Continue23	285	varchar
DrugNameAndStrength24	286	varchar
DrugForm24	287	varchar
DrugDose24	288	varchar
DrugRoute24	289	varchar
DrugFrequency24	290	varchar
NumberOfDays24	291	int
Continue24	292	varchar
DischargeWard	293	varchar
Pharmacist	294	varchar
ManagementPlan	295	varchar
FollowUpRequired	296	varchar
FollowUpTimeInWeeks_months	297	varchar
MedicationChangedByPharmacist	298	varchar
StatePharmacistChanges	299	varchar
InformationGivenToPatient	300	varchar
DateTimeRecordCreated	301	datetime
DateTimeRecordLastChanged	302	datetime
EnteredByTag	303	varchar
HospitalTag	304	varchar
WHO_REGISTRY_INDICATOR	305	varchar
WHO_POSSIBLE_DUPLICATE	306	char

CS2003F_PreProcedure

Field Name	Column ID	Type	Comments
EntryId	1	int
PatientId	2	int
DateOfOperation_ccad	3	datetime
TimeOfOperation_ccad	4	datetime
EntryStatus	5	varchar
PreviousEntry	6	int
NextEntry	7	int
AgeAtSurgery	8	int
Gender	9	varchar
DateOfAdmission	10	datetime
AnginaStatusPre_Surgery	11	varchar
DyspnoeaStatusPre_Surgery	12	varchar
NumberOfPreviousMis	13	varchar
IntervalBetweenOperationAndLastMi	14	varchar
PreviousPci	15	varchar
DateOfLastPci	16	datetime
PreviousCardiac_VascularOrThoracicSurgicalInterven	17	varchar
DateOfLastCardiacOperation	18	datetime
DiabetesManagement	19	varchar
Hypertension	20	varchar
CigaretteSmokingHistory	21	varchar
RenalDiseaseAtTheTimeOfSurgery	22	varchar
HistoryOfPulmonaryDisease	23	varchar
HistoryOfNeurologicalDisease	24	varchar
Pre_OperativeHeartRhythm	25	varchar
DateOfCatheterisation	26	datetime
PaSystolic_ifKnown	27	int
AvGradient_ifKnown	28	int
Lvedp_ifKnown	29	int
MeanPawp_la_ifKnown	30	int
IvNitrates_HeparinOfAnyKind	31	varchar
IvInotropesPriorToAnaesthesia	32	varchar
Ventilated	33	varchar
CardiogenicShock	34	varchar
OperativePriority	35	varchar
FirstOperatorGrade	36	varchar
FirstOperator_CalmanYearOfTrainee	37	varchar
CardiacProcedures	38	varchar
NumberOfDistalCoronaryAnastomoses	39	int
NumberOfValvesReplaced_Repaired	40	int
NumberOfSegmentsOfTheAorta	41	int
OtherCardiacProcedures	42	varchar
OtherThoracicAndVascularProcedures	43	varchar
NeurologicalDysfunction_euroscore	44	varchar
LeftMainStemDisease	45	varchar
ExtentOfCoronaryArteryDisease	46	varchar
ExtracardiacArteriopathy	47	varchar
EjectionFractionCategory	48	varchar
AdmissionCategory	49	varchar
CarotidBruits	50	varchar
LeftOrRightHeartCatheterisation	51	varchar
EjectionFractionValue_ifKnown	52	int
DateAndTimeOfOperation	53	varchar
NumberOfPreviousHeartOperations	54	int
ResponsibleConsultantSurgeon	55	varchar
FirstOperator	56	varchar
FirstAssistant	57	varchar
FirstAssistantGrade	58	varchar
FirstAssistant_CalmanYearOfTrainee	59	varchar
ResponsibleConsultantAnaesthetist	60	varchar
OperationFindings	61	varchar
ReferringCardiologist	62	varchar
DateOfReferral	63	datetime
DrugsOnAdmission	64	varchar
Allergies	65	varchar
AllOtherAssistants	66	varchar
WaitingListStatusUpdated	67	varchar
SprCases	68	varchar
DateOfCurrentStatus	69	datetime
DateOfEndStatus	70	datetime
DateTimeRecordCreated	71	datetime
DateTimeRecordLastChanged	72	datetime
EnteredByTag	73	varchar
EntryCurrentStatus	74	varchar
EntryEndStatus	75	varchar
HospitalTag	76	varchar
WHO_RESPONSIBLE_CONSULTANT_SURGEON	77	varchar
WHO_AGE_AT_OPERATION	78	int
WHO_REGISTRY_INDICATOR	79	varchar
WHO_POSSIBLE_DUPLICATE	80	char

CS2010F_PostProcedure

Field Name	Column ID	Type	Comments
EntryId	1	int
PatientId	2	int
PreOperativeStayInDays	3	int
PostOperativeStayInDays	4	int
TotalStayInDays	5	int
ParsonnetScoreFromHardData	6	int
CardiopulmonaryBypass	7	varchar
ParsonnetScoreWithCatastrophicStatesAndRareConditi	8	int
PredominantMethodOfMyocardialProtection	9	varchar
Parsonnet_AdditionsForCatastrophicStates	10	int
Parsonnet_AdditionsForRareConditions	11	int
AdditiveEuroscore	12	int
SctsComplexCabgBayesScore	13	float
LogisticEuroscore	14	float
Cardioplegia_Solution	15	varchar
Cardioplegia_Temperature	16	varchar
Cardioplegia_Timing	17	varchar
Non_CardioplegicMyocardialProtection	18	varchar
IntraAorticBalloonPumpUsed	19	varchar
ReasonForIntra_OperativeIntra_AorticBalloonPumpUse	20	varchar
HeightInCm	21	int
WeightInKg	22	float
CumulativeBypassTime	23	int
CumulativeCrossClampTime	24	int
TotalCirculatoryArrestTime	25	int
NewPost_OperativeNeurologicalDysfunction	26	varchar
NewHaemofiltrationOrDialysis	27	varchar
DischargeDestinationFromCardiothoracicWard	28	varchar
DateOfDischargeOrDeath	29	date
BodySurfaceArea	30	float
BodyMassIndex	31	float
Cardioplegia_InfusionMode	32	varchar
EuroscoreMinumumDatasetCheck	33	varchar
ParsonnetMinumumDatasetCheck	34	varchar
NameOfGpAtTimeOfSurgery	35	varchar
GpPracticeCodeAtTimeOfSurgery	36	varchar
PctAtTimeOfSurgery	37	varchar
NameOfReferringGpAtTimeOfSurgeryType8	38	varchar
ToePerformed	39	varchar
Sonographer	40	varchar
Sonographist	41	varchar
PrimaryPerfusionist	42	varchar
PcuPatient_pcu	43	varchar
DoesPatientMeetInterOperativeCriteria_pcu	44	varchar
AreaPatientAdmittedTo_pcu	45	varchar
AdmissionTimeToRecovery_cicu_pcu	46	varchar
ExtubationDateAndTime_pcu	47	varchar
WhatO2SystemWasUsed_pcu	48	varchar
TotalBloodLostOnDischargeFromRecovery_pcu	49	varchar
WereClottingProductsUsed_pcu	50	varchar
WhatProductsWereUsed_pcu	51	varchar
HowMuchColloidUsedInRecovery_pcu	52	varchar
TypeOfColloidUsed_pcu	53	varchar
PainScoreOnWaking_pcu	54	varchar
AnalgesiaUsedPcu	55	varchar
TotalMorphineDoseUsedIncludingBolus_pcu	56	varchar
InotropesUsed_pcu	57	varchar
Dosage_pcu	58	varchar
WereThereAnyArrhythmias_pcu	59	varchar
PleaseStateArrhythmias_pcu	60	varchar
TreatmentOfArrhythmias_pcu	61	varchar
PotassiumUsed_pcu	62	varchar
PotassiumDoseInMmols_pcu	63	varchar
TemperatureOnAdmission_pcu	64	float
BairhuggerWithPatient_pcu	65	varchar
TimeOfDischarge_pcu	66	varchar
PlaceOfDischarge_pcu	67	varchar
DoesPatientMeetDischargeCriteria_pcu	68	varchar
WasPatientDischargedFromPcuToHdu_pcu	69	varchar
LowUrineOutput_pcu	70	varchar
IfNoStateWhy_pcu	71	varchar
IfNoWhy_pcu	72	varchar
AmountOfTimeIntubated_pcu	73	float
AmountOfTimeInRecovery_cicu_pcu	74	float
OverallComments_sa	75	text
TeachingOfOtherStaffComments_sa	76	varchar
TeachingOfOtherStaffCommentsMade_sa	77	varchar
TeachingOfOtherStaffBySa_sa	78	varchar
IabpRemovalComments_sa	79	text
IabpRemovalCommentsMade_sa	80	varchar
IabpRemovalBySa_sa	81	varchar
IabpInsertionComments_sa	82	text
IabpInsertionCommentsMade_sa	83	varchar
IabpInsertionBySa_sa	84	varchar
SternotomyClosureComments_sa	85	text
SternotomyClosureCommentsMade_sa	86	varchar
SternotomyClosureBySa_sa	87	varchar
SternotomyComments_sa	88	varchar
SternotomyCommentsMade_sa	89	varchar
SternotomyPerformedBySa_sa	90	varchar
ThirdSiteComments_sa	91	varchar
ThirdSiteCommentsMade_sa	92	varchar
ThirdSiteConduit_location_sa	93	varchar
SecondSiteComments_sa	94	varchar
SecondSiteCommentsMade_sa	95	varchar
SecondSiteConduit_location_sa	96	varchar
FirstSiteComments_sa	97	varchar
FirstSiteCommentsMade_sa	98	varchar
FirstSiteConduei_location_sa	99	varchar
ThirdAssistant_sa	100	varchar
SecondAssistant_sa	101	varchar
FirstAssistant_sa	102	varchar
SurgicalAssistant_sa	103	varchar
ReferralToOperation_days	104	float
Arrhythmia_S	105	varchar
LowCardiacOutput	106	varchar
Ventilation	107	varchar
PulmonaryComplications	108	varchar
RenalComplications	109	varchar
GastrointestinalComplications	110	varchar
InfectiveComplications	111	varchar
CauseOfDeath	112	varchar
AdmittedFrom_hospitalNameOrWard	113	varchar
AdmittedToCardiacSurgery	114	date
DischargedFromCardiacSurgery	115	date
TotalCardiacSurgeryLosDays	116	float
DateOfFollowUp	117	date
BloodUsed	118	varchar
MutisystemFailure	119	varchar
DateFirstAdmittedToCicu	120	date
DateFirstDischargedFromCicu	121	date
TotalFirstStayOnCicu	122	float
ReAdmittedToCicu	123	varchar
DateOfSecondAdmissionToCicu	124	date
DateOfSecondDischargeFromCicu	125	date
SecondAdmissionTotalStay_nignts	126	float
DateOfThirdAdmissionToCicu	127	date
DateOfThirdDischargeFromCicu	128	date
ThirdAdmissionToCicuTotalStay_nights	129	float
InsertionOfPacemakerWiresViaVatsProcedure	130	varchar
IntubationTimeInHours	131	int
AuditTrail	132	text
NameOfDoctorCompletingBooklet	133	varchar
SecondPrimaryPerfusionist	134	varchar
SecondBypass	135	varchar
SecondMyocardialProtection	136	varchar
SecondCardioplegiaSolution	137	varchar
SecondCardioplegiaInfusion	138	varchar
SecondCardioplegiaTemperature	139	varchar
SecondCardioplegiaTiming	140	varchar
SecondNon_CardioplegiaMyocardialProtection	141	varchar
DoesPatientNeedAFollowUpAppiontment	142	varchar
Comments	143	varchar
MedicalRecordNumber	144	varchar
DateAddedToW_l	145	date
AddedToW_l	146	varchar
DateOfFourthAdmissionToCicu	147	date
DateOfFourthDischargeFromCicu	148	date
DateOfFifthAdmissionToCicu	149	date
DateOfFifthDischargeFromCicu	150	date
CumulativeStayFirstAndSecondAdmissionToCicu	151	float
Cumulative1st2ndAnd3rdStayInCicu	152	float
FourthAdmissionToCicuTotalStay_nights	153	float
Cumulative1st2nd3rd4thStayInCicu	154	float
FifthAdmissionToCicuTotalStay_nights	155	float
Cumulative1sr2nd3rd4th5thStayInCicu	156	float
PatientIdentifiedForSamedayAdmission	157	varchar
ProposedDateOfAdmission	158	date
SecondBypassTotal	159	int
SecondCrossClampTotal	160	int
SecondCiculatoryArrestTotal	161	int
CouncilCase	162	varchar
InitialConsultantInJointCase	163	varchar
ArrhythmiaOtherComplicationFreeText	164	text
LowCardiacOutputOtherComplicationFreeText	165	text
PulmonaryOtherComplicationFreeText	166	text
RenalOtherComplicationFreeText	167	text
GastrointestinalOtherComplicationFreeText	168	text
InfectiveOtherComplicationFreeText	169	varchar
SickNoteOffered	170	varchar
IfSickNoteOfferedDurationInDays	171	int
AdviceToGp	172	varchar
NameOfDischargingDoctor	173	varchar
GradeOfDischargingDoctor	174	varchar
PagerNumber	175	varchar
DrugSensitivity	176	varchar
Drug1	177	varchar
DrugRoute1	178	varchar
NumberOfDays1	179	int
Continue1	180	varchar
Drug2	181	varchar
DrugRoute2	182	varchar
NumberOfDays2	183	int
Continue2	184	varchar
Drug3	185	varchar
DrugRoute3	186	varchar
NumberOfDays3	187	int
Continue3	188	varchar
Drug4	189	varchar
DrugRoute4	190	varchar
NumberOfDays4	191	int
Continue4	192	varchar
Drug5	193	varchar
DrugRoute5	194	varchar
NumberOfDays5	195	int
Continue5	196	varchar
Drug6	197	varchar
DrugRoute6	198	varchar
NumberOfDays6	199	int
Continue6	200	varchar
Drug7	201	varchar
DrugRoute7	202	varchar
NumberOfDays7	203	int
Continue7	204	varchar
Drug8	205	varchar
DrugRoute8	206	varchar
NumberOfDays8	207	int
Continue8	208	varchar
Drug9	209	varchar
DrugRoute9	210	varchar
NumberOfDays9	211	int
Continue9	212	varchar
Drug10	213	varchar
DrugRoute10	214	varchar
NumberOfDays10	215	int
Continue10	216	varchar
Drug11	217	varchar
DrugRoute11	218	varchar
NumberOfDays11	219	int
Continue11	220	varchar
Drug12	221	varchar
DrugRoute12	222	varchar
NumberOfDays12	223	int
Continue12	224	varchar
Drug13	225	varchar
DrugRoute13	226	varchar
NumberOfDays13	227	int
Continue13	228	varchar
Drug14	229	varchar
DrugRoute14	230	varchar
NumberOfDays14	231	int
Continue14	232	varchar
Drug15	233	varchar
DrugRoute15	234	varchar
NumberOfDays15	235	int
Continue15	236	varchar
Drug16	237	varchar
DrugRoute16	238	varchar
NumberOfDays16	239	int
Continue16	240	varchar
Drug17	241	varchar
DrugRoute17	242	varchar
NumberOfDays17	243	int
Continue17	244	varchar
Drug18	245	varchar
DrugRoute18	246	varchar
NumberOfDays18	247	int
Continue18	248	varchar
DrugNameAndStrength19	249	varchar
DrugForm19	250	varchar
DrugDose19	251	varchar
DrugRoute19	252	varchar
DrugFrequency19	253	varchar
NumberOfDays19	254	int
Continue19	255	varchar
DrugNameAndStrength20	256	varchar
DrugForm20	257	varchar
DrugDose20	258	varchar
DrugRoute20	259	varchar
DrugFrequency20	260	varchar
NumberOfDays20	261	int
Continue20	262	varchar
DrugNameAndStrength21	263	varchar
DrugForm21	264	varchar
DrugDose21	265	varchar
DrugRoute21	266	varchar
DrugFrequency21	267	varchar
NumberOfDays21	268	int
Continue21	269	varchar
DrugNameAndStrength22	270	varchar
DrugForm22	271	varchar
DrugDose22	272	varchar
DrugRoute22	273	varchar
DrugFrequency22	274	varchar
NumberOfDays22	275	int
Continue22	276	varchar
DrugNameAndStrength23	277	varchar
DrugForm23	278	varchar
DrugDose23	279	varchar
DrugRoute23	280	varchar
DrugFrequency23	281	varchar
NumberOfDays23	282	int
Continue23	283	varchar
DrugNameAndStrength24	284	varchar
DrugForm24	285	varchar
DrugDose24	286	varchar
DrugRoute24	287	varchar
DrugFrequency24	288	varchar
NumberOfDays24	289	int
Continue24	290	varchar
DischargeWard	291	varchar
Pharmacist	292	varchar
ManagementPlan	293	varchar
FollowUpRequired	294	varchar
FollowUpTimeInWeeks_months	295	varchar
MedicationChangedByPharmacist	296	varchar
StatePharmacistChanges	297	text
InformationGivenToPatient	298	varchar
DateTimeRecordCreated	299	varchar
DateTimeRecordLastChanged	300	varchar
EnteredByTag	301	varchar
HospitalTag	302	varchar

CS2010F_PreProcedure

Field Name	Column ID	Type	Comments
EntryId	1	int
PatientId	2	int
DateOfOperation	3	date
TimeOfEntry	4	time
EntryStatus	5	varchar
PreviousEntry	6	int
NextEntry	7	int
AgeAtOperation	8	int
Gender	9	varchar
DateOfAdmission	10	date
AnginaStatusPre_Surgery	11	varchar
DyspnoeaStatusPre_Surgery	12	varchar
NumberOfPreviousMis	13	varchar
IntervalBetweenSurgeryAndLastMi	14	varchar
PreviousPci	15	varchar
PreviousCardiacSurgery	16	varchar
DateOfLastCardiacOperation	17	date
DiabetesManagement	18	varchar
HistoryOfHypertension	19	varchar
CigaretteSmokingHistory	20	varchar
HistoryOfPulmonaryDisease	21	varchar
HistoryOfNeurologicalDisease	22	varchar
Pre_OperativeHeartRhythm	23	varchar
DateOfLastCatheterisation	24	date
PaSystolic	25	int
IntravenousNitratesOrAnyHeparin	26	varchar
IntravenousInotropesPriorToAnaesthesia	27	varchar
VentilatedPreOperation	28	varchar
CardiogenicShock_pre_Operation	29	varchar
OperativeUrgency	30	varchar
FirstOperatorGrade	31	varchar
FirstOperator_CalmanYearOfTrainee	32	varchar
CardiacProcedures	33	varchar
OtherCardiacProcedures	34	varchar
OtherThoracicAndVascularProcedures	35	varchar
LeftMainStemDisease	36	varchar
ExtentOfCoronaryVesselDisease	37	varchar
ExtracardiacArteriopathy	38	varchar
EjectionFractionCategory	39	varchar
AdministrativeCategory	40	varchar
DateAndTimeOfOperation	41	varchar
NumberOfPreviousHeartOperations	42	int
ResponsibleConsultantSurgeon	43	varchar
FirstOperator	44	varchar
FirstAssistant	45	varchar
FirstAssistantGrade	46	varchar
FirstAssistant_CalmanYearOfTrainee	47	varchar
ResponsibleConsultantAnaesthetist	48	varchar
OperationFindings	49	varchar
ReferringCardiologist	50	varchar
DateOfReferral	51	date
DrugsOnAdmission	52	varchar
Allergies	53	varchar
AllOtherAssistants	54	varchar
WaitingListStatusUpdated	55	varchar
SprCases	56	varchar
DateOfCurrentStatus	57	date
DateOfEndStatus	58	date
DateTimeRecordCreated	59	varchar
DateTimeRecordLastChanged	60	varchar
EnteredByTag	61	varchar
EntryCurrentStatus	62	varchar
EntryEndStatus	63	varchar
HospitalTag	64	varchar

EPS_EPSINIVW

GGHMINAP_GGHMINAP

GGHMINAPNEW

GGHMINAPNEW_GGHMINAPINIVW

GGHPACEICD_GGHPACEICDINIALVW

GGHPCI_FLWGGHPCIVIEW

GGHPCI_INITIALGGHPCIVIEW

LRIMINAPNEW

LRIMINAPNEW_LRIMINAPNEWINITIALVW

VERTED_VERTEDINIALVW