Changes between Version 36 and Version 37 of i2b2 Data Import PATS Mapping v1

Timestamp:

03/14/13 13:12:25 (13 years ago)

Author:

Richard Bramley

Comment:

--

i2b2 Data Import PATS Mapping v1

@@ -229 +229 @@
 
 ||Field Name||Column ID||Type||Comments||
+||~~!EntryId~~||1||int||Ignored For Field Name||
+||~~!PatientId~~||2||int||Ignored For Field Name||
+||Pre_OperativeStayInDays||3||int||||
+||Post_OperativeStayInDays||4||int||||
+||!TotalStayInDays||5||int||||
+||!ParsonnetScoreFromHardData||6||int||||
+||!CardiopulmonaryBypass||7||varchar||||
+||!ParsonnetScoreWithCatastrophicStatesAndRareConditi||8||int||||
+||!PredominantMyocardialProtection||9||varchar||||
+||Parsonnet_AdditionsForCatastrophicStates||10||int||||
+||Parsonnet_AdditionsForRareConditions||11||int||||
+||Euroscore||12||int||||
+||Cs1999ComplexCabgBayesScore||13||float||||
+||!LogisticEuroscore||14||float||||
+||Cardioplegia_Solution||15||varchar||||
+||Cardioplegia_Temperature||16||varchar||||
+||Cardioplegia_Timing||17||varchar||||
+||Non_CardioplegiaMyocardialProtection||18||varchar||||
+||Intra_AorticBalloonPumpUsed||19||varchar||||
+||!ReaonForIabpUse||20||varchar||||
+||!HeightInCm||21||int||||
+||!WeightInKg||22||float||||
+||!CumulativeBypassTimeInMin||23||int||||
+||!CumulativeCrossClampTimeInMin||24||int||||
+||!TotalCirculatoryArrestTimeInMin||25||int||||
+||Re_Operation||26||varchar||||
+||NewPost_OperativeStroke||27||varchar||||
+||NewHaemofiltration_DialysisPost_Operatively||28||varchar||||
+||DischargeDestination_FromCardiothoracicWard||29||varchar||||
+||~~!DateOfDischargeOrDeath~~||30||datetime||Ignored For Datatype||
+||!BodySurfaceArea||31||float||||
+||!BodyMassIndex||32||float||||
+||Cardioplegia_Infusion||33||varchar||||
+||!EuroscoreMinumumDatasetCheck||34||varchar||||
+||!ParsonnetMinumumDatasetCheck||35||varchar||||
+||~~!NameOfGpAtTimeOfSurgery~~||36||varchar||Ignored For No Enum||
+||~~!GpPracticeCodeAtTimeOfSurgery~~||37||varchar||Ignored For No Enum||
+||~~!PctAtTimeOfSurgery~~||38||varchar||Ignored For No Enum||
+||~~NameOfReferringGpAtTimeOfSurgeryType8~~||39||varchar||Ignored For No Enum||
+||!ToePerformed||40||varchar||||
+||Sonographer||41||varchar||||
+||Sonographist||42||varchar||||
+||~~!PrimaryPerfusionist~~||43||varchar||Ignored For No Enum||
+||PcuPatient_pcu||44||varchar||||
+||DoesPatientMeetInterOperativeCriteria_pcu||45||varchar||||
+||AreaPatientAdmittedTo_pcu||46||varchar||||
+||AdmissionTimeToRecovery_cicu_pcu||47||varchar||||
+||ExtubationDateAndTime_pcu||48||varchar||||
+||WhatO2SystemWasUsed_pcu||49||varchar||||
+||TotalBloodLostOnDischargeFromRecovery_pcu||50||varchar||||
+||WereClottingProductsUsed_pcu||51||varchar||||
+||WhatProductsWereUsed_pcu||52||varchar||||
+||HowMuchColloidUsedInRecovery_pcu||53||varchar||||
+||TypeOfColloidUsed_pcu||54||varchar||||
+||PainScoreOnWaking_pcu||55||varchar||||
+||!AnalgesiaUsedPcu||56||varchar||||
+||TotalMorphineDoseUsedIncludingBolus_pcu||57||varchar||||
+||InotropesUsed_pcu||58||varchar||||
+||Dosage_pcu||59||varchar||||
+||WereThereAnyArrhythmias_pcu||60||varchar||||
+||PleaseStateArrhythmias_pcu||61||varchar||||
+||TreatmentOfArrhythmias_pcu||62||varchar||||
+||PotassiumUsed_pcu||63||varchar||||
+||PotassiumDoseInMmols_pcu||64||varchar||||
+||TemperatureOnAdmission_pcu||65||float||||
+||BairhuggerWithPatient_pcu||66||varchar||||
+||TimeOfDischarge_pcu||67||varchar||||
+||PlaceOfDischarge_pcu||68||varchar||||
+||DoesPatientMeetDischargeCriteria_pcu||69||varchar||||
+||WasPatientDischargedFromPcuToHdu_pcu||70||varchar||||
+||LowUrineOutput_pcu||71||varchar||||
+||IfNoStateWhy_pcu||72||varchar||||
+||IfNoWhy_pcu||73||varchar||||
+||AmountOfTimeIntubated_pcu||74||float||||
+||AmountOfTimeInRecovery_cicu_pcu||75||float||||
+||~~OverallComments_sa~~||76||varchar||Ignored For No Enum||
+||TeachingOfOtherStaffComments_sa||77||varchar||||
+||TeachingOfOtherStaffCommentsMade_sa||78||varchar||||
+||TeachingOfOtherStaffBySa_sa||79||varchar||||
+||IabpRemovalComments_sa||80||varchar||||
+||IabpRemovalCommentsMade_sa||81||varchar||||
+||IabpRemovalBySa_sa||82||varchar||||
+||IabpInsertionComments_sa||83||varchar||||
+||IabpInsertionCommentsMade_sa||84||varchar||||
+||IabpInsertionBySa_sa||85||varchar||||
+||SternotomyClosureComments_sa||86||varchar||||
+||SternotomyClosureCommentsMade_sa||87||varchar||||
+||SternotomyClosureBySa_sa||88||varchar||||
+||SternotomyComments_sa||89||varchar||||
+||SternotomyCommentsMade_sa||90||varchar||||
+||SternotomyPerformedBySa_sa||91||varchar||||
+||ThirdSiteComments_sa||92||varchar||||
+||ThirdSiteCommentsMade_sa||93||varchar||||
+||ThirdSiteConduit_location_sa||94||varchar||||
+||~~SecondSiteComments_sa~~||95||varchar||Ignored For No Enum||
+||SecondSiteCommentsMade_sa||96||varchar||||
+||SecondSiteConduit_location_sa||97||varchar||||
+||~~FirstSiteComments_sa~~||98||varchar||Ignored For No Enum||
+||FirstSiteCommentsMade_sa||99||varchar||||
+||FirstSiteConduei_location_sa||100||varchar||||
+||ThirdAssistant_sa||101||varchar||||
+||SecondAssistant_sa||102||varchar||||
+||FirstAssistant_sa||103||varchar||||
+||SurgicalAssistant_sa||104||varchar||||
+||ReferralToOperation_days||105||float||||
+||~~Arrhythmia_S~~||106||varchar||Ignored For No Enum||
+||!LowCardiacOutput||107||varchar||||
+||Ventilation||108||varchar||||
+||~~!PulmonaryComplications~~||109||varchar||Ignored For No Enum||
+||!RenalComplications||110||varchar||||
+||!GastrointestinalComplications||111||varchar||||
+||!InfectiveComplications||112||varchar||||
+||!CauseOfDeath||113||varchar||||
+||AdmittedFrom_hospitalNameOrWard||114||varchar||||
+||~~!AdmittedToCardiacSurgery~~||115||datetime||Ignored For Datatype||
+||~~!DischargedFromCardiacSurgery~~||116||datetime||Ignored For Datatype||
+||!TotalCardiacSurgeryLosDays||117||float||||
+||~~!DateOfFollowUp~~||118||datetime||Ignored For Datatype||
+||!BloodUsed||119||varchar||||
+||!MutisystemFailure||120||varchar||||
+||~~!DateFirstAdmittedToCicu~~||121||datetime||Ignored For Datatype||
+||~~!DateFirstDischargedFromCicu~~||122||datetime||Ignored For Datatype||
+||!TotalFirstStayOnCicu||123||float||||
+||!ReAdmittedToCicu||124||varchar||||
+||~~!DateOfSecondAdmissionToCicu~~||125||datetime||Ignored For Datatype||
+||~~!DateOfSecondDischargeFromCicu~~||126||datetime||Ignored For Datatype||
+||SecondAdmissionTotalStay_nignts||127||float||||
+||~~!DateOfThirdAdmissionToCicu~~||128||datetime||Ignored For Datatype||
+||~~!DateOfThirdDischargeFromCicu~~||129||datetime||Ignored For Datatype||
+||ThirdAdmissionToCicuTotalStay_nights||130||float||||
+||!InsertionOfPacemakerWiresViaVatsProcedure||131||varchar||||
+||!IntubationTimeInHours||132||int||||
+||!AuditTrail||133||varchar||||
+||~~!NameOfDoctorCompletingBooklet~~||134||varchar||Ignored For No Enum||
+||!SecondPrimaryPerfusionist||135||varchar||||
+||!SecondBypass||136||varchar||||
+||!SecondMyocardialProtection||137||varchar||||
+||!SecondCardioplegiaSolution||138||varchar||||
+||!SecondCardioplegiaInfusion||139||varchar||||
+||!SecondCardioplegiaTemperature||140||varchar||||
+||!SecondCardioplegiaTiming||141||varchar||||
+||SecondNon_CardioplegiaMyocardialProtection||142||varchar||||
+||!DoesPatientNeedAFollowUpAppiontment||143||varchar||||
+||~~Comments~~||144||varchar||Ignored For No Enum||
+||~~!MedicalRecordNumber~~||145||varchar||Ignored For No Enum||
+||~~DateAddedToW_l~~||146||datetime||Ignored For Datatype||
+||AddedToW_l||147||varchar||||
+||~~!DateOfFourthAdmissionToCicu~~||148||datetime||Ignored For Datatype||
+||~~!DateOfFourthDischargeFromCicu~~||149||datetime||Ignored For Datatype||
+||~~!DateOfFifthAdmissionToCicu~~||150||datetime||Ignored For Datatype||
+||~~!DateOfFifthDischargeFromCicu~~||151||datetime||Ignored For Datatype||
+||!CumulativeStayFirstAndSecondAdmissionToCicu||152||float||||
+||Cumulative1st2ndAnd3rdStayInCicu||153||float||||
+||FourthAdmissionToCicuTotalStay_nights||154||float||||
+||Cumulative1st2nd3rd4thStayInCicu||155||float||||
+||FifthAdmissionToCicuTotalStay_nights||156||float||||
+||Cumulative1sr2nd3rd4th5thStayInCicu||157||float||||
+||!PatientIdentifiedForSamedayAdmission||158||varchar||||
+||~~!ProposedDateOfAdmission~~||159||datetime||Ignored For Datatype||
+||!IfNotOperatedOnSamedayGiveReason||160||varchar||||
+||!SecondBypassTotal||161||int||||
+||!SecondCrossClampTotal||162||int||||
+||!SecondCiculatoryArrestTotal||163||int||||
+||!CouncilCase||164||varchar||||
+||!InitialConsultantInJointCase||165||varchar||||
+||!ArrhythmiaOtherComplicationFreeText||166||varchar||||
+||!LowCardiacOutputOtherComplicationFreeText||167||varchar||||
+||!PulmonaryOtherComplicationFreeText||168||varchar||||
+||!RenalOtherComplicationFreeText||169||varchar||||
+||!GastrointestinalOtherComplicationFreeText||170||varchar||||
+||~~!InfectiveOtherComplicationFreeText~~||171||varchar||Ignored For No Enum||
+||!SickNoteOffered||172||varchar||||
+||!IfSickNoteOfferedDurationInDays||173||int||||
+||~~!AdviceToGpAndAnyMedicationChangedOrStopped~~||174||varchar||Ignored For No Enum||
+||~~!NameOfDischargingDoctor~~||175||varchar||Ignored For No Enum||
+||~~!GradeOfDischargingDoctor~~||176||varchar||Ignored For No Enum||
+||~~!PagerNumber~~||177||varchar||Ignored For No Enum||
+||~~!DrugSensitivity~~||178||varchar||Ignored For No Enum||
+||~~Drug1~~||179||varchar||Ignored For No Enum||
+||DrugRoute1||180||varchar||||
+||NumberOfDays1||181||int||||
+||Continue1||182||varchar||||
+||~~Drug2~~||183||varchar||Ignored For No Enum||
+||DrugRoute2||184||varchar||||
+||NumberOfDays2||185||int||||
+||Continue2||186||varchar||||
+||~~Drug3~~||187||varchar||Ignored For No Enum||
+||DrugRoute3||188||varchar||||
+||NumberOfDays3||189||int||||
+||Continue3||190||varchar||||
+||~~Drug4~~||191||varchar||Ignored For No Enum||
+||DrugRoute4||192||varchar||||
+||NumberOfDays4||193||int||||
+||Continue4||194||varchar||||
+||~~Drug5~~||195||varchar||Ignored For No Enum||
+||DrugRoute5||196||varchar||||
+||NumberOfDays5||197||int||||
+||Continue5||198||varchar||||
+||~~Drug6~~||199||varchar||Ignored For No Enum||
+||DrugRoute6||200||varchar||||
+||NumberOfDays6||201||int||||
+||Continue6||202||varchar||||
+||~~Drug7~~||203||varchar||Ignored For No Enum||
+||DrugRoute7||204||varchar||||
+||NumberOfDays7||205||int||||
+||Continue7||206||varchar||||
+||~~Drug8~~||207||varchar||Ignored For No Enum||
+||DrugRoute8||208||varchar||||
+||NumberOfDays8||209||int||||
+||Continue8||210||varchar||||
+||~~Drug9~~||211||varchar||Ignored For No Enum||
+||DrugRoute9||212||varchar||||
+||NumberOfDays9||213||int||||
+||Continue9||214||varchar||||
+||~~Drug10~~||215||varchar||Ignored For No Enum||
+||DrugRoute10||216||varchar||||
+||NumberOfDays10||217||int||||
+||Continue10||218||varchar||||
+||~~Drug11~~||219||varchar||Ignored For No Enum||
+||DrugRoute11||220||varchar||||
+||NumberOfDays11||221||int||||
+||Continue11||222||varchar||||
+||~~Drug12~~||223||varchar||Ignored For No Enum||
+||DrugRoute12||224||varchar||||
+||NumberOfDays12||225||int||||
+||Continue12||226||varchar||||
+||Drug13||227||varchar||||
+||DrugRoute13||228||varchar||||
+||NumberOfDays13||229||int||||
+||Continue13||230||varchar||||
+||Drug14||231||varchar||||
+||DrugRoute14||232||varchar||||
+||NumberOfDays14||233||int||||
+||Continue14||234||varchar||||
+||Drug15||235||varchar||||
+||DrugRoute15||236||varchar||||
+||NumberOfDays15||237||int||||
+||Continue15||238||varchar||||
+||Drug16||239||varchar||||
+||DrugRoute16||240||varchar||||
+||NumberOfDays16||241||int||||
+||Continue16||242||varchar||||
+||Drug17||243||varchar||||
+||DrugRoute17||244||varchar||||
+||NumberOfDays17||245||int||||
+||Continue17||246||varchar||||
+||Drug18||247||varchar||||
+||DrugRoute18||248||varchar||||
+||NumberOfDays18||249||int||||
+||Continue18||250||varchar||||
+||~~DrugNameAndStrength19~~||251||varchar||Ignored For No Enum||
+||DrugForm19||252||varchar||||
+||~~DrugDose19~~||253||varchar||Ignored For No Enum||
+||DrugRoute19||254||varchar||||
+||DrugFrequency19||255||varchar||||
+||NumberOfDays19||256||int||||
+||Continue19||257||varchar||||
+||~~DrugNameAndStrength20~~||258||varchar||Ignored For No Enum||
+||DrugForm20||259||varchar||||
+||~~DrugDose20~~||260||varchar||Ignored For No Enum||
+||DrugRoute20||261||varchar||||
+||DrugFrequency20||262||varchar||||
+||NumberOfDays20||263||int||||
+||Continue20||264||varchar||||
+||~~DrugNameAndStrength21~~||265||varchar||Ignored For No Enum||
+||DrugForm21||266||varchar||||
+||~~DrugDose21~~||267||varchar||Ignored For No Enum||
+||DrugRoute21||268||varchar||||
+||DrugFrequency21||269||varchar||||
+||NumberOfDays21||270||int||||
+||Continue21||271||varchar||||
+||~~DrugNameAndStrength22~~||272||varchar||Ignored For No Enum||
+||DrugForm22||273||varchar||||
+||~~DrugDose22~~||274||varchar||Ignored For No Enum||
+||DrugRoute22||275||varchar||||
+||DrugFrequency22||276||varchar||||
+||NumberOfDays22||277||int||||
+||Continue22||278||varchar||||
+||~~DrugNameAndStrength23~~||279||varchar||Ignored For No Enum||
+||DrugForm23||280||varchar||||
+||~~DrugDose23~~||281||varchar||Ignored For No Enum||
+||DrugRoute23||282||varchar||||
+||DrugFrequency23||283||varchar||||
+||NumberOfDays23||284||int||||
+||Continue23||285||varchar||||
+||DrugNameAndStrength24||286||varchar||||
+||DrugForm24||287||varchar||||
+||DrugDose24||288||varchar||||
+||DrugRoute24||289||varchar||||
+||DrugFrequency24||290||varchar||||
+||NumberOfDays24||291||int||||
+||Continue24||292||varchar||||
+||!DischargeWard||293||varchar||||
+||Pharmacist||294||varchar||||
+||~~!ManagementPlan~~||295||varchar||Ignored For No Enum||
+||!FollowUpRequired||296||varchar||||
+||~~FollowUpTimeInWeeks_months~~||297||varchar||Ignored For No Enum||
+||!MedicationChangedByPharmacist||298||varchar||||
+||!StatePharmacistChanges||299||varchar||||
+||~~!InformationGivenToPatient~~||300||varchar||Ignored For No Enum||
+||~~!DateTimeRecordCreated~~||301||datetime||Ignored For Datatype||
+||~~!DateTimeRecordLastChanged~~||302||datetime||Ignored For Datatype||
+||!EnteredByTag||303||varchar||||
+||!HospitalTag||304||varchar||||
+||WHO_REGISTRY_INDICATOR||305||varchar||||
+||~~WHO_POSSIBLE_DUPLICATE~~||306||char||Ignored For Datatype||
 
 === CS2003F_PreProcedure
 
 ||Field Name||Column ID||Type||Comments||
+||~~!EntryId~~||1||int||Ignored For Field Name||
+||~~!PatientId~~||2||int||Ignored For Field Name||
+||~~DateOfOperation_ccad~~||3||datetime||Ignored For Datatype||
+||~~TimeOfOperation_ccad~~||4||datetime||Ignored For Datatype||
+||!EntryStatus||5||varchar||||
+||~~!PreviousEntry~~||6||int||Ignored For Field Name||
+||~~!NextEntry~~||7||int||Ignored For Field Name||
+||!AgeAtSurgery||8||int||||
+||Gender||9||varchar||||
+||~~!DateOfAdmission~~||10||datetime||Ignored For Datatype||
+||AnginaStatusPre_Surgery||11||varchar||||
+||DyspnoeaStatusPre_Surgery||12||varchar||||
+||!NumberOfPreviousMis||13||varchar||||
+||!IntervalBetweenOperationAndLastMi||14||varchar||||
+||!PreviousPci||15||varchar||||
+||~~!DateOfLastPci~~||16||datetime||Ignored For Datatype||
+||PreviousCardiac_VascularOrThoracicSurgicalInterven||17||varchar||||
+||~~!DateOfLastCardiacOperation~~||18||datetime||Ignored For Datatype||
+||!DiabetesManagement||19||varchar||||
+||Hypertension||20||varchar||||
+||!CigaretteSmokingHistory||21||varchar||||
+||!RenalDiseaseAtTheTimeOfSurgery||22||varchar||||
+||!HistoryOfPulmonaryDisease||23||varchar||||
+||!HistoryOfNeurologicalDisease||24||varchar||||
+||Pre_OperativeHeartRhythm||25||varchar||||
+||~~!DateOfCatheterisation~~||26||datetime||Ignored For Datatype||
+||PaSystolic_ifKnown||27||int||||
+||AvGradient_ifKnown||28||int||||
+||Lvedp_ifKnown||29||int||||
+||MeanPawp_la_ifKnown||30||int||||
+||IvNitrates_HeparinOfAnyKind||31||varchar||||
+||!IvInotropesPriorToAnaesthesia||32||varchar||||
+||Ventilated||33||varchar||||
+||!CardiogenicShock||34||varchar||||
+||!OperativePriority||35||varchar||||
+||!FirstOperatorGrade||36||varchar||||
+||FirstOperator_CalmanYearOfTrainee||37||varchar||||
+||!CardiacProcedures||38||varchar||||
+||!NumberOfDistalCoronaryAnastomoses||39||int||||
+||NumberOfValvesReplaced_Repaired||40||int||||
+||!NumberOfSegmentsOfTheAorta||41||int||||
+||!OtherCardiacProcedures||42||varchar||||
+||!OtherThoracicAndVascularProcedures||43||varchar||||
+||NeurologicalDysfunction_euroscore||44||varchar||||
+||!LeftMainStemDisease||45||varchar||||
+||!ExtentOfCoronaryArteryDisease||46||varchar||||
+||!ExtracardiacArteriopathy||47||varchar||||
+||!EjectionFractionCategory||48||varchar||||
+||!AdmissionCategory||49||varchar||||
+||!CarotidBruits||50||varchar||||
+||!LeftOrRightHeartCatheterisation||51||varchar||||
+||EjectionFractionValue_ifKnown||52||int||||
+||~~!DateAndTimeOfOperation~~||53||varchar||Ignored For No Enum||
+||!NumberOfPreviousHeartOperations||54||int||||
+||!ResponsibleConsultantSurgeon||55||varchar||||
+||~~!FirstOperator~~||56||varchar||Ignored For No Enum||
+||~~!FirstAssistant~~||57||varchar||Ignored For No Enum||
+||!FirstAssistantGrade||58||varchar||||
+||FirstAssistant_CalmanYearOfTrainee||59||varchar||||
+||~~!ResponsibleConsultantAnaesthetist~~||60||varchar||Ignored For No Enum||
+||~~!OperationFindings~~||61||varchar||Ignored For No Enum||
+||~~!ReferringCardiologist~~||62||varchar||Ignored For No Enum||
+||~~!DateOfReferral~~||63||datetime||Ignored For Datatype||
+||~~!DrugsOnAdmission~~||64||varchar||Ignored For No Enum||
+||~~Allergies~~||65||varchar||Ignored For No Enum||
+||~~!AllOtherAssistants~~||66||varchar||Ignored For No Enum||
+||!WaitingListStatusUpdated||67||varchar||||
+||!SprCases||68||varchar||||
+||~~!DateOfCurrentStatus~~||69||datetime||Ignored For Datatype||
+||~~!DateOfEndStatus~~||70||datetime||Ignored For Datatype||
+||~~!DateTimeRecordCreated~~||71||datetime||Ignored For Datatype||
+||~~!DateTimeRecordLastChanged~~||72||datetime||Ignored For Datatype||
+||!EnteredByTag||73||varchar||||
+||!EntryCurrentStatus||74||varchar||||
+||!EntryEndStatus||75||varchar||||
+||!HospitalTag||76||varchar||||
+||WHO_RESPONSIBLE_CONSULTANT_SURGEON||77||varchar||||
+||WHO_AGE_AT_OPERATION||78||int||||
+||WHO_REGISTRY_INDICATOR||79||varchar||||
+||~~WHO_POSSIBLE_DUPLICATE~~||80||char||Ignored For Datatype||
 
 === CS2010F_PostProcedure
 
 ||Field Name||Column ID||Type||Comments||
+||~~!EntryId~~||1||int||Ignored For Field Name||
+||~~!PatientId~~||2||int||Ignored For Field Name||
+||!PreOperativeStayInDays||3||int||||
+||!PostOperativeStayInDays||4||int||||
+||!TotalStayInDays||5||int||||
+||!ParsonnetScoreFromHardData||6||int||||
+||!CardiopulmonaryBypass||7||varchar||||
+||!ParsonnetScoreWithCatastrophicStatesAndRareConditi||8||int||||
+||!PredominantMethodOfMyocardialProtection||9||varchar||||
+||Parsonnet_AdditionsForCatastrophicStates||10||int||||
+||Parsonnet_AdditionsForRareConditions||11||int||||
+||!AdditiveEuroscore||12||int||||
+||!SctsComplexCabgBayesScore||13||float||||
+||!LogisticEuroscore||14||float||||
+||Cardioplegia_Solution||15||varchar||||
+||Cardioplegia_Temperature||16||varchar||||
+||Cardioplegia_Timing||17||varchar||||
+||Non_CardioplegicMyocardialProtection||18||varchar||||
+||!IntraAorticBalloonPumpUsed||19||varchar||||
+||ReasonForIntra_OperativeIntra_AorticBalloonPumpUse||20||varchar||||
+||!HeightInCm||21||int||||
+||!WeightInKg||22||float||||
+||!CumulativeBypassTime||23||int||||
+||!CumulativeCrossClampTime||24||int||||
+||!TotalCirculatoryArrestTime||25||int||||
+||NewPost_OperativeNeurologicalDysfunction||26||varchar||||
+||!NewHaemofiltrationOrDialysis||27||varchar||||
+||!DischargeDestinationFromCardiothoracicWard||28||varchar||||
+||~~!DateOfDischargeOrDeath~~||29||date||Ignored For Datatype||
+||!BodySurfaceArea||30||float||||
+||!BodyMassIndex||31||float||||
+||Cardioplegia_InfusionMode||32||varchar||||
+||!EuroscoreMinumumDatasetCheck||33||varchar||||
+||!ParsonnetMinumumDatasetCheck||34||varchar||||
+||!NameOfGpAtTimeOfSurgery||35||varchar||||
+||!GpPracticeCodeAtTimeOfSurgery||36||varchar||||
+||!PctAtTimeOfSurgery||37||varchar||||
+||~~NameOfReferringGpAtTimeOfSurgeryType8~~||38||varchar||Ignored For No Enum||
+||!ToePerformed||39||varchar||||
+||Sonographer||40||varchar||||
+||Sonographist||41||varchar||||
+||!PrimaryPerfusionist||42||varchar||||
+||PcuPatient_pcu||43||varchar||||
+||DoesPatientMeetInterOperativeCriteria_pcu||44||varchar||||
+||AreaPatientAdmittedTo_pcu||45||varchar||||
+||AdmissionTimeToRecovery_cicu_pcu||46||varchar||||
+||ExtubationDateAndTime_pcu||47||varchar||||
+||WhatO2SystemWasUsed_pcu||48||varchar||||
+||TotalBloodLostOnDischargeFromRecovery_pcu||49||varchar||||
+||WereClottingProductsUsed_pcu||50||varchar||||
+||WhatProductsWereUsed_pcu||51||varchar||||
+||HowMuchColloidUsedInRecovery_pcu||52||varchar||||
+||TypeOfColloidUsed_pcu||53||varchar||||
+||PainScoreOnWaking_pcu||54||varchar||||
+||!AnalgesiaUsedPcu||55||varchar||||
+||TotalMorphineDoseUsedIncludingBolus_pcu||56||varchar||||
+||InotropesUsed_pcu||57||varchar||||
+||Dosage_pcu||58||varchar||||
+||WereThereAnyArrhythmias_pcu||59||varchar||||
+||PleaseStateArrhythmias_pcu||60||varchar||||
+||TreatmentOfArrhythmias_pcu||61||varchar||||
+||PotassiumUsed_pcu||62||varchar||||
+||PotassiumDoseInMmols_pcu||63||varchar||||
+||TemperatureOnAdmission_pcu||64||float||||
+||BairhuggerWithPatient_pcu||65||varchar||||
+||TimeOfDischarge_pcu||66||varchar||||
+||PlaceOfDischarge_pcu||67||varchar||||
+||DoesPatientMeetDischargeCriteria_pcu||68||varchar||||
+||WasPatientDischargedFromPcuToHdu_pcu||69||varchar||||
+||LowUrineOutput_pcu||70||varchar||||
+||IfNoStateWhy_pcu||71||varchar||||
+||IfNoWhy_pcu||72||varchar||||
+||AmountOfTimeIntubated_pcu||73||float||||
+||AmountOfTimeInRecovery_cicu_pcu||74||float||||
+||~~OverallComments_sa~~||75||text||Ignored For Datatype||
+||TeachingOfOtherStaffComments_sa||76||varchar||||
+||TeachingOfOtherStaffCommentsMade_sa||77||varchar||||
+||TeachingOfOtherStaffBySa_sa||78||varchar||||
+||~~IabpRemovalComments_sa~~||79||text||Ignored For Datatype||
+||IabpRemovalCommentsMade_sa||80||varchar||||
+||IabpRemovalBySa_sa||81||varchar||||
+||~~IabpInsertionComments_sa~~||82||text||Ignored For Datatype||
+||IabpInsertionCommentsMade_sa||83||varchar||||
+||IabpInsertionBySa_sa||84||varchar||||
+||~~SternotomyClosureComments_sa~~||85||text||Ignored For Datatype||
+||SternotomyClosureCommentsMade_sa||86||varchar||||
+||SternotomyClosureBySa_sa||87||varchar||||
+||SternotomyComments_sa||88||varchar||||
+||SternotomyCommentsMade_sa||89||varchar||||
+||SternotomyPerformedBySa_sa||90||varchar||||
+||ThirdSiteComments_sa||91||varchar||||
+||ThirdSiteCommentsMade_sa||92||varchar||||
+||ThirdSiteConduit_location_sa||93||varchar||||
+||SecondSiteComments_sa||94||varchar||||
+||SecondSiteCommentsMade_sa||95||varchar||||
+||SecondSiteConduit_location_sa||96||varchar||||
+||FirstSiteComments_sa||97||varchar||||
+||FirstSiteCommentsMade_sa||98||varchar||||
+||FirstSiteConduei_location_sa||99||varchar||||
+||ThirdAssistant_sa||100||varchar||||
+||SecondAssistant_sa||101||varchar||||
+||FirstAssistant_sa||102||varchar||||
+||SurgicalAssistant_sa||103||varchar||||
+||ReferralToOperation_days||104||float||||
+||Arrhythmia_S||105||varchar||||
+||!LowCardiacOutput||106||varchar||||
+||Ventilation||107||varchar||||
+||!PulmonaryComplications||108||varchar||||
+||!RenalComplications||109||varchar||||
+||!GastrointestinalComplications||110||varchar||||
+||!InfectiveComplications||111||varchar||||
+||!CauseOfDeath||112||varchar||||
+||AdmittedFrom_hospitalNameOrWard||113||varchar||||
+||~~!AdmittedToCardiacSurgery~~||114||date||Ignored For Datatype||
+||~~!DischargedFromCardiacSurgery~~||115||date||Ignored For Datatype||
+||!TotalCardiacSurgeryLosDays||116||float||||
+||~~!DateOfFollowUp~~||117||date||Ignored For Datatype||
+||!BloodUsed||118||varchar||||
+||!MutisystemFailure||119||varchar||||
+||~~!DateFirstAdmittedToCicu~~||120||date||Ignored For Datatype||
+||~~!DateFirstDischargedFromCicu~~||121||date||Ignored For Datatype||
+||!TotalFirstStayOnCicu||122||float||||
+||!ReAdmittedToCicu||123||varchar||||
+||~~!DateOfSecondAdmissionToCicu~~||124||date||Ignored For Datatype||
+||~~!DateOfSecondDischargeFromCicu~~||125||date||Ignored For Datatype||
+||SecondAdmissionTotalStay_nignts||126||float||||
+||~~!DateOfThirdAdmissionToCicu~~||127||date||Ignored For Datatype||
+||~~!DateOfThirdDischargeFromCicu~~||128||date||Ignored For Datatype||
+||ThirdAdmissionToCicuTotalStay_nights||129||float||||
+||!InsertionOfPacemakerWiresViaVatsProcedure||130||varchar||||
+||!IntubationTimeInHours||131||int||||
+||~~!AuditTrail~~||132||text||Ignored For Datatype||
+||!NameOfDoctorCompletingBooklet||133||varchar||||
+||!SecondPrimaryPerfusionist||134||varchar||||
+||!SecondBypass||135||varchar||||
+||!SecondMyocardialProtection||136||varchar||||
+||!SecondCardioplegiaSolution||137||varchar||||
+||!SecondCardioplegiaInfusion||138||varchar||||
+||!SecondCardioplegiaTemperature||139||varchar||||
+||!SecondCardioplegiaTiming||140||varchar||||
+||SecondNon_CardioplegiaMyocardialProtection||141||varchar||||
+||!DoesPatientNeedAFollowUpAppiontment||142||varchar||||
+||~~Comments~~||143||varchar||Ignored For No Enum||
+||!MedicalRecordNumber||144||varchar||||
+||~~DateAddedToW_l~~||145||date||Ignored For Datatype||
+||AddedToW_l||146||varchar||||
+||~~!DateOfFourthAdmissionToCicu~~||147||date||Ignored For Datatype||
+||~~!DateOfFourthDischargeFromCicu~~||148||date||Ignored For Datatype||
+||~~!DateOfFifthAdmissionToCicu~~||149||date||Ignored For Datatype||
+||~~!DateOfFifthDischargeFromCicu~~||150||date||Ignored For Datatype||
+||!CumulativeStayFirstAndSecondAdmissionToCicu||151||float||||
+||Cumulative1st2ndAnd3rdStayInCicu||152||float||||
+||FourthAdmissionToCicuTotalStay_nights||153||float||||
+||Cumulative1st2nd3rd4thStayInCicu||154||float||||
+||FifthAdmissionToCicuTotalStay_nights||155||float||||
+||Cumulative1sr2nd3rd4th5thStayInCicu||156||float||||
+||!PatientIdentifiedForSamedayAdmission||157||varchar||||
+||~~!ProposedDateOfAdmission~~||158||date||Ignored For Datatype||
+||!SecondBypassTotal||159||int||||
+||!SecondCrossClampTotal||160||int||||
+||!SecondCiculatoryArrestTotal||161||int||||
+||!CouncilCase||162||varchar||||
+||!InitialConsultantInJointCase||163||varchar||||
+||~~!ArrhythmiaOtherComplicationFreeText~~||164||text||Ignored For Datatype||
+||~~!LowCardiacOutputOtherComplicationFreeText~~||165||text||Ignored For Datatype||
+||~~!PulmonaryOtherComplicationFreeText~~||166||text||Ignored For Datatype||
+||~~!RenalOtherComplicationFreeText~~||167||text||Ignored For Datatype||
+||~~!GastrointestinalOtherComplicationFreeText~~||168||text||Ignored For Datatype||
+||!InfectiveOtherComplicationFreeText||169||varchar||||
+||!SickNoteOffered||170||varchar||||
+||!IfSickNoteOfferedDurationInDays||171||int||||
+||~~!AdviceToGp~~||172||varchar||Ignored For No Enum||
+||!NameOfDischargingDoctor||173||varchar||||
+||!GradeOfDischargingDoctor||174||varchar||||
+||!PagerNumber||175||varchar||||
+||~~!DrugSensitivity~~||176||varchar||Ignored For No Enum||
+||~~Drug1~~||177||varchar||Ignored For No Enum||
+||DrugRoute1||178||varchar||||
+||NumberOfDays1||179||int||||
+||Continue1||180||varchar||||
+||~~Drug2~~||181||varchar||Ignored For No Enum||
+||DrugRoute2||182||varchar||||
+||NumberOfDays2||183||int||||
+||Continue2||184||varchar||||
+||~~Drug3~~||185||varchar||Ignored For No Enum||
+||DrugRoute3||186||varchar||||
+||NumberOfDays3||187||int||||
+||Continue3||188||varchar||||
+||~~Drug4~~||189||varchar||Ignored For No Enum||
+||DrugRoute4||190||varchar||||
+||NumberOfDays4||191||int||||
+||Continue4||192||varchar||||
+||~~Drug5~~||193||varchar||Ignored For No Enum||
+||DrugRoute5||194||varchar||||
+||NumberOfDays5||195||int||||
+||Continue5||196||varchar||||
+||~~Drug6~~||197||varchar||Ignored For No Enum||
+||DrugRoute6||198||varchar||||
+||NumberOfDays6||199||int||||
+||Continue6||200||varchar||||
+||~~Drug7~~||201||varchar||Ignored For No Enum||
+||DrugRoute7||202||varchar||||
+||NumberOfDays7||203||int||||
+||Continue7||204||varchar||||
+||~~Drug8~~||205||varchar||Ignored For No Enum||
+||DrugRoute8||206||varchar||||
+||NumberOfDays8||207||int||||
+||Continue8||208||varchar||||
+||~~Drug9~~||209||varchar||Ignored For No Enum||
+||DrugRoute9||210||varchar||||
+||NumberOfDays9||211||int||||
+||Continue9||212||varchar||||
+||~~Drug10~~||213||varchar||Ignored For No Enum||
+||DrugRoute10||214||varchar||||
+||NumberOfDays10||215||int||||
+||Continue10||216||varchar||||
+||Drug11||217||varchar||||
+||DrugRoute11||218||varchar||||
+||NumberOfDays11||219||int||||
+||Continue11||220||varchar||||
+||Drug12||221||varchar||||
+||DrugRoute12||222||varchar||||
+||NumberOfDays12||223||int||||
+||Continue12||224||varchar||||
+||Drug13||225||varchar||||
+||DrugRoute13||226||varchar||||
+||NumberOfDays13||227||int||||
+||Continue13||228||varchar||||
+||Drug14||229||varchar||||
+||DrugRoute14||230||varchar||||
+||NumberOfDays14||231||int||||
+||Continue14||232||varchar||||
+||Drug15||233||varchar||||
+||DrugRoute15||234||varchar||||
+||NumberOfDays15||235||int||||
+||Continue15||236||varchar||||
+||Drug16||237||varchar||||
+||DrugRoute16||238||varchar||||
+||NumberOfDays16||239||int||||
+||Continue16||240||varchar||||
+||Drug17||241||varchar||||
+||DrugRoute17||242||varchar||||
+||NumberOfDays17||243||int||||
+||Continue17||244||varchar||||
+||Drug18||245||varchar||||
+||DrugRoute18||246||varchar||||
+||NumberOfDays18||247||int||||
+||Continue18||248||varchar||||
+||~~DrugNameAndStrength19~~||249||varchar||Ignored For No Enum||
+||DrugForm19||250||varchar||||
+||~~DrugDose19~~||251||varchar||Ignored For No Enum||
+||DrugRoute19||252||varchar||||
+||DrugFrequency19||253||varchar||||
+||NumberOfDays19||254||int||||
+||Continue19||255||varchar||||
+||~~DrugNameAndStrength20~~||256||varchar||Ignored For No Enum||
+||DrugForm20||257||varchar||||
+||~~DrugDose20~~||258||varchar||Ignored For No Enum||
+||DrugRoute20||259||varchar||||
+||DrugFrequency20||260||varchar||||
+||NumberOfDays20||261||int||||
+||Continue20||262||varchar||||
+||DrugNameAndStrength21||263||varchar||||
+||DrugForm21||264||varchar||||
+||DrugDose21||265||varchar||||
+||DrugRoute21||266||varchar||||
+||DrugFrequency21||267||varchar||||
+||NumberOfDays21||268||int||||
+||Continue21||269||varchar||||
+||DrugNameAndStrength22||270||varchar||||
+||DrugForm22||271||varchar||||
+||DrugDose22||272||varchar||||
+||DrugRoute22||273||varchar||||
+||DrugFrequency22||274||varchar||||
+||NumberOfDays22||275||int||||
+||Continue22||276||varchar||||
+||DrugNameAndStrength23||277||varchar||||
+||DrugForm23||278||varchar||||
+||DrugDose23||279||varchar||||
+||DrugRoute23||280||varchar||||
+||DrugFrequency23||281||varchar||||
+||NumberOfDays23||282||int||||
+||Continue23||283||varchar||||
+||DrugNameAndStrength24||284||varchar||||
+||DrugForm24||285||varchar||||
+||DrugDose24||286||varchar||||
+||DrugRoute24||287||varchar||||
+||DrugFrequency24||288||varchar||||
+||NumberOfDays24||289||int||||
+||Continue24||290||varchar||||
+||!DischargeWard||291||varchar||||
+||Pharmacist||292||varchar||||
+||~~!ManagementPlan~~||293||varchar||Ignored For No Enum||
+||!FollowUpRequired||294||varchar||||
+||FollowUpTimeInWeeks_months||295||varchar||||
+||!MedicationChangedByPharmacist||296||varchar||||
+||~~!StatePharmacistChanges~~||297||text||Ignored For Datatype||
+||~~!InformationGivenToPatient~~||298||varchar||Ignored For No Enum||
+||~~!DateTimeRecordCreated~~||299||varchar||Ignored For No Enum||
+||~~!DateTimeRecordLastChanged~~||300||varchar||Ignored For No Enum||
+||!EnteredByTag||301||varchar||||
+||!HospitalTag||302||varchar||||
+
 
 === CS2010F_PreProcedure
 
 ||Field Name||Column ID||Type||Comments||
+||~~!EntryId~~||1||int||Ignored For Field Name||
+||~~!PatientId~~||2||int||Ignored For Field Name||
+||~~!DateOfOperation~~||3||date||Ignored For Datatype||
+||~~!TimeOfEntry~~||4||time||Ignored For Datatype||
+||!EntryStatus||5||varchar||||
+||~~!PreviousEntry~~||6||int||Ignored For Field Name||
+||~~!NextEntry~~||7||int||Ignored For Field Name||
+||!AgeAtOperation||8||int||||
+||Gender||9||varchar||||
+||~~!DateOfAdmission~~||10||date||Ignored For Datatype||
+||AnginaStatusPre_Surgery||11||varchar||||
+||DyspnoeaStatusPre_Surgery||12||varchar||||
+||!NumberOfPreviousMis||13||varchar||||
+||!IntervalBetweenSurgeryAndLastMi||14||varchar||||
+||!PreviousPci||15||varchar||||
+||!PreviousCardiacSurgery||16||varchar||||
+||~~!DateOfLastCardiacOperation~~||17||date||Ignored For Datatype||
+||!DiabetesManagement||18||varchar||||
+||!HistoryOfHypertension||19||varchar||||
+||!CigaretteSmokingHistory||20||varchar||||
+||!HistoryOfPulmonaryDisease||21||varchar||||
+||!HistoryOfNeurologicalDisease||22||varchar||||
+||Pre_OperativeHeartRhythm||23||varchar||||
+||~~!DateOfLastCatheterisation~~||24||date||Ignored For Datatype||
+||!PaSystolic||25||int||||
+||!IntravenousNitratesOrAnyHeparin||26||varchar||||
+||!IntravenousInotropesPriorToAnaesthesia||27||varchar||||
+||!VentilatedPreOperation||28||varchar||||
+||CardiogenicShock_pre_Operation||29||varchar||||
+||!OperativeUrgency||30||varchar||||
+||!FirstOperatorGrade||31||varchar||||
+||FirstOperator_CalmanYearOfTrainee||32||varchar||||
+||!CardiacProcedures||33||varchar||||
+||!OtherCardiacProcedures||34||varchar||||
+||!OtherThoracicAndVascularProcedures||35||varchar||||
+||!LeftMainStemDisease||36||varchar||||
+||!ExtentOfCoronaryVesselDisease||37||varchar||||
+||!ExtracardiacArteriopathy||38||varchar||||
+||!EjectionFractionCategory||39||varchar||||
+||!AdministrativeCategory||40||varchar||||
+||~~!DateAndTimeOfOperation~~||41||varchar||Ignored For No Enum||
+||!NumberOfPreviousHeartOperations||42||int||||
+||!ResponsibleConsultantSurgeon||43||varchar||||
+||!FirstOperator||44||varchar||||
+||!FirstAssistant||45||varchar||||
+||!FirstAssistantGrade||46||varchar||||
+||FirstAssistant_CalmanYearOfTrainee||47||varchar||||
+||!ResponsibleConsultantAnaesthetist||48||varchar||||
+||~~!OperationFindings~~||49||varchar||Ignored For No Enum||
+||!ReferringCardiologist||50||varchar||||
+||~~!DateOfReferral~~||51||date||Ignored For Datatype||
+||!DrugsOnAdmission||52||varchar||||
+||Allergies||53||varchar||||
+||!AllOtherAssistants||54||varchar||||
+||!WaitingListStatusUpdated||55||varchar||||
+||!SprCases||56||varchar||||
+||~~!DateOfCurrentStatus~~||57||date||Ignored For Datatype||
+||~~!DateOfEndStatus~~||58||date||Ignored For Datatype||
+||~~!DateTimeRecordCreated~~||59||varchar||Ignored For No Enum||
+||~~!DateTimeRecordLastChanged~~||60||varchar||Ignored For No Enum||
+||!EnteredByTag||61||varchar||||
+||!EntryCurrentStatus||62||varchar||||
+||!EntryEndStatus||63||varchar||||
+||!HospitalTag||64||varchar||||
 
 === EPS_EPSINIVW
 
 ||Field Name||Column ID||Type||Comments||
+||~~!EntryId~~||1||int||Ignored For Field Name||
+||~~!PatientId~~||2||int||Ignored For Field Name||
+||~~!DateOfEntry~~||3||date||Ignored For Datatype||
+||~~!TimeofEPSRFA~~||4||time||Ignored For Datatype||
+||!EntryStatus||5||varchar||||
+||~~!PreviousEntry~~||6||int||Ignored For Field Name||
+||~~!NextEntry~~||7||int||Ignored For Field Name||
+||~~!DateOfAdmission~~||8||date||Ignored For Datatype||
+||~~!DateOfDischarge~~||9||date||Ignored For Datatype||
+||~~!DateAddedToWaitingList~~||10||date||Ignored For Datatype||
+||!HospitalIdentifier||11||varchar||||
+||!PatientGender||12||varchar||||
+||!AgeAtOperation||13||int||||
+||!PatientEthnicGroup||14||varchar||||
+||!PatientAdminStatus||15||varchar||||
+||IsThisARe_Do||16||varchar||||
+||Preeps_ablationAetiology2||17||varchar||||
+||Preeps_ablationEcg||18||varchar||||
+||~~Prepacing_eps_ablationPresentingSymptom~~||19||varchar||Ignored For No Enum||
+||!GeneratorPacingMode||20||varchar||||
+||Preeps_ablationPreviousIntervention||21||varchar||||
+||Preeps_ablationArrhythmia||22||varchar||||
+||Eps_ablationIndicationForIntervention||23||varchar||||
+||Preicd_ablationQrsDuration||24||int||||
+||~~Date_timeOfProcedure~~||25||varchar||Ignored For No Enum||
+||!ProcedureUrgency||26||varchar||||
+||!OperativeUrgency||27||varchar||||
+||~~!PrimaryOperator~~||28||varchar||Ignored For No Enum||
+||!FirstOperatorStatus||29||varchar||||
+||~~!SecondOperator~~||30||varchar||Ignored For No Enum||
+||!SecondOperatorStatus||31||varchar||||
+||!ThirdOperator||32||varchar||||
+||!ThirdOperatorStatus||33||varchar||||
+||~~Ccso~~||34||varchar||Ignored For No Enum||
+||~~AblationProcedure_s~~||35||varchar||Ignored For No Enum||
+||~~!AccessoryPathway~~||36||varchar||Ignored For No Enum||
+||!NumberOfElectrodeCatheters||37||int||||
+||!MappingTechnique||38||varchar||||
+||!TransseptalApproach||39||varchar||||
+||Anticoagulation||40||varchar||||
+||HeparinDose_iu||41||int||||
+||!TotalFluoroscopyTime||42||float||||
+||~~!ProcedureStartTime~~||43||varchar||Ignored For No Enum||
+||~~!ProcedureEndTime~~||44||varchar||Ignored For No Enum||
+||!ProcedureDuration||45||int||||
+||!AblationAttempted||46||varchar||||
+||!WaitingTime||47||int||||
+||!WhyAblationNotAttempted||48||varchar||||
+||!NumberOfEnergyApplications||49||int||||
+||!TotalTimeOfEnergyApplication||50||int||||
+||!AblationEnergySource||51||varchar||||
+||~~Catheter~~||52||varchar||Ignored For No Enum||
+||~~!CatheterReach~~||53||varchar||Ignored For No Enum||
+||Ga||54||varchar||||
+||!WhichPulmonaryVeinsAblated||55||varchar||||
+||Success||56||varchar||||
+||!TransientHeartBlock||57||varchar||||
+||!AblationComplications||58||varchar||||
+||!AvBlock||59||varchar||||
+||!DeviceImplanted||60||varchar||||
+||~~IntraopDrugs2~~||61||varchar||Ignored For No Enum||
+||~~ProcedureReport_comment~~||62||varchar||Ignored For No Enum||
+||Early_24hrs_Recurrence||63||varchar||||
+||!ChestDrain||64||varchar||||
+||!PericardialTap||65||varchar||||
+||!ArterialRepair||66||varchar||||
+||!DeathOnSameAdmission||67||varchar||||
+||!LateRecurrenceOfArrhythmia||68||varchar||||
+||TimeToRecurrence_months||69||int||||
+||~~DateLastFollow_Up~~||70||date||Ignored For Datatype||
+||!PreOpStay||71||int||||
+||!PostOpStay||72||int||||
+||!TotalHospitalStay||73||int||||
+||!TotalTimeOnWaitingList||74||int||||
+||~~!ReferringGpOrDentist~~||75||varchar||Ignored For No Enum||
+||~~!NameOfReferringGpOrDentist~~||76||varchar||Ignored For No Enum||
+||~~!GpPracticeCode~~||77||varchar||Ignored For No Enum||
+||~~Pct~~||78||varchar||Ignored For No Enum||
+||~~!MedicalRecordNumberAtTimeOfEntry~~||79||varchar||Ignored For No Enum||
+||!AuditTrail||80||varchar||||
+||~~!CatheterCcad~~||81||varchar||Ignored For No Enum||
+||!CatheterReachCcad||82||varchar||||
+||~~!AfAblationStrategies~~||83||varchar||Ignored For No Enum||
+||Score||84||int||||
+||Tvac_pvac||85||varchar||||
+||Height||86||float||||
+||Weight||87||float||||
+||Bmi||88||float||||
+||!ScreeningDose||89||float||||
+||!ExceededDrl||90||varchar||||
+||Radiographer||91||varchar||||
+||!ReasonForExceedingDrl||92||varchar||||
+||~~!DateOfCurrentStatus~~||93||date||Ignored For Datatype||
+||~~!DateOfEndStatus~~||94||date||Ignored For Datatype||
+||~~!DateTimeRecordCreated~~||95||varchar||Ignored For No Enum||
+||~~!DateTimeRecordLastChanged~~||96||varchar||Ignored For No Enum||
+||!EnteredByTag||97||varchar||||
+||!EntryCurrentStatus||98||varchar||||
+||!EntryEndStatus||99||varchar||||
+||!HospitalTag||100||varchar||||
+||!ImportLinkId||101||int||||
 
 === GGHMINAP_GGHMINAP
 
 ||Field Name||Column ID||Type||Comments||
+||~~!EntryId~~||1||int||Ignored For Field Name||
+||~~!PatientId~~||2||int||Ignored For Field Name||
+||~~!DateofHospitalAdmission~~||3||datetime||Ignored For Datatype||
+||~~!TimeofHospitalAdmission~~||4||datetime||Ignored For Datatype||
+||!EntryStatus||5||varchar||||
+||~~!PreviousEntry~~||6||int||Ignored For Field Name||
+||~~!NextEntry~~||7||int||Ignored For Field Name||
+||Age||8||int||||
+||~~!DateOfAdmissionToCcu~~||9||datetime||Ignored For Datatype||
+||!DirectAdmission||10||varchar||||
+||!GenderCcad||11||varchar||||
+||!EthnicOriginCcad||12||varchar||||
+||!PatientAdminStatusCcad||13||varchar||||
+||!HospitalCentreCode||14||varchar||||
+||~~!GpPracticeCodeCcad~~||15||varchar||Ignored For No Enum||
+||!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||||
+||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||||
+||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||Ignored For No Enum||
+||~~!OnsetOfSymptomsCcad~~||52||varchar||Ignored For No Enum||
+||~~!CallForHelpCcad~~||53||varchar||Ignored For No Enum||
+||~~!ArrivalOfFirstProfessionalHelpCcad~~||54||varchar||Ignored For No Enum||
+||~~!ArrivalOfEmergencyServiceCcad~~||55||varchar||Ignored For No Enum||
+||~~!AmbulanceJobNumberCcad~~||56||varchar||Ignored For No Enum||
+||~~!ArrivalAtHospitalCcad~~||57||varchar||Ignored For No Enum||
+||WasReperfusionAttempted_Ccad||58||varchar||||
+||!ReasonThrombolyticTreatmentNotGivenCcad||59||varchar||||
+||~~!StartOfReperfusionTreatmentCcad~~||60||varchar||Ignored For No Enum||
+||!DelayBeforeTreatmentCcad||61||varchar||||
+||WhereWasInitialReperfusionTreatmentGiven_Ccad||62||varchar||||
+||WhoTookTheInitialDecisionToAttemptReperfusion_Ccad||63||varchar||||
+||~~!FirstCardiacArrestCcad~~||64||varchar||Ignored For No Enum||
+||!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||||
+||Iv2b_3aAgentCcad||77||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||Ignored For Datatype||
+||~~!DateOfDischargeFromCcu~~||91||datetime||Ignored For Datatype||
+||!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 For Datatype||
+||!ModeOfDischargeCcad||112||varchar||||
+||~~!DateOfTransferForDayCaseInvestigationCcad~~||113||datetime||Ignored For Datatype||
+||~~!DateOfAngioPerformedLocallyCcad~~||114||datetime||Ignored For Datatype||
+||~~!DateOfFirstInterventionOrSurgeryPerformedLocallyCc~~||115||datetime||Ignored For Datatype||
+||!ReferralCentreCcad||116||varchar||||
+||!ReferringHospitalCcad||117||varchar||||
+||~~!PatientCaseRecordNumberAtReferralCentreCcad~~||118||varchar||Ignored For No Enum||
+||!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||Ignored For No Enum||
+||~~!MedicalRecordNumberAtTimeOfEntryCcad~~||131||varchar||Ignored For No Enum||
+||~~Comments~~||132||varchar||Ignored For No Enum||
+||!PreAlertCall||133||varchar||||
+||~~!PickUpPostCode~~||134||varchar||Ignored For No Enum||
+||!CardiacNurseInAttendance||135||varchar||||
+||Cox_2InhibitorUse||136||varchar||||
+||!NsaidUse||137||varchar||||
+||!NitrateUse||138||varchar||||
+||!CalciumChannelBlockerUse||139||varchar||||
+||Spironolactone||140||varchar||||
+||Eplerenone||141||varchar||||
+||Nitrates||142||varchar||||
+||Warfarin||143||varchar||||
+||Other||144||varchar||||
+||!DateAndTimeOfFirstDiagnosticEcg||145||varchar||||
+||!AuditTrail||146||varchar||||
+||!DaysFromAdmissionToDeath||147||int||||
+||~~!DateOfCurrentStatus~~||148||datetime||Ignored For Datatype||
+||~~!DateOfEndStatus~~||149||datetime||Ignored For Datatype||
+||~~!DateTimeRecordCreated~~||150||datetime||Ignored For Datatype||
+||~~!DateTimeRecordLastChanged~~||151||datetime||Ignored For Datatype||
+||!EnteredByTag||152||varchar||||
+||!EntryCurrentStatus||153||varchar||||
+||!EntryEndStatus||154||varchar||||
+||!HospitalTag||155||varchar||||
 
 === GGHMINAPNEW
 
 ||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||||
 
 === GGHMINAPNEW_GGHMINAPINIVW
 
 ||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||Ignored For No Enum||
+||~~!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||||
+||~~!OtherComments~~||152||varchar||Ignored For No Enum||
+||!CathLabArrivalTime||153||varchar||||
+||!BalloonTime||154||varchar||||
+||!DelayCcuToLab||155||float||||
+||!DelayCallToBalloon||156||float||||
+||!DelayDoorToBalloon||157||float||||
+||!DelayLabToBalloon||158||float||||
+||!IncludeInCallToNeedle||159||varchar||||
+||!HospitalRefferedFrom||160||varchar||||
+||FirstMustafa1||161||int||||
+||SecondMustafa2||162||int||||
+||!DaysFromAdmissionToDeath||163||int||||
+||!InterventionalCentreCodeCcad||164||varchar||||
+||!ReferringHospitalCodeCcad||165||varchar||||
+||!TimeFromAdmissionToFirstEcg||166||float||||
+||!EcgQrsComplexDurationCcad||167||varchar||||
+||!AldosteroneAntagonistCcad||168||varchar||||
+||!DischargedOnThienopyridineInhibitorCcad||169||varchar||||
+||!DischargedOnAnAldosteroneAntagonistCcad||170||varchar||||
+||!WhatProcedureWasPerformedAtTheInterventionalHospit||171||varchar||||
+||!SmokingCessationAdviceGivenCcad||172||varchar||||
+||!DietaryAdviceGivenDuringThisAdmissionCcad||173||varchar||||
+||!OralBetaBlockerCcad||174||varchar||||
+||~~!DateAndTimeArrivalAtNonInterventionalHospitalCcad~~||175||varchar||Ignored For No Enum||
+||!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||||
+||!AcsAuditAdmittedFrom||187||varchar||||
+||!AcsAuditTimiScore||188||varchar||||
+||!AcsAuditRiskStrarification||189||varchar||||
+||!AcsAuditDateAndTimeOfEtt||190||varchar||||
+||!AcsAuditDateAndTimeOfEcho||191||varchar||||
+||!AcsAuditDateAndTimeOfAngiography||192||varchar||||
+||AcsAuditDateAndTimeOfPci_Cabg||193||varchar||||
+||!AcsAuditDischargedOnSublingualGtn||194||varchar||||
+||~~!AcsAuditComments~~||195||text||Ignored For Datatype||
+||~~!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||||
 
 === GGHPACEICD_GGHPACEICDINIALVW
 
 ||Field Name||Column ID||Type||Comments||
+||~~!EntryId~~||1||int||Ignored For Field Name||
+||~~!PatientId~~||2||int||Ignored For Field Name||
+||~~DateOfProcedure_Implant~~||3||date||Ignored For Datatype||
+||~~TimeOfProcedure_Implant~~||4||time||Ignored For Datatype||
+||!EntryStatus||5||varchar||||
+||~~!PreviousEntry~~||6||int||Ignored For Field Name||
+||~~!NextEntry~~||7||int||Ignored For Field Name||
+||!HospitalIdentifierCcad||8||varchar||||
+||!PatientGenderCcad||9||varchar||||
+||!PatientEthnicGroupCcad||10||varchar||||
+||!PatientAdminStatusCcad||11||varchar||||
+||~~!AuditTrail~~||12||text||Ignored For Datatype||
+||!AgeAtProcedure||13||int||||
+||~~!DateOfAdmission~~||14||date||Ignored For Datatype||
+||~~!DateOfFirstImplantCcad~~||15||date||Ignored For Datatype||
+||~~!PredeviceAetiologyCcad~~||16||varchar||Ignored For No Enum||
+||~~Predevice_eps_ablationPresentingSymptomCcad~~||17||varchar||Ignored For No Enum||
+||~~!PredeviceEcgCcad~~||18||varchar||Ignored For No Enum||
+||NyhaDyspnoeaStatus_pre_ProcedureStableOnly_Ccad||19||varchar||||
+||!LvFunctionAssessmentCcad||20||varchar||||
+||Lvef_30_Nice||21||varchar||||
+||!IcdIndicationCcad||22||varchar||||
+||Predevice_ablationQrsDuration_ms_Ccad||23||float||||
+||~~!DateAndTimeProcedureStart~~||24||varchar||Ignored For No Enum||
+||~~!DateAndTimeProcedureEnd~~||25||varchar||Ignored For No Enum||
+||!TotalTimeOfProcedure||26||int||||
+||!InterventionCcad||27||varchar||||
+||!ConsultantResponsibleForProcedureCcad||28||varchar||||
+||~~!PrimaryOperatorCcadOldData~~||29||varchar||Ignored For No Enum||
+||!GeneratorPacingModeCcad||30||varchar||||
+||!GeneratorManufacturerCcad||31||varchar||||
+||~~!GeneratorModelCcad~~||32||varchar||Ignored For No Enum||
+||~~!GeneratorSerialNumberCcad~~||33||varchar||Ignored For No Enum||
+||!GeneratorSiteOfImplantCcad||34||varchar||||
+||~~!DateGeneratorChangedCcad~~||35||date||Ignored For Datatype||
+||!WhyThisGeneratorEventuallyExplantedCcad||36||varchar||||
+||!VentricularLeadManufacturerCcad||37||varchar||||
+||~~!VentricularLeadModelCcad~~||38||varchar||Ignored For No Enum||
+||~~!VentricularLeadSerialNumberCcad~~||39||varchar||Ignored For No Enum||
+||!VentricularLeadImplantApproachCcad||40||varchar||||
+||~~!DateVentricularLeadChangedCcad~~||41||date||Ignored For Datatype||
+||!WhyThisVLeadEventuallyExplantedCcad||42||varchar||||
+||!AtrialLeadManufacturerCcad||43||varchar||||
+||~~!AtrialLeadModelCcad~~||44||varchar||Ignored For No Enum||
+||~~!AtrialLeadSerialNumberCcad~~||45||varchar||Ignored For No Enum||
+||!AtrialLeadImplantApproachCcad||46||varchar||||
+||~~!DateAtrialLeadChangedCcad~~||47||date||Ignored For Datatype||
+||!WhyThisALeadEventuallyExplantedCcad||48||varchar||||
+||VentricularLead2ManufacturerCcad||49||varchar||||
+||~~VentricularLead2ModelCcad~~||50||varchar||Ignored For No Enum||
+||~~VentricularLead2SerialNumberCcad~~||51||varchar||Ignored For No Enum||
+||VentricularLead2ImplantApproachCcad||52||varchar||||
+||~~DateVentricularLead2ChangedCcad~~||53||date||Ignored For Datatype||
+||WhyThisVLead2EventuallyExplantedCcad||54||varchar||||
+||AtrialLead2ManufacturerCcad||55||varchar||||
+||AtrialLead2ModelCcad||56||varchar||||
+||AtrialLead2SerialNumberCcad||57||varchar||||
+||AtrialLead2ImplantApproachCcad||58||varchar||||
+||~~DateAtrialLead2ChangedCcad~~||59||date||Ignored For Datatype||
+||WhyThisALead2EventuallyExplantedCcad||60||varchar||||
+||!IcdFunctionCcad||61||varchar||||
+||!BivFunctionCcad||62||varchar||||
+||!DefbrillatorLeadSiteCcad||63||varchar||||
+||!PacingProcedureComplicationsCcad||64||varchar||||
+||BradycardiaPacingOn_Ccad||65||varchar||||
+||!BradycardiaPacingModeCcad||66||varchar||||
+||PacingRate_low_Ccad||67||float||||
+||Anti_TachycardiaPacingOn_Ccad||68||varchar||||
+||VtShockTherapyOn_Ccad||69||varchar||||
+||VfShockTherapyOn_Ccad||70||varchar||||
+||BiventricularPacingOn_Ccad||71||varchar||||
+||AvDelay_sensed_Ccad||72||int||||
+||AvDelay_paced||73||int||||
+||BiventricularDelay_paced||74||int||||
+||BiventricularPacingWhichChamberPacedFirst_Ccad||75||varchar||||
+||!LeadExtractedCcad||76||varchar||||
+||~~!DateOfFileClosureCcad~~||77||date||Ignored For Datatype||
+||!DeviceFileClosureCcad||78||varchar||||
+||!EpsTestedNice||79||varchar||||
+||!TypeOfProcedure||80||varchar||||
+||~~Ccso~~||81||varchar||Ignored For No Enum||
+||~~!DateOfVentricularLeadImplant~~||82||date||Ignored For Datatype||
+||!TypeOfVentricularLeadProcedure||83||varchar||||
+||!TemporaryWire||84||varchar||||
+||!PolarityOfVentricularLead||85||varchar||||
+||!ConnectorAtrialLead||86||varchar||||
+||!ConnectorVentricularLead||87||varchar||||
+||VentricularLeadCurrent_5v_0_5ms||88||float||||
+||VentricularLeadImpedance_ohms||89||float||||
+||VentricularLeadRWave_mv||90||float||||
+||VentricularLeadThreshold_0_5ms||91||float||||
+||VentricularLeadStability_1v||92||varchar||||
+||VentricularLeadTwitch_10v||93||varchar||||
+||!VentricularLeadThresholdProblems||94||varchar||||
+||!VentricularLeadConfirmCorrectConnection||95||varchar||||
+||!ConfirmPacingVentricularLead||96||varchar||||
+||~~!DateOfAtrialLeadImplant~~||97||date||Ignored For Datatype||
+||!TypeOfAtrialLeadProcedure||98||varchar||||
+||!PolarityOfAtrialLead||99||varchar||||
+||AtrialLeadCurrent_5v_0_5ms||100||float||||
+||AtrialLeadImpedance_ohms||101||float||||
+||AtrialLeadPWave_mv||102||float||||
+||AtrialLeadThreshold_0_5ms||103||float||||
+||AtrialLeadStability_1v||104||varchar||||
+||AtrialLeadTwitch_10v||105||varchar||||
+||!AtrialLeadThresholdProblems||106||varchar||||
+||!AtrialLeadConfirmCorrectConnection||107||varchar||||
+||~~DateOfVentricularLead2Implant~~||108||date||Ignored For Datatype||
+||TypeOfVentricularLead2Procedure||109||varchar||||
+||PolarityOfVentricularLead2||110||varchar||||
+||ConnectorVentricularLead2||111||varchar||||
+||VentricularLead2Current_5v_0_5ms||112||float||||
+||VentricularLead2Impedance_ohms||113||float||||
+||VentricularLead2RWave_mv||114||float||||
+||VentricularLead2Threshold_0_5ms||115||float||||
+||VentricularLead2Stability_1v||116||varchar||||
+||VentricularLead2Twitch_10v||117||varchar||||
+||VentricularLead2ThresholdProblems||118||varchar||||
+||VentricularLead2ConfirmCorrectConnection||119||varchar||||
+||ConfirmPacingVentricularLead2||120||varchar||||
+||~~DateOfAtrialLead2Implant~~||121||date||Ignored For Datatype||
+||TypeOfAtrialLead2Procedure||122||varchar||||
+||PolarityOfAtrialLead2||123||varchar||||
+||ConnectorAtrialLead2||124||varchar||||
+||AtrialLead2Current_5v_0_5ms||125||float||||
+||AtrialLead2Impedance_ohms||126||float||||
+||AtrialLead2RWave_mv||127||float||||
+||!ConfirmPacingAtrialLead||128||varchar||||
+||AtrialLeas2Threshold_0_5ms||129||float||||
+||AtrialLead2Stability_1v||130||float||||
+||AtrialLead2Twitch_10v||131||float||||
+||AtrialLead2ThresholdProblems||132||varchar||||
+||AtrialLead2ConfirmCorrectConnection||133||varchar||||
+||ConfirmPacingAtrialLead2||134||varchar||||
+||~~DateVentricularLeadCut_cappedAndBuried~~||135||date||Ignored For Datatype||
+||~~DateAtrialLeadCut_cappedAndBuried~~||136||date||Ignored For Datatype||
+||~~DateVentricularLead2Cut_cappedAndBuried~~||137||date||Ignored For Datatype||
+||~~DateAtrialLead2Cut_cappedAndBuried~~||138||date||Ignored For Datatype||
+||~~!ProcedureReport~~||139||varchar||Ignored For No Enum||
+||~~!GpAtTimeOfProcedure~~||140||varchar||Ignored For No Enum||
+||~~!NameOfGp~~||141||varchar||Ignored For No Enum||
+||~~!GpPracticeCode~~||142||varchar||Ignored For No Enum||
+||~~Pct~~||143||varchar||Ignored For No Enum||
+||~~!MedicalRecordNumber~~||144||varchar||Ignored For No Enum||
+||!NumberOfDaysDeviceImplanted||145||int||||
+||~~!DateOfExplant~~||146||date||Ignored For Datatype||
+||~~!DateOfDischarge~~||147||date||Ignored For Datatype||
+||!ComplicationsBeforeDischarge||148||varchar||||
+||~~!DateOfComplication~~||149||date||Ignored For Datatype||
+||!TypeOfComplication||150||varchar||||
+||!IfOtherComplicationPleaseState||151||varchar||||
+||!DischargeDelayedDueToComplication||152||varchar||||
+||!PacemakerChecksTransferred||153||varchar||||
+||!TransferredTo||154||varchar||||
+||~~!DateOfTransfer~~||155||date||Ignored For Datatype||
+||!ProcedureUrgency||156||varchar||||
+||!OtherOperatorsOldData||157||varchar||||
+||!SideUsed||158||varchar||||
+||~~Ward~~||159||varchar||Ignored For No Enum||
+||~~!PrimaryOperatorCcad~~||160||varchar||Ignored For No Enum||
+||~~!OtherOperators~~||161||varchar||Ignored For No Enum||
+||!TotalDaysInHospital||162||float||||
+||!LvPortPlugged||163||varchar||||
+||!ClinicalGuidance||164||varchar||||
+||!PrimaryReplacementAppropriateTherapy||165||varchar||||
+||!NumberOfDaysDischargeDelayed||166||float||||
+||Height||167||float||||
+||Weight||168||float||||
+||Bmi||169||float||||
+||!ScreeningTime||170||float||||
+||!ScreeningDose||171||float||||
+||!ExceededDrl||172||varchar||||
+||Radiographer||173||varchar||||
+||!ReasonForExceedingDrl||174||varchar||||
+||!SickNoteGiven||175||varchar||||
+||!DurationOfSickNoteInDays||176||int||||
+||!ChangesToCurrentMedication||177||varchar||||
+||!NameOfDischargingDoctor||178||varchar||||
+||Grade||179||varchar||||
+||!PagerNumber||180||varchar||||
+||!DischargeWard||181||varchar||||
+||!DischargeDestination||182||varchar||||
+||!DrugSensitivity||183||varchar||||
+||Drug1||184||varchar||||
+||Route1||185||varchar||||
+||NumberOfDays1||186||int||||
+||Continue1||187||varchar||||
+||Drug2||188||varchar||||
+||Route2||189||varchar||||
+||NumberOfDays2||190||int||||
+||Continue2||191||varchar||||
+||Drug3||192||varchar||||
+||Route3||193||varchar||||
+||NumberOfDays3||194||int||||
+||Continue3||195||varchar||||
+||Drug4||196||varchar||||
+||Route4||197||varchar||||
+||NumberOfDays4||198||int||||
+||Continue4||199||varchar||||
+||Drug5||200||varchar||||
+||Route5||201||varchar||||
+||NumberOfDays5||202||int||||
+||Continue5||203||varchar||||
+||Drug6||204||varchar||||
+||Route6||205||varchar||||
+||NumberOfDays6||206||int||||
+||Continue6||207||varchar||||
+||Drug7||208||varchar||||
+||Route7||209||varchar||||
+||NumberOfDays7||210||int||||
+||Continue7||211||varchar||||
+||Drug8||212||varchar||||
+||Route8||213||varchar||||
+||NumberOfDays8||214||int||||
+||Continue8||215||varchar||||
+||Drug9||216||varchar||||
+||Route9||217||varchar||||
+||NumberOfDays9||218||int||||
+||Continue9||219||varchar||||
+||Drug10||220||varchar||||
+||Route10||221||varchar||||
+||NumberOfDays10||222||int||||
+||Continue10||223||varchar||||
+||Drug11||224||varchar||||
+||Route11||225||varchar||||
+||NumberOfDays11||226||int||||
+||Continue11||227||varchar||||
+||Drug12||228||varchar||||
+||Route12||229||varchar||||
+||NumberOfDays12||230||int||||
+||Continue12||231||varchar||||
+||Drug13||232||varchar||||
+||Route13||233||varchar||||
+||NumberOfDays13||234||int||||
+||Continue13||235||varchar||||
+||Drug14||236||varchar||||
+||Route14||237||varchar||||
+||NumberOfDays14||238||int||||
+||Continue14||239||varchar||||
+||Drug15||240||varchar||||
+||Route15||241||varchar||||
+||NumberOfDays15||242||int||||
+||Continue15||243||varchar||||
+||Drug16||244||varchar||||
+||Route16||245||varchar||||
+||NumberOfDays16||246||int||||
+||Continue16||247||varchar||||
+||Drug17||248||varchar||||
+||Route17||249||varchar||||
+||NumberOfDays17||250||int||||
+||Continue17||251||varchar||||
+||Drug18||252||varchar||||
+||Route18||253||varchar||||
+||NumberOfDays18||254||int||||
+||Continue18||255||varchar||||
 
 === GGHPCI_FLWGGHPCIVIEW
 
 ||Field Name||Column ID||Type||Comments||
+||!FlwId||1||int||||
+||~~!PatientId~~||2||int||Ignored For Field Name||
+||~~!EntryId~~||3||int||Ignored For Field Name||
+||~~!DateOfFollowup~~||4||date||Ignored For Datatype||
+||~~!TimeOfFollowup~~||5||time||Ignored For Datatype||
+||!EntryStatus||6||varchar||||
+||~~!DateOfLastFollowup~~||7||date||Ignored For Datatype||
+||~~!DateTimeRecordCreated~~||8||varchar||Ignored For No Enum||
+||~~!DateTimeRecordLastChanged~~||9||varchar||Ignored For No Enum||
+||!EnteredByTag||10||varchar||||
+||!HospitalTag||11||varchar||||
+||~~!IsPrimaryFlw~~||12||bit||Ignored For Datatype||
+||~~!TimeOfLastFollowup~~||13||time||Ignored For Datatype||
 
 === GGHPCI_INITIALGGHPCIVIEW
 
 ||Field Name||Column ID||Type||Comments||
+||~~!EntryId~~||1||int||Ignored For Field Name||
+||~~!PatientId~~||2||int||Ignored For Field Name||
+||~~!DateofProcedureCCAD~~||3||date||Ignored For Datatype||
+||~~!TimeofProcedureCCAD~~||4||time||Ignored For Datatype||
+||!EntryStatus||5||varchar||||
+||~~!PreviousEntry~~||6||int||Ignored For Field Name||
+||~~!NextEntry~~||7||int||Ignored For Field Name||
+||!PatientGenderCcad||8||varchar||||
+||!PatientEthnicGroupCcad||9||varchar||||
+||!AdministrativeCategoryCcad||10||varchar||||
+||!HospitalIdentifierCcad||11||varchar||||
+||!ClinicalSyndromeCcad||12||varchar||||
+||!IndicationForInterventionCcad||13||varchar||||
+||!ProcedureUrgencyCcad||14||varchar||||
+||CardiogenicShockPre_Anaesthesia_pre_Pci_Ccad||15||varchar||||
+||!CcsClassificationForStableAnginaCcad||16||varchar||||
+||NyhaDyspnoeaStatus_pre_Procedure_StableOnly_Ccad||17||varchar||||
+||~~DateAndTimeOfSymptomOnset_acs_Ccad~~||18||varchar||Ignored For No Enum||
+||~~DateAndTimeArrivalAtHospital_acsOnly_ccad~~||19||varchar||Ignored For No Enum||
+||AdmissionRoute_acs_Ccad||20||varchar||||
+||PresentingEcg_acsOnly_Ccad||21||varchar||||
+||RecentLysis_acs_Ccad||22||varchar||||
+||CardiacEnzymes_markersRaisedCcad||23||varchar||||
+||!PreviousMiCcad||24||varchar||||
+||!PreviousCabgCcad||25||varchar||||
+||!PreviousPciCcad||26||varchar||||
+||!DiabetesCcad||27||varchar||||
+||Height_cm_Ccad||28||int||||
+||Weight_kg_Ccad||29||float||||
+||!LvEjectionFractionCategoryCcad||30||varchar||||
+||!LvEjectionFractionCcad||31||int||||
+||NumberGraftsPresent_pre_Operation_Ccad||32||int||||
+||NumberGraftsPatent_pre_Operation_Ccad||33||int||||
+||LeftMainStemStenosis_pre_Pci_Ccad||34||varchar||||
+||LadProximalStenosis_pre_Pci_Ccad||35||varchar||||
+||LadOtherStenosis_pre_Pci_Ccad||36||varchar||||
+||RcaStenosis_pre_Pci_Ccad||37||varchar||||
+||CxStenosis_pre_Pci_Ccad||38||varchar||||
+||OtherStenosis_prePci||39||varchar||||
+||FlowInIraPreop_acs_Ccad||40||varchar||||
+||~~!DateAndTimeOfOperation~~||41||varchar||Ignored For No Enum||
+||!ConsultantResponsibleForProcedureCcad||42||varchar||||
+||~~!FirstOperatorCcad~~||43||varchar||Ignored For No Enum||
+||!PrimaryOperatorStatusCcad||44||varchar||||
+||~~!SecondOperatorCcad~~||45||varchar||Ignored For No Enum||
+||!SecondOperatorStatusCcad||46||varchar||||
+||~~!ThirdOperatorCcad~~||47||varchar||Ignored For No Enum||
+||!ThirdOperatorStatusCcad||48||varchar||||
+||~~!VesselsAttemptedCcad~~||49||varchar||Ignored For No Enum||
+||NumberOfVesselsAttempted_notEpicardialTerritories_||50||int||||
+||!NumberOfLesionsAttemptedCcad||51||int||||
+||!NumberOfChronicOcclusionsAttemptedCcad||52||int||||
+||!NumberRestenosesAttemptedCcad||53||int||||
+||!NumberInstentStenosesAttemptedCcad||54||int||||
+||!NumberStentsUsedCcad||55||int||||
+||NumberDrug_ElutingStentsUsedCcad||56||int||||
+||~~Drug_s_ElutedByStent_s_Ccad~~||57||varchar||Ignored For No Enum||
+||GpIib_iiiaDrug_s_UsedDuringProcedureCcad||58||varchar||||
+||DiagnosticDevice_s_UsedDuringProcedureCcad||59||varchar||||
+||ProceduralDevice_s_UsedCcad||60||varchar||||
+||Athero_ThrombusRemovalDevice_s_UsedCcad||61||varchar||||
+||BrachytherapyDevice_s_UsedCcad||62||varchar||||
+||EmboliProtectionDevice_s_UsedCcad||63||varchar||||
+||!CirculatorySupportCcad||64||varchar||||
+||!ArterialManagementCcad||65||varchar||||
+||~~Date_timeOfFirstBalloonInflation_pci_Ccad~~||66||varchar||Ignored For No Enum||
+||LeftMainStemStenosis_postPci_Ccad||67||varchar||||
+||LadProximalStenosis_postPci_Ccad||68||varchar||||
+||LadOtherStenosis_postPci_Ccad||69||varchar||||
+||RcaStenosis_postPci_Ccad||70||varchar||||
+||CxStenosis_postPci_Ccad||71||varchar||||
+||OtherStenosis_postPci||72||varchar||||
+||!NumberLesionsSuccessfulCcad||73||int||||
+||!NumberCoronaryGraftsPatentPostopCcad||74||int||||
+||FlowInIraPostop_acs_Ccad||75||varchar||||
+||~~ProcedureReport_commentCcad~~||76||varchar||Ignored For No Enum||
+||!DeviceFailureCcad||77||varchar||||
+||~~!PciHospitalOutcomeCcad~~||78||varchar||Ignored For No Enum||
+||!EnzymesPostopCcad||79||varchar||||
+||!StatusAtDischargeCcad||80||varchar||||
+||~~!DischargeDateCcad~~||81||date||Ignored For Datatype||
+||!LocalProcedureIdentifierCcad||82||varchar||||
+||!CholesterolCcad||83||float||||
+||!SmokingStatusCcad||84||varchar||||
+||!FamilyHistoryOfCadCcad||85||varchar||||
+||!MedicalHistoryCcad||86||varchar||||
+||!HistoryOfRenalDiseaseCcad||87||varchar||||
+||!VentilatedPreopCcad||88||varchar||||
+||!QWaveOnEcgCcad||89||varchar||||
+||!EcgIschaemiaCcad||90||varchar||||
+||~~!DrugTherapyPreopCcad~~||91||varchar||Ignored For No Enum||
+||FollowOn_adhoc_ProcedureCcad||92||varchar||||
+||!TrainingProcedureCcad||93||varchar||||
+||!ResearchProcedureCcad||94||varchar||||
+||~~!ResearchTitleCcad~~||95||varchar||Ignored For No Enum||
+||!ArterialAccessCcad||96||varchar||||
+||LargestBalloon_stentUsedCcad||97||float||||
+||LongestStented_TreatedSegmentCcad||98||int||||
+||~~!ProceduralComplicationCcad~~||99||varchar||Ignored For No Enum||
+||!ArterialComplicationsCcad||100||varchar||||
+||!TimeToBypassCcad||101||int||||
+||!PatientStatusDuringTransferToTheatreCcad||102||varchar||||
+||WhyNoIib_iiiaDuringProcedureCcad||103||varchar||||
+||!IndicationForStentCcad||104||varchar||||
+||!SurgicalCoverCcad||105||varchar||||
+||!LeftMainStemProtectedCcad||106||varchar||||
+||LmsQuestion1||107||varchar||||
+||LmsQuestion2||108||varchar||||
+||LmsQuestion3||109||varchar||||
+||BifurcationQuestion1||110||varchar||||
+||BifurcationQuestion2||111||varchar||||
+||!ChronicTotalOcclusion||112||varchar||||
+||!VesselWithChronicTotalOcclusion||113||varchar||||
+||!TypeOfOcclusion||114||varchar||||
+||!OcclusionSuccess||115||varchar||||
+||!InstentRestenosisDecribe||116||varchar||||
+||~~!BmsSize~~||117||varchar||Ignored For No Enum||
+||~~!DesSize~~||118||varchar||Ignored For No Enum||
+||!InstentRestenosisType||119||varchar||||
+||!GraftType||120||varchar||||
+||!TypeOfLesionLeftMainStem||121||varchar||||
+||!TypeOfLesionLadProximal||122||varchar||||
+||!TypeOfLesionLadOther||123||varchar||||
+||!TypeOfLesionRca||124||varchar||||
+||!TypeOfLesionCx||125||varchar||||
+||!TypeOfLesionOther||126||varchar||||
+||!TypeOfLesionIra||127||varchar||||
+||Restenosis||128||varchar||||
+||~~Ccco~~||129||varchar||Ignored For No Enum||
+||~~!MedicalRecordNumberAtTimeOfEntry~~||130||varchar||Ignored For No Enum||
+||~~!NameOfReferringGp~~||131||varchar||Ignored For No Enum||
+||~~Gp~~||132||varchar||Ignored For No Enum||
+||~~Pct~~||133||varchar||Ignored For No Enum||
+||~~!PracticeCode~~||134||varchar||Ignored For No Enum||
+||~~!DateOfDeathPostProcedure~~||135||date||Ignored For Datatype||
+||!IntervalBetweenProcedureAndDeath||136||int||||
+||~~!AuditTrail~~||137||text||Ignored For Datatype||
+||~~!DateOfAdmission~~||138||date||Ignored For Datatype||
+||!TotalInpatientStay||139||float||||
+||~~ArrivalInPciHospital_acs_Ccad~~||140||varchar||Ignored For No Enum||
+||~~DateAndTimeOfCallForHelp_stemiOnly_Ccad~~||141||varchar||Ignored For No Enum||
+||!ReferringHospitalCcad||142||varchar||||
+||~~!DateAndTimeOfEcgTriggeringPpciPathwayCcad~~||143||varchar||Ignored For No Enum||
+||PatientLocationAtTimeOfStemiOnset_forPatientsTreat||144||varchar||||
+||!ConsultantResponsibleForProcedureGmcNumberCcad||145||varchar||||
+||!PrimaryOperatorGmcNumberCcad||146||varchar||||
+||!SecondOperatorGmcNumberCcad||147||varchar||||
+||!ThirdOperatorGmcNumberCcad||148||varchar||||
+||Creatinine||149||float||||
+||!WardConsultant||150||varchar||||
+||!PinkClerkingForm||151||varchar||||
+||~~!BlueCathLabForm~~||152||varchar||Ignored For No Enum||
+||!WhiteHospitalOutcome||153||varchar||||
+||!AngioNumber||154||int||||
+||~~!TimeOfArrivalInLab~~||155||varchar||Ignored For No Enum||
+||~~!TimeOnTable~~||156||varchar||Ignored For No Enum||
+||~~!TimeOfSheathInsertion~~||157||varchar||Ignored For No Enum||
+||~~!TimeOfWireAcrossFirstLesion~~||158||varchar||Ignored For No Enum||
+||~~!TimeOffTable~~||159||varchar||Ignored For No Enum||
+||~~DateAndTimeOfStemiAlert_stemiOnly~~||160||varchar||Ignored For No Enum||
+||!NameOfDoctorResponsibleForCompletingForm||161||varchar||||
+||~~!ReasonForDelaysInLab~~||162||varchar||Ignored For No Enum||
+||~~!DateOfCholesterolResult~~||163||date||Ignored For Datatype||
+||WasPatientPre_LoadedWithClopidogrel||164||varchar||||
+||!ClopidogrelDose||165||varchar||||
+||!DiagnosticDeviceUsedDuringProcedure||166||varchar||||
+||~~NameOfInfarctRelatedArtery_ira~~||167||varchar||Ignored For No Enum||
+||!MedinaClassification||168||float||||
+||!ApproachToCto||169||varchar||||
+||!IfAntegradeWereRetrogradeInjectionsUsed||170||varchar||||
+||Bmi||171||float||||
+||!ScreeningTime||172||float||||
+||!ScreeningDose||173||float||||
+||!ExceededDrl||174||varchar||||
+||Radiographer||175||varchar||||
+||!FollowOnFromCatheterAtSameTime||176||varchar||||
+||!ReasonFoExceedingDrl||177||varchar||||
+||~~!DateOfCurrentStatus~~||178||date||Ignored For Datatype||
+||~~!DateOfEndStatus~~||179||date||Ignored For Datatype||
+||~~!DateTimeRecordCreated~~||180||varchar||Ignored For No Enum||
+||~~!DateTimeRecordLastChanged~~||181||varchar||Ignored For No Enum||
+||!EnteredByTag||182||varchar||||
+||!EntryCurrentStatus||183||varchar||||
+||!EntryEndStatus||184||varchar||||
+||!HospitalTag||185||varchar||||
+||!ImportLinkId||186||int||||
 
 === LRIMINAPNEW
 
 ||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||||
 
 === LRIMINAPNEW_LRIMINAPNEWINITIALVW
 
 ||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||||
 
 === VERTED_VERTEDINIALVW
 
 ||Field Name||Column ID||Type||Comments||
-
+||~~!EntryId~~||1||int||Ignored For Field Name||
+||~~!PatientId~~||2||int||Ignored For Field Name||
+||~~!DateOfCardioversion~~||3||date||Ignored For Datatype||
+||~~!TimeOfCardioversion~~||4||time||Ignored For Datatype||
+||!EntryStatus||5||varchar||||
+||~~!PreviousEntry~~||6||int||Ignored For Field Name||
+||~~!NextEntry~~||7||int||Ignored For Field Name||
+||~~!DateOnWaitingList~~||8||date||Ignored For Datatype||
+||!AgeAtCardioversion||9||int||||
+||~~!BloodPressure~~||10||varchar||Ignored For No Enum||
+||~~Height~~||11||varchar||Ignored For No Enum||
+||Rhythm||12||varchar||||
+||~~!DrugsOnAdmission~~||13||varchar||Ignored For No Enum||
+||~~!DateOfEcho~~||14||date||Ignored For Datatype||
+||Pacemaker||15||varchar||||
+||Weight||16||float||||
+||Inr||17||float||||
+||JoulesDelivered_1||18||int||||
+||~~Rhythm_1~~||19||varchar||Ignored For No Enum||
+||JoulesDelivered_2||20||int||||
+||~~Rhythm_2~~||21||varchar||Ignored For No Enum||
+||JoulesDelivered_3||22||int||||
+||Rhythm_3||23||varchar||||
+||JoulesDelivered_4||24||int||||
+||Rhythm_4||25||varchar||||
+||JoulesDelivered_5||26||int||||
+||Rhythm_5||27||varchar||||
+||JoulesDelivered_6||28||int||||
+||Rhythm_6||29||varchar||||
+||!InternalCardioversion||30||varchar||||
+||!ExternalCardioversion||31||varchar||||
+||!OutcomeSucces||32||varchar||||
+||Death||33||varchar||||
+||!CardioversionCancelled||34||varchar||||
+||~~Reason~~||35||varchar||Ignored For No Enum||
+||~~!DateOfDischarge~~||36||date||Ignored For Datatype||
+||~~!DateOfAdmission~~||37||date||Ignored For Datatype||
+||!RhythmAfterCardioversion||38||varchar||||
+||!AdmissionType||39||varchar||||
+||~~!DateOfFollowUp~~||40||date||Ignored For Datatype||
+||Ap_2||41||varchar||||
+||Ap_3||42||varchar||||
+||Ap_4||43||varchar||||
+||Ap_5||44||varchar||||
+||Ap_6||45||varchar||||
+||Consultant||46||varchar||||
+||!ContractDetails||47||varchar||||
+||Pcg||48||varchar||||
+||~~MedicationOnDischarge1~~||49||varchar||Ignored For No Enum||
+||~~MedicationOnDischarge2~~||50||varchar||Ignored For No Enum||
+||~~MedicationOnDischarge3~~||51||varchar||Ignored For No Enum||
+||~~MedicationOnDischarge4~~||52||varchar||Ignored For No Enum||
+||~~MedicationOnDischarge5~~||53||varchar||Ignored For No Enum||
+||~~MedicationOnDischarge6~~||54||varchar||Ignored For No Enum||
+||~~MedicationOnDischarge7~~||55||varchar||Ignored For No Enum||
+||~~MedicationOnDischarge8~~||56||varchar||Ignored For No Enum||
+||~~MedicationOnDischarge9~~||57||varchar||Ignored For No Enum||
+||!AuditLoopClosed||58||varchar||||
+||~~!DateAuditLoopClosed~~||59||date||Ignored For Datatype||
+||!ReasonAuditLoopClosed||60||varchar||||
+||~~!DateOfDeathPostDischarge~~||61||date||Ignored For Datatype||
+||PostDischargeDeathInterval_days||62||int||||
+||!ReasonForCancellation||63||varchar||||
+||IntervalBetweenProc_LoopClosed_days||64||int||||
+||PreOpStay_days||65||int||||
+||PostOpStay_days||66||int||||
+||TotalLos_days||67||int||||
+||ReferralToOp_days||68||int||||
+||DischargeToFollow_Up_days||69||int||||
+||!EchoPerformed||70||varchar||||
+||ImmeadiateReinitiationOfAf_iraf||71||varchar||||
+||!PacemakerMode||72||varchar||||
+||EcgResultAt1Week||73||varchar||||
+||EcgResultAt1Month||74||varchar||||
+||!ReCardiovert||75||varchar||||
+||!ReasonWhyYesOrNo||76||varchar||||
+||Anaesthetic_sedation||77||varchar||||
+||~~!IfSedationDose~~||78||varchar||Ignored For No Enum||
+||Reversal||79||varchar||||
+||!ComplicationsPreDischarge||80||varchar||||
+||!DoseOfFlumazenil||81||varchar||||
+||!TypeOfDefibUsed||82||varchar||||
+||!DoesPatientRememberShocks||83||varchar||||
+||!WasProcedureUnpleasant||84||varchar||||
+||~~!AnyOtherComments~~||85||varchar||Ignored For No Enum||
+||!BurnMarks||86||varchar||||
+||~~HeartRate_priorToDischarge~~||87||varchar||Ignored For No Enum||
+||Anaesthetist||88||varchar||||
+||!MedicalAssistant||89||varchar||||
+||~~!UnderlyingCardiacDiagnosisForAf~~||90||varchar||Ignored For No Enum||
+||~~!DrugListOnDischarge~~||91||varchar||Ignored For No Enum||
+||!FreeThyroxine||92||float||||
+||!ThyroidStimulatingHormone||93||float||||
+||~~Operator~~||94||varchar||Ignored For No Enum||
+||DoctorReading1WeekEcg||95||varchar||||
+||DoctorReading1MonthEcg||96||varchar||||
+||!PadsOrPaddles||97||varchar||||
+||!IfRevertsToAf||98||varchar||||
+||~~!AnyUntowardsEvents~~||99||varchar||Ignored For No Enum||
+||!DurationOfAf||100||varchar||||
+||FollowUpAt_Hospital||101||varchar||||
+||!TotalDoseOfSedation||102||varchar||||
+||!TotalJulesDelivered||103||float||||
+||!NumberOfPreviousCardioversion||104||varchar||||
+||~~!GpPracticeCode~~||105||varchar||Ignored For No Enum||
+||Pct||106||varchar||||
+||!TotalNumberOfShocks||107||int||||
+||~~!MedicalRecordNumber~~||108||varchar||Ignored For No Enum||
+||!HasPatientHadPreviousCardioversion||109||varchar||||
+||~~!DateOfLastCardioversion~~||110||date||Ignored For Datatype||
+||!IsProcedureForRecuurrenceOfAfOfFailure||111||varchar||||
+||~~MedicationOnDischarge10~~||112||varchar||Ignored For No Enum||
+||~~MedicationOnDischarge11~~||113||varchar||Ignored For No Enum||
+||~~MedicationOnDischarge12~~||114||varchar||Ignored For No Enum||
+||MedicationOnDischarge13||115||varchar||||
+||~~!DateAndTimeOfCardioversion~~||116||varchar||Ignored For No Enum||
+||~~UnderlyingCardiacDiagnosis2~~||117||varchar||Ignored For No Enum||
+||~~UnderlyingCardiacDiagnosis3~~||118||varchar||Ignored For No Enum||
+||~~UnderlyingCardiacDiagnosis4~~||119||varchar||Ignored For No Enum||
+||~~UnderlyingCardiacDiagnosis5~~||120||varchar||Ignored For No Enum||
+||UnderlyingCardiacDiagnosis6||121||varchar||||
+||!ConsultantTitle||122||varchar||||
+||!ConsultantsHospitalBase||123||varchar||||
+||!SickNoteOfferedToPatient||124||varchar||||
+||IfAccepted_DurationInDays||125||int||||
+||!ManagementPlan||126||varchar||||
+||!DoctorSigningLetter||127||varchar||||
+||!TitleOfDoctorSigning||128||varchar||||
+||~~!DateOfCurrentStatus~~||129||date||Ignored For Datatype||
+||~~!DateOfEndStatus~~||130||date||Ignored For Datatype||
+||!DateTimeRecordCreated||131||varchar||||
+||!DateTimeRecordLastChanged||132||varchar||||
+||!EnteredByTag||133||varchar||||
+||!EntryCurrentStatus||134||varchar||||
+||!EntryEndStatus||135||varchar||||
+||!HospitalTag||136||varchar||||
+||!ImportLinkId||137||int||||