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

Start Date Field: DateofAdmissiontoCCU

||Field Name||Column ID||Type||Comments||
||~~!EntryId~~||1||int||Ignored For Field Name||
||~~!PatientId~~||2||int||Ignored For Field Name||
||~~!DateofAdmissiontoCCU~~||3||datetime||Ignored For Datatype||
||~~!TimeofAdmissiontoCCU~~||4||datetime||Ignored For Datatype||
||!EntryStatus||5||varchar||||
||~~!PreviousEntry~~||6||int||Ignored For Field Name||
||~~!NextEntry~~||7||int||Ignored For Field Name||
||~~!OnsetOfSymptomsCcad~~||8||varchar||Ignored For No Enum||
||!MethodOfAdmissionCcad||9||varchar||||
||~~!CallForHelpCcad~~||10||varchar||Ignored For No Enum||
||~~!ArrivalOfEmergencyServiceCcad~~||11||varchar||Ignored For No Enum||
||~~!ArrivalAtHospitalCcad~~||12||varchar||Ignored For No Enum||
||~~!DateAndTimeOfReperfusionTreatmentCcad~~||13||varchar||Ignored For No Enum||
||~~!FirstCardiacArrestCcad~~||14||varchar||Ignored For No Enum||
||!CardiacArrestLocationCcad||15||varchar||||
||!ArrestPresentingRhythmCcad||16||varchar||||
||!OutcomeOfArrestCcad||17||varchar||||
||!InitialDiagnosisCcad||18||varchar||||
||!EcgDeterminingTreatmentCcad||19||varchar||||
||!AdditionalReperfusionTreatmentCcad||20||varchar||||
||WhereWasInitialReperfusionTreatmentGiven_Ccad||21||varchar||||
||WhoTookTheInitialDecisionToAttemptReperfusion_Ccad||22||varchar||||
||!ReasonReperfusionTreatmentNotGivenCcad||23||varchar||||
||Age||24||int||||
||WhereWasAspirin_otherAntiplateletGivenCcad||25||varchar||||
||!AdmissionWardCcad||26||varchar||||
||!AdmittingConsultantCcad||27||varchar||||
||!DischargeDiagnosisCcad||28||varchar||||
||!DeathInHospitalCcad||29||varchar||||
||~~!DateOfDischargeOrDeathCcad~~||30||datetime||Ignored For Datatype||
||!DischargedOnBetaBlockerCcad||31||varchar||||
||!AceInhibitorCcad||32||varchar||||
||!DischargedOnStatinCcad||33||varchar||||
||!DischargedOnAspirinOrOtherPlateletDrugCcad||34||varchar||||
||!CardiacRehabilitationCcad||35||varchar||||
||!ExerciseTestPerformedCcad||36||varchar||||
||!EchocardiographyCcad||37||varchar||||
||!RadionuclideStudyCcad||38||varchar||||
||!CoronaryAngiographyCcad||39||varchar||||
||!CoronaryInterventionCcad||40||varchar||||
||!GenderCcad||41||varchar||||
||!DelayBeforeTreatmentCcad||42||varchar||||
||!DaysInHospital||43||int||||
||!DelayFromOnsetOfSymptomsToCallForHelp||44||float||||
||!DelayFromCallForHelpToArrivalOfEmergencyServices||45||float||||
||!DelayFromCallForHelpToArrivalInHospital||46||float||||
||!DelayFromArrivalInHospitalToReperfusionTreatment||47||float||||
||!DelayFromCallForHelpToReperfusionTreatment||48||float||||
||!DelayFromOnsetOfSymptomsToReperfusionTreatment||49||float||||
||~~!AmbulanceJobNumberCcad~~||50||varchar||Ignored For No Enum||
||PeakCreatinineKinase_ck_Ccad||51||float||||
||!PeakTroponinCcad||52||float||||
||!TroponinAssayCcad||53||varchar||||
||!TroponinReferenceValue||54||varchar||||
||!PatientAdminStatusCcad||55||varchar||||
||!PreviousAmiCcad||56||varchar||||
||!PreviousAnginaCcad||57||varchar||||
||!HypertensionCcad||58||varchar||||
||!HypercholesterolaemiaCcad||59||varchar||||
||!PeripheralVascularDiseaseCcad||60||varchar||||
||!CerebrovascularDiseaseCcad||61||varchar||||
||!AsthmaOrCopdCcad||62||varchar||||
||!ChronicRenalFailureCcad||63||varchar||||
||!HeartFailureCcad||64||varchar||||
||CardiacEnzymes_markersRaisedCcad||65||varchar||||
||!SerumCholesterolCcad||66||float||||
||!SmokingStatusCcad||67||varchar||||
||!DiabetesCcad||68||varchar||||
||!PreviousPciCcad||69||varchar||||
||!PreviousCabgCcad||70||varchar||||
||!SystolicBpCcad||71||int||||
||!HeartRateCcad||72||int||||
||~~!ArrivalOfFirstProfessionalHelpCcad~~||73||varchar||Ignored For No Enum||
||!UnfractionatedHeparinCcad||74||varchar||||
||!LowMolecularWeightHeparinCcad||75||varchar||||
||!ThienopyridinePlateletInhibitorCcad||76||varchar||||
||!OtherOralAntiplateletAgentCcad||77||varchar||||
||Iv2b_3aAgentCcad||78||varchar||||
||!IvBetaBlockerCcad||79||varchar||||
||!CalciumChannelBlockerCcad||80||varchar||||
||!IvNitrateCcad||81||varchar||||
||!OralNitratesCcad||82||varchar||||
||!PotassiumChannelModulatorCcad||83||varchar||||
||!WarfarinCcad||84||varchar||||
||AngiotensinIiBlocker_arb_Ccad||85||varchar||||
||!ThiazideDiureticCcad||86||varchar||||
||!LoopDiureticCcad||87||varchar||||
||!SpironolactoneCcad||88||varchar||||
||!ThrombolyticDrugCcad||89||varchar||||
||!BleedingComplicationsCcad||90||varchar||||
||!DischargeDestinationCcad||91||varchar||||
||~~DateOfReferralForInvestigation_intervention~~||92||datetime||Ignored For Datatype||
||~~!DaycaseTransferDateCcad~~||93||datetime||Ignored For Datatype||
||~~!LocalAngioDateCcad~~||94||datetime||Ignored For Datatype||
||~~!LocalInterventionDateCcad~~||95||datetime||Ignored For Datatype||
||!OtherAdmissionDiagnosis||96||varchar||||
||!OtherDischargeDiagnosis||97||varchar||||
||!DischargedFromCcuDestination||98||varchar||||
||~~Gp_pctCodeCcad~~||99||varchar||Ignored For No Enum||
||DelayFromReferralForInvestigation_interventionToTr||100||float||||
||!PctCode||101||varchar||||
||~~!MedicalRecordNumberAtTimeOfEntryCcad~~||102||varchar||Ignored For No Enum||
||!SerumGlucoseCcad||103||float||||
||!DiabeticTherapyAtDischargeCcad||104||varchar||||
||!AuditTrail||105||varchar||||
||PlaceFirst12LeadEcgPerformedCcad||106||varchar||||
||!BetaBlockerUseCcad||107||varchar||||
||Ace1OrArbUseCcad||108||varchar||||
||!StatinUseCcad||109||varchar||||
||!ClopidogrelUseCcad||110||varchar||||
||!HeightCcad||111||float||||
||!WeightCcad||112||float||||
||!LeftVentricularEjectionFractionCcad||113||varchar||||
||!FamilyHistoryOfChdCcad||114||varchar||||
||!FollowedUpByCcad||115||varchar||||
||!ReinfarctionCcad||116||varchar||||
||!DischargedOnClopidogrelCcad||117||varchar||||
||~~!PatientCaseRecordNumberAtReferringHospitalCcad~~||118||varchar||Ignored For No Enum||
||!AmbulanceDriver||119||varchar||||
||!AmbulanceAttendant||120||varchar||||
||!AmbulanceResponder||121||varchar||||
||Comments||122||varchar||||
||!PreAlertCall||123||varchar||||
||~~!PickUpPostCode~~||124||varchar||Ignored For No Enum||
||!CardiacNurseInAttendance||125||varchar||||
||Cox_2InhibitorUse||126||varchar||||
||!NsaidUse||127||varchar||||
||!NitrateUse||128||varchar||||
||!CalciumChannelBlockerUse||129||varchar||||
||Spironolactone||130||varchar||||
||Eplerenone||131||varchar||||
||Nitrates||132||varchar||||
||Warfarin||133||varchar||||
||Other||134||varchar||||
||~~!TimeLeftScene~~||135||varchar||Ignored For No Enum||
||!HospitalCentreCode||136||varchar||||
||!TotalTimeOnScene||137||float||||
||~~!DateAndTimeOfFirstDiagnosticEcg~~||138||varchar||Ignored For No Enum||
||!CardiologicalCareDuringAdmissionCcad||139||varchar||||
||!CreatinineCcad||140||float||||
||!HaemoglobinCcad||141||float||||
||!SiteOfInfarctionCcad||142||varchar||||
||!FondaparinuxCcad||143||varchar||||
||!InitialReperfusionTreatmentCcad||144||varchar||||
||InPatientManagementOfHyperglycaemia_diabetesCcad||145||varchar||||
||~~!DateOfReturnToReferringHospital~~||146||datetime||Ignored For Datatype||
||!DelayForCallToFrv||147||float||||
||!DelayFrvToFullCrew||148||float||||
||!DelayCallToDepart||149||float||||
||!PatientEthnicGroup||150||varchar||||
||IncludeInD2n||151||varchar||||
||~~Comments2~~||152||varchar||Ignored For No Enum||
||!CathLabArrivalTime||153||varchar||||
||!BallonTime||154||varchar||||
||!DelayCcuToLab||155||float||||
||!DelayCallToBalloon||156||float||||
||!DelayDoorToBalloon||157||float||||
||!DelayLabToBalloon||158||float||||
||IncludeC2n||159||varchar||||
||!InterventionalCentreCodeCcad||160||varchar||||
||!ReferringHospitalCodeCcad||161||varchar||||
||Mustafa1||162||int||||
||Mustafa2||163||int||||
||!DaysFromAdmissionToDeath||164||int||||
||~~!DateOfCurrentStatus~~||165||datetime||Ignored For Datatype||
||~~!DateOfEndStatus~~||166||datetime||Ignored For Datatype||
||~~!DateTimeRecordCreated~~||167||datetime||Ignored For Datatype||
||~~!DateTimeRecordLastChanged~~||168||datetime||Ignored For Datatype||
||!EnteredByTag||169||varchar||||
||!EntryCurrentStatus||170||varchar||||
||!EntryEndStatus||171||varchar||||
||!HospitalTag||172||varchar||||