[[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||||