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