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

Start Date Field: !DateofHospitalAdmission

||~~!EntryId~~||int||Ignored For Field Name||Y||
||~~!PatientId~~||int||Ignored For Field Name||Y||
||~~!DateofHospitalAdmission~~||datetime||Ignored For Datatype||Y||
||~~!TimeofHospitalAdmission~~||datetime||Ignored For Datatype||Y||
||!EntryStatus||varchar|| ||Y||
||~~!PreviousEntry~~||int||Ignored For Field Name||Y||
||~~!NextEntry~~||int||Ignored For Field Name||Y||
||Age||int|| ||Y||
||~~!DateOfAdmissionToCcu~~||datetime||Ignored For Datatype||Y||
||!DirectAdmission||varchar|| ||Y||
||!GenderCcad||varchar|| ||Y||
||!EthnicOriginCcad||varchar|| ||Y||
||!PatientAdminStatusCcad||varchar|| ||Y||
||!HospitalCentreCode||varchar|| ||Y||
||~~!GpPracticeCodeCcad~~||varchar||Ignored For No Enum||Y||
||!InitialDiagnosisCcad||varchar|| ||Y||
||!OtherAdmissionDiagnosis||varchar|| ||Y||
||!MethodOfAdmissionCcad||varchar|| ||Y||
||!EcgDeterminingTreatmentCcad||varchar|| ||Y||
||WhereWasAspirin_otherAntiplateletGivenCcad||varchar|| ||Y||
||!PreviousAmiCcad||varchar|| ||Y||
||!PreviousAnginaCcad||varchar|| ||Y||
||!HypertensionCcad||varchar|| ||Y||
||!HypercholesterolaemiaCcad||varchar|| ||Y||
||!PeripheralVascularDiseaseCcad||varchar|| ||Y||
||!CerebrovascularDiseaseCcad||varchar|| ||Y||
||!AsthmaOrCopdCcad||varchar|| ||Y||
||!ChronicRenalFailureCcad||varchar|| ||Y||
||!HeartFailureCcad||varchar|| ||Y||
||CardiacEnzymes_markersRaisedCcad||varchar|| ||Y||
||!SerumCholesterolCcad||float|| ||Y||
||!SmokingStatusCcad||varchar|| ||Y||
||!DiabetesCcad||varchar|| ||Y||
||!PreviousPciCcad||varchar|| ||Y||
||!PreviousCabgCcad||varchar|| ||Y||
||!SystolicBpCcad||int|| ||Y||
||!HeartRateCcad||int|| ||Y||
||!AdmittingConsultantCcad||varchar|| ||Y||
||PlaceFirst12LeadEcgPerformedCcad||varchar|| ||Y||
||!BetaBlockerUseCcad||varchar|| ||Y||
||Ace1OrArbUseCcad||varchar|| ||Y||
||!StatinUseCcad||varchar|| ||Y||
||!ClopidogrelUseCcad||varchar|| ||Y||
||!HeightCcad||float|| ||Y||
||!WeightCcad||float|| ||Y||
||!LeftVentricularEjectionFractionCcad||varchar|| ||Y||
||!FamilyHistoryOfChdCcad||varchar|| ||Y||
||!AmbulanceDriver||varchar|| ||Y||
||!AmbulanceAttendant||varchar|| ||Y||
||!AmbulanceResponder||varchar|| ||Y||
||~~!TimeLeftScene~~||varchar||Ignored For No Enum||Y||
||~~!OnsetOfSymptomsCcad~~||varchar||Ignored For No Enum||Y||
||~~!CallForHelpCcad~~||varchar||Ignored For No Enum||Y||
||~~!ArrivalOfFirstProfessionalHelpCcad~~||varchar||Ignored For No Enum||Y||
||~~!ArrivalOfEmergencyServiceCcad~~||varchar||Ignored For No Enum||Y||
||~~!AmbulanceJobNumberCcad~~||varchar||Ignored For No Enum||Y||
||~~!ArrivalAtHospitalCcad~~||varchar||Ignored For No Enum||Y||
||WasReperfusionAttempted_Ccad||varchar|| ||Y||
||!ReasonThrombolyticTreatmentNotGivenCcad||varchar|| ||Y||
||~~!StartOfReperfusionTreatmentCcad~~||varchar||Ignored For No Enum||Y||
||!DelayBeforeTreatmentCcad||varchar|| ||Y||
||WhereWasInitialReperfusionTreatmentGiven_Ccad||varchar|| ||Y||
||WhoTookTheInitialDecisionToAttemptReperfusion_Ccad||varchar|| ||Y||
||~~!FirstCardiacArrestCcad~~||varchar||Ignored For No Enum||Y||
||!CardiacArrestCcad||varchar|| ||Y||
||!ArrestPresentingRhythmCcad||varchar|| ||Y||
||!OutcomeOfArrestCcad||varchar|| ||Y||
||!AdmissionWardCcad||varchar|| ||Y||
||PeakCreatinineKinase_ck_Ccad||float|| ||Y||
||!PeakTroponinCcad||float|| ||Y||
||!TroponinAssayCcad||varchar|| ||Y||
||!TroponinReferenceValue||varchar|| ||Y||
||!UnfractionatedHeparinCcad||varchar|| ||Y||
||!LowMolecularWeightHeparinCcad||varchar|| ||Y||
||!ThienopyridinePlateletInhibitorCcad||varchar|| ||Y||
||!OtherOralAntiplateletAgentCcad||varchar|| ||Y||
||Iv2b_3aAgentCcad||varchar|| ||Y||
||!IvBetaBlockerCcad||varchar|| ||Y||
||!CalciumChannelBlockerCcad||varchar|| ||Y||
||!IvNitrateCcad||varchar|| ||Y||
||!OralNitratesCcad||varchar|| ||Y||
||!PotassiumChannelModulatorCcad||varchar|| ||Y||
||!WarfarinCcad||varchar|| ||Y||
||AngiotensinIiBlocker_arb_Ccad||varchar|| ||Y||
||!ThiazideDiureticCcad||varchar|| ||Y||
||!AdmissionPlasmaGlucoseCcad||float|| ||Y||
||!LoopDiureticCcad||varchar|| ||Y||
||!SpironolactoneCcad||varchar|| ||Y||
||!ThrombolyticDrugCcad||varchar|| ||Y||
||~~!DateOfDischargeOrDeathCcad~~||datetime||Ignored For Datatype||Y||
||~~!DateOfDischargeFromCcu~~||datetime||Ignored For Datatype||Y||
||!DischargedFromCcuDestination||varchar|| ||Y||
||!DischargeDiagnosisCcad||varchar|| ||Y||
||!OtherDischargeDiagnosis||varchar|| ||Y||
||!DiagamiCcad||varchar|| ||Y||
||!RecommendedTherapyAtDischargeCcad||varchar|| ||Y||
||!DaysInHospital||int|| ||Y||
||!DaysInCcu||int|| ||Y||
||!BleedingComplicationsCcad||varchar|| ||Y||
||!DeathInHospitalCcad||varchar|| ||Y||
||!DischargedOnBetaBlockerCcad||varchar|| ||Y||
||!AceInhibitorCcad||varchar|| ||Y||
||!DischargedOnStatinCcad||varchar|| ||Y||
||!DischargedOnAspirinOrOtherPlateletDrugCcad||varchar|| ||Y||
||!CardiacRehabilitationCcad||varchar|| ||Y||
||!ExerciseTestPerformedCcad||varchar|| ||Y||
||!EchocardiographyCcad||varchar|| ||Y||
||!RadionuclideStudyCcad||varchar|| ||Y||
||!CoronaryAngiographyAtThisAdmissionCcad||varchar|| ||Y||
||!CoronaryInterventionPerformedAtThisAdmissionCcad||varchar|| ||Y||
||~~DateOfReferralForInvestigation_intervention~~||datetime||Ignored For Datatype||Y||
||!ModeOfDischargeCcad||varchar|| ||Y||
||~~!DateOfTransferForDayCaseInvestigationCcad~~||datetime||Ignored For Datatype||Y||
||~~!DateOfAngioPerformedLocallyCcad~~||datetime||Ignored For Datatype||Y||
||~~!DateOfFirstInterventionOrSurgeryPerformedLocallyCc~~||datetime||Ignored For Datatype||Y||
||!ReferralCentreCcad||varchar|| ||Y||
||!ReferringHospitalCcad||varchar|| ||Y||
||~~!PatientCaseRecordNumberAtReferralCentreCcad~~||varchar||Ignored For No Enum||Y||
||!FollowedUpByCcad||varchar|| ||Y||
||!ReinfarctionCcad||varchar|| ||Y||
||!DischargedOnClopidogrelCcad||varchar|| ||Y||
||!DelayFromOnsetOfSymptomsToCallForHelp||float|| ||Y||
||!DelayFromCallForHelpToArrivalOfEmergencyServices||float|| ||Y||
||!DelayFromCallForHelpToArrivalInHospital||float|| ||Y||
||!DelayFromArrivalInHospitalToReperfusionTreatment||float|| ||Y||
||!DelayFromCallForHelpToReperfusionTreatment||float|| ||Y||
||!DelayFromOnsetOfSymptomsToReperfusionTreatment||float|| ||Y||
||!TotalTimeOnScene||float|| ||Y||
||DelayFromReferralForInvestigation_interventionToTr||float|| ||Y||
||~~!PctCode~~||varchar||Ignored For No Enum||Y||
||~~!MedicalRecordNumberAtTimeOfEntryCcad~~||varchar||Ignored For No Enum||Y||
||~~Comments~~||varchar||Ignored For No Enum||Y||
||!PreAlertCall||varchar|| ||Y||
||~~!PickUpPostCode~~||varchar||Ignored For No Enum||Y||
||!CardiacNurseInAttendance||varchar|| ||Y||
||Cox_2InhibitorUse||varchar|| ||Y||
||!NsaidUse||varchar|| ||Y||
||!NitrateUse||varchar|| ||Y||
||!CalciumChannelBlockerUse||varchar|| ||Y||
||Spironolactone||varchar|| ||Y||
||Eplerenone||varchar|| ||Y||
||Nitrates||varchar|| ||Y||
||Warfarin||varchar|| ||Y||
||Other||varchar|| ||Y||
||!DateAndTimeOfFirstDiagnosticEcg||varchar|| ||Y||
||!AuditTrail||varchar|| ||Y||
||!DaysFromAdmissionToDeath||int|| ||Y||
||~~!DateOfCurrentStatus~~||datetime||Ignored For Datatype||Y||
||~~!DateOfEndStatus~~||datetime||Ignored For Datatype||Y||
||~~!DateTimeRecordCreated~~||datetime||Ignored For Datatype||Y||
||~~!DateTimeRecordLastChanged~~||datetime||Ignored For Datatype||Y||
||!EnteredByTag||varchar|| ||Y||
||!EntryCurrentStatus||varchar|| ||Y||
||!EntryEndStatus||varchar|| ||Y||
||!HospitalTag||varchar|| ||Y||