Changes between Version 29 and Version 30 of i2b2 Data Import PATS Mapping v1

Timestamp:

03/14/13 11:33:37 (11 years ago)

Author:

Richard Bramley

Comment:

--

i2b2 Data Import PATS Mapping v1

@@ -104 +104 @@
 '''''COMMENT (RB): There are quite a few denormalised fields. For example: drug1, drug2 - could these be normalised into one concept code.  Or: readmittedDate1, readmittedDate2 - could these be different encounters?  Are these already being recorded?'''''
 
+'''''COMMENT (RB): Some dates are recorded as varchars and so presumably are being imported'''''
+
+'''''COMMENT (RB): Are some text fields also being ignored because they don't have entries in the enum data dictionary?'''''
 
 
@@ -644 +647 @@
 ||!TotalCirculatoryArrestTime||25||int||||
 ||NewPost_OperativeNeurologicalDysfunction||26||varchar||||
-||NewHaemofiltrationOrDialysis||27||varchar||||
+||!NewHaemofiltrationOrDialysis||27||varchar||||
 ||!DischargeDestinationFromCardiothoracicWard||28||varchar||||
 ||~~!DateOfDischargeOrDeath~~||29||date||IGNORED||
@@ -924 +927 @@
 
 ||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||||
+||~~!EntryId~~||1||int||IGNORED||
+||~~!PatientId~~||2||int||IGNORED||
+||~~!DateOfOperation~~||3||date||IGNORED||
+||~~!TimeOfEntry~~||4||time||IGNORED||
+||!EntryStatus||5||varchar||||
+||~~!PreviousEntry~~||6||int||IGNORED||
+||~~!NextEntry~~||7||int||IGNORED||
+||!AgeAtOperation||8||int||||
 ||Gender||9||varchar||||
-||DateOfAdmission||10||date||||
+||~~!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||||
+||!NumberOfPreviousMis||13||varchar||||
+||!IntervalBetweenSurgeryAndLastMi||14||varchar||||
+||!PreviousPci||15||varchar||||
+||!PreviousCardiacSurgery||16||varchar||||
+||~~!DateOfLastCardiacOperation~~||17||date||IGNORED||
+||!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||||
+||~~!DateOfLastCatheterisation~~||24||date||IGNORED||
+||!PaSystolic||25||int||||
+||!IntravenousNitratesOrAnyHeparin||26||varchar||||
+||!IntravenousInotropesPriorToAnaesthesia||27||varchar||||
+||!VentilatedPreOperation||28||varchar||||
 ||CardiogenicShock_pre_Operation||29||varchar||||
-||OperativeUrgency||30||varchar||||
-||FirstOperatorGrade||31||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||||
+||!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|||| HERE
 ||FirstOperator||44||varchar||||
 ||FirstAssistant||45||varchar||||