[[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||
||!InterventionalCentreCodeCcad||96||varchar||||
||!OtherAdmissionDiagnosis||97||varchar||||
||!OtherDischargeDiagnosis||98||varchar||||
||!DischargedFromCcuDestination||99||varchar||||
||~~Gp_pctCodeCcad~~||100||varchar||Ignored For No Enum||
||DelayFromReferralForInvestigation_interventionToTr||101||float||||
||~~!PctCode~~||102||varchar||Ignored For No Enum||
||~~!MedicalRecordNumberAtTimeOfEntryCcad~~||103||varchar||Ignored For No Enum||
||!SerumGlucoseCcad||104||float||||
||!DiabeticTherapyAtDischargeCcad||105||varchar||||
||!AuditTrail||106||varchar||||
||PlaceFirst12LeadEcgPerformedCcad||107||varchar||||
||!BetaBlockerUseCcad||108||varchar||||
||Ace1OrArbUseCcad||109||varchar||||
||!StatinUseCcad||110||varchar||||
||!ClopidogrelUseCcad||111||varchar||||
||!HeightCcad||112||float||||
||!WeightCcad||113||float||||
||!LeftVentricularEjectionFractionCcad||114||varchar||||
||!FamilyHistoryOfChdCcad||115||varchar||||
||!FollowedUpByCcad||116||varchar||||
||!ReinfarctionCcad||117||varchar||||
||!DischargedOnClopidogrelCcad||118||varchar||||
||!ReferringHospitalCodeCcad||119||varchar||||
||~~!PatientCaseRecordNumberAtReferringHospitalCcad~~||120||varchar||Ignored For No Enum||
||!AmbulanceDriver||121||varchar||||
||!AmbulanceAttendant||122||varchar||||
||!AmbulanceResponder||123||varchar||||
||Comments||124||varchar||||
||!PreAlertCall||125||varchar||||
||~~!PickUpPostCode~~||126||varchar||Ignored For No Enum||
||!CardiacNurseInAttendance||127||varchar||||
||Cox_2InhibitorUse||128||varchar||||
||!NsaidUse||129||varchar||||
||!NitrateUse||130||varchar||||
||!CalciumChannelBlockerUse||131||varchar||||
||Spironolactone||132||varchar||||
||Eplerenone||133||varchar||||
||Nitrates||134||varchar||||
||Warfarin||135||varchar||||
||Other||136||varchar||||
||~~!TimeLeftScene~~||137||varchar||Ignored For No Enum||
||!HospitalCentreCode||138||varchar||||
||!TotalTimeOnScene||139||float||||
||~~!DateAndTimeOfFirstDiagnosticEcg~~||140||varchar||Ignored For No Enum||
||!CardiologicalCareDuringAdmissionCcad||141||varchar||||
||!CreatinineCcad||142||float||||
||!HaemoglobinCcad||143||float||||
||!SiteOfInfarctionCcad||144||varchar||||
||!FondaparinuxCcad||145||varchar||||
||!InitialReperfusionTreatmentCcad||146||varchar||||
||InPatientManagementOfHyperglycaemia_diabetesCcad||147||varchar||||
||~~!DateOfReturnToReferringHospital~~||148||datetime||Ignored For Datatype||
||!DelayForCallToFrv||149||float||||
||!DelayFrvToFullCrew||150||float||||
||!DelayCallToDepart||151||float||||
||!PatientEthnicGroup||152||varchar||||
||IncludeInD2n||153||varchar||||
||~~!OtherComments~~||154||varchar||Ignored For No Enum||
||!CathLabArrivalTime||155||varchar||||
||!BalloonTime||156||varchar||||
||!DelayCcuToLab||157||float||||
||!DelayCallToBalloon||158||float||||
||!DelayDoorToBalloon||159||float||||
||!DelayLabToBalloon||160||float||||
||!IncludeInCallToNeedle||161||varchar||||
||!HospitalRefferedFrom||162||varchar||||
||FirstMustafa1||163||int||||
||SecondMustafa2||164||int||||
||!DaysFromAdmissionToDeath||165||int||||
||~~!DateOfCurrentStatus~~||166||datetime||Ignored For Datatype||
||~~!DateOfEndStatus~~||167||datetime||Ignored For Datatype||
||~~!DateTimeRecordCreated~~||168||datetime||Ignored For Datatype||
||~~!DateTimeRecordLastChanged~~||169||datetime||Ignored For Datatype||
||!EnteredByTag||170||varchar||||
||!EntryCurrentStatus||171||varchar||||
||!EntryEndStatus||172||varchar||||
||!HospitalTag||173||varchar||||