Changes between Initial Version and Version 1 of i2b2 - UHL clinical informatics system integration PATS CATH_CATHINITIALVW


Ignore:
Timestamp:
03/15/13 08:47:44 (11 years ago)
Author:
Richard Bramley
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • i2b2 - UHL clinical informatics system integration PATS CATH_CATHINITIALVW

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