Changes between Version 31 and Version 32 of i2b2 Data Import PATS Mapping v1

Timestamp:

03/14/13 12:00:49 (12 years ago)

Author:

Richard Bramley

Comment:

--

i2b2 Data Import PATS Mapping v1

@@ -1058 +1058 @@
 ||ProcedureReport_comment||62||varchar||||
 ||Early_24hrs_Recurrence||63||varchar||||
-||ChestDrain||64||varchar||||
+||!ChestDrain||64||varchar||||
 ||!PericardialTap||65||varchar||||
 ||!ArterialRepair||66||varchar||||
@@ -1100 +1100 @@
 
 ||Field Name||Column ID||Type||Comments||
-||EntryId||1||int||||
-||PatientId||2||int||||
-||DateofHospitalAdmission||3||datetime||||
-||TimeofHospitalAdmission||4||datetime||||
-||EntryStatus||5||varchar||||
-||PreviousEntry||6||int||||
-||NextEntry||7||int||||
+||~~!EntryId~~||1||int||IGNORED||
+||~~!PatientId~~||2||int||IGNORED||
+||~~!DateofHospitalAdmission~~||3||datetime||IGNORED||
+||~~!TimeofHospitalAdmission~~||4||datetime||IGNORED||
+||!EntryStatus||5||varchar||||
+||~~!PreviousEntry~~||6||int||IGNORED||
+||~~!NextEntry~~||7||int||IGNORED||
 ||Age||8||int||||
-||DateOfAdmissionToCcu||9||datetime||||
-||DirectAdmission||10||varchar||||
-||GenderCcad||11||varchar||||
-||EthnicOriginCcad||12||varchar||||
-||PatientAdminStatusCcad||13||varchar||||
-||HospitalCentreCode||14||varchar||||
-||GpPracticeCodeCcad||15||varchar||||
-||InitialDiagnosisCcad||16||varchar||||
-||OtherAdmissionDiagnosis||17||varchar||||
-||MethodOfAdmissionCcad||18||varchar||||
-||EcgDeterminingTreatmentCcad||19||varchar||||
+||~~!DateOfAdmissionToCcu~~||9||datetime||IGNORED||
+||!DirectAdmission||10||varchar||||
+||!GenderCcad||11||varchar||||
+||!EthnicOriginCcad||12||varchar||||
+||!PatientAdminStatusCcad||13||varchar||||
+||!HospitalCentreCode||14||varchar||||
+||!GpPracticeCodeCcad||15||varchar||||
+||!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||||
+||!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||||
+||!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||||
-||OnsetOfSymptomsCcad||52||varchar||||
-||CallForHelpCcad||53||varchar||||
-||ArrivalOfFirstProfessionalHelpCcad||54||varchar||||
-||ArrivalOfEmergencyServiceCcad||55||varchar||||
-||AmbulanceJobNumberCcad||56||varchar||||
-||ArrivalAtHospitalCcad||57||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||||
+||!OnsetOfSymptomsCcad||52||varchar||||
+||!CallForHelpCcad||53||varchar||||
+||!ArrivalOfFirstProfessionalHelpCcad||54||varchar||||
+||!ArrivalOfEmergencyServiceCcad||55||varchar||||
+||!AmbulanceJobNumberCcad||56||varchar||||
+||!ArrivalAtHospitalCcad||57||varchar||||
 ||WasReperfusionAttempted_Ccad||58||varchar||||
-||ReasonThrombolyticTreatmentNotGivenCcad||59||varchar||||
-||StartOfReperfusionTreatmentCcad||60||varchar||||
-||DelayBeforeTreatmentCcad||61||varchar||||
+||!ReasonThrombolyticTreatmentNotGivenCcad||59||varchar||||
+||!StartOfReperfusionTreatmentCcad||60||varchar||||
+||!DelayBeforeTreatmentCcad||61||varchar||||
 ||WhereWasInitialReperfusionTreatmentGiven_Ccad||62||varchar||||
 ||WhoTookTheInitialDecisionToAttemptReperfusion_Ccad||63||varchar||||
-||FirstCardiacArrestCcad||64||varchar||||
-||CardiacArrestCcad||65||varchar||||
-||ArrestPresentingRhythmCcad||66||varchar||||
-||OutcomeOfArrestCcad||67||varchar||||
-||AdmissionWardCcad||68||varchar||||
+||!FirstCardiacArrestCcad||64||varchar||||
+||!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||||
+||!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||||
+||!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||||
-||DateOfDischargeFromCcu||91||datetime||||
-||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||||
-||ModeOfDischargeCcad||112||varchar||||
-||DateOfTransferForDayCaseInvestigationCcad||113||datetime||||
-||DateOfAngioPerformedLocallyCcad||114||datetime||||
-||DateOfFirstInterventionOrSurgeryPerformedLocallyCc||115||datetime||||
-||ReferralCentreCcad||116||varchar||||
-||ReferringHospitalCcad||117||varchar||||
-||PatientCaseRecordNumberAtReferralCentreCcad||118||varchar||||
-||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||||
+||!ThiazideDiureticCcad||85||varchar||||
+||!AdmissionPlasmaGlucoseCcad||86||float||||
+||!LoopDiureticCcad||87||varchar||||
+||!SpironolactoneCcad||88||varchar||||
+||!ThrombolyticDrugCcad||89||varchar||||
+||~~!DateOfDischargeOrDeathCcad~~||90||datetime||IGNORED||
+||~~!DateOfDischargeFromCcu~~||91||datetime||IGNORED||
+||!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||
+||!ModeOfDischargeCcad||112||varchar||||
+||~~!DateOfTransferForDayCaseInvestigationCcad~~||113||datetime||IGNORED||
+||~~!DateOfAngioPerformedLocallyCcad~~||114||datetime||IGNORED||
+||~~!DateOfFirstInterventionOrSurgeryPerformedLocallyCc~~||115||datetime||IGNORED||
+||!ReferralCentreCcad||116||varchar||||
+||!ReferringHospitalCcad||117||varchar||||
+||!PatientCaseRecordNumberAtReferralCentreCcad||118||varchar||||
+||!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||||
-||MedicalRecordNumberAtTimeOfEntryCcad||131||varchar||||
+||!PctCode||130||varchar||||
+||!MedicalRecordNumberAtTimeOfEntryCcad||131||varchar||||
 ||Comments||132||varchar||||
-||PreAlertCall||133||varchar||||
-||PickUpPostCode||134||varchar||||
-||CardiacNurseInAttendance||135||varchar||||
+||!PreAlertCall||133||varchar||||
+||!PickUpPostCode||134||varchar||||
+||!CardiacNurseInAttendance||135||varchar||||
 ||Cox_2InhibitorUse||136||varchar||||
-||NsaidUse||137||varchar||||
-||NitrateUse||138||varchar||||
-||CalciumChannelBlockerUse||139||varchar||||
+||!NsaidUse||137||varchar||||
+||!NitrateUse||138||varchar||||
+||!CalciumChannelBlockerUse||139||varchar||||
 ||Spironolactone||140||varchar||||
 ||Eplerenone||141||varchar||||
@@ -1244 +1244 @@
 ||Warfarin||143||varchar||||
 ||Other||144||varchar||||
-||DateAndTimeOfFirstDiagnosticEcg||145||varchar||||
-||AuditTrail||146||varchar||||
-||DaysFromAdmissionToDeath||147||int||||
-||DateOfCurrentStatus||148||datetime||||
-||DateOfEndStatus||149||datetime||||
-||DateTimeRecordCreated||150||datetime||||
-||DateTimeRecordLastChanged||151||datetime||||
-||EnteredByTag||152||varchar||||
-||EntryCurrentStatus||153||varchar||||
-||EntryEndStatus||154||varchar||||
-||HospitalTag||155||varchar||||
+||!DateAndTimeOfFirstDiagnosticEcg||145||varchar||||
+||!AuditTrail||146||varchar||||
+||!DaysFromAdmissionToDeath||147||int||||
+||~~!DateOfCurrentStatus~~||148||datetime||IGNORED||
+||~~!DateOfEndStatus~~||149||datetime||IGNORED||
+||~~!DateTimeRecordCreated~~||150||datetime||IGNORED||
+||~~!DateTimeRecordLastChanged~~||151||datetime||IGNORED||
+||!EnteredByTag||152||varchar||||
+||!EntryCurrentStatus||153||varchar||||
+||!EntryEndStatus||154||varchar||||
+||!HospitalTag||155||varchar||||
 
 === GGHMINAPNEW
 
 ||Field Name||Column ID||Type||Comments||
-||EntryId||1||int||||
-||PatientId||2||int||||
-||DateofAdmissiontoCCU||3||datetime||||
-||TimeofAdmissiontoCCU||4||datetime||||
-||EntryStatus||5||varchar||||
-||PreviousEntry||6||int||||
-||NextEntry||7||int||||
-||OnsetOfSymptomsCcad||8||varchar||||
-||MethodOfAdmissionCcad||9||varchar||||
-||CallForHelpCcad||10||varchar||||
-||ArrivalOfEmergencyServiceCcad||11||varchar||||
-||ArrivalAtHospitalCcad||12||varchar||||
-||DateAndTimeOfReperfusionTreatmentCcad||13||varchar||||
-||FirstCardiacArrestCcad||14||varchar||||
-||CardiacArrestLocationCcad||15||varchar||||
-||ArrestPresentingRhythmCcad||16||varchar||||
-||OutcomeOfArrestCcad||17||varchar||||
-||InitialDiagnosisCcad||18||varchar||||
-||EcgDeterminingTreatmentCcad||19||varchar||||
-||AdditionalReperfusionTreatmentCcad||20||varchar||||
+||~~!EntryId~~||1||int||IGNORED||
+||~~!PatientId~~||2||int||IGNORED||
+||~~!DateofAdmissiontoCCU|~~|3||datetime||IGNORED||
+||~~!TimeofAdmissiontoCCU~~||4||datetime||IGNORED||
+||!EntryStatus||5||varchar||||
+||~~!PreviousEntry~~||6||int||IGNORED||
+||~~!NextEntry~~||7||int||IGNORED||
+||!OnsetOfSymptomsCcad||8||varchar||||
+||!MethodOfAdmissionCcad||9||varchar||||
+||!CallForHelpCcad||10||varchar||||
+||!ArrivalOfEmergencyServiceCcad||11||varchar||||
+||!ArrivalAtHospitalCcad||12||varchar||||
+||!DateAndTimeOfReperfusionTreatmentCcad||13||varchar||||
+||!FirstCardiacArrestCcad||14||varchar||||
+||!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||||
+||!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||||
-||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||||
+||!AdmissionWardCcad||26||varchar||||
+||!AdmittingConsultantCcad||27||varchar||||
+||!DischargeDiagnosisCcad||28||varchar||||
+||!DeathInHospitalCcad||29||varchar||||
+||~~!DateOfDischargeOrDeathCcad~~||30||datetime||IGNORED||
+||!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||||
 ||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||||
+||!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||||
-||UnfractionatedHeparinCcad||74||varchar||||
-||LowMolecularWeightHeparinCcad||75||varchar||||
-||ThienopyridinePlateletInhibitorCcad||76||varchar||||
-||OtherOralAntiplateletAgentCcad||77||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||||
+||!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||||
+||!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||||
-||DaycaseTransferDateCcad||93||datetime||||
-||LocalAngioDateCcad||94||datetime||||
-||LocalInterventionDateCcad||95||datetime||||
-||InterventionalCentreCodeCcad||96||varchar||||
-||OtherAdmissionDiagnosis||97||varchar||||
-||OtherDischargeDiagnosis||98||varchar||||
-||DischargedFromCcuDestination||99||varchar||||
+||!ThiazideDiureticCcad||86||varchar||||
+||!LoopDiureticCcad||87||varchar||||
+||!SpironolactoneCcad||88||varchar||||
+||!ThrombolyticDrugCcad||89||varchar||||
+||!BleedingComplicationsCcad||90||varchar||||
+||!DischargeDestinationCcad||91||varchar||||
+||~~DateOfReferralForInvestigation_intervention~~||92||datetime||IGNORED||
+||~~!DaycaseTransferDateCcad~~||93||datetime||IGNORED||
+||~~!LocalAngioDateCcad~~||94||datetime||IGNORED||
+||~~!LocalInterventionDateCcad~~||95||datetime||IGNORED||
+||!InterventionalCentreCodeCcad||96||varchar||||
+||!OtherAdmissionDiagnosis||97||varchar||||
+||!OtherDischargeDiagnosis||98||varchar||||
+||!DischargedFromCcuDestination||99||varchar||||
 ||Gp_pctCodeCcad||100||varchar||||
 ||DelayFromReferralForInvestigation_interventionToTr||101||float||||
-||PctCode||102||varchar||||
-||MedicalRecordNumberAtTimeOfEntryCcad||103||varchar||||
-||SerumGlucoseCcad||104||float||||
-||DiabeticTherapyAtDischargeCcad||105||varchar||||
-||AuditTrail||106||varchar||||
+||!PctCode||102||varchar||||
+||!MedicalRecordNumberAtTimeOfEntryCcad||103||varchar||||
+||!SerumGlucoseCcad||104||float||||
+||!DiabeticTherapyAtDischargeCcad||105||varchar||||
+||!AuditTrail||106||varchar||||
 ||PlaceFirst12LeadEcgPerformedCcad||107||varchar||||
-||BetaBlockerUseCcad||108||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||||
-||AmbulanceDriver||121||varchar||||
-||AmbulanceAttendant||122||varchar||||
-||AmbulanceResponder||123||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||||
+||!AmbulanceDriver||121||varchar||||
+||!AmbulanceAttendant||122||varchar||||
+||!AmbulanceResponder||123||varchar||||
 ||Comments||124||varchar||||
-||PreAlertCall||125||varchar||||
-||PickUpPostCode||126||varchar||||
-||CardiacNurseInAttendance||127||varchar||||
+||!PreAlertCall||125||varchar||||
+||!PickUpPostCode||126||varchar||||
+||!CardiacNurseInAttendance||127||varchar||||
 ||Cox_2InhibitorUse||128||varchar||||
-||NsaidUse||129||varchar||||
-||NitrateUse||130||varchar||||
-||CalciumChannelBlockerUse||131||varchar||||
+||!NsaidUse||129||varchar||||
+||!NitrateUse||130||varchar||||
+||!CalciumChannelBlockerUse||131||varchar||||
 ||Spironolactone||132||varchar||||
 ||Eplerenone||133||varchar||||
@@ -1395 +1395 @@
 ||Warfarin||135||varchar||||
 ||Other||136||varchar||||
-||TimeLeftScene||137||varchar||||
-||HospitalCentreCode||138||varchar||||
-||TotalTimeOnScene||139||float||||
-||DateAndTimeOfFirstDiagnosticEcg||140||varchar||||
-||CardiologicalCareDuringAdmissionCcad||141||varchar||||
-||CreatinineCcad||142||float||||
-||HaemoglobinCcad||143||float||||
-||SiteOfInfarctionCcad||144||varchar||||
-||FondaparinuxCcad||145||varchar||||
-||InitialReperfusionTreatmentCcad||146||varchar||||
+||!TimeLeftScene||137||varchar||||
+||!HospitalCentreCode||138||varchar||||
+||!TotalTimeOnScene||139||float||||
+||!DateAndTimeOfFirstDiagnosticEcg||140||varchar||||
+||!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||||
-||DelayForCallToFrv||149||float||||
-||DelayFrvToFullCrew||150||float||||
-||DelayCallToDepart||151||float||||
-||PatientEthnicGroup||152||varchar||||
+||~~!DateOfReturnToReferringHospital~~||148||datetime||IGNORED||
+||!DelayForCallToFrv||149||float||||
+||!DelayFrvToFullCrew||150||float||||
+||!DelayCallToDepart||151||float||||
+||!PatientEthnicGroup||152||varchar||||
 ||IncludeInD2n||153||varchar||||
-||OtherComments||154||varchar||||
-||CathLabArrivalTime||155||varchar||||
-||BalloonTime||156||varchar||||
-||DelayCcuToLab||157||float||||
-||DelayCallToBalloon||158||float||||
-||DelayDoorToBalloon||159||float||||
-||DelayLabToBalloon||160||float||||
-||IncludeInCallToNeedle||161||varchar||||
-||HospitalRefferedFrom||162||varchar||||
+||!OtherComments||154||varchar||||
+||!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||||
-||DateOfEndStatus||167||datetime||||
-||DateTimeRecordCreated||168||datetime||||
-||DateTimeRecordLastChanged||169||datetime||||
-||EnteredByTag||170||varchar||||
-||EntryCurrentStatus||171||varchar||||
-||EntryEndStatus||172||varchar||||
-||HospitalTag||173||varchar||||
+||!DaysFromAdmissionToDeath||165||int||||
+||~~!DateOfCurrentStatus~~||166||datetime||IGNORED||
+||~~!DateOfEndStatus~~||167||datetime||IGNORED||
+||~~!DateTimeRecordCreated~~||168||datetime||IGNORED||
+||~~!DateTimeRecordLastChanged~~||169||datetime||IGNORED||
+||!EnteredByTag||170||varchar||||
+||!EntryCurrentStatus||171||varchar||||
+||!EntryEndStatus||172||varchar||||
+||!HospitalTag||173||varchar||||
 
 === GGHMINAPNEW_GGHMINAPINIVW