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


Ignore:
Timestamp:
03/15/13 09:01:02 (11 years ago)
Author:
Richard Bramley
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • i2b2 - UHL clinical informatics system integration PATS GGHPACEICD_GGHPACEICDINIALVW

    v1 v1  
     1[[i2b2 - UHL clinical informatics system integration PATS Mappings v1|back]]
     2
     3Start Date Field: DateOfProcedure_Implant
     4
     5||Field Name||Column ID||Type||Comments||
     6||~~!EntryId~~||1||int||Ignored For Field Name||
     7||~~!PatientId~~||2||int||Ignored For Field Name||
     8||~~DateOfProcedure_Implant~~||3||date||Ignored For Datatype||
     9||~~TimeOfProcedure_Implant~~||4||time||Ignored For Datatype||
     10||!EntryStatus||5||varchar||||
     11||~~!PreviousEntry~~||6||int||Ignored For Field Name||
     12||~~!NextEntry~~||7||int||Ignored For Field Name||
     13||!HospitalIdentifierCcad||8||varchar||||
     14||!PatientGenderCcad||9||varchar||||
     15||!PatientEthnicGroupCcad||10||varchar||||
     16||!PatientAdminStatusCcad||11||varchar||||
     17||~~!AuditTrail~~||12||text||Ignored For Datatype||
     18||!AgeAtProcedure||13||int||||
     19||~~!DateOfAdmission~~||14||date||Ignored For Datatype||
     20||~~!DateOfFirstImplantCcad~~||15||date||Ignored For Datatype||
     21||~~!PredeviceAetiologyCcad~~||16||varchar||Ignored For No Enum||
     22||~~Predevice_eps_ablationPresentingSymptomCcad~~||17||varchar||Ignored For No Enum||
     23||~~!PredeviceEcgCcad~~||18||varchar||Ignored For No Enum||
     24||NyhaDyspnoeaStatus_pre_ProcedureStableOnly_Ccad||19||varchar||||
     25||!LvFunctionAssessmentCcad||20||varchar||||
     26||Lvef_30_Nice||21||varchar||||
     27||!IcdIndicationCcad||22||varchar||||
     28||Predevice_ablationQrsDuration_ms_Ccad||23||float||||
     29||~~!DateAndTimeProcedureStart~~||24||varchar||Ignored For No Enum||
     30||~~!DateAndTimeProcedureEnd~~||25||varchar||Ignored For No Enum||
     31||!TotalTimeOfProcedure||26||int||||
     32||!InterventionCcad||27||varchar||||
     33||!ConsultantResponsibleForProcedureCcad||28||varchar||||
     34||~~!PrimaryOperatorCcadOldData~~||29||varchar||Ignored For No Enum||
     35||!GeneratorPacingModeCcad||30||varchar||||
     36||!GeneratorManufacturerCcad||31||varchar||||
     37||~~!GeneratorModelCcad~~||32||varchar||Ignored For No Enum||
     38||~~!GeneratorSerialNumberCcad~~||33||varchar||Ignored For No Enum||
     39||!GeneratorSiteOfImplantCcad||34||varchar||||
     40||~~!DateGeneratorChangedCcad~~||35||date||Ignored For Datatype||
     41||!WhyThisGeneratorEventuallyExplantedCcad||36||varchar||||
     42||!VentricularLeadManufacturerCcad||37||varchar||||
     43||~~!VentricularLeadModelCcad~~||38||varchar||Ignored For No Enum||
     44||~~!VentricularLeadSerialNumberCcad~~||39||varchar||Ignored For No Enum||
     45||!VentricularLeadImplantApproachCcad||40||varchar||||
     46||~~!DateVentricularLeadChangedCcad~~||41||date||Ignored For Datatype||
     47||!WhyThisVLeadEventuallyExplantedCcad||42||varchar||||
     48||!AtrialLeadManufacturerCcad||43||varchar||||
     49||~~!AtrialLeadModelCcad~~||44||varchar||Ignored For No Enum||
     50||~~!AtrialLeadSerialNumberCcad~~||45||varchar||Ignored For No Enum||
     51||!AtrialLeadImplantApproachCcad||46||varchar||||
     52||~~!DateAtrialLeadChangedCcad~~||47||date||Ignored For Datatype||
     53||!WhyThisALeadEventuallyExplantedCcad||48||varchar||||
     54||VentricularLead2ManufacturerCcad||49||varchar||||
     55||~~VentricularLead2ModelCcad~~||50||varchar||Ignored For No Enum||
     56||~~VentricularLead2SerialNumberCcad~~||51||varchar||Ignored For No Enum||
     57||VentricularLead2ImplantApproachCcad||52||varchar||||
     58||~~DateVentricularLead2ChangedCcad~~||53||date||Ignored For Datatype||
     59||WhyThisVLead2EventuallyExplantedCcad||54||varchar||||
     60||AtrialLead2ManufacturerCcad||55||varchar||||
     61||AtrialLead2ModelCcad||56||varchar||||
     62||AtrialLead2SerialNumberCcad||57||varchar||||
     63||AtrialLead2ImplantApproachCcad||58||varchar||||
     64||~~DateAtrialLead2ChangedCcad~~||59||date||Ignored For Datatype||
     65||WhyThisALead2EventuallyExplantedCcad||60||varchar||||
     66||!IcdFunctionCcad||61||varchar||||
     67||!BivFunctionCcad||62||varchar||||
     68||!DefbrillatorLeadSiteCcad||63||varchar||||
     69||!PacingProcedureComplicationsCcad||64||varchar||||
     70||BradycardiaPacingOn_Ccad||65||varchar||||
     71||!BradycardiaPacingModeCcad||66||varchar||||
     72||PacingRate_low_Ccad||67||float||||
     73||Anti_TachycardiaPacingOn_Ccad||68||varchar||||
     74||VtShockTherapyOn_Ccad||69||varchar||||
     75||VfShockTherapyOn_Ccad||70||varchar||||
     76||BiventricularPacingOn_Ccad||71||varchar||||
     77||AvDelay_sensed_Ccad||72||int||||
     78||AvDelay_paced||73||int||||
     79||BiventricularDelay_paced||74||int||||
     80||BiventricularPacingWhichChamberPacedFirst_Ccad||75||varchar||||
     81||!LeadExtractedCcad||76||varchar||||
     82||~~!DateOfFileClosureCcad~~||77||date||Ignored For Datatype||
     83||!DeviceFileClosureCcad||78||varchar||||
     84||!EpsTestedNice||79||varchar||||
     85||!TypeOfProcedure||80||varchar||||
     86||~~Ccso~~||81||varchar||Ignored For No Enum||
     87||~~!DateOfVentricularLeadImplant~~||82||date||Ignored For Datatype||
     88||!TypeOfVentricularLeadProcedure||83||varchar||||
     89||!TemporaryWire||84||varchar||||
     90||!PolarityOfVentricularLead||85||varchar||||
     91||!ConnectorAtrialLead||86||varchar||||
     92||!ConnectorVentricularLead||87||varchar||||
     93||VentricularLeadCurrent_5v_0_5ms||88||float||||
     94||VentricularLeadImpedance_ohms||89||float||||
     95||VentricularLeadRWave_mv||90||float||||
     96||VentricularLeadThreshold_0_5ms||91||float||||
     97||VentricularLeadStability_1v||92||varchar||||
     98||VentricularLeadTwitch_10v||93||varchar||||
     99||!VentricularLeadThresholdProblems||94||varchar||||
     100||!VentricularLeadConfirmCorrectConnection||95||varchar||||
     101||!ConfirmPacingVentricularLead||96||varchar||||
     102||~~!DateOfAtrialLeadImplant~~||97||date||Ignored For Datatype||
     103||!TypeOfAtrialLeadProcedure||98||varchar||||
     104||!PolarityOfAtrialLead||99||varchar||||
     105||AtrialLeadCurrent_5v_0_5ms||100||float||||
     106||AtrialLeadImpedance_ohms||101||float||||
     107||AtrialLeadPWave_mv||102||float||||
     108||AtrialLeadThreshold_0_5ms||103||float||||
     109||AtrialLeadStability_1v||104||varchar||||
     110||AtrialLeadTwitch_10v||105||varchar||||
     111||!AtrialLeadThresholdProblems||106||varchar||||
     112||!AtrialLeadConfirmCorrectConnection||107||varchar||||
     113||~~DateOfVentricularLead2Implant~~||108||date||Ignored For Datatype||
     114||TypeOfVentricularLead2Procedure||109||varchar||||
     115||PolarityOfVentricularLead2||110||varchar||||
     116||ConnectorVentricularLead2||111||varchar||||
     117||VentricularLead2Current_5v_0_5ms||112||float||||
     118||VentricularLead2Impedance_ohms||113||float||||
     119||VentricularLead2RWave_mv||114||float||||
     120||VentricularLead2Threshold_0_5ms||115||float||||
     121||VentricularLead2Stability_1v||116||varchar||||
     122||VentricularLead2Twitch_10v||117||varchar||||
     123||VentricularLead2ThresholdProblems||118||varchar||||
     124||VentricularLead2ConfirmCorrectConnection||119||varchar||||
     125||ConfirmPacingVentricularLead2||120||varchar||||
     126||~~DateOfAtrialLead2Implant~~||121||date||Ignored For Datatype||
     127||TypeOfAtrialLead2Procedure||122||varchar||||
     128||PolarityOfAtrialLead2||123||varchar||||
     129||ConnectorAtrialLead2||124||varchar||||
     130||AtrialLead2Current_5v_0_5ms||125||float||||
     131||AtrialLead2Impedance_ohms||126||float||||
     132||AtrialLead2RWave_mv||127||float||||
     133||!ConfirmPacingAtrialLead||128||varchar||||
     134||AtrialLeas2Threshold_0_5ms||129||float||||
     135||AtrialLead2Stability_1v||130||float||||
     136||AtrialLead2Twitch_10v||131||float||||
     137||AtrialLead2ThresholdProblems||132||varchar||||
     138||AtrialLead2ConfirmCorrectConnection||133||varchar||||
     139||ConfirmPacingAtrialLead2||134||varchar||||
     140||~~DateVentricularLeadCut_cappedAndBuried~~||135||date||Ignored For Datatype||
     141||~~DateAtrialLeadCut_cappedAndBuried~~||136||date||Ignored For Datatype||
     142||~~DateVentricularLead2Cut_cappedAndBuried~~||137||date||Ignored For Datatype||
     143||~~DateAtrialLead2Cut_cappedAndBuried~~||138||date||Ignored For Datatype||
     144||~~!ProcedureReport~~||139||varchar||Ignored For No Enum||
     145||~~!GpAtTimeOfProcedure~~||140||varchar||Ignored For No Enum||
     146||~~!NameOfGp~~||141||varchar||Ignored For No Enum||
     147||~~!GpPracticeCode~~||142||varchar||Ignored For No Enum||
     148||~~Pct~~||143||varchar||Ignored For No Enum||
     149||~~!MedicalRecordNumber~~||144||varchar||Ignored For No Enum||
     150||!NumberOfDaysDeviceImplanted||145||int||||
     151||~~!DateOfExplant~~||146||date||Ignored For Datatype||
     152||~~!DateOfDischarge~~||147||date||Ignored For Datatype||
     153||!ComplicationsBeforeDischarge||148||varchar||||
     154||~~!DateOfComplication~~||149||date||Ignored For Datatype||
     155||!TypeOfComplication||150||varchar||||
     156||!IfOtherComplicationPleaseState||151||varchar||||
     157||!DischargeDelayedDueToComplication||152||varchar||||
     158||!PacemakerChecksTransferred||153||varchar||||
     159||!TransferredTo||154||varchar||||
     160||~~!DateOfTransfer~~||155||date||Ignored For Datatype||
     161||!ProcedureUrgency||156||varchar||||
     162||!OtherOperatorsOldData||157||varchar||||
     163||!SideUsed||158||varchar||||
     164||~~Ward~~||159||varchar||Ignored For No Enum||
     165||~~!PrimaryOperatorCcad~~||160||varchar||Ignored For No Enum||
     166||~~!OtherOperators~~||161||varchar||Ignored For No Enum||
     167||!TotalDaysInHospital||162||float||||
     168||!LvPortPlugged||163||varchar||||
     169||!ClinicalGuidance||164||varchar||||
     170||!PrimaryReplacementAppropriateTherapy||165||varchar||||
     171||!NumberOfDaysDischargeDelayed||166||float||||
     172||Height||167||float||||
     173||Weight||168||float||||
     174||Bmi||169||float||||
     175||!ScreeningTime||170||float||||
     176||!ScreeningDose||171||float||||
     177||!ExceededDrl||172||varchar||||
     178||Radiographer||173||varchar||||
     179||!ReasonForExceedingDrl||174||varchar||||
     180||!SickNoteGiven||175||varchar||||
     181||!DurationOfSickNoteInDays||176||int||||
     182||!ChangesToCurrentMedication||177||varchar||||
     183||!NameOfDischargingDoctor||178||varchar||||
     184||Grade||179||varchar||||
     185||!PagerNumber||180||varchar||||
     186||!DischargeWard||181||varchar||||
     187||!DischargeDestination||182||varchar||||
     188||!DrugSensitivity||183||varchar||||
     189||Drug1||184||varchar||||
     190||Route1||185||varchar||||
     191||NumberOfDays1||186||int||||
     192||Continue1||187||varchar||||
     193||Drug2||188||varchar||||
     194||Route2||189||varchar||||
     195||NumberOfDays2||190||int||||
     196||Continue2||191||varchar||||
     197||Drug3||192||varchar||||
     198||Route3||193||varchar||||
     199||NumberOfDays3||194||int||||
     200||Continue3||195||varchar||||
     201||Drug4||196||varchar||||
     202||Route4||197||varchar||||
     203||NumberOfDays4||198||int||||
     204||Continue4||199||varchar||||
     205||Drug5||200||varchar||||
     206||Route5||201||varchar||||
     207||NumberOfDays5||202||int||||
     208||Continue5||203||varchar||||
     209||Drug6||204||varchar||||
     210||Route6||205||varchar||||
     211||NumberOfDays6||206||int||||
     212||Continue6||207||varchar||||
     213||Drug7||208||varchar||||
     214||Route7||209||varchar||||
     215||NumberOfDays7||210||int||||
     216||Continue7||211||varchar||||
     217||Drug8||212||varchar||||
     218||Route8||213||varchar||||
     219||NumberOfDays8||214||int||||
     220||Continue8||215||varchar||||
     221||Drug9||216||varchar||||
     222||Route9||217||varchar||||
     223||NumberOfDays9||218||int||||
     224||Continue9||219||varchar||||
     225||Drug10||220||varchar||||
     226||Route10||221||varchar||||
     227||NumberOfDays10||222||int||||
     228||Continue10||223||varchar||||
     229||Drug11||224||varchar||||
     230||Route11||225||varchar||||
     231||NumberOfDays11||226||int||||
     232||Continue11||227||varchar||||
     233||Drug12||228||varchar||||
     234||Route12||229||varchar||||
     235||NumberOfDays12||230||int||||
     236||Continue12||231||varchar||||
     237||Drug13||232||varchar||||
     238||Route13||233||varchar||||
     239||NumberOfDays13||234||int||||
     240||Continue13||235||varchar||||
     241||Drug14||236||varchar||||
     242||Route14||237||varchar||||
     243||NumberOfDays14||238||int||||
     244||Continue14||239||varchar||||
     245||Drug15||240||varchar||||
     246||Route15||241||varchar||||
     247||NumberOfDays15||242||int||||
     248||Continue15||243||varchar||||
     249||Drug16||244||varchar||||
     250||Route16||245||varchar||||
     251||NumberOfDays16||246||int||||
     252||Continue16||247||varchar||||
     253||Drug17||248||varchar||||
     254||Route17||249||varchar||||
     255||NumberOfDays17||250||int||||
     256||Continue17||251||varchar||||
     257||Drug18||252||varchar||||
     258||Route18||253||varchar||||
     259||NumberOfDays18||254||int||||
     260||Continue18||255||varchar||||