[[i2b2 - UHL clinical informatics system integration PATS|Back]] The PATS mappings are split into text and numeric fields. == Text Fields Text fields are mapped to the i2b2 Observation Fact table like this ||i2b2 Field||Source|| ||Encounter_Num||i2b2 Patient ID|| ||Patient_Num||i2b2 PatientID|| ||Concept_Cd||Enum lookup value (see below)|| ||Provider_Id||"@"|| ||Start_Date||The source table observation date field (see below)|| ||Modifier_Cd||"@"|| ||ValType_Cd||"T" (text)|| ||Units_Cd||"@"|| ||Location_Cd||"@"|| ||Update_Date||The current date using the GETDATE() Function|| ||SourceSystem_Cd||"BRICCS"|| ||Upload_Id||"1"|| '''''SOMETIME (RB): Convert Update_Date to use a date parameter. It's just a little quicker.''''' '''''SOMETIME (RB): Should the SourceSystem_Cd not be "PATS"? Or maybe "MINAP" or whatever.''''' '''''SOMETIME (RB): The Upload_Id is presumably always one because everything is reloaded each time. Might be nice to change this to something more meaningful.''''' === Enum Lookup Value The Concept Code to use is found in the table DATA_DICTIONARY_ENUM_VALUES in the DWBRICCS database on UHLDWH server. This table contains records for concept code keyed on source table name, column name and column value. NULL column values may be mapped to the field '(empty)'. '''''ACTION (RB): Check if all possible values of column value contain a mapping in the ''DATA_DICTIONARY_ENUM_VALUES'' table.''''' === Source Table Observation Date Field For each source table in the there is a single field that is used as the start date for all columns from that field. The observation date field to use for each table is stored in the ''pats_tables'' table in the DWBRICS on the UHLDWH server. == Numeric Fields Numeric fields are mapped to the i2b2 Observation Fact table like this ||i2b2 Field||Source|| ||Encounter_Num||i2b2 Patient ID|| ||Patient_Num||i2b2 PatientID|| ||Concept_Cd||"PTS:{TABLE_NAME}_{COLUMN_ID}"|| ||Provider_Id||"@"|| ||Start_Date||The source table observation date field (see above)|| ||Modifier_Cd||"@"|| ||ValType_Cd||"N" (numeric)|| ||TVal_Char||"E" (see below)|| ||Units_Cd||Value calculated by ufn_get_units function (see below)|| ||Location_Cd||"@"|| ||Update_Date||The current date using the GETDATE() Function|| ||SourceSystem_Cd||"BRICCS"|| ||Upload_Id||"1"|| === TVal_Char The ''TVal_Char'' describes the meaning of the value contained in the ''NVal_Num'' field. For all values currently the value of ''TVal_Char'' is set to "E", which means equals. That is, the value in the ''NVal_Num'' field is the result of the test. All possible values of ''TVal_Char'' are: ||Value||Meaning|| ||E||Equals|| ||NE||Not Equal|| ||L||Less Than|| ||LE||Less Than or Equals|| ||G||Greater Than|| ||GE||Greater Than or Equals|| From a casual look at the data, I think that a value of less than X, or greater than Y is sometimes used for Pathology data. === ufn_get_units Function The function ufn_get_units in the DWBRICCS database is called with parameters of ''table_name'' and ''field_name'' to determine the units. '''''ACTION (RB): Work out what this function actually does and then move the logic into a join if possible. This should be clearer and also quicker.''''' == Tables The PATS i2b2 data integration load maps source table types to either Text or Numeric. All other types are ignored. The mapping is as follows. ||Source Type||i2b2 Type|| ||VARCHAR||Text|| ||INT or FLOAT||Numeric|| ||All other types||NOT LOADED|| In addition, all fields with certain names are also ignored. '''Ignored Field Names''' * PatientId * EntryId * PreviousEntry * NextEntry === CATH_CATHINITIALVW ||Field Name||Column ID||Type||Comments|| ||~~!EntryId~~||1||int||IGNORED|| ||~~!PatientId~~||2||int||IGNORED|| ||~~!DateofCatheter~~||3||date||IGNORED|| ||~~!TimeofCatheter~~||4||time||IGNORED|| ||!EntryStatus||5||varchar|||| ||~~!PreviousEntry~~||6||int||IGNORED|| ||~~!NextEntry~~||7||int||IGNORED|| ||~~!DateOfAdmission~~||8||date||IGNORED|| ||!AgeAtCatheter||9||int|||| ||!DoneInMobileLab||10||varchar|||| ||Consultant||11||varchar|||| ||Operator||12||varchar|||| ||!SecondOperator||13||varchar|||| ||Technician||14||varchar|||| ||!PatientType||15||varchar|||| ||!WasThePatientCatheterised||16||varchar|||| ||!ProcedureType||17||varchar|||| ||!GeneralAnaesthetics||18||varchar|||| ||!ProcedureSite||19||varchar|||| ||!BiopsyTaken||20||varchar|||| ||!BiopsySite||21||varchar|||| ||!OtherProcedure||22||varchar|||| ||Arterial_1||23||varchar|||| ||Vessel_1_Arterial||24||varchar|||| ||Complicated_1_Arterial||25||varchar|||| ||Arterial_2||26||varchar|||| ||Vessel_2_Arterial||27||varchar|||| ||Complicated2Arterial||28||varchar|||| ||Arterial_3||29||varchar|||| ||Vessel_3_Arterial||30||varchar|||| ||Complicated_3_Arterial||31||varchar|||| ||Venous_1||32||varchar|||| ||Vessel_1_Venous||33||varchar|||| ||Complicated_1_Venous||34||varchar|||| ||Venous_2||35||varchar|||| ||Vessel_2_Venous||36||varchar|||| ||Complicated_2_Venous||37||varchar|||| ||Venous_3||38||varchar|||| ||Vessel_3_Venous||39||varchar|||| ||Complicated_3_Venous||40||varchar|||| ||Vessels||41||varchar|||| ||!ReturnedTo||42||varchar|||| ||!FurtherProcedure||43||varchar|||| ||!ImmediateComplications||44||varchar|||| ||!ProcedureAbandoned||45||varchar|||| ||!ReasonForAbandoningProcedure||46||varchar|||| ||!OtherComplications||47||varchar|||| ||!DiedInCathLab||48||varchar|||| ||!CoronaryDisease||49||varchar|||| ||!SignificantValveDisease||50||varchar|||| ||!SignificantLvDisease||51||varchar|||| ||Outcome||52||varchar|||| ||!ReturnToCathLab||53||varchar|||| ||!EmbolicSequelae||54||varchar|||| ||!NonEmergencySurgery||55||varchar|||| ||!GroinComplication||56||varchar|||| ||Death||57||varchar|||| ||!DischargeComplications||58||varchar|||| ||!OutcomeOfCatheter||59||varchar|||| ||~~!DateOfDischarge~~||60||date||IGNORED|| ||~~!DateOfDeath~~||61||date||IGNORED|| ||!DischargeTo||62||varchar|||| ||PreopStay_days||63||int|||| ||PostOpStay_days||64||int|||| ||!TotalHospitalStay||65||int|||| ||IhdScore_cardwl||66||int|||| ||NihdScore_cardwl||67||int|||| ||!OtherComplicationsPreDischarge||68||varchar|||| ||~~!DateOfDeathPostDischarge~~||69||date||IGNORED|| ||PostProcedureDeathInterval_days||70||int|||| ||!FormsVerified||71||varchar|||| ||Contract||72||varchar|||| ||Pcg||73||varchar|||| ||!AuditLoopClosed||74||varchar|||| ||!DateAuditLoopClosed||75||date|||| ||!ReasonAuditLoopClosed||76||varchar|||| ||IntervalBetweenProc_LoopClosed_days||77||int|||| ||~~!DateOnWaitingList~~||78||date||IGNORED|| ||!DaysOnList||79||int|||| ||!GpPracticeCode||80||varchar|||| ||Pct||81||varchar|||| ||!MedicalRecordNumber||82||varchar|||| ||!AdministrativeCategory||83||varchar|||| ||!AuditTrail||84||text|||| ||!DateAndTimeOfProcedure||85||varchar|||| ||!IsThisAcs||86||varchar|||| ||Sub_Xiphoid||87||varchar|||| ||!PreDischargeComplications||88||varchar|||| ||!IfOtherPreDischargeComplicationsPleaseState||89||varchar|||| ||Height||90||float|||| ||Weight||91||float|||| ||Bmi||92||float|||| ||!ScreeningTime||93||float|||| ||!ScreeningDose||94||float|||| ||!ExceededDrl||95||varchar|||| ||Radiographer||96||varchar|||| ||!ReasonForExceedingDrl||97||varchar|||| ||!CatheterProcedureReport||98||varchar|||| ||!ConsultantCode||99||varchar|||| ||!OperatorCode||100||varchar|||| ||!SecondOperatorCode||101||varchar|||| ||!TroponinPositive||102||varchar|||| ||~~!DateOfCurrentStatus~~||103||date||IGNORED|| ||~~!DateOfEndStatus~~||104||date||IGNORED|| ||!DateTimeRecordCreated||105||varchar|||| ||!DateTimeRecordLastChanged||106||varchar|||| ||!EnteredByTag||107||varchar|||| ||!EntryCurrentStatus||108||varchar|||| ||!EntryEndStatus||109||varchar|||| ||!HospitalTag||110||varchar|||| ||!ImportLinkId||111||int|||| === CS2003F_PostProcedure ||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|||| ||PatientId||2||int|||| ||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|||| ||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|||| ||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|||| ||DischargedFromCardiacSurgery||115||date|||| ||TotalCardiacSurgeryLosDays||116||float|||| ||DateOfFollowUp||117||date|||| ||BloodUsed||118||varchar|||| ||MutisystemFailure||119||varchar|||| ||DateFirstAdmittedToCicu||120||date|||| ||DateFirstDischargedFromCicu||121||date|||| ||TotalFirstStayOnCicu||122||float|||| ||ReAdmittedToCicu||123||varchar|||| ||DateOfSecondAdmissionToCicu||124||date|||| ||DateOfSecondDischargeFromCicu||125||date|||| ||SecondAdmissionTotalStay_nignts||126||float|||| ||DateOfThirdAdmissionToCicu||127||date|||| ||DateOfThirdDischargeFromCicu||128||date|||| ||ThirdAdmissionToCicuTotalStay_nights||129||float|||| ||InsertionOfPacemakerWiresViaVatsProcedure||130||varchar|||| ||IntubationTimeInHours||131||int|||| ||AuditTrail||132||text|||| ||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|||| ||AddedToW_l||146||varchar|||| ||DateOfFourthAdmissionToCicu||147||date|||| ||DateOfFourthDischargeFromCicu||148||date|||| ||DateOfFifthAdmissionToCicu||149||date|||| ||DateOfFifthDischargeFromCicu||150||date|||| ||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|||| ||SecondBypassTotal||159||int|||| ||SecondCrossClampTotal||160||int|||| ||SecondCiculatoryArrestTotal||161||int|||| ||CouncilCase||162||varchar|||| ||InitialConsultantInJointCase||163||varchar|||| ||ArrhythmiaOtherComplicationFreeText||164||text|||| ||LowCardiacOutputOtherComplicationFreeText||165||text|||| ||PulmonaryOtherComplicationFreeText||166||text|||| ||RenalOtherComplicationFreeText||167||text|||| ||GastrointestinalOtherComplicationFreeText||168||text|||| ||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|||| ||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|||| ||PatientId||2||int|||| ||DateOfOperation||3||date|||| ||TimeOfEntry||4||time|||| ||EntryStatus||5||varchar|||| ||PreviousEntry||6||int|||| ||NextEntry||7||int|||| ||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|||| ||DiabetesManagement||18||varchar|||| ||HistoryOfHypertension||19||varchar|||| ||CigaretteSmokingHistory||20||varchar|||| ||HistoryOfPulmonaryDisease||21||varchar|||| ||HistoryOfNeurologicalDisease||22||varchar|||| ||Pre_OperativeHeartRhythm||23||varchar|||| ||DateOfLastCatheterisation||24||date|||| ||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|||| ||DrugsOnAdmission||52||varchar|||| ||Allergies||53||varchar|||| ||AllOtherAssistants||54||varchar|||| ||WaitingListStatusUpdated||55||varchar|||| ||SprCases||56||varchar|||| ||DateOfCurrentStatus||57||date|||| ||DateOfEndStatus||58||date|||| ||DateTimeRecordCreated||59||varchar|||| ||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|||| ||PatientId||2||int|||| ||DateOfEntry||3||date|||| ||TimeofEPSRFA||4||time|||| ||EntryStatus||5||varchar|||| ||PreviousEntry||6||int|||| ||NextEntry||7||int|||| ||DateOfAdmission||8||date|||| ||DateOfDischarge||9||date|||| ||DateAddedToWaitingList||10||date|||| ||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|||| ||DateOfEndStatus||94||date|||| ||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|||| ||PatientId||2||int|||| ||DateofHospitalAdmission||3||datetime|||| ||TimeofHospitalAdmission||4||datetime|||| ||EntryStatus||5||varchar|||| ||PreviousEntry||6||int|||| ||NextEntry||7||int|||| ||Age||8||int|||| ||DateOfAdmissionToCcu||9||datetime|||| ||DirectAdmission||10||varchar|||| ||GenderCcad||11||varchar|||| ||EthnicOriginCcad||12||varchar|||| ||PatientAdminStatusCcad||13||varchar|||| ||HospitalCentreCode||14||varchar|||| ||GpPracticeCodeCcad||15||varchar|||| ||InitialDiagnosisCcad||16||varchar|||| ||OtherAdmissionDiagnosis||17||varchar|||| ||MethodOfAdmissionCcad||18||varchar|||| ||EcgDeterminingTreatmentCcad||19||varchar|||| ||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|||| ||DateOfDischargeFromCcu||91||datetime|||| ||DischargedFromCcuDestination||92||varchar|||| ||DischargeDiagnosisCcad||93||varchar|||| ||OtherDischargeDiagnosis||94||varchar|||| ||DiagamiCcad||95||varchar|||| ||RecommendedTherapyAtDischargeCcad||96||varchar|||| ||DaysInHospital||97||int|||| ||DaysInCcu||98||int|||| ||BleedingComplicationsCcad||99||varchar|||| ||DeathInHospitalCcad||100||varchar|||| ||DischargedOnBetaBlockerCcad||101||varchar|||| ||AceInhibitorCcad||102||varchar|||| ||DischargedOnStatinCcad||103||varchar|||| ||DischargedOnAspirinOrOtherPlateletDrugCcad||104||varchar|||| ||CardiacRehabilitationCcad||105||varchar|||| ||ExerciseTestPerformedCcad||106||varchar|||| ||EchocardiographyCcad||107||varchar|||| ||RadionuclideStudyCcad||108||varchar|||| ||CoronaryAngiographyAtThisAdmissionCcad||109||varchar|||| ||CoronaryInterventionPerformedAtThisAdmissionCcad||110||varchar|||| ||DateOfReferralForInvestigation_intervention||111||datetime|||| ||ModeOfDischargeCcad||112||varchar|||| ||DateOfTransferForDayCaseInvestigationCcad||113||datetime|||| ||DateOfAngioPerformedLocallyCcad||114||datetime|||| ||DateOfFirstInterventionOrSurgeryPerformedLocallyCc||115||datetime|||| ||ReferralCentreCcad||116||varchar|||| ||ReferringHospitalCcad||117||varchar|||| ||PatientCaseRecordNumberAtReferralCentreCcad||118||varchar|||| ||FollowedUpByCcad||119||varchar|||| ||ReinfarctionCcad||120||varchar|||| ||DischargedOnClopidogrelCcad||121||varchar|||| ||DelayFromOnsetOfSymptomsToCallForHelp||122||float|||| ||DelayFromCallForHelpToArrivalOfEmergencyServices||123||float|||| ||DelayFromCallForHelpToArrivalInHospital||124||float|||| ||DelayFromArrivalInHospitalToReperfusionTreatment||125||float|||| ||DelayFromCallForHelpToReperfusionTreatment||126||float|||| ||DelayFromOnsetOfSymptomsToReperfusionTreatment||127||float|||| ||TotalTimeOnScene||128||float|||| ||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|||| ||DateOfEndStatus||149||datetime|||| ||DateTimeRecordCreated||150||datetime|||| ||DateTimeRecordLastChanged||151||datetime|||| ||EnteredByTag||152||varchar|||| ||EntryCurrentStatus||153||varchar|||| ||EntryEndStatus||154||varchar|||| ||HospitalTag||155||varchar|||| === GGHMINAPNEW ||Field Name||Column ID||Type||Comments|| ||EntryId||1||int|||| ||PatientId||2||int|||| ||DateofAdmissiontoCCU||3||datetime|||| ||TimeofAdmissiontoCCU||4||datetime|||| ||EntryStatus||5||varchar|||| ||PreviousEntry||6||int|||| ||NextEntry||7||int|||| ||OnsetOfSymptomsCcad||8||varchar|||| ||MethodOfAdmissionCcad||9||varchar|||| ||CallForHelpCcad||10||varchar|||| ||ArrivalOfEmergencyServiceCcad||11||varchar|||| ||ArrivalAtHospitalCcad||12||varchar|||| ||DateAndTimeOfReperfusionTreatmentCcad||13||varchar|||| ||FirstCardiacArrestCcad||14||varchar|||| ||CardiacArrestLocationCcad||15||varchar|||| ||ArrestPresentingRhythmCcad||16||varchar|||| ||OutcomeOfArrestCcad||17||varchar|||| ||InitialDiagnosisCcad||18||varchar|||| ||EcgDeterminingTreatmentCcad||19||varchar|||| ||AdditionalReperfusionTreatmentCcad||20||varchar|||| ||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|||| ||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|||| ||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|||| ||DateOfEndStatus||167||datetime|||| ||DateTimeRecordCreated||168||datetime|||| ||DateTimeRecordLastChanged||169||datetime|||| ||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||||