Changes between Version 25 and Version 26 of i2b2 Data Import PATS Mapping v1


Ignore:
Timestamp:
03/14/13 10:14:10 (13 years ago)
Author:
Richard Bramley
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • i2b2 Data Import PATS Mapping v1

    v25 v26  
    101101
    102102||Field Name||Column ID||Type||Comments||
    103 ||EntryId||1||int||||
    104 ||PatientId||2||int||||
    105 ||DateofCatheter||3||date||||
    106 ||TimeofCatheter||4||time||||
    107 ||EntryStatus||5||varchar||||
    108 ||PreviousEntry||6||int||||
    109 ||NextEntry||7||int||||
    110 ||DateOfAdmission||8||date||||
    111 ||AgeAtCatheter||9||int||||
    112 ||DoneInMobileLab||10||varchar||||
     103||~~!EntryId~~||1||int||IGNORED||
     104||~~!PatientId~~||2||int||IGNORED||
     105||~~!DateofCatheter~~||3||date||IGNORED||
     106||~~!TimeofCatheter~~||4||time||IGNORED||
     107||!EntryStatus||5||varchar||||
     108||~~!PreviousEntry~~||6||int||IGNORED||
     109||~~!NextEntry~~||7||int||IGNORED||
     110||~~!DateOfAdmission~~||8||date||IGNORED||
     111||!AgeAtCatheter||9||int||||
     112||!DoneInMobileLab||10||varchar||||
    113113||Consultant||11||varchar||||
    114114||Operator||12||varchar||||
    115 ||SecondOperator||13||varchar||||
     115||!SecondOperator||13||varchar||||
    116116||Technician||14||varchar||||
    117 ||PatientType||15||varchar||||
    118 ||WasThePatientCatheterised||16||varchar||||
    119 ||ProcedureType||17||varchar||||
    120 ||GeneralAnaesthetics||18||varchar||||
    121 ||ProcedureSite||19||varchar||||
    122 ||BiopsyTaken||20||varchar||||
    123 ||BiopsySite||21||varchar||||
    124 ||OtherProcedure||22||varchar||||
     117||!PatientType||15||varchar||||
     118||!WasThePatientCatheterised||16||varchar||||
     119||!ProcedureType||17||varchar||||
     120||!GeneralAnaesthetics||18||varchar||||
     121||!ProcedureSite||19||varchar||||
     122||!BiopsyTaken||20||varchar||||
     123||!BiopsySite||21||varchar||||
     124||!OtherProcedure||22||varchar||||
    125125||Arterial_1||23||varchar||||
    126126||Vessel_1_Arterial||24||varchar||||
    … …  
    140140||Venous_3||38||varchar||||
    141141||Vessel_3_Venous||39||varchar||||
    142 ||Complicated_3_Venous||40||varchar||||
     142||!Complicated_3_Venous||40||varchar||||
    143143||Vessels||41||varchar||||
    144 ||ReturnedTo||42||varchar||||
    145 ||FurtherProcedure||43||varchar||||
    146 ||ImmediateComplications||44||varchar||||
    147 ||ProcedureAbandoned||45||varchar||||
    148 ||ReasonForAbandoningProcedure||46||varchar||||
    149 ||OtherComplications||47||varchar||||
    150 ||DiedInCathLab||48||varchar||||
    151 ||CoronaryDisease||49||varchar||||
    152 ||SignificantValveDisease||50||varchar||||
    153 ||SignificantLvDisease||51||varchar||||
     144||!ReturnedTo||42||varchar||||
     145||!FurtherProcedure||43||varchar||||
     146||!ImmediateComplications||44||varchar||||
     147||!ProcedureAbandoned||45||varchar||||
     148||!ReasonForAbandoningProcedure||46||varchar||||
     149||!OtherComplications||47||varchar||||
     150||!DiedInCathLab||48||varchar||||
     151||!CoronaryDisease||49||varchar||||
     152||!SignificantValveDisease||50||varchar||||
     153||!SignificantLvDisease||51||varchar||||
    154154||Outcome||52||varchar||||
    155 ||ReturnToCathLab||53||varchar||||
    156 ||EmbolicSequelae||54||varchar||||
    157 ||NonEmergencySurgery||55||varchar||||
    158 ||GroinComplication||56||varchar||||
     155||!ReturnToCathLab||53||varchar||||
     156||!EmbolicSequelae||54||varchar||||
     157||!NonEmergencySurgery||55||varchar||||
     158||!GroinComplication||56||varchar||||
    159159||Death||57||varchar||||
    160 ||DischargeComplications||58||varchar||||
    161 ||OutcomeOfCatheter||59||varchar||||
    162 ||DateOfDischarge||60||date||||
    163 ||DateOfDeath||61||date||||
    164 ||DischargeTo||62||varchar||||
     160||!DischargeComplications||58||varchar||||
     161||!OutcomeOfCatheter||59||varchar||||
     162||~~!DateOfDischarge~~||60||date||IGNORED||
     163||~~!DateOfDeath~~||61||date||IGNORED||
     164||!DischargeTo||62||varchar||||
    165165||PreopStay_days||63||int||||
    166166||PostOpStay_days||64||int||||
    167 ||TotalHospitalStay||65||int||||
     167||!TotalHospitalStay||65||int||||
    168168||IhdScore_cardwl||66||int||||
    169169||NihdScore_cardwl||67||int||||
    170 ||OtherComplicationsPreDischarge||68||varchar||||
    171 ||DateOfDeathPostDischarge||69||date||||
     170||!OtherComplicationsPreDischarge||68||varchar||||
     171||~~!DateOfDeathPostDischarge~~||69||date||IGNORED||
    172172||PostProcedureDeathInterval_days||70||int||||
    173 ||FormsVerified||71||varchar||||
     173||!FormsVerified||71||varchar||||
    174174||Contract||72||varchar||||
    175175||Pcg||73||varchar||||
    176 ||AuditLoopClosed||74||varchar||||
    177 ||DateAuditLoopClosed||75||date||||
    178 ||ReasonAuditLoopClosed||76||varchar||||
     176||!AuditLoopClosed||74||varchar||||
     177||!DateAuditLoopClosed||75||date||||
     178||!ReasonAuditLoopClosed||76||varchar||||
    179179||IntervalBetweenProc_LoopClosed_days||77||int||||
    180 ||DateOnWaitingList||78||date||||
    181 ||DaysOnList||79||int||||
    182 ||GpPracticeCode||80||varchar||||
     180||~~!DateOnWaitingList~~||78||date||IGNORED||
     181||!DaysOnList||79||int||||
     182||!GpPracticeCode||80||varchar||||
    183183||Pct||81||varchar||||
    184 ||MedicalRecordNumber||82||varchar||||
    185 ||AdministrativeCategory||83||varchar||||
    186 ||AuditTrail||84||text||||
    187 ||DateAndTimeOfProcedure||85||varchar||||
    188 ||IsThisAcs||86||varchar||||
     184||!MedicalRecordNumber||82||varchar||||
     185||!AdministrativeCategory||83||varchar||||
     186||!AuditTrail||84||text||||
     187||!DateAndTimeOfProcedure||85||varchar||||
     188||!IsThisAcs||86||varchar||||
    189189||Sub_Xiphoid||87||varchar||||
    190 ||PreDischargeComplications||88||varchar||||
    191 ||IfOtherPreDischargeComplicationsPleaseState||89||varchar||||
     190||!PreDischargeComplications||88||varchar||||
     191||!IfOtherPreDischargeComplicationsPleaseState||89||varchar||||
    192192||Height||90||float||||
    193193||Weight||91||float||||
    194194||Bmi||92||float||||
    195 ||ScreeningTime||93||float||||
    196 ||ScreeningDose||94||float||||
    197 ||ExceededDrl||95||varchar||||
     195||!ScreeningTime||93||float||||
     196||!ScreeningDose||94||float||||
     197||!ExceededDrl||95||varchar||||
    198198||Radiographer||96||varchar||||
    199 ||ReasonForExceedingDrl||97||varchar||||
    200 ||CatheterProcedureReport||98||varchar||||
    201 ||ConsultantCode||99||varchar||||
    202 ||OperatorCode||100||varchar||||
    203 ||SecondOperatorCode||101||varchar||||
    204 ||TroponinPositive||102||varchar||||
    205 ||DateOfCurrentStatus||103||date||||
    206 ||DateOfEndStatus||104||date||||
    207 ||DateTimeRecordCreated||105||varchar||||
    208 ||DateTimeRecordLastChanged||106||varchar||||
    209 ||EnteredByTag||107||varchar||||
    210 ||EntryCurrentStatus||108||varchar||||
    211 ||EntryEndStatus||109||varchar||||
    212 ||HospitalTag||110||varchar||||
    213 ||ImportLinkId||111||int||||
     199||!ReasonForExceedingDrl||97||varchar||||
     200||!CatheterProcedureReport||98||varchar||||
     201||!ConsultantCode||99||varchar||||
     202||!OperatorCode||100||varchar||||
     203||!SecondOperatorCode||101||varchar||||
     204||!TroponinPositive||102||varchar||||
     205||~~!DateOfCurrentStatus~~||103||date||IGNORED||
     206||~~!DateOfEndStatus~~||104||date||IGNORED||
     207||!DateTimeRecordCreated||105||varchar||||
     208||!DateTimeRecordLastChanged||106||varchar||||
     209||!EnteredByTag||107||varchar||||
     210||!EntryCurrentStatus||108||varchar||||
     211||!EntryEndStatus||109||varchar||||
     212||!HospitalTag||110||varchar||||
     213||!ImportLinkId||111||int||||
    214214
    215215=== CS2003F_PostProcedure