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

Start Date Field: !DateOfOperation_ccad

||Field Name||Column ID||Type||Comments||
||~~!EntryId~~||1||int||Ignored For Field Name||
||~~!PatientId~~||2||int||Ignored For Field Name||
||~~DateOfOperation_ccad~~||3||datetime||Ignored For Datatype||
||~~TimeOfOperation_ccad~~||4||datetime||Ignored For Datatype||
||!EntryStatus||5||varchar||||
||~~!PreviousEntry~~||6||int||Ignored For Field Name||
||~~!NextEntry~~||7||int||Ignored For Field Name||
||!AgeAtSurgery||8||int||||
||Gender||9||varchar||||
||~~!DateOfAdmission~~||10||datetime||Ignored For Datatype||
||AnginaStatusPre_Surgery||11||varchar||||
||DyspnoeaStatusPre_Surgery||12||varchar||||
||!NumberOfPreviousMis||13||varchar||||
||!IntervalBetweenOperationAndLastMi||14||varchar||||
||!PreviousPci||15||varchar||||
||~~!DateOfLastPci~~||16||datetime||Ignored For Datatype||
||PreviousCardiac_VascularOrThoracicSurgicalInterven||17||varchar||||
||~~!DateOfLastCardiacOperation~~||18||datetime||Ignored For Datatype||
||!DiabetesManagement||19||varchar||||
||Hypertension||20||varchar||||
||!CigaretteSmokingHistory||21||varchar||||
||!RenalDiseaseAtTheTimeOfSurgery||22||varchar||||
||!HistoryOfPulmonaryDisease||23||varchar||||
||!HistoryOfNeurologicalDisease||24||varchar||||
||Pre_OperativeHeartRhythm||25||varchar||||
||~~!DateOfCatheterisation~~||26||datetime||Ignored For Datatype||
||PaSystolic_ifKnown||27||int||||
||AvGradient_ifKnown||28||int||||
||Lvedp_ifKnown||29||int||||
||MeanPawp_la_ifKnown||30||int||||
||IvNitrates_HeparinOfAnyKind||31||varchar||||
||!IvInotropesPriorToAnaesthesia||32||varchar||||
||Ventilated||33||varchar||||
||!CardiogenicShock||34||varchar||||
||!OperativePriority||35||varchar||||
||!FirstOperatorGrade||36||varchar||||
||FirstOperator_CalmanYearOfTrainee||37||varchar||||
||!CardiacProcedures||38||varchar||||
||!NumberOfDistalCoronaryAnastomoses||39||int||||
||NumberOfValvesReplaced_Repaired||40||int||||
||!NumberOfSegmentsOfTheAorta||41||int||||
||!OtherCardiacProcedures||42||varchar||||
||!OtherThoracicAndVascularProcedures||43||varchar||||
||NeurologicalDysfunction_euroscore||44||varchar||||
||!LeftMainStemDisease||45||varchar||||
||!ExtentOfCoronaryArteryDisease||46||varchar||||
||!ExtracardiacArteriopathy||47||varchar||||
||!EjectionFractionCategory||48||varchar||||
||!AdmissionCategory||49||varchar||||
||!CarotidBruits||50||varchar||||
||!LeftOrRightHeartCatheterisation||51||varchar||||
||EjectionFractionValue_ifKnown||52||int||||
||~~!DateAndTimeOfOperation~~||53||varchar||Ignored For No Enum||
||!NumberOfPreviousHeartOperations||54||int||||
||!ResponsibleConsultantSurgeon||55||varchar||||
||~~!FirstOperator~~||56||varchar||Ignored For No Enum||
||~~!FirstAssistant~~||57||varchar||Ignored For No Enum||
||!FirstAssistantGrade||58||varchar||||
||FirstAssistant_CalmanYearOfTrainee||59||varchar||||
||~~!ResponsibleConsultantAnaesthetist~~||60||varchar||Ignored For No Enum||
||~~!OperationFindings~~||61||varchar||Ignored For No Enum||
||~~!ReferringCardiologist~~||62||varchar||Ignored For No Enum||
||~~!DateOfReferral~~||63||datetime||Ignored For Datatype||
||~~!DrugsOnAdmission~~||64||varchar||Ignored For No Enum||
||~~Allergies~~||65||varchar||Ignored For No Enum||
||~~!AllOtherAssistants~~||66||varchar||Ignored For No Enum||
||!WaitingListStatusUpdated||67||varchar||||
||!SprCases||68||varchar||||
||~~!DateOfCurrentStatus~~||69||datetime||Ignored For Datatype||
||~~!DateOfEndStatus~~||70||datetime||Ignored For Datatype||
||~~!DateTimeRecordCreated~~||71||datetime||Ignored For Datatype||
||~~!DateTimeRecordLastChanged~~||72||datetime||Ignored For Datatype||
||!EnteredByTag||73||varchar||||
||!EntryCurrentStatus||74||varchar||||
||!EntryEndStatus||75||varchar||||
||!HospitalTag||76||varchar||||
||WHO_RESPONSIBLE_CONSULTANT_SURGEON||77||varchar||||
||WHO_AGE_AT_OPERATION||78||int||||
||WHO_REGISTRY_INDICATOR||79||varchar||||
||~~WHO_POSSIBLE_DUPLICATE~~||80||char||Ignored For Datatype||