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

Timestamp:

03/14/13 13:07:05 (12 years ago)

Author:

Richard Bramley

Comment:

--

i2b2 Data Import PATS Mapping v1

@@ -229 +229 @@
 
 ||Field Name||Column ID||Type||Comments||
-||~~!EntryId~~||1||int||IGNORED||
-||~~!PatientId~~||2||int||IGNORED||
-||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||
-||!BodySurfaceArea||31||float||||
-||!BodyMassIndex||32||float||||
-||Cardioplegia_Infusion||33||varchar||||
-||!EuroscoreMinumumDatasetCheck||34||varchar||||
-||!ParsonnetMinumumDatasetCheck||35||varchar||||
-||!NameOfGpAtTimeOfSurgery||36||varchar||||
-||!GpPracticeCodeAtTimeOfSurgery||37||varchar||||
-||!PctAtTimeOfSurgery||38||varchar||||
-||!NameOfReferringGpAtTimeOfSurgeryType8||39||varchar||||
-||!ToePerformed||40||varchar||||
-||Sonographer||41||varchar||||
-||Sonographist||42||varchar||||
-||!PrimaryPerfusionist||43||varchar||||
-||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||||
-||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||||
-||SecondSiteCommentsMade_sa||96||varchar||||
-||SecondSiteConduit_location_sa||97||varchar||||
-||FirstSiteComments_sa||98||varchar||||
-||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||||
-||!LowCardiacOutput||107||varchar||||
-||Ventilation||108||varchar||||
-||!PulmonaryComplications||109||varchar||||
-||!RenalComplications||110||varchar||||
-||!GastrointestinalComplications||111||varchar||||
-||!InfectiveComplications||112||varchar||||
-||!CauseOfDeath||113||varchar||||
-||AdmittedFrom_hospitalNameOrWard||114||varchar||||
-||~~!AdmittedToCardiacSurgery~~||115||datetime||IGNORED||
-||~~!DischargedFromCardiacSurgery~~||116||datetime||IGNORED||
-||!TotalCardiacSurgeryLosDays||117||float||||
-||~~!DateOfFollowUp~~||118||datetime||IGNORED||
-||!BloodUsed||119||varchar||||
-||!MutisystemFailure||120||varchar||||
-||~~!DateFirstAdmittedToCicu~~||121||datetime||IGNORED||
-||~~!DateFirstDischargedFromCicu~~||122||datetime||IGNORED||
-||!TotalFirstStayOnCicu||123||float||||
-||!ReAdmittedToCicu||124||varchar||||
-||~~!DateOfSecondAdmissionToCicu~~||125||datetime||IGNORED||
-||~~!DateOfSecondDischargeFromCicu~~||126||datetime||IGNORED||
-||SecondAdmissionTotalStay_nignts||127||float||||
-||~~!DateOfThirdAdmissionToCicu~~||128||datetime||IGNORED||
-||~~!DateOfThirdDischargeFromCicu~~||129||datetime||IGNORED||
-||ThirdAdmissionToCicuTotalStay_nights||130||float||||
-||!InsertionOfPacemakerWiresViaVatsProcedure||131||varchar||||
-||!IntubationTimeInHours||132||int||||
-||!AuditTrail||133||varchar||||
-||!NameOfDoctorCompletingBooklet||134||varchar||||
-||!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||||
-||!MedicalRecordNumber||145||varchar||||
-||~~DateAddedToW_l~~||146||datetime||IGNORED||
-||AddedToW_l||147||varchar||||
-||~~!DateOfFourthAdmissionToCicu~~||148||datetime||IGNORED||
-||~~!DateOfFourthDischargeFromCicu~~||149||datetime||IGNORED||
-||~~!DateOfFifthAdmissionToCicu~~||150||datetime||IGNORED||
-||~~!DateOfFifthDischargeFromCicu~~||151||datetime||IGNORED||
-||!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||
-||!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||||
-||!SickNoteOffered||172||varchar||||
-||!IfSickNoteOfferedDurationInDays||173||int||||
-||!AdviceToGpAndAnyMedicationChangedOrStopped||174||varchar||||
-||!NameOfDischargingDoctor||175||varchar||||
-||!GradeOfDischargingDoctor||176||varchar||||
-||!PagerNumber||177||varchar||||
-||!DrugSensitivity||178||varchar||||
-||Drug1||179||varchar||||
-||DrugRoute1||180||varchar||||
-||NumberOfDays1||181||int||||
-||Continue1||182||varchar||||
-||Drug2||183||varchar||||
-||DrugRoute2||184||varchar||||
-||NumberOfDays2||185||int||||
-||Continue2||186||varchar||||
-||Drug3||187||varchar||||
-||DrugRoute3||188||varchar||||
-||NumberOfDays3||189||int||||
-||Continue3||190||varchar||||
-||Drug4||191||varchar||||
-||DrugRoute4||192||varchar||||
-||NumberOfDays4||193||int||||
-||Continue4||194||varchar||||
-||Drug5||195||varchar||||
-||DrugRoute5||196||varchar||||
-||NumberOfDays5||197||int||||
-||Continue5||198||varchar||||
-||Drug6||199||varchar||||
-||DrugRoute6||200||varchar||||
-||NumberOfDays6||201||int||||
-||Continue6||202||varchar||||
-||Drug7||203||varchar||||
-||DrugRoute7||204||varchar||||
-||NumberOfDays7||205||int||||
-||Continue7||206||varchar||||
-||Drug8||207||varchar||||
-||DrugRoute8||208||varchar||||
-||NumberOfDays8||209||int||||
-||Continue8||210||varchar||||
-||Drug9||211||varchar||||
-||DrugRoute9||212||varchar||||
-||NumberOfDays9||213||int||||
-||Continue9||214||varchar||||
-||Drug10||215||varchar||||
-||DrugRoute10||216||varchar||||
-||NumberOfDays10||217||int||||
-||Continue10||218||varchar||||
-||Drug11||219||varchar||||
-||DrugRoute11||220||varchar||||
-||NumberOfDays11||221||int||||
-||Continue11||222||varchar||||
-||Drug12||223||varchar||||
-||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||||
-||DrugForm19||252||varchar||||
-||DrugDose19||253||varchar||||
-||DrugRoute19||254||varchar||||
-||DrugFrequency19||255||varchar||||
-||NumberOfDays19||256||int||||
-||Continue19||257||varchar||||
-||DrugNameAndStrength20||258||varchar||||
-||DrugForm20||259||varchar||||
-||DrugDose20||260||varchar||||
-||DrugRoute20||261||varchar||||
-||DrugFrequency20||262||varchar||||
-||NumberOfDays20||263||int||||
-||Continue20||264||varchar||||
-||DrugNameAndStrength21||265||varchar||||
-||DrugForm21||266||varchar||||
-||DrugDose21||267||varchar||||
-||DrugRoute21||268||varchar||||
-||DrugFrequency21||269||varchar||||
-||NumberOfDays21||270||int||||
-||Continue21||271||varchar||||
-||DrugNameAndStrength22||272||varchar||||
-||DrugForm22||273||varchar||||
-||DrugDose22||274||varchar||||
-||DrugRoute22||275||varchar||||
-||DrugFrequency22||276||varchar||||
-||NumberOfDays22||277||int||||
-||Continue22||278||varchar||||
-||DrugNameAndStrength23||279||varchar||||
-||DrugForm23||280||varchar||||
-||DrugDose23||281||varchar||||
-||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||||
-||!FollowUpRequired||296||varchar||||
-||!FollowUpTimeInWeeks_months||297||varchar||||
-||!MedicationChangedByPharmacist||298||varchar||||
-||!StatePharmacistChanges||299||varchar||||
-||!InformationGivenToPatient||300||varchar||||
-||~~!DateTimeRecordCreated~~||301||datetime||IGNORED||
-||~~!DateTimeRecordLastChanged~~||302||datetime||||
-||!EnteredByTag||303||varchar||||
-||!HospitalTag||304||varchar||||
-||WHO_REGISTRY_INDICATOR||305||varchar||||
-||~~WHO_POSSIBLE_DUPLICATE~~||306||char||IGNORED||
 
 === CS2003F_PreProcedure
 
 ||Field Name||Column ID||Type||Comments||
-||~~!EntryId~~||1||int||IGNORED||
-||~~!PatientId~~||2||int||IGNORED||
-||~~DateOfOperation_ccad~~||3||datetime||IGNORED||
-||~~TimeOfOperation_ccad~~||4||datetime||IGNORED||
-||!EntryStatus||5||varchar||||
-||~~!PreviousEntry~~||6||int||IGNORED||
-||~~!NextEntry~~||7||int||IGNORED||
-||!AgeAtSurgery||8||int||||
-||Gender||9||varchar||||
-||~~!DateOfAdmission~~||10||datetime||IGNORED||
-||AnginaStatusPre_Surgery||11||varchar||||
-||DyspnoeaStatusPre_Surgery||12||varchar||||
-||!NumberOfPreviousMis||13||varchar||||
-||!IntervalBetweenOperationAndLastMi||14||varchar||||
-||!PreviousPci||15||varchar||||
-||~~!DateOfLastPci~||16||datetime||IGNORED||
-||PreviousCardiac_VascularOrThoracicSurgicalInterven||17||varchar||||
-||~~!DateOfLastCardiacOperation~~||18||datetime||IGNORED||
-||!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||
-||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||||
-||!NumberOfPreviousHeartOperations||54||int||||
-||!ResponsibleConsultantSurgeon||55||varchar||||
-||!FirstOperator||56||varchar||||
-||!FirstAssistant||57||varchar||||
-||!FirstAssistantGrade||58||varchar||||
-||FirstAssistant_CalmanYearOfTrainee||59||varchar||||
-||!ResponsibleConsultantAnaesthetist||60||varchar||||
-||!OperationFindings||61||varchar||||
-||!ReferringCardiologist||62||varchar||||
-||~~!DateOfReferral~~||63||datetime||IGNORED||
-||!DrugsOnAdmission||64||varchar||||
-||Allergies||65||varchar||||
-||!AllOtherAssistants||66||varchar||||
-||!WaitingListStatusUpdated||67||varchar||||
-||!SprCases||68||varchar||||
-||~~!DateOfCurrentStatus~~||69||datetime||IGNORED||
-||~~!DateOfEndStatus~~||70||datetime||IGNORED||
-||~~!DateTimeRecordCreated~~||71||datetime||IGNORED||
-||~~!DateTimeRecordLastChanged~~||72||datetime||IGNORED||
-||!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||||
 
 === CS2010F_PostProcedure
 
 ||Field Name||Column ID||Type||Comments||
-||~~!EntryId~~||1||int||IGNORED||
-||~~!PatientId~~||2||int||IGNORED||
-||!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||
-||!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||||
-||!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||||
-||TeachingOfOtherStaffComments_sa||76||varchar||||
-||TeachingOfOtherStaffCommentsMade_sa||77||varchar||||
-||TeachingOfOtherStaffBySa_sa||78||varchar||||
-||IabpRemovalComments_sa||79||text||||
-||IabpRemovalCommentsMade_sa||80||varchar||||
-||IabpRemovalBySa_sa||81||varchar||||
-||IabpInsertionComments_sa||82||text||||
-||IabpInsertionCommentsMade_sa||83||varchar||||
-||IabpInsertionBySa_sa||84||varchar||||
-||~~SternotomyClosureComments_sa~~||85||text||IGNORED||
-||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||
-||~~!DischargedFromCardiacSurgery~~||115||date||IGNORED||
-||!TotalCardiacSurgeryLosDays||116||float||||
-||~~!DateOfFollowUp~~||117||date||IGNORED||
-||!BloodUsed||118||varchar||||
-||!MutisystemFailure||119||varchar||||
-||~~!DateFirstAdmittedToCicu~~||120||date||IGNORED||
-||~~!DateFirstDischargedFromCicu~~||121||date||IGNORED||
-||!TotalFirstStayOnCicu||122||float||||
-||!ReAdmittedToCicu||123||varchar||||
-||~~!DateOfSecondAdmissionToCicu~~||124||date||IGNORED||
-||~~!DateOfSecondDischargeFromCicu~~||125||date||IGNORED||
-||SecondAdmissionTotalStay_nignts||126||float||||
-||~~!DateOfThirdAdmissionToCicu~~||127||date||IGNORED||
-||~~!DateOfThirdDischargeFromCicu~~||128||date||IGNORED||
-||ThirdAdmissionToCicuTotalStay_nights||129||float||||
-||!InsertionOfPacemakerWiresViaVatsProcedure||130||varchar||||
-||!IntubationTimeInHours||131||int||||
-||~~!AuditTrail~~||132||text||IGNORED||
-||!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||||
-||!MedicalRecordNumber||144||varchar||||
-||~~DateAddedToW_l~~||145||date||IGNORED||
-||AddedToW_l||146||varchar||||
-||~~!DateOfFourthAdmissionToCicu~~||147||date||IGNORED||
-||~~!DateOfFourthDischargeFromCicu~~||148||date||IGNORED||
-||~~!DateOfFifthAdmissionToCicu~~||149||date||IGNORED||
-||~~!DateOfFifthDischargeFromCicu~~||150||date||IGNORED||
-||!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||
-||!SecondBypassTotal||159||int||||
-||!SecondCrossClampTotal||160||int||||
-||!SecondCiculatoryArrestTotal||161||int||||
-||!CouncilCase||162||varchar||||
-||!InitialConsultantInJointCase||163||varchar||||
-||~~!ArrhythmiaOtherComplicationFreeText~~||164||text||IGNORED||
-||~~!LowCardiacOutputOtherComplicationFreeText~~||165||text||IGNORED||
-||~~!PulmonaryOtherComplicationFreeText~~||166||text||IGNORED||
-||~~!RenalOtherComplicationFreeText~~||167||text||IGNORED||
-||~~!GastrointestinalOtherComplicationFreeText~~||168||text||IGNORED||
-||!InfectiveOtherComplicationFreeText||169||varchar||||
-||!SickNoteOffered||170||varchar||||
-||!IfSickNoteOfferedDurationInDays||171||int||||
-||!AdviceToGp||172||varchar||||
-||!NameOfDischargingDoctor||173||varchar||||
-||!GradeOfDischargingDoctor||174||varchar||||
-||!PagerNumber||175||varchar||||
-||!DrugSensitivity||176||varchar||||
-||Drug1||177||varchar||||
-||DrugRoute1||178||varchar||||
-||NumberOfDays1||179||int||||
-||Continue1||180||varchar||||
-||Drug2||181||varchar||||
-||DrugRoute2||182||varchar||||
-||NumberOfDays2||183||int||||
-||Continue2||184||varchar||||
-||Drug3||185||varchar||||
-||DrugRoute3||186||varchar||||
-||NumberOfDays3||187||int||||
-||Continue3||188||varchar||||
-||Drug4||189||varchar||||
-||DrugRoute4||190||varchar||||
-||NumberOfDays4||191||int||||
-||Continue4||192||varchar||||
-||Drug5||193||varchar||||
-||DrugRoute5||194||varchar||||
-||NumberOfDays5||195||int||||
-||Continue5||196||varchar||||
-||Drug6||197||varchar||||
-||DrugRoute6||198||varchar||||
-||NumberOfDays6||199||int||||
-||Continue6||200||varchar||||
-||Drug7||201||varchar||||
-||DrugRoute7||202||varchar||||
-||NumberOfDays7||203||int||||
-||Continue7||204||varchar||||
-||Drug8||205||varchar||||
-||DrugRoute8||206||varchar||||
-||NumberOfDays8||207||int||||
-||Continue8||208||varchar||||
-||Drug9||209||varchar||||
-||DrugRoute9||210||varchar||||
-||NumberOfDays9||211||int||||
-||Continue9||212||varchar||||
-||Drug10||213||varchar||||
-||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||||
-||DrugForm19||250||varchar||||
-||DrugDose19||251||varchar||||
-||DrugRoute19||252||varchar||||
-||DrugFrequency19||253||varchar||||
-||NumberOfDays19||254||int||||
-||Continue19||255||varchar||||
-||DrugNameAndStrength20||256||varchar||||
-||DrugForm20||257||varchar||||
-||DrugDose20||258||varchar||||
-||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||||
-||!FollowUpRequired||294||varchar||||
-||FollowUpTimeInWeeks_months||295||varchar||||
-||!MedicationChangedByPharmacist||296||varchar||||
-||~~!StatePharmacistChanges~~||297||text||IGNORED||
-||!InformationGivenToPatient||298||varchar||||
-||!DateTimeRecordCreated||299||varchar||||
-||!DateTimeRecordLastChanged||300||varchar||||
-||!EnteredByTag||301||varchar||||
-||!HospitalTag||302||varchar||||
 
 === CS2010F_PreProcedure
 
 ||Field Name||Column ID||Type||Comments||
-||~~!EntryId~~||1||int||IGNORED||
-||~~!PatientId~~||2||int||IGNORED||
-||~~!DateOfOperation~~||3||date||IGNORED||
-||~~!TimeOfEntry~~||4||time||IGNORED||
-||!EntryStatus||5||varchar||||
-||~~!PreviousEntry~~||6||int||IGNORED||
-||~~!NextEntry~~||7||int||IGNORED||
-||!AgeAtOperation||8||int||||
-||Gender||9||varchar||||
-||~~!DateOfAdmission~~||10||date||||
-||AnginaStatusPre_Surgery||11||varchar||||
-||DyspnoeaStatusPre_Surgery||12||varchar||||
-||!NumberOfPreviousMis||13||varchar||||
-||!IntervalBetweenSurgeryAndLastMi||14||varchar||||
-||!PreviousPci||15||varchar||||
-||!PreviousCardiacSurgery||16||varchar||||
-||~~!DateOfLastCardiacOperation~~||17||date||IGNORED||
-||!DiabetesManagement||18||varchar||||
-||!HistoryOfHypertension||19||varchar||||
-||!CigaretteSmokingHistory||20||varchar||||
-||!HistoryOfPulmonaryDisease||21||varchar||||
-||!HistoryOfNeurologicalDisease||22||varchar||||
-||Pre_OperativeHeartRhythm||23||varchar||||
-||~~!DateOfLastCatheterisation~~||24||date||IGNORED||
-||!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||||
-||!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||||
-||!ReferringCardiologist||50||varchar||||
-||~~!DateOfReferral~~||51||date||IGNORED||
-||!DrugsOnAdmission||52||varchar||||
-||Allergies||53||varchar||||
-||!AllOtherAssistants||54||varchar||||
-||!WaitingListStatusUpdated||55||varchar||||
-||!SprCases||56||varchar||||
-||~~!DateOfCurrentStatus~~||57||date||IGNORED||
-||~~!DateOfEndStatus~~||58||date||IGNORED||
-||~~!DateTimeRecordCreated~~||59||varchar||IGNORED||
-||!DateTimeRecordLastChanged||60||varchar||||
-||!EnteredByTag||61||varchar||||
-||!EntryCurrentStatus||62||varchar||||
-||!EntryEndStatus||63||varchar||||
-||!HospitalTag||64||varchar||||
 
 === EPS_EPSINIVW
 
 ||Field Name||Column ID||Type||Comments||
-||~~!EntryId~~||1||int||IGNORED||
-||~~!PatientId~~||2||int||IGNORED||
-||~~!DateOfEntry~~||3||date||IGNORED||
-||~~!TimeofEPSRFA~~||4||time||IGNORED||
-||!EntryStatus||5||varchar||||
-||~~!PreviousEntry~~||6||int||||
-||~~!NextEntry~~||7||int||IGNORED||
-||~~!DateOfAdmission~~||8||date||IGNORED||
-||~~!DateOfDischarge~~||9||date||IGNORED||
-||~~!DateAddedToWaitingList~~||10||date||IGNORED||
-||!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||||
-||!GeneratorPacingMode||20||varchar||||
-||Preeps_ablationPreviousIntervention||21||varchar||||
-||Preeps_ablationArrhythmia||22||varchar||||
-||Eps_ablationIndicationForIntervention||23||varchar||||
-||!Preicd_ablationQrsDuration||24||int||||
-||Date_timeOfProcedure||25||varchar||||
-||!ProcedureUrgency||26||varchar||||
-||!OperativeUrgency||27||varchar||||
-||!PrimaryOperator||28||varchar||||
-||!FirstOperatorStatus||29||varchar||||
-||!SecondOperator||30||varchar||||
-||!SecondOperatorStatus||31||varchar||||
-||!ThirdOperator||32||varchar||||
-||!ThirdOperatorStatus||33||varchar||||
-||Ccso||34||varchar||||
-||AblationProcedure_s||35||varchar||||
-||!AccessoryPathway||36||varchar||||
-||!NumberOfElectrodeCatheters||37||int||||
-||!MappingTechnique||38||varchar||||
-||!TransseptalApproach||39||varchar||||
-||Anticoagulation||40||varchar||||
-||HeparinDose_iu||41||int||||
-||!TotalFluoroscopyTime||42||float||||
-||!ProcedureStartTime||43||varchar||||
-||!ProcedureEndTime||44||varchar||||
-||!ProcedureDuration||45||int||||
-||!AblationAttempted||46||varchar||||
-||!WaitingTime||47||int||||
-||!WhyAblationNotAttempted||48||varchar||||
-||!NumberOfEnergyApplications||49||int||||
-||!TotalTimeOfEnergyApplication||50||int||||
-||!AblationEnergySource||51||varchar||||
-||Catheter||52||varchar||||
-||!CatheterReach||53||varchar||||
-||Ga||54||varchar||||
-||!WhichPulmonaryVeinsAblated||55||varchar||||
-||Success||56||varchar||||
-||!TransientHeartBlock||57||varchar||||
-||!AblationComplications||58||varchar||||
-||!AvBlock||59||varchar||||
-||!DeviceImplanted||60||varchar||||
-||IntraopDrugs2||61||varchar||||
-||ProcedureReport_comment||62||varchar||||
-||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||||
-||!PreOpStay||71||int||||
-||!PostOpStay||72||int||||
-||!TotalHospitalStay||73||int||||
-||!TotalTimeOnWaitingList||74||int||||
-||!ReferringGpOrDentist||75||varchar||||
-||!NameOfReferringGpOrDentist||76||varchar||||
-||!GpPracticeCode||77||varchar||||
-||Pct||78||varchar||||
-||!MedicalRecordNumberAtTimeOfEntry||79||varchar||||
-||!AuditTrail||80||varchar||||
-||!CatheterCcad||81||varchar||||
-||!CatheterReachCcad||82||varchar||||
-||!AfAblationStrategies||83||varchar||||
-||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||
-||~~!DateOfEndStatus~~||94||date||IGNORED||
-||!DateTimeRecordCreated||95||varchar||||
-||!DateTimeRecordLastChanged||96||varchar||||
-||!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||
-||~~!PatientId~~||2||int||IGNORED||
-||~~!DateofHospitalAdmission~~||3||datetime||IGNORED||
-||~~!TimeofHospitalAdmission~~||4||datetime||IGNORED||
-||!EntryStatus||5||varchar||||
-||~~!PreviousEntry~~||6||int||IGNORED||
-||~~!NextEntry~~||7||int||IGNORED||
-||Age||8||int||||
-||~~!DateOfAdmissionToCcu~~||9||datetime||IGNORED||
-||!DirectAdmission||10||varchar||||
-||!GenderCcad||11||varchar||||
-||!EthnicOriginCcad||12||varchar||||
-||!PatientAdminStatusCcad||13||varchar||||
-||!HospitalCentreCode||14||varchar||||
-||!GpPracticeCodeCcad||15||varchar||||
-||!InitialDiagnosisCcad||16||varchar||||
-||!OtherAdmissionDiagnosis||17||varchar||||
-||!MethodOfAdmissionCcad||18||varchar||||
-||!EcgDeterminingTreatmentCcad||19||varchar||||
-||WhereWasAspirin_otherAntiplateletGivenCcad||20||varchar||||
-||!PreviousAmiCcad||21||varchar||||
-||!PreviousAnginaCcad||22||varchar||||
-||!HypertensionCcad||23||varchar||||
-||!HypercholesterolaemiaCcad||24||varchar||||
-||!PeripheralVascularDiseaseCcad||25||varchar||||
-||!CerebrovascularDiseaseCcad||26||varchar||||
-||!AsthmaOrCopdCcad||27||varchar||||
-||!ChronicRenalFailureCcad||28||varchar||||
-||!HeartFailureCcad||29||varchar||||
-||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||||
-||!OnsetOfSymptomsCcad||52||varchar||||
-||!CallForHelpCcad||53||varchar||||
-||!ArrivalOfFirstProfessionalHelpCcad||54||varchar||||
-||!ArrivalOfEmergencyServiceCcad||55||varchar||||
-||!AmbulanceJobNumberCcad||56||varchar||||
-||!ArrivalAtHospitalCcad||57||varchar||||
-||WasReperfusionAttempted_Ccad||58||varchar||||
-||!ReasonThrombolyticTreatmentNotGivenCcad||59||varchar||||
-||!StartOfReperfusionTreatmentCcad||60||varchar||||
-||!DelayBeforeTreatmentCcad||61||varchar||||
-||WhereWasInitialReperfusionTreatmentGiven_Ccad||62||varchar||||
-||WhoTookTheInitialDecisionToAttemptReperfusion_Ccad||63||varchar||||
-||!FirstCardiacArrestCcad||64||varchar||||
-||!CardiacArrestCcad||65||varchar||||
-||!ArrestPresentingRhythmCcad||66||varchar||||
-||!OutcomeOfArrestCcad||67||varchar||||
-||!AdmissionWardCcad||68||varchar||||
-||PeakCreatinineKinase_ck_Ccad||69||float||||
-||!PeakTroponinCcad||70||float||||
-||!TroponinAssayCcad||71||varchar||||
-||!TroponinReferenceValue||72||varchar||||
-||!UnfractionatedHeparinCcad||73||varchar||||
-||!LowMolecularWeightHeparinCcad||74||varchar||||
-||!ThienopyridinePlateletInhibitorCcad||75||varchar||||
-||!OtherOralAntiplateletAgentCcad||76||varchar||||
-||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||
-||~~!DateOfDischargeFromCcu~~||91||datetime||IGNORED||
-||!DischargedFromCcuDestination||92||varchar||||
-||!DischargeDiagnosisCcad||93||varchar||||
-||!OtherDischargeDiagnosis||94||varchar||||
-||!DiagamiCcad||95||varchar||||
-||!RecommendedTherapyAtDischargeCcad||96||varchar||||
-||!DaysInHospital||97||int||||
-||!DaysInCcu||98||int||||
-||!BleedingComplicationsCcad||99||varchar||||
-||!DeathInHospitalCcad||100||varchar||||
-||!DischargedOnBetaBlockerCcad||101||varchar||||
-||!AceInhibitorCcad||102||varchar||||
-||!DischargedOnStatinCcad||103||varchar||||
-||!DischargedOnAspirinOrOtherPlateletDrugCcad||104||varchar||||
-||!CardiacRehabilitationCcad||105||varchar||||
-||!ExerciseTestPerformedCcad||106||varchar||||
-||!EchocardiographyCcad||107||varchar||||
-||!RadionuclideStudyCcad||108||varchar||||
-||!CoronaryAngiographyAtThisAdmissionCcad||109||varchar||||
-||!CoronaryInterventionPerformedAtThisAdmissionCcad||110||varchar||||
-||~~DateOfReferralForInvestigation_intervention~~||111||datetime||IGNORED||
-||!ModeOfDischargeCcad||112||varchar||||
-||~~!DateOfTransferForDayCaseInvestigationCcad~~||113||datetime||IGNORED||
-||~~!DateOfAngioPerformedLocallyCcad~~||114||datetime||IGNORED||
-||~~!DateOfFirstInterventionOrSurgeryPerformedLocallyCc~~||115||datetime||IGNORED||
-||!ReferralCentreCcad||116||varchar||||
-||!ReferringHospitalCcad||117||varchar||||
-||!PatientCaseRecordNumberAtReferralCentreCcad||118||varchar||||
-||!FollowedUpByCcad||119||varchar||||
-||!ReinfarctionCcad||120||varchar||||
-||!DischargedOnClopidogrelCcad||121||varchar||||
-||!DelayFromOnsetOfSymptomsToCallForHelp||122||float||||
-||!DelayFromCallForHelpToArrivalOfEmergencyServices||123||float||||
-||!DelayFromCallForHelpToArrivalInHospital||124||float||||
-||!DelayFromArrivalInHospitalToReperfusionTreatment||125||float||||
-||!DelayFromCallForHelpToReperfusionTreatment||126||float||||
-||!DelayFromOnsetOfSymptomsToReperfusionTreatment||127||float||||
-||!TotalTimeOnScene||128||float||||
-||DelayFromReferralForInvestigation_interventionToTr||129||float||||
-||!PctCode||130||varchar||||
-||!MedicalRecordNumberAtTimeOfEntryCcad||131||varchar||||
-||Comments||132||varchar||||
-||!PreAlertCall||133||varchar||||
-||!PickUpPostCode||134||varchar||||
-||!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||
-||~~!DateOfEndStatus~~||149||datetime||IGNORED||
-||~~!DateTimeRecordCreated~~||150||datetime||IGNORED||
-||~~!DateTimeRecordLastChanged~~||151||datetime||IGNORED||
-||!EnteredByTag||152||varchar||||
-||!EntryCurrentStatus||153||varchar||||
-||!EntryEndStatus||154||varchar||||
-||!HospitalTag||155||varchar||||
 
 === GGHMINAPNEW
 
 ||Field Name||Column ID||Type||Comments||
-||~~!EntryId~~||1||int||IGNORED||
-||~~!PatientId~~||2||int||IGNORED||
-||~~!DateofAdmissiontoCCU|~~|3||datetime||IGNORED||
-||~~!TimeofAdmissiontoCCU~~||4||datetime||IGNORED||
-||!EntryStatus||5||varchar||||
-||~~!PreviousEntry~~||6||int||IGNORED||
-||~~!NextEntry~~||7||int||IGNORED||
-||!OnsetOfSymptomsCcad||8||varchar||||
-||!MethodOfAdmissionCcad||9||varchar||||
-||!CallForHelpCcad||10||varchar||||
-||!ArrivalOfEmergencyServiceCcad||11||varchar||||
-||!ArrivalAtHospitalCcad||12||varchar||||
-||!DateAndTimeOfReperfusionTreatmentCcad||13||varchar||||
-||!FirstCardiacArrestCcad||14||varchar||||
-||!CardiacArrestLocationCcad||15||varchar||||
-||!ArrestPresentingRhythmCcad||16||varchar||||
-||!OutcomeOfArrestCcad||17||varchar||||
-||!InitialDiagnosisCcad||18||varchar||||
-||!EcgDeterminingTreatmentCcad||19||varchar||||
-||!AdditionalReperfusionTreatmentCcad||20||varchar||||
-||WhereWasInitialReperfusionTreatmentGiven_Ccad||21||varchar||||
-||WhoTookTheInitialDecisionToAttemptReperfusion_Ccad||22||varchar||||
-||!ReasonReperfusionTreatmentNotGivenCcad||23||varchar||||
-||Age||24||int||||
-||WhereWasAspirin_otherAntiplateletGivenCcad||25||varchar||||
-||!AdmissionWardCcad||26||varchar||||
-||!AdmittingConsultantCcad||27||varchar||||
-||!DischargeDiagnosisCcad||28||varchar||||
-||!DeathInHospitalCcad||29||varchar||||
-||~~!DateOfDischargeOrDeathCcad~~||30||datetime||IGNORED||
-||!DischargedOnBetaBlockerCcad||31||varchar||||
-||!AceInhibitorCcad||32||varchar||||
-||!DischargedOnStatinCcad||33||varchar||||
-||!DischargedOnAspirinOrOtherPlateletDrugCcad||34||varchar||||
-||!CardiacRehabilitationCcad||35||varchar||||
-||!ExerciseTestPerformedCcad||36||varchar||||
-||!EchocardiographyCcad||37||varchar||||
-||!RadionuclideStudyCcad||38||varchar||||
-||!CoronaryAngiographyCcad||39||varchar||||
-||!CoronaryInterventionCcad||40||varchar||||
-||!GenderCcad||41||varchar||||
-||!DelayBeforeTreatmentCcad||42||varchar||||
-||!DaysInHospital||43||int||||
-||!DelayFromOnsetOfSymptomsToCallForHelp||44||float||||
-||!DelayFromCallForHelpToArrivalOfEmergencyServices||45||float||||
-||!DelayFromCallForHelpToArrivalInHospital||46||float||||
-||!DelayFromArrivalInHospitalToReperfusionTreatment||47||float||||
-||!DelayFromCallForHelpToReperfusionTreatment||48||float||||
-||!DelayFromOnsetOfSymptomsToReperfusionTreatment||49||float||||
-||!AmbulanceJobNumberCcad||50||varchar||||
-||PeakCreatinineKinase_ck_Ccad||51||float||||
-||!PeakTroponinCcad||52||float||||
-||!TroponinAssayCcad||53||varchar||||
-||!TroponinReferenceValue||54||varchar||||
-||!PatientAdminStatusCcad||55||varchar||||
-||!PreviousAmiCcad||56||varchar||||
-||!PreviousAnginaCcad||57||varchar||||
-||!HypertensionCcad||58||varchar||||
-||!HypercholesterolaemiaCcad||59||varchar||||
-||!PeripheralVascularDiseaseCcad||60||varchar||||
-||!CerebrovascularDiseaseCcad||61||varchar||||
-||!AsthmaOrCopdCcad||62||varchar||||
-||!ChronicRenalFailureCcad||63||varchar||||
-||!HeartFailureCcad||64||varchar||||
-||CardiacEnzymes_markersRaisedCcad||65||varchar||||
-||!SerumCholesterolCcad||66||float||||
-||!SmokingStatusCcad||67||varchar||||
-||!DiabetesCcad||68||varchar||||
-||!PreviousPciCcad||69||varchar||||
-||!PreviousCabgCcad||70||varchar||||
-||!SystolicBpCcad||71||int||||
-||!HeartRateCcad||72||int||||
-||!ArrivalOfFirstProfessionalHelpCcad||73||varchar||||
-||!UnfractionatedHeparinCcad||74||varchar||||
-||!LowMolecularWeightHeparinCcad||75||varchar||||
-||!ThienopyridinePlateletInhibitorCcad||76||varchar||||
-||!OtherOralAntiplateletAgentCcad||77||varchar||||
-||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||
-||~~!DaycaseTransferDateCcad~~||93||datetime||IGNORED||
-||~~!LocalAngioDateCcad~~||94||datetime||IGNORED||
-||~~!LocalInterventionDateCcad~~||95||datetime||IGNORED||
-||!InterventionalCentreCodeCcad||96||varchar||||
-||!OtherAdmissionDiagnosis||97||varchar||||
-||!OtherDischargeDiagnosis||98||varchar||||
-||!DischargedFromCcuDestination||99||varchar||||
-||Gp_pctCodeCcad||100||varchar||||
-||DelayFromReferralForInvestigation_interventionToTr||101||float||||
-||!PctCode||102||varchar||||
-||!MedicalRecordNumberAtTimeOfEntryCcad||103||varchar||||
-||!SerumGlucoseCcad||104||float||||
-||!DiabeticTherapyAtDischargeCcad||105||varchar||||
-||!AuditTrail||106||varchar||||
-||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||||
-||!AmbulanceDriver||121||varchar||||
-||!AmbulanceAttendant||122||varchar||||
-||!AmbulanceResponder||123||varchar||||
-||Comments||124||varchar||||
-||!PreAlertCall||125||varchar||||
-||!PickUpPostCode||126||varchar||||
-||!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||||
-||!HospitalCentreCode||138||varchar||||
-||!TotalTimeOnScene||139||float||||
-||!DateAndTimeOfFirstDiagnosticEcg||140||varchar||||
-||!CardiologicalCareDuringAdmissionCcad||141||varchar||||
-||!CreatinineCcad||142||float||||
-||!HaemoglobinCcad||143||float||||
-||!SiteOfInfarctionCcad||144||varchar||||
-||!FondaparinuxCcad||145||varchar||||
-||!InitialReperfusionTreatmentCcad||146||varchar||||
-||InPatientManagementOfHyperglycaemia_diabetesCcad||147||varchar||||
-||~~!DateOfReturnToReferringHospital~~||148||datetime||IGNORED||
-||!DelayForCallToFrv||149||float||||
-||!DelayFrvToFullCrew||150||float||||
-||!DelayCallToDepart||151||float||||
-||!PatientEthnicGroup||152||varchar||||
-||IncludeInD2n||153||varchar||||
-||!OtherComments||154||varchar||||
-||!CathLabArrivalTime||155||varchar||||
-||!BalloonTime||156||varchar||||
-||!DelayCcuToLab||157||float||||
-||!DelayCallToBalloon||158||float||||
-||!DelayDoorToBalloon||159||float||||
-||!DelayLabToBalloon||160||float||||
-||!IncludeInCallToNeedle||161||varchar||||
-||!HospitalRefferedFrom||162||varchar||||
-||FirstMustafa1||163||int||||
-||SecondMustafa2||164||int||||
-||!DaysFromAdmissionToDeath||165||int||||
-||~~!DateOfCurrentStatus~~||166||datetime||IGNORED||
-||~~!DateOfEndStatus~~||167||datetime||IGNORED||
-||~~!DateTimeRecordCreated~~||168||datetime||IGNORED||
-||~~!DateTimeRecordLastChanged~~||169||datetime||IGNORED||
-||!EnteredByTag||170||varchar||||
-||!EntryCurrentStatus||171||varchar||||
-||!EntryEndStatus||172||varchar||||
-||!HospitalTag||173||varchar||||
 
 === GGHMINAPNEW_GGHMINAPINIVW
 
 ||Field Name||Column ID||Type||Comments||
-||EntryId||1||int||||
-||PatientId||2||int||||
-||DateofAdmissiontoCCU||3||date||||
-||TimeofAdmissiontoCCU||4||time||||
-||EntryStatus||5||varchar||||
-||PreviousEntry||6||int||||
-||NextEntry||7||int||||
-||OnsetOfSymptomsCcad||8||varchar||||
-||MethodOfAdmissionCcad||9||varchar||||
-||CallForHelpCcad||10||varchar||||
-||ArrivalOfEmergencyServiceCcad||11||varchar||||
-||ArrivalAtHospitalCcad||12||varchar||||
-||DateAndTimeOfReperfusionTreatmentCcad||13||varchar||||
-||FirstCardiacArrestCcad||14||varchar||||
-||CardiacArrestLocationCcad||15||varchar||||
-||ArrestPresentingRhythmCcad||16||varchar||||
-||OutcomeOfArrestCcad||17||varchar||||
-||InitialDiagnosisCcad||18||varchar||||
-||EcgDeterminingTreatmentCcad||19||varchar||||
-||AdditionalReperfusionTreatmentCcad||20||varchar||||
-||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||||
-||DischargedOnBetaBlockerCcad||31||varchar||||
-||AceInhibitorCcad||32||varchar||||
-||DischargedOnStatinCcad||33||varchar||||
-||DischargedOnAspirinOrOtherPlateletDrugCcad||34||varchar||||
-||CardiacRehabilitationCcad||35||varchar||||
-||ExerciseTestPerformedCcad||36||varchar||||
-||EchocardiographyCcad||37||varchar||||
-||RadionuclideStudyCcad||38||varchar||||
-||CoronaryAngiographyCcad||39||varchar||||
-||CoronaryInterventionCcad||40||varchar||||
-||GenderCcad||41||varchar||||
-||DelayBeforeTreatmentCcad||42||varchar||||
-||DaysInHospital||43||int||||
-||DelayFromOnsetOfSymptomsToCallForHelp||44||float||||
-||DelayFromCallForHelpToArrivalOfEmergencyServices||45||float||||
-||DelayFromCallForHelpToArrivalInHospital||46||float||||
-||DelayFromArrivalInHospitalToReperfusionTreatment||47||float||||
-||DelayFromCallForHelpToReperfusionTreatment||48||float||||
-||DelayFromOnsetOfSymptomsToReperfusionTreatment||49||float||||
-||AmbulanceJobNumberCcad||50||varchar||||
-||PeakCreatinineKinase_ck_Ccad||51||float||||
-||PeakTroponinCcad||52||float||||
-||TroponinAssayCcad||53||varchar||||
-||TroponinReferenceValue||54||varchar||||
-||PatientAdminStatusCcad||55||varchar||||
-||PreviousAmiCcad||56||varchar||||
-||PreviousAnginaCcad||57||varchar||||
-||HypertensionCcad||58||varchar||||
-||HypercholesterolaemiaCcad||59||varchar||||
-||PeripheralVascularDiseaseCcad||60||varchar||||
-||CerebrovascularDiseaseCcad||61||varchar||||
-||AsthmaOrCopdCcad||62||varchar||||
-||ChronicRenalFailureCcad||63||varchar||||
-||HeartFailureCcad||64||varchar||||
-||CardiacEnzymes_markersRaisedCcad||65||varchar||||
-||SerumCholesterolCcad||66||float||||
-||SmokingStatusCcad||67||varchar||||
-||DiabetesCcad||68||varchar||||
-||PreviousPciCcad||69||varchar||||
-||PreviousCabgCcad||70||varchar||||
-||SystolicBpCcad||71||int||||
-||HeartRateCcad||72||int||||
-||ArrivalOfFirstProfessionalHelpCcad||73||varchar||||
-||UnfractionatedHeparinCcad||74||varchar||||
-||LowMolecularWeightHeparinCcad||75||varchar||||
-||ThienopyridinePlateletInhibitorCcad||76||varchar||||
-||OtherOralAntiplateletAgentCcad||77||varchar||||
-||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||||
-||DaycaseTransferDateCcad||93||date||||
-||LocalAngioDateCcad||94||date||||
-||LocalInterventionDateCcad||95||date||||
-||OtherAdmissionDiagnosis||96||varchar||||
-||OtherDischargeDiagnosis||97||varchar||||
-||DischargedFromCcuDestination||98||varchar||||
-||Gp_pctCodeCcad||99||varchar||||
-||DelayFromReferralForInvestigation_interventionToTr||100||float||||
-||PctCode||101||varchar||||
-||MedicalRecordNumberAtTimeOfEntryCcad||102||varchar||||
-||SerumGlucoseCcad||103||float||||
-||DiabeticTherapyAtDischargeCcad||104||varchar||||
-||AuditTrail||105||text||||
-||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||||
-||AmbulanceDriver||119||varchar||||
-||AmbulanceAttendant||120||varchar||||
-||AmbulanceResponder||121||varchar||||
-||Comments||122||text||||
-||PreAlertCall||123||varchar||||
-||PickUpPostCode||124||varchar||||
-||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||||
-||HospitalCentreCode||136||varchar||||
-||TotalTimeOnScene||137||float||||
-||DateAndTimeOfFirstDiagnosticEcg||138||varchar||||
-||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||||
-||DelayForCallToFrv||147||float||||
-||DelayFrvToFullCrew||148||float||||
-||DelayCallToDepart||149||float||||
-||PatientEthnicGroup||150||varchar||||
-||IncludeInD2n||151||varchar||||
-||OtherComments||152||varchar||||
-||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||||
-||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||||
-||DateOfCurrentStatus||196||date||||
-||DateOfEndStatus||197||date||||
-||DateTimeRecordCreated||198||varchar||||
-||DateTimeRecordLastChanged||199||varchar||||
-||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||||
-||PatientId||2||int||||
-||DateOfProcedure_Implant||3||date||||
-||TimeOfProcedure_Implant||4||time||||
-||EntryStatus||5||varchar||||
-||PreviousEntry||6||int||||
-||NextEntry||7||int||||
-||HospitalIdentifierCcad||8||varchar||||
-||PatientGenderCcad||9||varchar||||
-||PatientEthnicGroupCcad||10||varchar||||
-||PatientAdminStatusCcad||11||varchar||||
-||AuditTrail||12||text||||
-||AgeAtProcedure||13||int||||
-||DateOfAdmission||14||date||||
-||DateOfFirstImplantCcad||15||date||||
-||PredeviceAetiologyCcad||16||varchar||||
-||Predevice_eps_ablationPresentingSymptomCcad||17||varchar||||
-||PredeviceEcgCcad||18||varchar||||
-||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||||
-||DateAndTimeProcedureEnd||25||varchar||||
-||TotalTimeOfProcedure||26||int||||
-||InterventionCcad||27||varchar||||
-||ConsultantResponsibleForProcedureCcad||28||varchar||||
-||PrimaryOperatorCcadOldData||29||varchar||||
-||GeneratorPacingModeCcad||30||varchar||||
-||GeneratorManufacturerCcad||31||varchar||||
-||GeneratorModelCcad||32||varchar||||
-||GeneratorSerialNumberCcad||33||varchar||||
-||GeneratorSiteOfImplantCcad||34||varchar||||
-||DateGeneratorChangedCcad||35||date||||
-||WhyThisGeneratorEventuallyExplantedCcad||36||varchar||||
-||VentricularLeadManufacturerCcad||37||varchar||||
-||VentricularLeadModelCcad||38||varchar||||
-||VentricularLeadSerialNumberCcad||39||varchar||||
-||VentricularLeadImplantApproachCcad||40||varchar||||
-||DateVentricularLeadChangedCcad||41||date||||
-||WhyThisVLeadEventuallyExplantedCcad||42||varchar||||
-||AtrialLeadManufacturerCcad||43||varchar||||
-||AtrialLeadModelCcad||44||varchar||||
-||AtrialLeadSerialNumberCcad||45||varchar||||
-||AtrialLeadImplantApproachCcad||46||varchar||||
-||DateAtrialLeadChangedCcad||47||date||||
-||WhyThisALeadEventuallyExplantedCcad||48||varchar||||
-||VentricularLead2ManufacturerCcad||49||varchar||||
-||VentricularLead2ModelCcad||50||varchar||||
-||VentricularLead2SerialNumberCcad||51||varchar||||
-||VentricularLead2ImplantApproachCcad||52||varchar||||
-||DateVentricularLead2ChangedCcad||53||date||||
-||WhyThisVLead2EventuallyExplantedCcad||54||varchar||||
-||AtrialLead2ManufacturerCcad||55||varchar||||
-||AtrialLead2ModelCcad||56||varchar||||
-||AtrialLead2SerialNumberCcad||57||varchar||||
-||AtrialLead2ImplantApproachCcad||58||varchar||||
-||DateAtrialLead2ChangedCcad||59||date||||
-||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||||
-||DeviceFileClosureCcad||78||varchar||||
-||EpsTestedNice||79||varchar||||
-||TypeOfProcedure||80||varchar||||
-||Ccso||81||varchar||||
-||DateOfVentricularLeadImplant||82||date||||
-||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||||
-||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||||
-||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||||
-||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||||
-||DateAtrialLeadCut_cappedAndBuried||136||date||||
-||DateVentricularLead2Cut_cappedAndBuried||137||date||||
-||DateAtrialLead2Cut_cappedAndBuried||138||date||||
-||ProcedureReport||139||varchar||||
-||GpAtTimeOfProcedure||140||varchar||||
-||NameOfGp||141||varchar||||
-||GpPracticeCode||142||varchar||||
-||Pct||143||varchar||||
-||MedicalRecordNumber||144||varchar||||
-||NumberOfDaysDeviceImplanted||145||int||||
-||DateOfExplant||146||date||||
-||DateOfDischarge||147||date||||
-||ComplicationsBeforeDischarge||148||varchar||||
-||DateOfComplication||149||date||||
-||TypeOfComplication||150||varchar||||
-||IfOtherComplicationPleaseState||151||varchar||||
-||DischargeDelayedDueToComplication||152||varchar||||
-||PacemakerChecksTransferred||153||varchar||||
-||TransferredTo||154||varchar||||
-||DateOfTransfer||155||date||||
-||ProcedureUrgency||156||varchar||||
-||OtherOperatorsOldData||157||varchar||||
-||SideUsed||158||varchar||||
-||Ward||159||varchar||||
-||PrimaryOperatorCcad||160||varchar||||
-||OtherOperators||161||varchar||||
-||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||||
-||EntryId||3||int||||
-||DateOfFollowup||4||date||||
-||TimeOfFollowup||5||time||||
-||EntryStatus||6||varchar||||
-||DateOfLastFollowup||7||date||||
-||DateTimeRecordCreated||8||varchar||||
-||DateTimeRecordLastChanged||9||varchar||||
-||EnteredByTag||10||varchar||||
-||HospitalTag||11||varchar||||
-||IsPrimaryFlw||12||bit||||
-||TimeOfLastFollowup||13||time||||
 
 === GGHPCI_INITIALGGHPCIVIEW
 
 ||Field Name||Column ID||Type||Comments||
-||EntryId||1||int||||
-||PatientId||2||int||||
-||DateofProcedureCCAD||3||date||||
-||TimeofProcedureCCAD||4||time||||
-||EntryStatus||5||varchar||||
-||PreviousEntry||6||int||||
-||NextEntry||7||int||||
-||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||||
-||DateAndTimeArrivalAtHospital_acsOnly_ccad||19||varchar||||
-||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||||
-||ConsultantResponsibleForProcedureCcad||42||varchar||||
-||FirstOperatorCcad||43||varchar||||
-||PrimaryOperatorStatusCcad||44||varchar||||
-||SecondOperatorCcad||45||varchar||||
-||SecondOperatorStatusCcad||46||varchar||||
-||ThirdOperatorCcad||47||varchar||||
-||ThirdOperatorStatusCcad||48||varchar||||
-||VesselsAttemptedCcad||49||varchar||||
-||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||||
-||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||||
-||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||||
-||DeviceFailureCcad||77||varchar||||
-||PciHospitalOutcomeCcad||78||varchar||||
-||EnzymesPostopCcad||79||varchar||||
-||StatusAtDischargeCcad||80||varchar||||
-||DischargeDateCcad||81||date||||
-||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||||
-||FollowOn_adhoc_ProcedureCcad||92||varchar||||
-||TrainingProcedureCcad||93||varchar||||
-||ResearchProcedureCcad||94||varchar||||
-||ResearchTitleCcad||95||varchar||||
-||ArterialAccessCcad||96||varchar||||
-||LargestBalloon_stentUsedCcad||97||float||||
-||LongestStented_TreatedSegmentCcad||98||int||||
-||ProceduralComplicationCcad||99||varchar||||
-||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||||
-||DesSize||118||varchar||||
-||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||||
-||MedicalRecordNumberAtTimeOfEntry||130||varchar||||
-||NameOfReferringGp||131||varchar||||
-||Gp||132||varchar||||
-||Pct||133||varchar||||
-||PracticeCode||134||varchar||||
-||DateOfDeathPostProcedure||135||date||||
-||IntervalBetweenProcedureAndDeath||136||int||||
-||AuditTrail||137||text||||
-||DateOfAdmission||138||date||||
-||TotalInpatientStay||139||float||||
-||ArrivalInPciHospital_acs_Ccad||140||varchar||||
-||DateAndTimeOfCallForHelp_stemiOnly_Ccad||141||varchar||||
-||ReferringHospitalCcad||142||varchar||||
-||DateAndTimeOfEcgTriggeringPpciPathwayCcad||143||varchar||||
-||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||||
-||WhiteHospitalOutcome||153||varchar||||
-||AngioNumber||154||int||||
-||TimeOfArrivalInLab||155||varchar||||
-||TimeOnTable||156||varchar||||
-||TimeOfSheathInsertion||157||varchar||||
-||TimeOfWireAcrossFirstLesion||158||varchar||||
-||TimeOffTable||159||varchar||||
-||DateAndTimeOfStemiAlert_stemiOnly||160||varchar||||
-||NameOfDoctorResponsibleForCompletingForm||161||varchar||||
-||ReasonForDelaysInLab||162||varchar||||
-||DateOfCholesterolResult||163||date||||
-||WasPatientPre_LoadedWithClopidogrel||164||varchar||||
-||ClopidogrelDose||165||varchar||||
-||DiagnosticDeviceUsedDuringProcedure||166||varchar||||
-||NameOfInfarctRelatedArtery_ira||167||varchar||||
-||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||||
-||DateOfEndStatus||179||date||||
-||DateTimeRecordCreated||180||varchar||||
-||DateTimeRecordLastChanged||181||varchar||||
-||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||||
-||PatientId||2||int||||
-||DateofAdmissiontoCCU||3||datetime||||
-||TimeofAdmissiontoCCU||4||datetime||||
-||EntryStatus||5||varchar||||
-||PreviousEntry||6||int||||
-||NextEntry||7||int||||
-||OnsetOfSymptomsCcad||8||varchar||||
-||MethodOfAdmissionCcad||9||varchar||||
-||CallForHelpCcad||10||varchar||||
-||ArrivalOfEmergencyServiceCcad||11||varchar||||
-||ArrivalAtHospitalCcad||12||varchar||||
-||DateAndTimeOfReperfusionTreatmentCcad||13||varchar||||
-||FirstCardiacArrestCcad||14||varchar||||
-||CardiacArrestLocationCcad||15||varchar||||
-||ArrestPresentingRhythmCcad||16||varchar||||
-||OutcomeOfArrestCcad||17||varchar||||
-||InitialDiagnosisCcad||18||varchar||||
-||EcgDeterminingTreatmentCcad||19||varchar||||
-||AdditionalReperfusionTreatmentCcad||20||varchar||||
-||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||||
-||DischargedOnBetaBlockerCcad||31||varchar||||
-||AceInhibitorCcad||32||varchar||||
-||DischargedOnStatinCcad||33||varchar||||
-||DischargedOnAspirinOrOtherPlateletDrugCcad||34||varchar||||
-||CardiacRehabilitationCcad||35||varchar||||
-||ExerciseTestPerformedCcad||36||varchar||||
-||EchocardiographyCcad||37||varchar||||
-||RadionuclideStudyCcad||38||varchar||||
-||CoronaryAngiographyCcad||39||varchar||||
-||CoronaryInterventionCcad||40||varchar||||
-||GenderCcad||41||varchar||||
-||DelayBeforeTreatmentCcad||42||varchar||||
-||DaysInHospital||43||int||||
-||DelayFromOnsetOfSymptomsToCallForHelp||44||float||||
-||DelayFromCallForHelpToArrivalOfEmergencyServices||45||float||||
-||DelayFromCallForHelpToArrivalInHospital||46||float||||
-||DelayFromArrivalInHospitalToReperfusionTreatment||47||float||||
-||DelayFromCallForHelpToReperfusionTreatment||48||float||||
-||DelayFromOnsetOfSymptomsToReperfusionTreatment||49||float||||
-||AmbulanceJobNumberCcad||50||varchar||||
-||PeakCreatinineKinase_ck_Ccad||51||float||||
-||PeakTroponinCcad||52||float||||
-||TroponinAssayCcad||53||varchar||||
-||TroponinReferenceValue||54||varchar||||
-||PatientAdminStatusCcad||55||varchar||||
-||PreviousAmiCcad||56||varchar||||
-||PreviousAnginaCcad||57||varchar||||
-||HypertensionCcad||58||varchar||||
-||HypercholesterolaemiaCcad||59||varchar||||
-||PeripheralVascularDiseaseCcad||60||varchar||||
-||CerebrovascularDiseaseCcad||61||varchar||||
-||AsthmaOrCopdCcad||62||varchar||||
-||ChronicRenalFailureCcad||63||varchar||||
-||HeartFailureCcad||64||varchar||||
-||CardiacEnzymes_markersRaisedCcad||65||varchar||||
-||SerumCholesterolCcad||66||float||||
-||SmokingStatusCcad||67||varchar||||
-||DiabetesCcad||68||varchar||||
-||PreviousPciCcad||69||varchar||||
-||PreviousCabgCcad||70||varchar||||
-||SystolicBpCcad||71||int||||
-||HeartRateCcad||72||int||||
-||ArrivalOfFirstProfessionalHelpCcad||73||varchar||||
-||UnfractionatedHeparinCcad||74||varchar||||
-||LowMolecularWeightHeparinCcad||75||varchar||||
-||ThienopyridinePlateletInhibitorCcad||76||varchar||||
-||OtherOralAntiplateletAgentCcad||77||varchar||||
-||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||||
-||DaycaseTransferDateCcad||93||datetime||||
-||LocalAngioDateCcad||94||datetime||||
-||LocalInterventionDateCcad||95||datetime||||
-||OtherAdmissionDiagnosis||96||varchar||||
-||OtherDischargeDiagnosis||97||varchar||||
-||DischargedFromCcuDestination||98||varchar||||
-||Gp_pctCodeCcad||99||varchar||||
-||DelayFromReferralForInvestigation_interventionToTr||100||float||||
-||PctCode||101||varchar||||
-||MedicalRecordNumberAtTimeOfEntryCcad||102||varchar||||
-||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||||
-||AmbulanceDriver||119||varchar||||
-||AmbulanceAttendant||120||varchar||||
-||AmbulanceResponder||121||varchar||||
-||Comments||122||varchar||||
-||PreAlertCall||123||varchar||||
-||PickUpPostCode||124||varchar||||
-||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||||
-||HospitalCentreCode||136||varchar||||
-||TotalTimeOnScene||137||float||||
-||DateAndTimeOfFirstDiagnosticEcg||138||varchar||||
-||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||||
-||DelayForCallToFrv||147||float||||
-||DelayFrvToFullCrew||148||float||||
-||DelayCallToDepart||149||float||||
-||PatientEthnicGroup||150||varchar||||
-||IncludeInD2n||151||varchar||||
-||Comments2||152||varchar||||
-||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||||
-||DateOfEndStatus||166||datetime||||
-||DateTimeRecordCreated||167||datetime||||
-||DateTimeRecordLastChanged||168||datetime||||
-||EnteredByTag||169||varchar||||
-||EntryCurrentStatus||170||varchar||||
-||EntryEndStatus||171||varchar||||
-||HospitalTag||172||varchar||||
 
 === LRIMINAPNEW_LRIMINAPNEWINITIALVW
 
 ||Field Name||Column ID||Type||Comments||
-||EntryId||1||int||||
-||PatientId||2||int||||
-||DateofAdmissiontoCCU||3||date||||
-||TimeofAdmissiontoCCU||4||time||||
-||EntryStatus||5||varchar||||
-||PreviousEntry||6||int||||
-||NextEntry||7||int||||
-||OnsetOfSymptomsCcad||8||varchar||||
-||MethodOfAdmissionCcad||9||varchar||||
-||CallForHelpCcad||10||varchar||||
-||ArrivalOfEmergencyServiceCcad||11||varchar||||
-||ArrivalAtHospitalCcad||12||varchar||||
-||DateAndTimeOfReperfusionTreatmentCcad||13||varchar||||
-||FirstCardiacArrestCcad||14||varchar||||
-||CardiacArrestLocationCcad||15||varchar||||
-||ArrestPresentingRhythmCcad||16||varchar||||
-||OutcomeOfArrestCcad||17||varchar||||
-||InitialDiagnosisCcad||18||varchar||||
-||EcgDeterminingTreatmentCcad||19||varchar||||
-||AdditionalReperfusionTreatmentCcad||20||varchar||||
-||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||||
-||DischargedOnBetaBlockerCcad||31||varchar||||
-||AceInhibitorCcad||32||varchar||||
-||DischargedOnStatinCcad||33||varchar||||
-||DischargedOnAspirinOrOtherPlateletDrugCcad||34||varchar||||
-||CardiacRehabilitationCcad||35||varchar||||
-||ExerciseTestPerformedCcad||36||varchar||||
-||EchocardiographyCcad||37||varchar||||
-||RadionuclideStudyCcad||38||varchar||||
-||CoronaryAngiographyCcad||39||varchar||||
-||CoronaryInterventionCcad||40||varchar||||
-||GenderCcad||41||varchar||||
-||DelayBeforeTreatmentCcad||42||varchar||||
-||DaysInHospital||43||int||||
-||DelayFromOnsetOfSymptomsToCallForHelp||44||float||||
-||DelayFromCallForHelpToArrivalOfEmergencyServices||45||float||||
-||DelayFromCallForHelpToArrivalInHospital||46||float||||
-||DelayFromArrivalInHospitalToReperfusionTreatment||47||float||||
-||DelayFromCallForHelpToReperfusionTreatment||48||float||||
-||DelayFromOnsetOfSymptomsToReperfusionTreatment||49||float||||
-||AmbulanceJobNumberCcad||50||varchar||||
-||PeakCreatinineKinase_ck_Ccad||51||float||||
-||PeakTroponinCcad||52||float||||
-||TroponinAssayCcad||53||varchar||||
-||TroponinReferenceValue||54||varchar||||
-||PatientAdminStatusCcad||55||varchar||||
-||PreviousAmiCcad||56||varchar||||
-||PreviousAnginaCcad||57||varchar||||
-||HypertensionCcad||58||varchar||||
-||HypercholesterolaemiaCcad||59||varchar||||
-||PeripheralVascularDiseaseCcad||60||varchar||||
-||CerebrovascularDiseaseCcad||61||varchar||||
-||AsthmaOrCopdCcad||62||varchar||||
-||ChronicRenalFailureCcad||63||varchar||||
-||HeartFailureCcad||64||varchar||||
-||CardiacEnzymes_markersRaisedCcad||65||varchar||||
-||SerumCholesterolCcad||66||float||||
-||SmokingStatusCcad||67||varchar||||
-||DiabetesCcad||68||varchar||||
-||PreviousPciCcad||69||varchar||||
-||PreviousCabgCcad||70||varchar||||
-||SystolicBpCcad||71||int||||
-||HeartRateCcad||72||int||||
-||ArrivalOfFirstProfessionalHelpCcad||73||varchar||||
-||UnfractionatedHeparinCcad||74||varchar||||
-||LowMolecularWeightHeparinCcad||75||varchar||||
-||ThienopyridinePlateletInhibitorCcad||76||varchar||||
-||OtherOralAntiplateletAgentCcad||77||varchar||||
-||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||||
-||DaycaseTransferDateCcad||93||date||||
-||LocalAngioDateCcad||94||date||||
-||LocalInterventionDateCcad||95||date||||
-||OtherAdmissionDiagnosis||96||varchar||||
-||OtherDischargeDiagnosis||97||varchar||||
-||DischargedFromCcuDestination||98||varchar||||
-||Gp_pctCodeCcad||99||varchar||||
-||DelayFromReferralForInvestigation_interventionToTr||100||float||||
-||PctCode||101||varchar||||
-||MedicalRecordNumberAtTimeOfEntryCcad||102||varchar||||
-||SerumGlucoseCcad||103||float||||
-||DiabeticTherapyAtDischargeCcad||104||varchar||||
-||AuditTrail||105||text||||
-||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||||
-||AmbulanceDriver||119||varchar||||
-||AmbulanceAttendant||120||varchar||||
-||AmbulanceResponder||121||varchar||||
-||Comments||122||text||||
-||PreAlertCall||123||varchar||||
-||PickUpPostCode||124||varchar||||
-||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||||
-||HospitalCentreCode||136||varchar||||
-||TotalTimeOnScene||137||float||||
-||DateAndTimeOfFirstDiagnosticEcg||138||varchar||||
-||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||||
-||DelayForCallToFrv||147||float||||
-||DelayFrvToFullCrew||148||float||||
-||DelayCallToDepart||149||float||||
-||PatientEthnicGroup||150||varchar||||
-||IncludeInD2n||151||varchar||||
-||ASComments2||152||varchar||||
-||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||||
-||DateOfEndStatus||197||date||||
-||DateTimeRecordCreated||198||varchar||||
-||DateTimeRecordLastChanged||199||varchar||||
-||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||||
-||PatientId||2||int||||
-||DateOfCardioversion||3||date||||
-||TimeOfCardioversion||4||time||||
-||EntryStatus||5||varchar||||
-||PreviousEntry||6||int||||
-||NextEntry||7||int||||
-||DateOnWaitingList||8||date||||
-||AgeAtCardioversion||9||int||||
-||BloodPressure||10||varchar||||
-||Height||11||varchar||||
-||Rhythm||12||varchar||||
-||DrugsOnAdmission||13||varchar||||
-||DateOfEcho||14||date||||
-||Pacemaker||15||varchar||||
-||Weight||16||float||||
-||Inr||17||float||||
-||JoulesDelivered_1||18||int||||
-||Rhythm_1||19||varchar||||
-||JoulesDelivered_2||20||int||||
-||Rhythm_2||21||varchar||||
-||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||||
-||DateOfDischarge||36||date||||
-||DateOfAdmission||37||date||||
-||RhythmAfterCardioversion||38||varchar||||
-||AdmissionType||39||varchar||||
-||DateOfFollowUp||40||date||||
-||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||||
-||MedicationOnDischarge2||50||varchar||||
-||MedicationOnDischarge3||51||varchar||||
-||MedicationOnDischarge4||52||varchar||||
-||MedicationOnDischarge5||53||varchar||||
-||MedicationOnDischarge6||54||varchar||||
-||MedicationOnDischarge7||55||varchar||||
-||MedicationOnDischarge8||56||varchar||||
-||MedicationOnDischarge9||57||varchar||||
-||AuditLoopClosed||58||varchar||||
-||DateAuditLoopClosed||59||date||||
-||ReasonAuditLoopClosed||60||varchar||||
-||DateOfDeathPostDischarge||61||date||||
-||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||||
-||Reversal||79||varchar||||
-||ComplicationsPreDischarge||80||varchar||||
-||DoseOfFlumazenil||81||varchar||||
-||TypeOfDefibUsed||82||varchar||||
-||DoesPatientRememberShocks||83||varchar||||
-||WasProcedureUnpleasant||84||varchar||||
-||AnyOtherComments||85||varchar||||
-||BurnMarks||86||varchar||||
-||HeartRate_priorToDischarge||87||varchar||||
-||Anaesthetist||88||varchar||||
-||MedicalAssistant||89||varchar||||
-||UnderlyingCardiacDiagnosisForAf||90||varchar||||
-||DrugListOnDischarge||91||varchar||||
-||FreeThyroxine||92||float||||
-||ThyroidStimulatingHormone||93||float||||
-||Operator||94||varchar||||
-||DoctorReading1WeekEcg||95||varchar||||
-||DoctorReading1MonthEcg||96||varchar||||
-||PadsOrPaddles||97||varchar||||
-||IfRevertsToAf||98||varchar||||
-||AnyUntowardsEvents||99||varchar||||
-||DurationOfAf||100||varchar||||
-||FollowUpAt_Hospital||101||varchar||||
-||TotalDoseOfSedation||102||varchar||||
-||TotalJulesDelivered||103||float||||
-||NumberOfPreviousCardioversion||104||varchar||||
-||GpPracticeCode||105||varchar||||
-||Pct||106||varchar||||
-||TotalNumberOfShocks||107||int||||
-||MedicalRecordNumber||108||varchar||||
-||HasPatientHadPreviousCardioversion||109||varchar||||
-||DateOfLastCardioversion||110||date||||
-||IsProcedureForRecuurrenceOfAfOfFailure||111||varchar||||
-||MedicationOnDischarge10||112||varchar||||
-||MedicationOnDischarge11||113||varchar||||
-||MedicationOnDischarge12||114||varchar||||
-||MedicationOnDischarge13||115||varchar||||
-||DateAndTimeOfCardioversion||116||varchar||||
-||UnderlyingCardiacDiagnosis2||117||varchar||||
-||UnderlyingCardiacDiagnosis3||118||varchar||||
-||UnderlyingCardiacDiagnosis4||119||varchar||||
-||UnderlyingCardiacDiagnosis5||120||varchar||||
-||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||||
-||DateOfEndStatus||130||date||||
-||DateTimeRecordCreated||131||varchar||||
-||DateTimeRecordLastChanged||132||varchar||||
-||EnteredByTag||133||varchar||||
-||EntryCurrentStatus||134||varchar||||
-||EntryEndStatus||135||varchar||||
-||HospitalTag||136||varchar||||
-||ImportLinkId||137||int||||
+