[[i2b2 - UHL clinical informatics system integration PATS Mappings v1|back]]

Start Date Field: !DateOfAdmission

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