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