Changes between Version 44 and Version 45 of i2b2 Data Import PATS Mapping v1

Timestamp:

03/15/13 09:07:10 (11 years ago)

Author:

Richard Bramley

Comment:

--

i2b2 Data Import PATS Mapping v1

@@ -115 +115 @@
 === [[i2b2 - UHL clinical informatics system integration PATS CATH_CATHINITIALVW|CATH_CATHINITIALVW]]
 
-Start Date Field: !DateofCatheter
+=== [[i2b2 - UHL clinical informatics system integration PATS CS2003F_PostProcedure|CS2003F_PostProcedure]]
 
-||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||||
+=== [[i2b2 - UHL clinical informatics system integration PATS CS2003F_PreProcedure|CS2003F_PreProcedure]]
 
-=== CS2003F_PostProcedure
+=== [[i2b2 - UHL clinical informatics system integration PATS CS2010F_PostProcedure|CS2010F_PostProcedure]]
 
-Start Date Field: !DateOfDischargeOrDeath
+=== [[i2b2 - UHL clinical informatics system integration PATS CS2010F_PreProcedure|CS2010F_PreProcedure]]
 
-||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||
+=== [[i2b2 - UHL clinical informatics system integration PATS EPS_EPSINIVW|EPS_EPSINIVW]]
 
-=== CS2003F_PreProcedure
+=== [[i2b2 - UHL clinical informatics system integration PATS GGHMINAP_GGHMINAP|GGHMINAP_GGHMINAP]]
 
-Start Date Field: !DateOfOperation_ccad
+=== [[i2b2 - UHL clinical informatics system integration PATS GGHMINAPNEW|GGHMINAPNEW]]
 
-||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||
+=== [[i2b2 - UHL clinical informatics system integration PATS GGHMINAPNEW_GGHMINAPINIVW|GGHMINAPNEW_GGHMINAPINIVW]]
 
-=== CS2010F_PostProcedure
+=== [[i2b2 - UHL clinical informatics system integration PATS GGHPACEICD_GGHPACEICDINIALVW|GGHPACEICD_GGHPACEICDINIALVW]]
 
-Start Date Field: !DateOfDischargeOrDeath
+=== [[i2b2 - UHL clinical informatics system integration PATS GGHPCI_FLWGGHPCIVIEW|GGHPCI_FLWGGHPCIVIEW]]
 
-||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||||
+=== [[i2b2 - UHL clinical informatics system integration PATS GGHPCI_INITIALGGHPCIVIEW|GGHPCI_INITIALGGHPCIVIEW]]
 
+=== [[i2b2 - UHL clinical informatics system integration PATS LRIMINAPNEW|LRIMINAPNEW]]
 
-=== CS2010F_PreProcedure
+=== [[i2b2 - UHL clinical informatics system integration PATS LRIMINAPNEW_LRIMINAPNEWINITIALVW|LRIMINAPNEW_LRIMINAPNEWINITIALVW]]
 
-Start Date Field: !DateOfOperation
+=== [[i2b2 - UHL clinical informatics system integration PATS VERTED_VERTEDINIALVW|VERTED_VERTEDINIALVW]]
 
-||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