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

Start Date Field: !DateofHospitalAdmission

||Field Name||Column ID||Type||Comments||
||~~!EntryId~~||1||int||Ignored For Field Name||
||~~!PatientId~~||2||int||Ignored For Field Name||
||~~!DateofHospitalAdmission~~||3||datetime||Ignored For Datatype||
||~~!TimeofHospitalAdmission~~||4||datetime||Ignored For Datatype||
||!EntryStatus||5||varchar||||
||~~!PreviousEntry~~||6||int||Ignored For Field Name||
||~~!NextEntry~~||7||int||Ignored For Field Name||
||Age||8||int||||
||~~!DateOfAdmissionToCcu~~||9||datetime||Ignored For Datatype||
||!DirectAdmission||10||varchar||||
||!GenderCcad||11||varchar||||
||!EthnicOriginCcad||12||varchar||||
||!PatientAdminStatusCcad||13||varchar||||
||!HospitalCentreCode||14||varchar||||
||~~!GpPracticeCodeCcad~~||15||varchar||Ignored For No Enum||
||!InitialDiagnosisCcad||16||varchar||||
||!OtherAdmissionDiagnosis||17||varchar||||
||!MethodOfAdmissionCcad||18||varchar||||
||!EcgDeterminingTreatmentCcad||19||varchar||||
||WhereWasAspirin_otherAntiplateletGivenCcad||20||varchar||||
||!PreviousAmiCcad||21||varchar||||
||!PreviousAnginaCcad||22||varchar||||
||!HypertensionCcad||23||varchar||||
||!HypercholesterolaemiaCcad||24||varchar||||
||!PeripheralVascularDiseaseCcad||25||varchar||||
||!CerebrovascularDiseaseCcad||26||varchar||||
||!AsthmaOrCopdCcad||27||varchar||||
||!ChronicRenalFailureCcad||28||varchar||||
||!HeartFailureCcad||29||varchar||||
||CardiacEnzymes_markersRaisedCcad||30||varchar||||
||!SerumCholesterolCcad||31||float||||
||!SmokingStatusCcad||32||varchar||||
||!DiabetesCcad||33||varchar||||
||!PreviousPciCcad||34||varchar||||
||!PreviousCabgCcad||35||varchar||||
||!SystolicBpCcad||36||int||||
||!HeartRateCcad||37||int||||
||!AdmittingConsultantCcad||38||varchar||||
||PlaceFirst12LeadEcgPerformedCcad||39||varchar||||
||!BetaBlockerUseCcad||40||varchar||||
||Ace1OrArbUseCcad||41||varchar||||
||!StatinUseCcad||42||varchar||||
||!ClopidogrelUseCcad||43||varchar||||
||!HeightCcad||44||float||||
||!WeightCcad||45||float||||
||!LeftVentricularEjectionFractionCcad||46||varchar||||
||!FamilyHistoryOfChdCcad||47||varchar||||
||!AmbulanceDriver||48||varchar||||
||!AmbulanceAttendant||49||varchar||||
||!AmbulanceResponder||50||varchar||||
||~~!TimeLeftScene~~||51||varchar||Ignored For No Enum||
||~~!OnsetOfSymptomsCcad~~||52||varchar||Ignored For No Enum||
||~~!CallForHelpCcad~~||53||varchar||Ignored For No Enum||
||~~!ArrivalOfFirstProfessionalHelpCcad~~||54||varchar||Ignored For No Enum||
||~~!ArrivalOfEmergencyServiceCcad~~||55||varchar||Ignored For No Enum||
||~~!AmbulanceJobNumberCcad~~||56||varchar||Ignored For No Enum||
||~~!ArrivalAtHospitalCcad~~||57||varchar||Ignored For No Enum||
||WasReperfusionAttempted_Ccad||58||varchar||||
||!ReasonThrombolyticTreatmentNotGivenCcad||59||varchar||||
||~~!StartOfReperfusionTreatmentCcad~~||60||varchar||Ignored For No Enum||
||!DelayBeforeTreatmentCcad||61||varchar||||
||WhereWasInitialReperfusionTreatmentGiven_Ccad||62||varchar||||
||WhoTookTheInitialDecisionToAttemptReperfusion_Ccad||63||varchar||||
||~~!FirstCardiacArrestCcad~~||64||varchar||Ignored For No Enum||
||!CardiacArrestCcad||65||varchar||||
||!ArrestPresentingRhythmCcad||66||varchar||||
||!OutcomeOfArrestCcad||67||varchar||||
||!AdmissionWardCcad||68||varchar||||
||PeakCreatinineKinase_ck_Ccad||69||float||||
||!PeakTroponinCcad||70||float||||
||!TroponinAssayCcad||71||varchar||||
||!TroponinReferenceValue||72||varchar||||
||!UnfractionatedHeparinCcad||73||varchar||||
||!LowMolecularWeightHeparinCcad||74||varchar||||
||!ThienopyridinePlateletInhibitorCcad||75||varchar||||
||!OtherOralAntiplateletAgentCcad||76||varchar||||
||Iv2b_3aAgentCcad||77||varchar||||
||!IvBetaBlockerCcad||78||varchar||||
||!CalciumChannelBlockerCcad||79||varchar||||
||!IvNitrateCcad||80||varchar||||
||!OralNitratesCcad||81||varchar||||
||!PotassiumChannelModulatorCcad||82||varchar||||
||!WarfarinCcad||83||varchar||||
||AngiotensinIiBlocker_arb_Ccad||84||varchar||||
||!ThiazideDiureticCcad||85||varchar||||
||!AdmissionPlasmaGlucoseCcad||86||float||||
||!LoopDiureticCcad||87||varchar||||
||!SpironolactoneCcad||88||varchar||||
||!ThrombolyticDrugCcad||89||varchar||||
||~~!DateOfDischargeOrDeathCcad~~||90||datetime||Ignored For Datatype||
||~~!DateOfDischargeFromCcu~~||91||datetime||Ignored For Datatype||
||!DischargedFromCcuDestination||92||varchar||||
||!DischargeDiagnosisCcad||93||varchar||||
||!OtherDischargeDiagnosis||94||varchar||||
||!DiagamiCcad||95||varchar||||
||!RecommendedTherapyAtDischargeCcad||96||varchar||||
||!DaysInHospital||97||int||||
||!DaysInCcu||98||int||||
||!BleedingComplicationsCcad||99||varchar||||
||!DeathInHospitalCcad||100||varchar||||
||!DischargedOnBetaBlockerCcad||101||varchar||||
||!AceInhibitorCcad||102||varchar||||
||!DischargedOnStatinCcad||103||varchar||||
||!DischargedOnAspirinOrOtherPlateletDrugCcad||104||varchar||||
||!CardiacRehabilitationCcad||105||varchar||||
||!ExerciseTestPerformedCcad||106||varchar||||
||!EchocardiographyCcad||107||varchar||||
||!RadionuclideStudyCcad||108||varchar||||
||!CoronaryAngiographyAtThisAdmissionCcad||109||varchar||||
||!CoronaryInterventionPerformedAtThisAdmissionCcad||110||varchar||||
||~~DateOfReferralForInvestigation_intervention~~||111||datetime||Ignored For Datatype||
||!ModeOfDischargeCcad||112||varchar||||
||~~!DateOfTransferForDayCaseInvestigationCcad~~||113||datetime||Ignored For Datatype||
||~~!DateOfAngioPerformedLocallyCcad~~||114||datetime||Ignored For Datatype||
||~~!DateOfFirstInterventionOrSurgeryPerformedLocallyCc~~||115||datetime||Ignored For Datatype||
||!ReferralCentreCcad||116||varchar||||
||!ReferringHospitalCcad||117||varchar||||
||~~!PatientCaseRecordNumberAtReferralCentreCcad~~||118||varchar||Ignored For No Enum||
||!FollowedUpByCcad||119||varchar||||
||!ReinfarctionCcad||120||varchar||||
||!DischargedOnClopidogrelCcad||121||varchar||||
||!DelayFromOnsetOfSymptomsToCallForHelp||122||float||||
||!DelayFromCallForHelpToArrivalOfEmergencyServices||123||float||||
||!DelayFromCallForHelpToArrivalInHospital||124||float||||
||!DelayFromArrivalInHospitalToReperfusionTreatment||125||float||||
||!DelayFromCallForHelpToReperfusionTreatment||126||float||||
||!DelayFromOnsetOfSymptomsToReperfusionTreatment||127||float||||
||!TotalTimeOnScene||128||float||||
||DelayFromReferralForInvestigation_interventionToTr||129||float||||
||~~!PctCode~~||130||varchar||Ignored For No Enum||
||~~!MedicalRecordNumberAtTimeOfEntryCcad~~||131||varchar||Ignored For No Enum||
||~~Comments~~||132||varchar||Ignored For No Enum||
||!PreAlertCall||133||varchar||||
||~~!PickUpPostCode~~||134||varchar||Ignored For No Enum||
||!CardiacNurseInAttendance||135||varchar||||
||Cox_2InhibitorUse||136||varchar||||
||!NsaidUse||137||varchar||||
||!NitrateUse||138||varchar||||
||!CalciumChannelBlockerUse||139||varchar||||
||Spironolactone||140||varchar||||
||Eplerenone||141||varchar||||
||Nitrates||142||varchar||||
||Warfarin||143||varchar||||
||Other||144||varchar||||
||!DateAndTimeOfFirstDiagnosticEcg||145||varchar||||
||!AuditTrail||146||varchar||||
||!DaysFromAdmissionToDeath||147||int||||
||~~!DateOfCurrentStatus~~||148||datetime||Ignored For Datatype||
||~~!DateOfEndStatus~~||149||datetime||Ignored For Datatype||
||~~!DateTimeRecordCreated~~||150||datetime||Ignored For Datatype||
||~~!DateTimeRecordLastChanged~~||151||datetime||Ignored For Datatype||
||!EnteredByTag||152||varchar||||
||!EntryCurrentStatus||153||varchar||||
||!EntryEndStatus||154||varchar||||
||!HospitalTag||155||varchar||||