[[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||date||Ignored For Datatype||
||~~!TimeofAdmissiontoCCU~~||4||time||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||date||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||date||Ignored For Datatype||
||~~!DaycaseTransferDateCcad~~||93||date||Ignored For Datatype||
||~~!LocalAngioDateCcad~~||94||date||Ignored For Datatype||
||~~!LocalInterventionDateCcad~~||95||date||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||text||Ignored For Datatype||
||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||text||Ignored For Datatype||
||!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||date||Ignored For Datatype||
||!DelayForCallToFrv||147||float||||
||!DelayFrvToFullCrew||148||float||||
||!DelayCallToDepart||149||float||||
||!PatientEthnicGroup||150||varchar||||
||IncludeInD2n||151||varchar||||
||~~ASComments2~~||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||||
||!TimeFromAdmissionToFirstEcg||165||float||||
||!HospitalRefferedFrom||166||varchar||||
||!EcgQrsComplexDurationCcad||167||varchar||||
||!AldosteroneAntagonistCcad||168||varchar||||
||!DischargedOnTheinopyridineInhibitorCcad||169||varchar||||
||!DischargedOnAnAldosteroneAntagonistCcad||170||varchar||||
||!WhatProcedureWasPerformedAtTheInterventionalHospit||171||varchar||||
||!SmokingCessationAdviceGivenCcad||172||varchar||||
||!DietaryAdviceGivenDuringThisAdmissionCcad||173||varchar||||
||!OralBetaBlockerCcad||174||varchar||||
||!DateAndTimeArrivalAtNonInterventionalHospitalCcad||175||varchar||||
||!AssessmentAtNonInterventionalHospitalCcad||176||varchar||||
||!AssessmentAtInterventionalCentreCcad||177||varchar||||
||!IntendedReprofusionProcedureCcad||178||varchar||||
||!ProcedurePerformedCcad||179||varchar||||
||WhyWasNoAngiogramPerformed_Ccad||180||varchar||||
||!WhyWasNoInterventionPerformedCcad||181||varchar||||
||!PatientLocationAtTimeOfStemiOnset||182||varchar||||
||!AcsAuditSite||183||varchar||||
||!AcsAuditWard||184||varchar||||
||!AcsAuditHowManyDosesOfLmwh||185||int||||
||!AcsAuditCardiologicalOpinionRequestedDuringAdmissi||186||varchar||||
||!AcsAuditAdmittesFrom||187||varchar||||
||!AcsAuditTimiScore||188||varchar||||
||!AcsAuditRiskStratification||189||varchar||||
||!AcsAuditDateAndTimeOfEtt||190||varchar||||
||!AcsAuditDateAndTimeOfEcho||191||varchar||||
||!AcsAuditDateAndTimeOfAngiography||192||varchar||||
||AcsAuditDateAndTimeOfPci_Cabg||193||varchar||||
||!AcsAuditDischargedOnSublingualGtn||194||varchar||||
||!AcsAuditComments||195||varchar||||
||~~!DateOfCurrentStatus~~||196||date||Ignored For Datatype||
||~~!DateOfEndStatus~~||197||date||Ignored For Datatype||
||~~!DateTimeRecordCreated~~||198||varchar||Ignored For No Enum||
||~~!DateTimeRecordLastChanged~~||199||varchar||Ignored For No Enum||
||!EnteredByTag||200||varchar||||
||!EntryCurrentStatus||201||varchar||||
||!EntryEndStatus||202||varchar||||
||!HospitalTag||203||varchar||||
||!ImportLinkId||204||int||||