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


Ignore:
Timestamp:
03/15/13 08:55:48 (12 years ago)
Author:
Richard Bramley
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • i2b2 - UHL clinical informatics system integration PATS EPS_EPSINIVW

    v1 v1  
     1[[i2b2 - UHL clinical informatics system integration PATS Mappings v1|back]]
     2
     3Start Date Field: !DateOfAdmission
     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||~~!DateOfEntry~~||3||date||Ignored For Datatype||
     9||~~!TimeofEPSRFA~~||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||~~!DateOfAdmission~~||8||date||Ignored For Datatype||
     14||~~!DateOfDischarge~~||9||date||Ignored For Datatype||
     15||~~!DateAddedToWaitingList~~||10||date||Ignored For Datatype||
     16||!HospitalIdentifier||11||varchar||||
     17||!PatientGender||12||varchar||||
     18||!AgeAtOperation||13||int||||
     19||!PatientEthnicGroup||14||varchar||||
     20||!PatientAdminStatus||15||varchar||||
     21||IsThisARe_Do||16||varchar||||
     22||Preeps_ablationAetiology2||17||varchar||||
     23||Preeps_ablationEcg||18||varchar||||
     24||~~Prepacing_eps_ablationPresentingSymptom~~||19||varchar||Ignored For No Enum||
     25||!GeneratorPacingMode||20||varchar||||
     26||Preeps_ablationPreviousIntervention||21||varchar||||
     27||Preeps_ablationArrhythmia||22||varchar||||
     28||Eps_ablationIndicationForIntervention||23||varchar||||
     29||Preicd_ablationQrsDuration||24||int||||
     30||~~Date_timeOfProcedure~~||25||varchar||Ignored For No Enum||
     31||!ProcedureUrgency||26||varchar||||
     32||!OperativeUrgency||27||varchar||||
     33||~~!PrimaryOperator~~||28||varchar||Ignored For No Enum||
     34||!FirstOperatorStatus||29||varchar||||
     35||~~!SecondOperator~~||30||varchar||Ignored For No Enum||
     36||!SecondOperatorStatus||31||varchar||||
     37||!ThirdOperator||32||varchar||||
     38||!ThirdOperatorStatus||33||varchar||||
     39||~~Ccso~~||34||varchar||Ignored For No Enum||
     40||~~AblationProcedure_s~~||35||varchar||Ignored For No Enum||
     41||~~!AccessoryPathway~~||36||varchar||Ignored For No Enum||
     42||!NumberOfElectrodeCatheters||37||int||||
     43||!MappingTechnique||38||varchar||||
     44||!TransseptalApproach||39||varchar||||
     45||Anticoagulation||40||varchar||||
     46||HeparinDose_iu||41||int||||
     47||!TotalFluoroscopyTime||42||float||||
     48||~~!ProcedureStartTime~~||43||varchar||Ignored For No Enum||
     49||~~!ProcedureEndTime~~||44||varchar||Ignored For No Enum||
     50||!ProcedureDuration||45||int||||
     51||!AblationAttempted||46||varchar||||
     52||!WaitingTime||47||int||||
     53||!WhyAblationNotAttempted||48||varchar||||
     54||!NumberOfEnergyApplications||49||int||||
     55||!TotalTimeOfEnergyApplication||50||int||||
     56||!AblationEnergySource||51||varchar||||
     57||~~Catheter~~||52||varchar||Ignored For No Enum||
     58||~~!CatheterReach~~||53||varchar||Ignored For No Enum||
     59||Ga||54||varchar||||
     60||!WhichPulmonaryVeinsAblated||55||varchar||||
     61||Success||56||varchar||||
     62||!TransientHeartBlock||57||varchar||||
     63||!AblationComplications||58||varchar||||
     64||!AvBlock||59||varchar||||
     65||!DeviceImplanted||60||varchar||||
     66||~~IntraopDrugs2~~||61||varchar||Ignored For No Enum||
     67||~~ProcedureReport_comment~~||62||varchar||Ignored For No Enum||
     68||Early_24hrs_Recurrence||63||varchar||||
     69||!ChestDrain||64||varchar||||
     70||!PericardialTap||65||varchar||||
     71||!ArterialRepair||66||varchar||||
     72||!DeathOnSameAdmission||67||varchar||||
     73||!LateRecurrenceOfArrhythmia||68||varchar||||
     74||TimeToRecurrence_months||69||int||||
     75||~~DateLastFollow_Up~~||70||date||Ignored For Datatype||
     76||!PreOpStay||71||int||||
     77||!PostOpStay||72||int||||
     78||!TotalHospitalStay||73||int||||
     79||!TotalTimeOnWaitingList||74||int||||
     80||~~!ReferringGpOrDentist~~||75||varchar||Ignored For No Enum||
     81||~~!NameOfReferringGpOrDentist~~||76||varchar||Ignored For No Enum||
     82||~~!GpPracticeCode~~||77||varchar||Ignored For No Enum||
     83||~~Pct~~||78||varchar||Ignored For No Enum||
     84||~~!MedicalRecordNumberAtTimeOfEntry~~||79||varchar||Ignored For No Enum||
     85||!AuditTrail||80||varchar||||
     86||~~!CatheterCcad~~||81||varchar||Ignored For No Enum||
     87||!CatheterReachCcad||82||varchar||||
     88||~~!AfAblationStrategies~~||83||varchar||Ignored For No Enum||
     89||Score||84||int||||
     90||Tvac_pvac||85||varchar||||
     91||Height||86||float||||
     92||Weight||87||float||||
     93||Bmi||88||float||||
     94||!ScreeningDose||89||float||||
     95||!ExceededDrl||90||varchar||||
     96||Radiographer||91||varchar||||
     97||!ReasonForExceedingDrl||92||varchar||||
     98||~~!DateOfCurrentStatus~~||93||date||Ignored For Datatype||
     99||~~!DateOfEndStatus~~||94||date||Ignored For Datatype||
     100||~~!DateTimeRecordCreated~~||95||varchar||Ignored For No Enum||
     101||~~!DateTimeRecordLastChanged~~||96||varchar||Ignored For No Enum||
     102||!EnteredByTag||97||varchar||||
     103||!EntryCurrentStatus||98||varchar||||
     104||!EntryEndStatus||99||varchar||||
     105||!HospitalTag||100||varchar||||
     106||!ImportLinkId||101||int||||