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

Start Date Field: !DateOfOperation

||Field Name||Column ID||Type||Comments||
||~~!EntryId~~||1||int||Ignored For Field Name||
||~~!PatientId~~||2||int||Ignored For Field Name||
||~~!DateOfOperation~~||3||date||Ignored For Datatype||
||~~!TimeOfEntry~~||4||time||Ignored For Datatype||
||!EntryStatus||5||varchar||||
||~~!PreviousEntry~~||6||int||Ignored For Field Name||
||~~!NextEntry~~||7||int||Ignored For Field Name||
||!AgeAtOperation||8||int||||
||Gender||9||varchar||||
||~~!DateOfAdmission~~||10||date||Ignored For Datatype||
||AnginaStatusPre_Surgery||11||varchar||||
||DyspnoeaStatusPre_Surgery||12||varchar||||
||!NumberOfPreviousMis||13||varchar||||
||!IntervalBetweenSurgeryAndLastMi||14||varchar||||
||!PreviousPci||15||varchar||||
||!PreviousCardiacSurgery||16||varchar||||
||~~!DateOfLastCardiacOperation~~||17||date||Ignored For Datatype||
||!DiabetesManagement||18||varchar||||
||!HistoryOfHypertension||19||varchar||||
||!CigaretteSmokingHistory||20||varchar||||
||!HistoryOfPulmonaryDisease||21||varchar||||
||!HistoryOfNeurologicalDisease||22||varchar||||
||Pre_OperativeHeartRhythm||23||varchar||||
||~~!DateOfLastCatheterisation~~||24||date||Ignored For Datatype||
||!PaSystolic||25||int||||
||!IntravenousNitratesOrAnyHeparin||26||varchar||||
||!IntravenousInotropesPriorToAnaesthesia||27||varchar||||
||!VentilatedPreOperation||28||varchar||||
||CardiogenicShock_pre_Operation||29||varchar||||
||!OperativeUrgency||30||varchar||||
||!FirstOperatorGrade||31||varchar||||
||FirstOperator_CalmanYearOfTrainee||32||varchar||||
||!CardiacProcedures||33||varchar||||
||!OtherCardiacProcedures||34||varchar||||
||!OtherThoracicAndVascularProcedures||35||varchar||||
||!LeftMainStemDisease||36||varchar||||
||!ExtentOfCoronaryVesselDisease||37||varchar||||
||!ExtracardiacArteriopathy||38||varchar||||
||!EjectionFractionCategory||39||varchar||||
||!AdministrativeCategory||40||varchar||||
||~~!DateAndTimeOfOperation~~||41||varchar||Ignored For No Enum||
||!NumberOfPreviousHeartOperations||42||int||||
||!ResponsibleConsultantSurgeon||43||varchar||||
||!FirstOperator||44||varchar||||
||!FirstAssistant||45||varchar||||
||!FirstAssistantGrade||46||varchar||||
||FirstAssistant_CalmanYearOfTrainee||47||varchar||||
||!ResponsibleConsultantAnaesthetist||48||varchar||||
||~~!OperationFindings~~||49||varchar||Ignored For No Enum||
||!ReferringCardiologist||50||varchar||||
||~~!DateOfReferral~~||51||date||Ignored For Datatype||
||!DrugsOnAdmission||52||varchar||||
||Allergies||53||varchar||||
||!AllOtherAssistants||54||varchar||||
||!WaitingListStatusUpdated||55||varchar||||
||!SprCases||56||varchar||||
||~~!DateOfCurrentStatus~~||57||date||Ignored For Datatype||
||~~!DateOfEndStatus~~||58||date||Ignored For Datatype||
||~~!DateTimeRecordCreated~~||59||varchar||Ignored For No Enum||
||~~!DateTimeRecordLastChanged~~||60||varchar||Ignored For No Enum||
||!EnteredByTag||61||varchar||||
||!EntryCurrentStatus||62||varchar||||
||!EntryEndStatus||63||varchar||||
||!HospitalTag||64||varchar||||