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

Start Date Field: !DateofHospitalAdmission

||'''Field Name'''||'''Type'''||'''Comments'''||GGHMINAP_GGHMINAP||
||~~!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||