Changes between Version 34 and Version 35 of i2b2 Data Import PATS Mapping v1
- Timestamp:
- 03/14/13 12:57:56 (12 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
i2b2 Data Import PATS Mapping v1
v34 v35 114 114 115 115 ||Field Name||Column ID||Type||Comments|| 116 || !EntryId||1||int||Ignored For Field Name||117 || !PatientId||2||int||Ignored For Field Name||118 || !DateofCatheter||3||date||Ignored For Datatype||119 || !TimeofCatheter||4||time||Ignored For Datatype||116 ||~~!EntryId~~||1||int||Ignored For Field Name|| 117 ||~~!PatientId~~||2||int||Ignored For Field Name|| 118 ||~~!DateofCatheter~~||3||date||Ignored For Datatype|| 119 ||~~!TimeofCatheter~~||4||time||Ignored For Datatype|| 120 120 ||!EntryStatus||5||varchar|||| 121 || !PreviousEntry||6||int||Ignored For Field Name||122 || !NextEntry||7||int||Ignored For Field Name||123 || !DateOfAdmission||8||date||Ignored For Datatype||121 ||~~!PreviousEntry~~||6||int||Ignored For Field Name|| 122 ||~~!NextEntry~~||7||int||Ignored For Field Name|| 123 ||~~!DateOfAdmission~~||8||date||Ignored For Datatype|| 124 124 ||!AgeAtCatheter||9||int|||| 125 125 ||!DoneInMobileLab||10||varchar|||| 126 || Consultant||11||varchar||Ignored For No Enum||127 || Operator||12||varchar||Ignored For No Enum||128 || !SecondOperator||13||varchar||Ignored For No Enum||129 || Technician||14||varchar||Ignored For No Enum||126 ||~~Consultant~~||11||varchar||Ignored For No Enum|| 127 ||~~Operator~~||12||varchar||Ignored For No Enum|| 128 ||~~!SecondOperator~~||13||varchar||Ignored For No Enum|| 129 ||~~Technician~~||14||varchar||Ignored For No Enum|| 130 130 ||!PatientType||15||varchar|||| 131 131 ||!WasThePatientCatheterised||16||varchar|||| 132 132 ||!ProcedureType||17||varchar|||| 133 133 ||!GeneralAnaesthetics||18||varchar|||| 134 || !ProcedureSite||19||varchar||Ignored For No Enum||134 ||~~!ProcedureSite~~||19||varchar||Ignored For No Enum|| 135 135 ||!BiopsyTaken||20||varchar|||| 136 136 ||!BiopsySite||21||varchar|||| 137 || !OtherProcedure||22||varchar||Ignored For No Enum||137 ||~~!OtherProcedure~~||22||varchar||Ignored For No Enum|| 138 138 ||Arterial_1||23||varchar|||| 139 139 ||Vessel_1_Arterial||24||varchar|||| … … 154 154 ||Vessel_3_Venous||39||varchar|||| 155 155 ||Complicated_3_Venous||40||varchar|||| 156 || Vessels||41||varchar||Ignored For No Enum||156 ||~~Vessels~~||41||varchar||Ignored For No Enum|| 157 157 ||!ReturnedTo||42||varchar|||| 158 158 ||!FurtherProcedure||43||varchar|||| … … 160 160 ||!ProcedureAbandoned||45||varchar|||| 161 161 ||!ReasonForAbandoningProcedure||46||varchar|||| 162 || !OtherComplications||47||varchar||Ignored For No Enum||162 ||~~!OtherComplications~~||47||varchar||Ignored For No Enum|| 163 163 ||!DiedInCathLab||48||varchar|||| 164 164 ||!CoronaryDisease||49||varchar|||| … … 173 173 ||!DischargeComplications||58||varchar|||| 174 174 ||!OutcomeOfCatheter||59||varchar|||| 175 || !DateOfDischarge||60||date||Ignored For Datatype||176 || !DateOfDeath||61||date||Ignored For Datatype||175 ||~~!DateOfDischarge~~||60||date||Ignored For Datatype|| 176 ||~~!DateOfDeath~~||61||date||Ignored For Datatype|| 177 177 ||!DischargeTo||62||varchar|||| 178 178 ||PreopStay_days||63||int|||| … … 182 182 ||NihdScore_cardwl||67||int|||| 183 183 ||!OtherComplicationsPreDischarge||68||varchar|||| 184 || !DateOfDeathPostDischarge||69||date||Ignored For Datatype||184 ||~~!DateOfDeathPostDischarge~~||69||date||Ignored For Datatype|| 185 185 ||PostProcedureDeathInterval_days||70||int|||| 186 186 ||!FormsVerified||71||varchar|||| 187 || Contract||72||varchar||Ignored For No Enum||188 || Pcg||73||varchar||Ignored For No Enum||187 ||~~Contract~~||72||varchar||Ignored For No Enum|| 188 ||~~Pcg~~||73||varchar||Ignored For No Enum|| 189 189 ||!AuditLoopClosed||74||varchar|||| 190 || !DateAuditLoopClosed||75||date||Ignored For Datatype||190 ||~~!DateAuditLoopClosed~~||75||date||Ignored For Datatype|| 191 191 ||!ReasonAuditLoopClosed||76||varchar|||| 192 192 ||IntervalBetweenProc_LoopClosed_days||77||int|||| 193 || !DateOnWaitingList||78||date||Ignored For Datatype||193 ||~~!DateOnWaitingList~~||78||date||Ignored For Datatype|| 194 194 ||!DaysOnList||79||int|||| 195 || !GpPracticeCode||80||varchar||Ignored For No Enum||196 || Pct||81||varchar||Ignored For No Enum||197 || !MedicalRecordNumber||82||varchar||Ignored For No Enum||195 ||~~!GpPracticeCode~~||80||varchar||Ignored For No Enum|| 196 ||~~Pct~~||81||varchar||Ignored For No Enum|| 197 ||~~!MedicalRecordNumber~~||82||varchar||Ignored For No Enum|| 198 198 ||!AdministrativeCategory||83||varchar|||| 199 || !AuditTrail||84||text||Ignored For Datatype||200 || !DateAndTimeOfProcedure||85||varchar||Ignored For No Enum||199 ||~~!AuditTrail~~||84||text||Ignored For Datatype|| 200 ||~~!DateAndTimeOfProcedure~~||85||varchar||Ignored For No Enum|| 201 201 ||!IsThisAcs||86||varchar|||| 202 202 ||Sub_Xiphoid||87||varchar|||| … … 211 211 ||Radiographer||96||varchar|||| 212 212 ||!ReasonForExceedingDrl||97||varchar|||| 213 || !CatheterProcedureReport||98||varchar||Ignored For No Enum||214 || !ConsultantCode||99||varchar||Ignored For No Enum||215 || !OperatorCode||100||varchar||Ignored For No Enum||216 || !SecondOperatorCode||101||varchar||Ignored For No Enum||213 ||~~!CatheterProcedureReport~~||98||varchar||Ignored For No Enum|| 214 ||~~!ConsultantCode~~||99||varchar||Ignored For No Enum|| 215 ||~~!OperatorCode~~||100||varchar||Ignored For No Enum|| 216 ||~~!SecondOperatorCode~~||101||varchar||Ignored For No Enum|| 217 217 ||!TroponinPositive||102||varchar|||| 218 || !DateOfCurrentStatus||103||date||Ignored For Datatype||219 || !DateOfEndStatus||104||date||Ignored For Datatype||220 || !DateTimeRecordCreated||105||varchar||Ignored For No Enum||221 || !DateTimeRecordLastChanged||106||varchar||Ignored For No Enum||218 ||~~!DateOfCurrentStatus~~||103||date||Ignored For Datatype|| 219 ||~~!DateOfEndStatus~~||104||date||Ignored For Datatype|| 220 ||~~!DateTimeRecordCreated~~||105||varchar||Ignored For No Enum|| 221 ||~~!DateTimeRecordLastChanged~~||106||varchar||Ignored For No Enum|| 222 222 ||!EnteredByTag||107||varchar|||| 223 223 ||!EntryCurrentStatus||108||varchar||||
