[[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 === CATH_CATHINITIALVW ||Field Name||Column ID||Type||Comments|| ||EntryId||1||int|||| ||PatientId||2||int|||| ||DateofCatheter||3||date|||| ||TimeofCatheter||4||time|||| ||EntryStatus||5||varchar|||| ||PreviousEntry||6||int|||| ||NextEntry||7||int|||| ||DateOfAdmission||8||date|||| ||AgeAtCatheter||9||int|||| ||DoneInMobileLab||10||varchar|||| ||Consultant||11||varchar|||| ||Operator||12||varchar|||| ||SecondOperator||13||varchar|||| ||Technician||14||varchar|||| ||PatientType||15||varchar|||| ||WasThePatientCatheterised||16||varchar|||| ||ProcedureType||17||varchar|||| ||GeneralAnaesthetics||18||varchar|||| ||ProcedureSite||19||varchar|||| ||BiopsyTaken||20||varchar|||| ||BiopsySite||21||varchar|||| ||OtherProcedure||22||varchar|||| ||Arterial_1||23||varchar|||| ||Vessel_1_Arterial||24||varchar|||| ||Complicated_1_Arterial||25||varchar|||| ||Arterial_2||26||varchar|||| ||Vessel_2_Arterial||27||varchar|||| ||Complicated2Arterial||28||varchar|||| ||Arterial_3||29||varchar|||| ||Vessel_3_Arterial||30||varchar|||| ||Complicated_3_Arterial||31||varchar|||| ||Venous_1||32||varchar|||| ||Vessel_1_Venous||33||varchar|||| ||Complicated_1_Venous||34||varchar|||| ||Venous_2||35||varchar|||| ||Vessel_2_Venous||36||varchar|||| ||Complicated_2_Venous||37||varchar|||| ||Venous_3||38||varchar|||| ||Vessel_3_Venous||39||varchar|||| ||Complicated_3_Venous||40||varchar|||| ||Vessels||41||varchar|||| ||ReturnedTo||42||varchar|||| ||FurtherProcedure||43||varchar|||| ||ImmediateComplications||44||varchar|||| ||ProcedureAbandoned||45||varchar|||| ||ReasonForAbandoningProcedure||46||varchar|||| ||OtherComplications||47||varchar|||| ||DiedInCathLab||48||varchar|||| ||CoronaryDisease||49||varchar|||| ||SignificantValveDisease||50||varchar|||| ||SignificantLvDisease||51||varchar|||| ||Outcome||52||varchar|||| ||ReturnToCathLab||53||varchar|||| ||EmbolicSequelae||54||varchar|||| ||NonEmergencySurgery||55||varchar|||| ||GroinComplication||56||varchar|||| ||Death||57||varchar|||| ||DischargeComplications||58||varchar|||| ||OutcomeOfCatheter||59||varchar|||| ||DateOfDischarge||60||date|||| ||DateOfDeath||61||date|||| ||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|||| ||PostProcedureDeathInterval_days||70||int|||| ||FormsVerified||71||varchar|||| ||Contract||72||varchar|||| ||Pcg||73||varchar|||| ||AuditLoopClosed||74||varchar|||| ||DateAuditLoopClosed||75||date|||| ||ReasonAuditLoopClosed||76||varchar|||| ||IntervalBetweenProc_LoopClosed_days||77||int|||| ||DateOnWaitingList||78||date|||| ||DaysOnList||79||int|||| ||GpPracticeCode||80||varchar|||| ||Pct||81||varchar|||| ||MedicalRecordNumber||82||varchar|||| ||AdministrativeCategory||83||varchar|||| ||AuditTrail||84||text|||| ||DateAndTimeOfProcedure||85||varchar|||| ||IsThisAcs||86||varchar|||| ||Sub_Xiphoid||87||varchar|||| ||PreDischargeComplications||88||varchar|||| ||IfOtherPreDischargeComplicationsPleaseState||89||varchar|||| ||Height||90||float|||| ||Weight||91||float|||| ||Bmi||92||float|||| ||ScreeningTime||93||float|||| ||ScreeningDose||94||float|||| ||ExceededDrl||95||varchar|||| ||Radiographer||96||varchar|||| ||ReasonForExceedingDrl||97||varchar|||| ||CatheterProcedureReport||98||varchar|||| ||ConsultantCode||99||varchar|||| ||OperatorCode||100||varchar|||| ||SecondOperatorCode||101||varchar|||| ||TroponinPositive||102||varchar|||| ||DateOfCurrentStatus||103||date|||| ||DateOfEndStatus||104||date|||| ||DateTimeRecordCreated||105||varchar|||| ||DateTimeRecordLastChanged||106||varchar|||| ||EnteredByTag||107||varchar|||| ||EntryCurrentStatus||108||varchar|||| ||EntryEndStatus||109||varchar|||| ||HospitalTag||110||varchar|||| ||ImportLinkId||111||int|||| === CS2003F_PostProcedure ||Field Name||Column ID||Type||Comments|| ||EntryId||1||int|||| ||PatientId||2||int|||| ||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|||| ||BodySurfaceArea||31||float|||| ||BodyMassIndex||32||float|||| ||Cardioplegia_Infusion||33||varchar|||| ||EuroscoreMinumumDatasetCheck||34||varchar|||| ||ParsonnetMinumumDatasetCheck||35||varchar|||| ||NameOfGpAtTimeOfSurgery||36||varchar|||| ||GpPracticeCodeAtTimeOfSurgery||37||varchar|||| ||PctAtTimeOfSurgery||38||varchar|||| ||NameOfReferringGpAtTimeOfSurgeryType8||39||varchar|||| ||ToePerformed||40||varchar|||| ||Sonographer||41||varchar|||| ||Sonographist||42||varchar|||| ||PrimaryPerfusionist||43||varchar|||| ||PcuPatient_pcu||44||varchar|||| ||DoesPatientMeetInterOperativeCriteria_pcu||45||varchar|||| ||AreaPatientAdmittedTo_pcu||46||varchar|||| ||AdmissionTimeToRecovery_cicu_pcu||47||varchar|||| ||ExtubationDateAndTime_pcu||48||varchar|||| ||WhatO2SystemWasUsed_pcu||49||varchar|||| ||TotalBloodLostOnDischargeFromRecovery_pcu||50||varchar|||| ||WereClottingProductsUsed_pcu||51||varchar|||| ||WhatProductsWereUsed_pcu||52||varchar|||| ||HowMuchColloidUsedInRecovery_pcu||53||varchar|||| ||TypeOfColloidUsed_pcu||54||varchar|||| ||PainScoreOnWaking_pcu||55||varchar|||| ||AnalgesiaUsedPcu||56||varchar|||| ||TotalMorphineDoseUsedIncludingBolus_pcu||57||varchar|||| ||InotropesUsed_pcu||58||varchar|||| ||Dosage_pcu||59||varchar|||| ||WereThereAnyArrhythmias_pcu||60||varchar|||| ||PleaseStateArrhythmias_pcu||61||varchar|||| ||TreatmentOfArrhythmias_pcu||62||varchar|||| ||PotassiumUsed_pcu||63||varchar|||| ||PotassiumDoseInMmols_pcu||64||varchar|||| ||TemperatureOnAdmission_pcu||65||float|||| ||BairhuggerWithPatient_pcu||66||varchar|||| ||TimeOfDischarge_pcu||67||varchar|||| ||PlaceOfDischarge_pcu||68||varchar|||| ||DoesPatientMeetDischargeCriteria_pcu||69||varchar|||| ||WasPatientDischargedFromPcuToHdu_pcu||70||varchar|||| ||LowUrineOutput_pcu||71||varchar|||| ||IfNoStateWhy_pcu||72||varchar|||| ||IfNoWhy_pcu||73||varchar|||| ||AmountOfTimeIntubated_pcu||74||float|||| ||AmountOfTimeInRecovery_cicu_pcu||75||float|||| ||OverallComments_sa||76||varchar|||| ||TeachingOfOtherStaffComments_sa||77||varchar|||| ||TeachingOfOtherStaffCommentsMade_sa||78||varchar|||| ||TeachingOfOtherStaffBySa_sa||79||varchar|||| ||IabpRemovalComments_sa||80||varchar|||| ||IabpRemovalCommentsMade_sa||81||varchar|||| ||IabpRemovalBySa_sa||82||varchar|||| ||IabpInsertionComments_sa||83||varchar|||| ||IabpInsertionCommentsMade_sa||84||varchar|||| ||IabpInsertionBySa_sa||85||varchar|||| ||SternotomyClosureComments_sa||86||varchar|||| ||SternotomyClosureCommentsMade_sa||87||varchar|||| ||SternotomyClosureBySa_sa||88||varchar|||| ||SternotomyComments_sa||89||varchar|||| ||SternotomyCommentsMade_sa||90||varchar|||| ||SternotomyPerformedBySa_sa||91||varchar|||| ||ThirdSiteComments_sa||92||varchar|||| ||ThirdSiteCommentsMade_sa||93||varchar|||| ||ThirdSiteConduit_location_sa||94||varchar|||| ||SecondSiteComments_sa||95||varchar|||| ||SecondSiteCommentsMade_sa||96||varchar|||| ||SecondSiteConduit_location_sa||97||varchar|||| ||FirstSiteComments_sa||98||varchar|||| ||FirstSiteCommentsMade_sa||99||varchar|||| ||FirstSiteConduei_location_sa||100||varchar|||| ||ThirdAssistant_sa||101||varchar|||| ||SecondAssistant_sa||102||varchar|||| ||FirstAssistant_sa||103||varchar|||| ||SurgicalAssistant_sa||104||varchar|||| ||ReferralToOperation_days||105||float|||| ||Arrhythmia_S||106||varchar|||| ||LowCardiacOutput||107||varchar|||| ||Ventilation||108||varchar|||| ||PulmonaryComplications||109||varchar|||| ||RenalComplications||110||varchar|||| ||GastrointestinalComplications||111||varchar|||| ||InfectiveComplications||112||varchar|||| ||CauseOfDeath||113||varchar|||| ||AdmittedFrom_hospitalNameOrWard||114||varchar|||| ||AdmittedToCardiacSurgery||115||datetime|||| ||DischargedFromCardiacSurgery||116||datetime|||| ||TotalCardiacSurgeryLosDays||117||float|||| ||DateOfFollowUp||118||datetime|||| ||BloodUsed||119||varchar|||| ||MutisystemFailure||120||varchar|||| ||DateFirstAdmittedToCicu||121||datetime|||| ||DateFirstDischargedFromCicu||122||datetime|||| ||TotalFirstStayOnCicu||123||float|||| ||ReAdmittedToCicu||124||varchar|||| ||DateOfSecondAdmissionToCicu||125||datetime|||| ||DateOfSecondDischargeFromCicu||126||datetime|||| ||SecondAdmissionTotalStay_nignts||127||float|||| ||DateOfThirdAdmissionToCicu||128||datetime|||| ||DateOfThirdDischargeFromCicu||129||datetime|||| ||ThirdAdmissionToCicuTotalStay_nights||130||float|||| ||InsertionOfPacemakerWiresViaVatsProcedure||131||varchar|||| ||IntubationTimeInHours||132||int|||| ||AuditTrail||133||varchar|||| ||NameOfDoctorCompletingBooklet||134||varchar|||| ||SecondPrimaryPerfusionist||135||varchar|||| ||SecondBypass||136||varchar|||| ||SecondMyocardialProtection||137||varchar|||| ||SecondCardioplegiaSolution||138||varchar|||| ||SecondCardioplegiaInfusion||139||varchar|||| ||SecondCardioplegiaTemperature||140||varchar|||| ||SecondCardioplegiaTiming||141||varchar|||| ||SecondNon_CardioplegiaMyocardialProtection||142||varchar|||| ||DoesPatientNeedAFollowUpAppiontment||143||varchar|||| ||Comments||144||varchar|||| ||MedicalRecordNumber||145||varchar|||| ||DateAddedToW_l||146||datetime|||| ||AddedToW_l||147||varchar|||| ||DateOfFourthAdmissionToCicu||148||datetime|||| ||DateOfFourthDischargeFromCicu||149||datetime|||| ||DateOfFifthAdmissionToCicu||150||datetime|||| ||DateOfFifthDischargeFromCicu||151||datetime|||| ||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|||| ||IfNotOperatedOnSamedayGiveReason||160||varchar|||| ||SecondBypassTotal||161||int|||| ||SecondCrossClampTotal||162||int|||| ||SecondCiculatoryArrestTotal||163||int|||| ||CouncilCase||164||varchar|||| ||InitialConsultantInJointCase||165||varchar|||| ||ArrhythmiaOtherComplicationFreeText||166||varchar|||| ||LowCardiacOutputOtherComplicationFreeText||167||varchar|||| ||PulmonaryOtherComplicationFreeText||168||varchar|||| ||RenalOtherComplicationFreeText||169||varchar|||| ||GastrointestinalOtherComplicationFreeText||170||varchar|||| ||InfectiveOtherComplicationFreeText||171||varchar|||| ||SickNoteOffered||172||varchar|||| ||IfSickNoteOfferedDurationInDays||173||int|||| ||AdviceToGpAndAnyMedicationChangedOrStopped||174||varchar|||| ||NameOfDischargingDoctor||175||varchar|||| ||GradeOfDischargingDoctor||176||varchar|||| ||PagerNumber||177||varchar|||| ||DrugSensitivity||178||varchar|||| ||Drug1||179||varchar|||| ||DrugRoute1||180||varchar|||| ||NumberOfDays1||181||int|||| ||Continue1||182||varchar|||| ||Drug2||183||varchar|||| ||DrugRoute2||184||varchar|||| ||NumberOfDays2||185||int|||| ||Continue2||186||varchar|||| ||Drug3||187||varchar|||| ||DrugRoute3||188||varchar|||| ||NumberOfDays3||189||int|||| ||Continue3||190||varchar|||| ||Drug4||191||varchar|||| ||DrugRoute4||192||varchar|||| ||NumberOfDays4||193||int|||| ||Continue4||194||varchar|||| ||Drug5||195||varchar|||| ||DrugRoute5||196||varchar|||| ||NumberOfDays5||197||int|||| ||Continue5||198||varchar|||| ||Drug6||199||varchar|||| ||DrugRoute6||200||varchar|||| ||NumberOfDays6||201||int|||| ||Continue6||202||varchar|||| ||Drug7||203||varchar|||| ||DrugRoute7||204||varchar|||| ||NumberOfDays7||205||int|||| ||Continue7||206||varchar|||| ||Drug8||207||varchar|||| ||DrugRoute8||208||varchar|||| ||NumberOfDays8||209||int|||| ||Continue8||210||varchar|||| ||Drug9||211||varchar|||| ||DrugRoute9||212||varchar|||| ||NumberOfDays9||213||int|||| ||Continue9||214||varchar|||| ||Drug10||215||varchar|||| ||DrugRoute10||216||varchar|||| ||NumberOfDays10||217||int|||| ||Continue10||218||varchar|||| ||Drug11||219||varchar|||| ||DrugRoute11||220||varchar|||| ||NumberOfDays11||221||int|||| ||Continue11||222||varchar|||| ||Drug12||223||varchar|||| ||DrugRoute12||224||varchar|||| ||NumberOfDays12||225||int|||| ||Continue12||226||varchar|||| ||Drug13||227||varchar|||| ||DrugRoute13||228||varchar|||| ||NumberOfDays13||229||int|||| ||Continue13||230||varchar|||| ||Drug14||231||varchar|||| ||DrugRoute14||232||varchar|||| ||NumberOfDays14||233||int|||| ||Continue14||234||varchar|||| ||Drug15||235||varchar|||| ||DrugRoute15||236||varchar|||| ||NumberOfDays15||237||int|||| ||Continue15||238||varchar|||| ||Drug16||239||varchar|||| ||DrugRoute16||240||varchar|||| ||NumberOfDays16||241||int|||| ||Continue16||242||varchar|||| ||Drug17||243||varchar|||| ||DrugRoute17||244||varchar|||| ||NumberOfDays17||245||int|||| ||Continue17||246||varchar|||| ||Drug18||247||varchar|||| ||DrugRoute18||248||varchar|||| ||NumberOfDays18||249||int|||| ||Continue18||250||varchar|||| ||DrugNameAndStrength19||251||varchar|||| ||DrugForm19||252||varchar|||| ||DrugDose19||253||varchar|||| ||DrugRoute19||254||varchar|||| ||DrugFrequency19||255||varchar|||| ||NumberOfDays19||256||int|||| ||Continue19||257||varchar|||| ||DrugNameAndStrength20||258||varchar|||| ||DrugForm20||259||varchar|||| ||DrugDose20||260||varchar|||| ||DrugRoute20||261||varchar|||| ||DrugFrequency20||262||varchar|||| ||NumberOfDays20||263||int|||| ||Continue20||264||varchar|||| ||DrugNameAndStrength21||265||varchar|||| ||DrugForm21||266||varchar|||| ||DrugDose21||267||varchar|||| ||DrugRoute21||268||varchar|||| ||DrugFrequency21||269||varchar|||| ||NumberOfDays21||270||int|||| ||Continue21||271||varchar|||| ||DrugNameAndStrength22||272||varchar|||| ||DrugForm22||273||varchar|||| ||DrugDose22||274||varchar|||| ||DrugRoute22||275||varchar|||| ||DrugFrequency22||276||varchar|||| ||NumberOfDays22||277||int|||| ||Continue22||278||varchar|||| ||DrugNameAndStrength23||279||varchar|||| ||DrugForm23||280||varchar|||| ||DrugDose23||281||varchar|||| ||DrugRoute23||282||varchar|||| ||DrugFrequency23||283||varchar|||| ||NumberOfDays23||284||int|||| ||Continue23||285||varchar|||| ||DrugNameAndStrength24||286||varchar|||| ||DrugForm24||287||varchar|||| ||DrugDose24||288||varchar|||| ||DrugRoute24||289||varchar|||| ||DrugFrequency24||290||varchar|||| ||NumberOfDays24||291||int|||| ||Continue24||292||varchar|||| ||DischargeWard||293||varchar|||| ||Pharmacist||294||varchar|||| ||ManagementPlan||295||varchar|||| ||FollowUpRequired||296||varchar|||| ||FollowUpTimeInWeeks_months||297||varchar|||| ||MedicationChangedByPharmacist||298||varchar|||| ||StatePharmacistChanges||299||varchar|||| ||InformationGivenToPatient||300||varchar|||| ||DateTimeRecordCreated||301||datetime|||| ||DateTimeRecordLastChanged||302||datetime|||| ||EnteredByTag||303||varchar|||| ||HospitalTag||304||varchar|||| ||WHO_REGISTRY_INDICATOR||305||varchar|||| ||WHO_POSSIBLE_DUPLICATE||306||char|||| === CS2003F_PreProcedure ||Field Name||Column ID||Type||Comments|| ||EntryId||1||int|||| ||PatientId||2||int|||| ||DateOfOperation_ccad||3||datetime|||| ||TimeOfOperation_ccad||4||datetime|||| ||EntryStatus||5||varchar|||| ||PreviousEntry||6||int|||| ||NextEntry||7||int|||| ||AgeAtSurgery||8||int|||| ||Gender||9||varchar|||| ||DateOfAdmission||10||datetime|||| ||AnginaStatusPre_Surgery||11||varchar|||| ||DyspnoeaStatusPre_Surgery||12||varchar|||| ||NumberOfPreviousMis||13||varchar|||| ||IntervalBetweenOperationAndLastMi||14||varchar|||| ||PreviousPci||15||varchar|||| ||DateOfLastPci||16||datetime|||| ||PreviousCardiac_VascularOrThoracicSurgicalInterven||17||varchar|||| ||DateOfLastCardiacOperation||18||datetime|||| ||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|||| ||PaSystolic_ifKnown||27||int|||| ||AvGradient_ifKnown||28||int|||| ||Lvedp_ifKnown||29||int|||| ||MeanPawp_la_ifKnown||30||int|||| ||IvNitrates_HeparinOfAnyKind||31||varchar|||| ||IvInotropesPriorToAnaesthesia||32||varchar|||| ||Ventilated||33||varchar|||| ||CardiogenicShock||34||varchar|||| ||OperativePriority||35||varchar|||| ||FirstOperatorGrade||36||varchar|||| ||FirstOperator_CalmanYearOfTrainee||37||varchar|||| ||CardiacProcedures||38||varchar|||| ||NumberOfDistalCoronaryAnastomoses||39||int|||| ||NumberOfValvesReplaced_Repaired||40||int|||| ||NumberOfSegmentsOfTheAorta||41||int|||| ||OtherCardiacProcedures||42||varchar|||| ||OtherThoracicAndVascularProcedures||43||varchar|||| ||NeurologicalDysfunction_euroscore||44||varchar|||| ||LeftMainStemDisease||45||varchar|||| ||ExtentOfCoronaryArteryDisease||46||varchar|||| ||ExtracardiacArteriopathy||47||varchar|||| ||EjectionFractionCategory||48||varchar|||| ||AdmissionCategory||49||varchar|||| ||CarotidBruits||50||varchar|||| ||LeftOrRightHeartCatheterisation||51||varchar|||| ||EjectionFractionValue_ifKnown||52||int|||| ||DateAndTimeOfOperation||53||varchar|||| ||NumberOfPreviousHeartOperations||54||int|||| ||ResponsibleConsultantSurgeon||55||varchar|||| ||FirstOperator||56||varchar|||| ||FirstAssistant||57||varchar|||| ||FirstAssistantGrade||58||varchar|||| ||FirstAssistant_CalmanYearOfTrainee||59||varchar|||| ||ResponsibleConsultantAnaesthetist||60||varchar|||| ||OperationFindings||61||varchar|||| ||ReferringCardiologist||62||varchar|||| ||DateOfReferral||63||datetime|||| ||DrugsOnAdmission||64||varchar|||| ||Allergies||65||varchar|||| ||AllOtherAssistants||66||varchar|||| ||WaitingListStatusUpdated||67||varchar|||| ||SprCases||68||varchar|||| ||DateOfCurrentStatus||69||datetime|||| ||DateOfEndStatus||70||datetime|||| ||DateTimeRecordCreated||71||datetime|||| ||DateTimeRecordLastChanged||72||datetime|||| ||EnteredByTag||73||varchar|||| ||EntryCurrentStatus||74||varchar|||| ||EntryEndStatus||75||varchar|||| ||HospitalTag||76||varchar|||| ||WHO_RESPONSIBLE_CONSULTANT_SURGEON||77||varchar|||| ||WHO_AGE_AT_OPERATION||78||int|||| ||WHO_REGISTRY_INDICATOR||79||varchar|||| ||WHO_POSSIBLE_DUPLICATE||80||char|||| === CS2010F_PostProcedure ||Field Name||Column ID||Type||Comments|| ||EntryId||1||int|||| ||PatientId||2||int|||| ||PreOperativeStayInDays||3||int|||| ||PostOperativeStayInDays||4||int|||| ||TotalStayInDays||5||int|||| ||ParsonnetScoreFromHardData||6||int|||| ||CardiopulmonaryBypass||7||varchar|||| ||ParsonnetScoreWithCatastrophicStatesAndRareConditi||8||int|||| ||PredominantMethodOfMyocardialProtection||9||varchar|||| ||Parsonnet_AdditionsForCatastrophicStates||10||int|||| ||Parsonnet_AdditionsForRareConditions||11||int|||| ||AdditiveEuroscore||12||int|||| ||SctsComplexCabgBayesScore||13||float|||| ||LogisticEuroscore||14||float|||| ||Cardioplegia_Solution||15||varchar|||| ||Cardioplegia_Temperature||16||varchar|||| ||Cardioplegia_Timing||17||varchar|||| ||Non_CardioplegicMyocardialProtection||18||varchar|||| ||IntraAorticBalloonPumpUsed||19||varchar|||| ||ReasonForIntra_OperativeIntra_AorticBalloonPumpUse||20||varchar|||| ||HeightInCm||21||int|||| ||WeightInKg||22||float|||| ||CumulativeBypassTime||23||int|||| ||CumulativeCrossClampTime||24||int|||| ||TotalCirculatoryArrestTime||25||int|||| ||NewPost_OperativeNeurologicalDysfunction||26||varchar|||| ||NewHaemofiltrationOrDialysis||27||varchar|||| ||DischargeDestinationFromCardiothoracicWard||28||varchar|||| ||DateOfDischargeOrDeath||29||date|||| ||BodySurfaceArea||30||float|||| ||BodyMassIndex||31||float|||| ||Cardioplegia_InfusionMode||32||varchar|||| ||EuroscoreMinumumDatasetCheck||33||varchar|||| ||ParsonnetMinumumDatasetCheck||34||varchar|||| ||NameOfGpAtTimeOfSurgery||35||varchar|||| ||GpPracticeCodeAtTimeOfSurgery||36||varchar|||| ||PctAtTimeOfSurgery||37||varchar|||| ||NameOfReferringGpAtTimeOfSurgeryType8||38||varchar|||| ||ToePerformed||39||varchar|||| ||Sonographer||40||varchar|||| ||Sonographist||41||varchar|||| ||PrimaryPerfusionist||42||varchar|||| ||PcuPatient_pcu||43||varchar|||| ||DoesPatientMeetInterOperativeCriteria_pcu||44||varchar|||| ||AreaPatientAdmittedTo_pcu||45||varchar|||| ||AdmissionTimeToRecovery_cicu_pcu||46||varchar|||| ||ExtubationDateAndTime_pcu||47||varchar|||| ||WhatO2SystemWasUsed_pcu||48||varchar|||| ||TotalBloodLostOnDischargeFromRecovery_pcu||49||varchar|||| ||WereClottingProductsUsed_pcu||50||varchar|||| ||WhatProductsWereUsed_pcu||51||varchar|||| ||HowMuchColloidUsedInRecovery_pcu||52||varchar|||| ||TypeOfColloidUsed_pcu||53||varchar|||| ||PainScoreOnWaking_pcu||54||varchar|||| ||AnalgesiaUsedPcu||55||varchar|||| ||TotalMorphineDoseUsedIncludingBolus_pcu||56||varchar|||| ||InotropesUsed_pcu||57||varchar|||| ||Dosage_pcu||58||varchar|||| ||WereThereAnyArrhythmias_pcu||59||varchar|||| ||PleaseStateArrhythmias_pcu||60||varchar|||| ||TreatmentOfArrhythmias_pcu||61||varchar|||| ||PotassiumUsed_pcu||62||varchar|||| ||PotassiumDoseInMmols_pcu||63||varchar|||| ||TemperatureOnAdmission_pcu||64||float|||| ||BairhuggerWithPatient_pcu||65||varchar|||| ||TimeOfDischarge_pcu||66||varchar|||| ||PlaceOfDischarge_pcu||67||varchar|||| ||DoesPatientMeetDischargeCriteria_pcu||68||varchar|||| ||WasPatientDischargedFromPcuToHdu_pcu||69||varchar|||| ||LowUrineOutput_pcu||70||varchar|||| ||IfNoStateWhy_pcu||71||varchar|||| ||IfNoWhy_pcu||72||varchar|||| ||AmountOfTimeIntubated_pcu||73||float|||| ||AmountOfTimeInRecovery_cicu_pcu||74||float|||| ||OverallComments_sa||75||text|||| ||TeachingOfOtherStaffComments_sa||76||varchar|||| ||TeachingOfOtherStaffCommentsMade_sa||77||varchar|||| ||TeachingOfOtherStaffBySa_sa||78||varchar|||| ||IabpRemovalComments_sa||79||text|||| ||IabpRemovalCommentsMade_sa||80||varchar|||| ||IabpRemovalBySa_sa||81||varchar|||| ||IabpInsertionComments_sa||82||text|||| ||IabpInsertionCommentsMade_sa||83||varchar|||| ||IabpInsertionBySa_sa||84||varchar|||| ||SternotomyClosureComments_sa||85||text|||| ||SternotomyClosureCommentsMade_sa||86||varchar|||| ||SternotomyClosureBySa_sa||87||varchar|||| ||SternotomyComments_sa||88||varchar|||| ||SternotomyCommentsMade_sa||89||varchar|||| ||SternotomyPerformedBySa_sa||90||varchar|||| ||ThirdSiteComments_sa||91||varchar|||| ||ThirdSiteCommentsMade_sa||92||varchar|||| ||ThirdSiteConduit_location_sa||93||varchar|||| ||SecondSiteComments_sa||94||varchar|||| ||SecondSiteCommentsMade_sa||95||varchar|||| ||SecondSiteConduit_location_sa||96||varchar|||| ||FirstSiteComments_sa||97||varchar|||| ||FirstSiteCommentsMade_sa||98||varchar|||| ||FirstSiteConduei_location_sa||99||varchar|||| ||ThirdAssistant_sa||100||varchar|||| ||SecondAssistant_sa||101||varchar|||| ||FirstAssistant_sa||102||varchar|||| ||SurgicalAssistant_sa||103||varchar|||| ||ReferralToOperation_days||104||float|||| ||Arrhythmia_S||105||varchar|||| ||LowCardiacOutput||106||varchar|||| ||Ventilation||107||varchar|||| ||PulmonaryComplications||108||varchar|||| ||RenalComplications||109||varchar|||| ||GastrointestinalComplications||110||varchar|||| ||InfectiveComplications||111||varchar|||| ||CauseOfDeath||112||varchar|||| ||AdmittedFrom_hospitalNameOrWard||113||varchar|||| ||AdmittedToCardiacSurgery||114||date|||| ||DischargedFromCardiacSurgery||115||date|||| ||TotalCardiacSurgeryLosDays||116||float|||| ||DateOfFollowUp||117||date|||| ||BloodUsed||118||varchar|||| ||MutisystemFailure||119||varchar|||| ||DateFirstAdmittedToCicu||120||date|||| ||DateFirstDischargedFromCicu||121||date|||| ||TotalFirstStayOnCicu||122||float|||| ||ReAdmittedToCicu||123||varchar|||| ||DateOfSecondAdmissionToCicu||124||date|||| ||DateOfSecondDischargeFromCicu||125||date|||| ||SecondAdmissionTotalStay_nignts||126||float|||| ||DateOfThirdAdmissionToCicu||127||date|||| ||DateOfThirdDischargeFromCicu||128||date|||| ||ThirdAdmissionToCicuTotalStay_nights||129||float|||| ||InsertionOfPacemakerWiresViaVatsProcedure||130||varchar|||| ||IntubationTimeInHours||131||int|||| ||AuditTrail||132||text|||| ||NameOfDoctorCompletingBooklet||133||varchar|||| ||SecondPrimaryPerfusionist||134||varchar|||| ||SecondBypass||135||varchar|||| ||SecondMyocardialProtection||136||varchar|||| ||SecondCardioplegiaSolution||137||varchar|||| ||SecondCardioplegiaInfusion||138||varchar|||| ||SecondCardioplegiaTemperature||139||varchar|||| ||SecondCardioplegiaTiming||140||varchar|||| ||SecondNon_CardioplegiaMyocardialProtection||141||varchar|||| ||DoesPatientNeedAFollowUpAppiontment||142||varchar|||| ||Comments||143||varchar|||| ||MedicalRecordNumber||144||varchar|||| ||DateAddedToW_l||145||date|||| ||AddedToW_l||146||varchar|||| ||DateOfFourthAdmissionToCicu||147||date|||| ||DateOfFourthDischargeFromCicu||148||date|||| ||DateOfFifthAdmissionToCicu||149||date|||| ||DateOfFifthDischargeFromCicu||150||date|||| ||CumulativeStayFirstAndSecondAdmissionToCicu||151||float|||| ||Cumulative1st2ndAnd3rdStayInCicu||152||float|||| ||FourthAdmissionToCicuTotalStay_nights||153||float|||| ||Cumulative1st2nd3rd4thStayInCicu||154||float|||| ||FifthAdmissionToCicuTotalStay_nights||155||float|||| ||Cumulative1sr2nd3rd4th5thStayInCicu||156||float|||| ||PatientIdentifiedForSamedayAdmission||157||varchar|||| ||ProposedDateOfAdmission||158||date|||| ||SecondBypassTotal||159||int|||| ||SecondCrossClampTotal||160||int|||| ||SecondCiculatoryArrestTotal||161||int|||| ||CouncilCase||162||varchar|||| ||InitialConsultantInJointCase||163||varchar|||| ||ArrhythmiaOtherComplicationFreeText||164||text|||| ||LowCardiacOutputOtherComplicationFreeText||165||text|||| ||PulmonaryOtherComplicationFreeText||166||text|||| ||RenalOtherComplicationFreeText||167||text|||| ||GastrointestinalOtherComplicationFreeText||168||text|||| ||InfectiveOtherComplicationFreeText||169||varchar|||| ||SickNoteOffered||170||varchar|||| ||IfSickNoteOfferedDurationInDays||171||int|||| ||AdviceToGp||172||varchar|||| ||NameOfDischargingDoctor||173||varchar|||| ||GradeOfDischargingDoctor||174||varchar|||| ||PagerNumber||175||varchar|||| ||DrugSensitivity||176||varchar|||| ||Drug1||177||varchar|||| ||DrugRoute1||178||varchar|||| ||NumberOfDays1||179||int|||| ||Continue1||180||varchar|||| ||Drug2||181||varchar|||| ||DrugRoute2||182||varchar|||| ||NumberOfDays2||183||int|||| ||Continue2||184||varchar|||| ||Drug3||185||varchar|||| ||DrugRoute3||186||varchar|||| ||NumberOfDays3||187||int|||| ||Continue3||188||varchar|||| ||Drug4||189||varchar|||| ||DrugRoute4||190||varchar|||| ||NumberOfDays4||191||int|||| ||Continue4||192||varchar|||| ||Drug5||193||varchar|||| ||DrugRoute5||194||varchar|||| ||NumberOfDays5||195||int|||| ||Continue5||196||varchar|||| ||Drug6||197||varchar|||| ||DrugRoute6||198||varchar|||| ||NumberOfDays6||199||int|||| ||Continue6||200||varchar|||| ||Drug7||201||varchar|||| ||DrugRoute7||202||varchar|||| ||NumberOfDays7||203||int|||| ||Continue7||204||varchar|||| ||Drug8||205||varchar|||| ||DrugRoute8||206||varchar|||| ||NumberOfDays8||207||int|||| ||Continue8||208||varchar|||| ||Drug9||209||varchar|||| ||DrugRoute9||210||varchar|||| ||NumberOfDays9||211||int|||| ||Continue9||212||varchar|||| ||Drug10||213||varchar|||| ||DrugRoute10||214||varchar|||| ||NumberOfDays10||215||int|||| ||Continue10||216||varchar|||| ||Drug11||217||varchar|||| ||DrugRoute11||218||varchar|||| ||NumberOfDays11||219||int|||| ||Continue11||220||varchar|||| ||Drug12||221||varchar|||| ||DrugRoute12||222||varchar|||| ||NumberOfDays12||223||int|||| ||Continue12||224||varchar|||| ||Drug13||225||varchar|||| ||DrugRoute13||226||varchar|||| ||NumberOfDays13||227||int|||| ||Continue13||228||varchar|||| ||Drug14||229||varchar|||| ||DrugRoute14||230||varchar|||| ||NumberOfDays14||231||int|||| ||Continue14||232||varchar|||| ||Drug15||233||varchar|||| ||DrugRoute15||234||varchar|||| ||NumberOfDays15||235||int|||| ||Continue15||236||varchar|||| ||Drug16||237||varchar|||| ||DrugRoute16||238||varchar|||| ||NumberOfDays16||239||int|||| ||Continue16||240||varchar|||| ||Drug17||241||varchar|||| ||DrugRoute17||242||varchar|||| ||NumberOfDays17||243||int|||| ||Continue17||244||varchar|||| ||Drug18||245||varchar|||| ||DrugRoute18||246||varchar|||| ||NumberOfDays18||247||int|||| ||Continue18||248||varchar|||| ||DrugNameAndStrength19||249||varchar|||| ||DrugForm19||250||varchar|||| ||DrugDose19||251||varchar|||| ||DrugRoute19||252||varchar|||| ||DrugFrequency19||253||varchar|||| ||NumberOfDays19||254||int|||| ||Continue19||255||varchar|||| ||DrugNameAndStrength20||256||varchar|||| ||DrugForm20||257||varchar|||| ||DrugDose20||258||varchar|||| ||DrugRoute20||259||varchar|||| ||DrugFrequency20||260||varchar|||| ||NumberOfDays20||261||int|||| ||Continue20||262||varchar|||| ||DrugNameAndStrength21||263||varchar|||| ||DrugForm21||264||varchar|||| ||DrugDose21||265||varchar|||| ||DrugRoute21||266||varchar|||| ||DrugFrequency21||267||varchar|||| ||NumberOfDays21||268||int|||| ||Continue21||269||varchar|||| ||DrugNameAndStrength22||270||varchar|||| ||DrugForm22||271||varchar|||| ||DrugDose22||272||varchar|||| ||DrugRoute22||273||varchar|||| ||DrugFrequency22||274||varchar|||| ||NumberOfDays22||275||int|||| ||Continue22||276||varchar|||| ||DrugNameAndStrength23||277||varchar|||| ||DrugForm23||278||varchar|||| ||DrugDose23||279||varchar|||| ||DrugRoute23||280||varchar|||| ||DrugFrequency23||281||varchar|||| ||NumberOfDays23||282||int|||| ||Continue23||283||varchar|||| ||DrugNameAndStrength24||284||varchar|||| ||DrugForm24||285||varchar|||| ||DrugDose24||286||varchar|||| ||DrugRoute24||287||varchar|||| ||DrugFrequency24||288||varchar|||| ||NumberOfDays24||289||int|||| ||Continue24||290||varchar|||| ||DischargeWard||291||varchar|||| ||Pharmacist||292||varchar|||| ||ManagementPlan||293||varchar|||| ||FollowUpRequired||294||varchar|||| ||FollowUpTimeInWeeks_months||295||varchar|||| ||MedicationChangedByPharmacist||296||varchar|||| ||StatePharmacistChanges||297||text|||| ||InformationGivenToPatient||298||varchar|||| ||DateTimeRecordCreated||299||varchar|||| ||DateTimeRecordLastChanged||300||varchar|||| ||EnteredByTag||301||varchar|||| ||HospitalTag||302||varchar|||| === CS2010F_PreProcedure ||Field Name||Column ID||Type||Comments|| ||EntryId||1||int|||| ||PatientId||2||int|||| ||DateOfOperation||3||date|||| ||TimeOfEntry||4||time|||| ||EntryStatus||5||varchar|||| ||PreviousEntry||6||int|||| ||NextEntry||7||int|||| ||AgeAtOperation||8||int|||| ||Gender||9||varchar|||| ||DateOfAdmission||10||date|||| ||AnginaStatusPre_Surgery||11||varchar|||| ||DyspnoeaStatusPre_Surgery||12||varchar|||| ||NumberOfPreviousMis||13||varchar|||| ||IntervalBetweenSurgeryAndLastMi||14||varchar|||| ||PreviousPci||15||varchar|||| ||PreviousCardiacSurgery||16||varchar|||| ||DateOfLastCardiacOperation||17||date|||| ||DiabetesManagement||18||varchar|||| ||HistoryOfHypertension||19||varchar|||| ||CigaretteSmokingHistory||20||varchar|||| ||HistoryOfPulmonaryDisease||21||varchar|||| ||HistoryOfNeurologicalDisease||22||varchar|||| ||Pre_OperativeHeartRhythm||23||varchar|||| ||DateOfLastCatheterisation||24||date|||| ||PaSystolic||25||int|||| ||IntravenousNitratesOrAnyHeparin||26||varchar|||| ||IntravenousInotropesPriorToAnaesthesia||27||varchar|||| ||VentilatedPreOperation||28||varchar|||| ||CardiogenicShock_pre_Operation||29||varchar|||| ||OperativeUrgency||30||varchar|||| ||FirstOperatorGrade||31||varchar|||| ||FirstOperator_CalmanYearOfTrainee||32||varchar|||| ||CardiacProcedures||33||varchar|||| ||OtherCardiacProcedures||34||varchar|||| ||OtherThoracicAndVascularProcedures||35||varchar|||| ||LeftMainStemDisease||36||varchar|||| ||ExtentOfCoronaryVesselDisease||37||varchar|||| ||ExtracardiacArteriopathy||38||varchar|||| ||EjectionFractionCategory||39||varchar|||| ||AdministrativeCategory||40||varchar|||| ||DateAndTimeOfOperation||41||varchar|||| ||NumberOfPreviousHeartOperations||42||int|||| ||ResponsibleConsultantSurgeon||43||varchar|||| ||FirstOperator||44||varchar|||| ||FirstAssistant||45||varchar|||| ||FirstAssistantGrade||46||varchar|||| ||FirstAssistant_CalmanYearOfTrainee||47||varchar|||| ||ResponsibleConsultantAnaesthetist||48||varchar|||| ||OperationFindings||49||varchar|||| ||ReferringCardiologist||50||varchar|||| ||DateOfReferral||51||date|||| ||DrugsOnAdmission||52||varchar|||| ||Allergies||53||varchar|||| ||AllOtherAssistants||54||varchar|||| ||WaitingListStatusUpdated||55||varchar|||| ||SprCases||56||varchar|||| ||DateOfCurrentStatus||57||date|||| ||DateOfEndStatus||58||date|||| ||DateTimeRecordCreated||59||varchar|||| ||DateTimeRecordLastChanged||60||varchar|||| ||EnteredByTag||61||varchar|||| ||EntryCurrentStatus||62||varchar|||| ||EntryEndStatus||63||varchar|||| ||HospitalTag||64||varchar|||| === EPS_EPSINIVW ||Field Name||Column ID||Type||Comments|| ||EntryId||1||int|||| ||PatientId||2||int|||| ||DateOfEntry||3||date|||| ||TimeofEPSRFA||4||time|||| ||EntryStatus||5||varchar|||| ||PreviousEntry||6||int|||| ||NextEntry||7||int|||| ||DateOfAdmission||8||date|||| ||DateOfDischarge||9||date|||| ||DateAddedToWaitingList||10||date|||| ||HospitalIdentifier||11||varchar|||| ||PatientGender||12||varchar|||| ||AgeAtOperation||13||int|||| ||PatientEthnicGroup||14||varchar|||| ||PatientAdminStatus||15||varchar|||| ||IsThisARe_Do||16||varchar|||| ||Preeps_ablationAetiology2||17||varchar|||| ||Preeps_ablationEcg||18||varchar|||| ||Prepacing_eps_ablationPresentingSymptom||19||varchar|||| ||GeneratorPacingMode||20||varchar|||| ||Preeps_ablationPreviousIntervention||21||varchar|||| ||Preeps_ablationArrhythmia||22||varchar|||| ||Eps_ablationIndicationForIntervention||23||varchar|||| ||Preicd_ablationQrsDuration||24||int|||| ||Date_timeOfProcedure||25||varchar|||| ||ProcedureUrgency||26||varchar|||| ||OperativeUrgency||27||varchar|||| ||PrimaryOperator||28||varchar|||| ||FirstOperatorStatus||29||varchar|||| ||SecondOperator||30||varchar|||| ||SecondOperatorStatus||31||varchar|||| ||ThirdOperator||32||varchar|||| ||ThirdOperatorStatus||33||varchar|||| ||Ccso||34||varchar|||| ||AblationProcedure_s||35||varchar|||| ||AccessoryPathway||36||varchar|||| ||NumberOfElectrodeCatheters||37||int|||| ||MappingTechnique||38||varchar|||| ||TransseptalApproach||39||varchar|||| ||Anticoagulation||40||varchar|||| ||HeparinDose_iu||41||int|||| ||TotalFluoroscopyTime||42||float|||| ||ProcedureStartTime||43||varchar|||| ||ProcedureEndTime||44||varchar|||| ||ProcedureDuration||45||int|||| ||AblationAttempted||46||varchar|||| ||WaitingTime||47||int|||| ||WhyAblationNotAttempted||48||varchar|||| ||NumberOfEnergyApplications||49||int|||| ||TotalTimeOfEnergyApplication||50||int|||| ||AblationEnergySource||51||varchar|||| ||Catheter||52||varchar|||| ||CatheterReach||53||varchar|||| ||Ga||54||varchar|||| ||WhichPulmonaryVeinsAblated||55||varchar|||| ||Success||56||varchar|||| ||TransientHeartBlock||57||varchar|||| ||AblationComplications||58||varchar|||| ||AvBlock||59||varchar|||| ||DeviceImplanted||60||varchar|||| ||IntraopDrugs2||61||varchar|||| ||ProcedureReport_comment||62||varchar|||| ||Early_24hrs_Recurrence||63||varchar|||| ||ChestDrain||64||varchar|||| ||PericardialTap||65||varchar|||| ||ArterialRepair||66||varchar|||| ||DeathOnSameAdmission||67||varchar|||| ||LateRecurrenceOfArrhythmia||68||varchar|||| ||TimeToRecurrence_months||69||int|||| ||DateLastFollow_Up||70||date|||| ||PreOpStay||71||int|||| ||PostOpStay||72||int|||| ||TotalHospitalStay||73||int|||| ||TotalTimeOnWaitingList||74||int|||| ||ReferringGpOrDentist||75||varchar|||| ||NameOfReferringGpOrDentist||76||varchar|||| ||GpPracticeCode||77||varchar|||| ||Pct||78||varchar|||| ||MedicalRecordNumberAtTimeOfEntry||79||varchar|||| ||AuditTrail||80||varchar|||| ||CatheterCcad||81||varchar|||| ||CatheterReachCcad||82||varchar|||| ||AfAblationStrategies||83||varchar|||| ||Score||84||int|||| ||Tvac_pvac||85||varchar|||| ||Height||86||float|||| ||Weight||87||float|||| ||Bmi||88||float|||| ||ScreeningDose||89||float|||| ||ExceededDrl||90||varchar|||| ||Radiographer||91||varchar|||| ||ReasonForExceedingDrl||92||varchar|||| ||DateOfCurrentStatus||93||date|||| ||DateOfEndStatus||94||date|||| ||DateTimeRecordCreated||95||varchar|||| ||DateTimeRecordLastChanged||96||varchar|||| ||EnteredByTag||97||varchar|||| ||EntryCurrentStatus||98||varchar|||| ||EntryEndStatus||99||varchar|||| ||HospitalTag||100||varchar|||| ||ImportLinkId||101||int|||| === GGHMINAP_GGHMINAP ||Field Name||Column ID||Type||Comments|| ||EntryId||1||int|||| ||PatientId||2||int|||| ||DateofHospitalAdmission||3||datetime|||| ||TimeofHospitalAdmission||4||datetime|||| ||EntryStatus||5||varchar|||| ||PreviousEntry||6||int|||| ||NextEntry||7||int|||| ||Age||8||int|||| ||DateOfAdmissionToCcu||9||datetime|||| ||DirectAdmission||10||varchar|||| ||GenderCcad||11||varchar|||| ||EthnicOriginCcad||12||varchar|||| ||PatientAdminStatusCcad||13||varchar|||| ||HospitalCentreCode||14||varchar|||| ||GpPracticeCodeCcad||15||varchar|||| ||InitialDiagnosisCcad||16||varchar|||| ||OtherAdmissionDiagnosis||17||varchar|||| ||MethodOfAdmissionCcad||18||varchar|||| ||EcgDeterminingTreatmentCcad||19||varchar|||| ||WhereWasAspirin_otherAntiplateletGivenCcad||20||varchar|||| ||PreviousAmiCcad||21||varchar|||| ||PreviousAnginaCcad||22||varchar|||| ||HypertensionCcad||23||varchar|||| ||HypercholesterolaemiaCcad||24||varchar|||| ||PeripheralVascularDiseaseCcad||25||varchar|||| ||CerebrovascularDiseaseCcad||26||varchar|||| ||AsthmaOrCopdCcad||27||varchar|||| ||ChronicRenalFailureCcad||28||varchar|||| ||HeartFailureCcad||29||varchar|||| ||CardiacEnzymes_markersRaisedCcad||30||varchar|||| ||SerumCholesterolCcad||31||float|||| ||SmokingStatusCcad||32||varchar|||| ||DiabetesCcad||33||varchar|||| ||PreviousPciCcad||34||varchar|||| ||PreviousCabgCcad||35||varchar|||| ||SystolicBpCcad||36||int|||| ||HeartRateCcad||37||int|||| ||AdmittingConsultantCcad||38||varchar|||| ||PlaceFirst12LeadEcgPerformedCcad||39||varchar|||| ||BetaBlockerUseCcad||40||varchar|||| ||Ace1OrArbUseCcad||41||varchar|||| ||StatinUseCcad||42||varchar|||| ||ClopidogrelUseCcad||43||varchar|||| ||HeightCcad||44||float|||| ||WeightCcad||45||float|||| ||LeftVentricularEjectionFractionCcad||46||varchar|||| ||FamilyHistoryOfChdCcad||47||varchar|||| ||AmbulanceDriver||48||varchar|||| ||AmbulanceAttendant||49||varchar|||| ||AmbulanceResponder||50||varchar|||| ||TimeLeftScene||51||varchar|||| ||OnsetOfSymptomsCcad||52||varchar|||| ||CallForHelpCcad||53||varchar|||| ||ArrivalOfFirstProfessionalHelpCcad||54||varchar|||| ||ArrivalOfEmergencyServiceCcad||55||varchar|||| ||AmbulanceJobNumberCcad||56||varchar|||| ||ArrivalAtHospitalCcad||57||varchar|||| ||WasReperfusionAttempted_Ccad||58||varchar|||| ||ReasonThrombolyticTreatmentNotGivenCcad||59||varchar|||| ||StartOfReperfusionTreatmentCcad||60||varchar|||| ||DelayBeforeTreatmentCcad||61||varchar|||| ||WhereWasInitialReperfusionTreatmentGiven_Ccad||62||varchar|||| ||WhoTookTheInitialDecisionToAttemptReperfusion_Ccad||63||varchar|||| ||FirstCardiacArrestCcad||64||varchar|||| ||CardiacArrestCcad||65||varchar|||| ||ArrestPresentingRhythmCcad||66||varchar|||| ||OutcomeOfArrestCcad||67||varchar|||| ||AdmissionWardCcad||68||varchar|||| ||PeakCreatinineKinase_ck_Ccad||69||float|||| ||PeakTroponinCcad||70||float|||| ||TroponinAssayCcad||71||varchar|||| ||TroponinReferenceValue||72||varchar|||| ||UnfractionatedHeparinCcad||73||varchar|||| ||LowMolecularWeightHeparinCcad||74||varchar|||| ||ThienopyridinePlateletInhibitorCcad||75||varchar|||| ||OtherOralAntiplateletAgentCcad||76||varchar|||| ||Iv2b_3aAgentCcad||77||varchar|||| ||IvBetaBlockerCcad||78||varchar|||| ||CalciumChannelBlockerCcad||79||varchar|||| ||IvNitrateCcad||80||varchar|||| ||OralNitratesCcad||81||varchar|||| ||PotassiumChannelModulatorCcad||82||varchar|||| ||WarfarinCcad||83||varchar|||| ||AngiotensinIiBlocker_arb_Ccad||84||varchar|||| ||ThiazideDiureticCcad||85||varchar|||| ||AdmissionPlasmaGlucoseCcad||86||float|||| ||LoopDiureticCcad||87||varchar|||| ||SpironolactoneCcad||88||varchar|||| ||ThrombolyticDrugCcad||89||varchar|||| ||DateOfDischargeOrDeathCcad||90||datetime|||| ||DateOfDischargeFromCcu||91||datetime|||| ||DischargedFromCcuDestination||92||varchar|||| ||DischargeDiagnosisCcad||93||varchar|||| ||OtherDischargeDiagnosis||94||varchar|||| ||DiagamiCcad||95||varchar|||| ||RecommendedTherapyAtDischargeCcad||96||varchar|||| ||DaysInHospital||97||int|||| ||DaysInCcu||98||int|||| ||BleedingComplicationsCcad||99||varchar|||| ||DeathInHospitalCcad||100||varchar|||| ||DischargedOnBetaBlockerCcad||101||varchar|||| ||AceInhibitorCcad||102||varchar|||| ||DischargedOnStatinCcad||103||varchar|||| ||DischargedOnAspirinOrOtherPlateletDrugCcad||104||varchar|||| ||CardiacRehabilitationCcad||105||varchar|||| ||ExerciseTestPerformedCcad||106||varchar|||| ||EchocardiographyCcad||107||varchar|||| ||RadionuclideStudyCcad||108||varchar|||| ||CoronaryAngiographyAtThisAdmissionCcad||109||varchar|||| ||CoronaryInterventionPerformedAtThisAdmissionCcad||110||varchar|||| ||DateOfReferralForInvestigation_intervention||111||datetime|||| ||ModeOfDischargeCcad||112||varchar|||| ||DateOfTransferForDayCaseInvestigationCcad||113||datetime|||| ||DateOfAngioPerformedLocallyCcad||114||datetime|||| ||DateOfFirstInterventionOrSurgeryPerformedLocallyCc||115||datetime|||| ||ReferralCentreCcad||116||varchar|||| ||ReferringHospitalCcad||117||varchar|||| ||PatientCaseRecordNumberAtReferralCentreCcad||118||varchar|||| ||FollowedUpByCcad||119||varchar|||| ||ReinfarctionCcad||120||varchar|||| ||DischargedOnClopidogrelCcad||121||varchar|||| ||DelayFromOnsetOfSymptomsToCallForHelp||122||float|||| ||DelayFromCallForHelpToArrivalOfEmergencyServices||123||float|||| ||DelayFromCallForHelpToArrivalInHospital||124||float|||| ||DelayFromArrivalInHospitalToReperfusionTreatment||125||float|||| ||DelayFromCallForHelpToReperfusionTreatment||126||float|||| ||DelayFromOnsetOfSymptomsToReperfusionTreatment||127||float|||| ||TotalTimeOnScene||128||float|||| ||DelayFromReferralForInvestigation_interventionToTr||129||float|||| ||PctCode||130||varchar|||| ||MedicalRecordNumberAtTimeOfEntryCcad||131||varchar|||| ||Comments||132||varchar|||| ||PreAlertCall||133||varchar|||| ||PickUpPostCode||134||varchar|||| ||CardiacNurseInAttendance||135||varchar|||| ||Cox_2InhibitorUse||136||varchar|||| ||NsaidUse||137||varchar|||| ||NitrateUse||138||varchar|||| ||CalciumChannelBlockerUse||139||varchar|||| ||Spironolactone||140||varchar|||| ||Eplerenone||141||varchar|||| ||Nitrates||142||varchar|||| ||Warfarin||143||varchar|||| ||Other||144||varchar|||| ||DateAndTimeOfFirstDiagnosticEcg||145||varchar|||| ||AuditTrail||146||varchar|||| ||DaysFromAdmissionToDeath||147||int|||| ||DateOfCurrentStatus||148||datetime|||| ||DateOfEndStatus||149||datetime|||| ||DateTimeRecordCreated||150||datetime|||| ||DateTimeRecordLastChanged||151||datetime|||| ||EnteredByTag||152||varchar|||| ||EntryCurrentStatus||153||varchar|||| ||EntryEndStatus||154||varchar|||| ||HospitalTag||155||varchar|||| === GGHMINAPNEW ||Field Name||Column ID||Type||Comments|| ||EntryId||1||int|||| ||PatientId||2||int|||| ||DateofAdmissiontoCCU||3||datetime|||| ||TimeofAdmissiontoCCU||4||datetime|||| ||EntryStatus||5||varchar|||| ||PreviousEntry||6||int|||| ||NextEntry||7||int|||| ||OnsetOfSymptomsCcad||8||varchar|||| ||MethodOfAdmissionCcad||9||varchar|||| ||CallForHelpCcad||10||varchar|||| ||ArrivalOfEmergencyServiceCcad||11||varchar|||| ||ArrivalAtHospitalCcad||12||varchar|||| ||DateAndTimeOfReperfusionTreatmentCcad||13||varchar|||| ||FirstCardiacArrestCcad||14||varchar|||| ||CardiacArrestLocationCcad||15||varchar|||| ||ArrestPresentingRhythmCcad||16||varchar|||| ||OutcomeOfArrestCcad||17||varchar|||| ||InitialDiagnosisCcad||18||varchar|||| ||EcgDeterminingTreatmentCcad||19||varchar|||| ||AdditionalReperfusionTreatmentCcad||20||varchar|||| ||WhereWasInitialReperfusionTreatmentGiven_Ccad||21||varchar|||| ||WhoTookTheInitialDecisionToAttemptReperfusion_Ccad||22||varchar|||| ||ReasonReperfusionTreatmentNotGivenCcad||23||varchar|||| ||Age||24||int|||| ||WhereWasAspirin_otherAntiplateletGivenCcad||25||varchar|||| ||AdmissionWardCcad||26||varchar|||| ||AdmittingConsultantCcad||27||varchar|||| ||DischargeDiagnosisCcad||28||varchar|||| ||DeathInHospitalCcad||29||varchar|||| ||DateOfDischargeOrDeathCcad||30||datetime|||| ||DischargedOnBetaBlockerCcad||31||varchar|||| ||AceInhibitorCcad||32||varchar|||| ||DischargedOnStatinCcad||33||varchar|||| ||DischargedOnAspirinOrOtherPlateletDrugCcad||34||varchar|||| ||CardiacRehabilitationCcad||35||varchar|||| ||ExerciseTestPerformedCcad||36||varchar|||| ||EchocardiographyCcad||37||varchar|||| ||RadionuclideStudyCcad||38||varchar|||| ||CoronaryAngiographyCcad||39||varchar|||| ||CoronaryInterventionCcad||40||varchar|||| ||GenderCcad||41||varchar|||| ||DelayBeforeTreatmentCcad||42||varchar|||| ||DaysInHospital||43||int|||| ||DelayFromOnsetOfSymptomsToCallForHelp||44||float|||| ||DelayFromCallForHelpToArrivalOfEmergencyServices||45||float|||| ||DelayFromCallForHelpToArrivalInHospital||46||float|||| ||DelayFromArrivalInHospitalToReperfusionTreatment||47||float|||| ||DelayFromCallForHelpToReperfusionTreatment||48||float|||| ||DelayFromOnsetOfSymptomsToReperfusionTreatment||49||float|||| ||AmbulanceJobNumberCcad||50||varchar|||| ||PeakCreatinineKinase_ck_Ccad||51||float|||| ||PeakTroponinCcad||52||float|||| ||TroponinAssayCcad||53||varchar|||| ||TroponinReferenceValue||54||varchar|||| ||PatientAdminStatusCcad||55||varchar|||| ||PreviousAmiCcad||56||varchar|||| ||PreviousAnginaCcad||57||varchar|||| ||HypertensionCcad||58||varchar|||| ||HypercholesterolaemiaCcad||59||varchar|||| ||PeripheralVascularDiseaseCcad||60||varchar|||| ||CerebrovascularDiseaseCcad||61||varchar|||| ||AsthmaOrCopdCcad||62||varchar|||| ||ChronicRenalFailureCcad||63||varchar|||| ||HeartFailureCcad||64||varchar|||| ||CardiacEnzymes_markersRaisedCcad||65||varchar|||| ||SerumCholesterolCcad||66||float|||| ||SmokingStatusCcad||67||varchar|||| ||DiabetesCcad||68||varchar|||| ||PreviousPciCcad||69||varchar|||| ||PreviousCabgCcad||70||varchar|||| ||SystolicBpCcad||71||int|||| ||HeartRateCcad||72||int|||| ||ArrivalOfFirstProfessionalHelpCcad||73||varchar|||| ||UnfractionatedHeparinCcad||74||varchar|||| ||LowMolecularWeightHeparinCcad||75||varchar|||| ||ThienopyridinePlateletInhibitorCcad||76||varchar|||| ||OtherOralAntiplateletAgentCcad||77||varchar|||| ||Iv2b_3aAgentCcad||78||varchar|||| ||IvBetaBlockerCcad||79||varchar|||| ||CalciumChannelBlockerCcad||80||varchar|||| ||IvNitrateCcad||81||varchar|||| ||OralNitratesCcad||82||varchar|||| ||PotassiumChannelModulatorCcad||83||varchar|||| ||WarfarinCcad||84||varchar|||| ||AngiotensinIiBlocker_arb_Ccad||85||varchar|||| ||ThiazideDiureticCcad||86||varchar|||| ||LoopDiureticCcad||87||varchar|||| ||SpironolactoneCcad||88||varchar|||| ||ThrombolyticDrugCcad||89||varchar|||| ||BleedingComplicationsCcad||90||varchar|||| ||DischargeDestinationCcad||91||varchar|||| ||DateOfReferralForInvestigation_intervention||92||datetime|||| ||DaycaseTransferDateCcad||93||datetime|||| ||LocalAngioDateCcad||94||datetime|||| ||LocalInterventionDateCcad||95||datetime|||| ||InterventionalCentreCodeCcad||96||varchar|||| ||OtherAdmissionDiagnosis||97||varchar|||| ||OtherDischargeDiagnosis||98||varchar|||| ||DischargedFromCcuDestination||99||varchar|||| ||Gp_pctCodeCcad||100||varchar|||| ||DelayFromReferralForInvestigation_interventionToTr||101||float|||| ||PctCode||102||varchar|||| ||MedicalRecordNumberAtTimeOfEntryCcad||103||varchar|||| ||SerumGlucoseCcad||104||float|||| ||DiabeticTherapyAtDischargeCcad||105||varchar|||| ||AuditTrail||106||varchar|||| ||PlaceFirst12LeadEcgPerformedCcad||107||varchar|||| ||BetaBlockerUseCcad||108||varchar|||| ||Ace1OrArbUseCcad||109||varchar|||| ||StatinUseCcad||110||varchar|||| ||ClopidogrelUseCcad||111||varchar|||| ||HeightCcad||112||float|||| ||WeightCcad||113||float|||| ||LeftVentricularEjectionFractionCcad||114||varchar|||| ||FamilyHistoryOfChdCcad||115||varchar|||| ||FollowedUpByCcad||116||varchar|||| ||ReinfarctionCcad||117||varchar|||| ||DischargedOnClopidogrelCcad||118||varchar|||| ||ReferringHospitalCodeCcad||119||varchar|||| ||PatientCaseRecordNumberAtReferringHospitalCcad||120||varchar|||| ||AmbulanceDriver||121||varchar|||| ||AmbulanceAttendant||122||varchar|||| ||AmbulanceResponder||123||varchar|||| ||Comments||124||varchar|||| ||PreAlertCall||125||varchar|||| ||PickUpPostCode||126||varchar|||| ||CardiacNurseInAttendance||127||varchar|||| ||Cox_2InhibitorUse||128||varchar|||| ||NsaidUse||129||varchar|||| ||NitrateUse||130||varchar|||| ||CalciumChannelBlockerUse||131||varchar|||| ||Spironolactone||132||varchar|||| ||Eplerenone||133||varchar|||| ||Nitrates||134||varchar|||| ||Warfarin||135||varchar|||| ||Other||136||varchar|||| ||TimeLeftScene||137||varchar|||| ||HospitalCentreCode||138||varchar|||| ||TotalTimeOnScene||139||float|||| ||DateAndTimeOfFirstDiagnosticEcg||140||varchar|||| ||CardiologicalCareDuringAdmissionCcad||141||varchar|||| ||CreatinineCcad||142||float|||| ||HaemoglobinCcad||143||float|||| ||SiteOfInfarctionCcad||144||varchar|||| ||FondaparinuxCcad||145||varchar|||| ||InitialReperfusionTreatmentCcad||146||varchar|||| ||InPatientManagementOfHyperglycaemia_diabetesCcad||147||varchar|||| ||DateOfReturnToReferringHospital||148||datetime|||| ||DelayForCallToFrv||149||float|||| ||DelayFrvToFullCrew||150||float|||| ||DelayCallToDepart||151||float|||| ||PatientEthnicGroup||152||varchar|||| ||IncludeInD2n||153||varchar|||| ||OtherComments||154||varchar|||| ||CathLabArrivalTime||155||varchar|||| ||BalloonTime||156||varchar|||| ||DelayCcuToLab||157||float|||| ||DelayCallToBalloon||158||float|||| ||DelayDoorToBalloon||159||float|||| ||DelayLabToBalloon||160||float|||| ||IncludeInCallToNeedle||161||varchar|||| ||HospitalRefferedFrom||162||varchar|||| ||FirstMustafa1||163||int|||| ||SecondMustafa2||164||int|||| ||DaysFromAdmissionToDeath||165||int|||| ||DateOfCurrentStatus||166||datetime|||| ||DateOfEndStatus||167||datetime|||| ||DateTimeRecordCreated||168||datetime|||| ||DateTimeRecordLastChanged||169||datetime|||| ||EnteredByTag||170||varchar|||| ||EntryCurrentStatus||171||varchar|||| ||EntryEndStatus||172||varchar|||| ||HospitalTag||173||varchar|||| === GGHMINAPNEW_GGHMINAPINIVW === GGHPACEICD_GGHPACEICDINIALVW === GGHPCI_FLWGGHPCIVIEW === GGHPCI_INITIALGGHPCIVIEW === LRIMINAPNEW === LRIMINAPNEW_LRIMINAPNEWINITIALVW === VERTED_VERTEDINIALVW