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