[[i2b2 - UHL clinical informatics system integration PATS|Back]]

The PATS mappings are split into text and numeric fields.

== Text Fields

Text fields are mapped to the i2b2 Observation Fact table like this

||i2b2 Field||Source||
||Encounter_Num||i2b2 Patient ID||
||Patient_Num||i2b2 PatientID||
||Concept_Cd||Enum lookup value (see below)||
||Provider_Id||"@"||
||Start_Date||The source table observation date field (see below)||
||Modifier_Cd||"@"||
||ValType_Cd||"T" (text)||
||Units_Cd||"@"||
||Location_Cd||"@"||
||Update_Date||The current date using the GETDATE() Function||
||SourceSystem_Cd||"BRICCS"||
||Upload_Id||"1"||

'''''SOMETIME (RB): Convert Update_Date to use a date parameter.  It's just a little quicker.'''''

'''''SOMETIME (RB): Should the SourceSystem_Cd not be "PATS"? Or maybe "MINAP" or whatever.'''''

'''''SOMETIME (RB): The Upload_Id is presumably always one because everything is reloaded each time.  Might be nice to change this to something more meaningful.'''''

=== Enum Lookup Value

The Concept Code to use is found in the table DATA_DICTIONARY_ENUM_VALUES in the DWBRICCS database on UHLDWH server.  This table contains records for concept code keyed on source table name, column name and column value.  NULL column values may be mapped to the field '(empty)'.

'''''ACTION (RB): Check if all possible values of column value contain a mapping in the ''DATA_DICTIONARY_ENUM_VALUES'' table.'''''

=== Source Table Observation Date Field

For each source table in the there is a single field that is used as the start date for all columns from that field.  The observation date field to use for each table is stored in the ''pats_tables'' table in the DWBRICS on the UHLDWH server.

== Numeric Fields

Numeric fields are mapped to the i2b2 Observation Fact table like this

||i2b2 Field||Source||
||Encounter_Num||i2b2 Patient ID||
||Patient_Num||i2b2 PatientID||
||Concept_Cd||"PTS:{TABLE_NAME}_{COLUMN_ID}"||
||Provider_Id||"@"||
||Start_Date||The source table observation date field (see above)||
||Modifier_Cd||"@"||
||ValType_Cd||"N" (numeric)||
||TVal_Char||"E" (see below)||
||Units_Cd||Value calculated by ufn_get_units function (see below)||
||Location_Cd||"@"||
||Update_Date||The current date using the GETDATE() Function||
||SourceSystem_Cd||"BRICCS"||
||Upload_Id||"1"||

=== TVal_Char

The ''TVal_Char'' describes the meaning of the value contained in the ''NVal_Num'' field.

For all values currently the value of ''TVal_Char'' is set to "E", which means equals.  That is, the value in the ''NVal_Num'' field is the result of the test.  All possible values of ''TVal_Char'' are:

||Value||Meaning||
||E||Equals||
||NE||Not Equal||
||L||Less Than||
||LE||Less Than or Equals||
||G||Greater Than||
||GE||Greater Than or Equals||

From a casual look at the data, I think that a value of less than X, or greater than Y is sometimes used for Pathology data.

=== ufn_get_units Function

The function ufn_get_units in the DWBRICCS database is called with parameters of ''table_name'' and ''field_name'' to determine the units.

'''''ACTION (RB): Work out what this function actually does and then move the logic into a join if possible.  This should be clearer and also quicker.'''''

== Tables

=== CATH_CATHINITIALVW

||Field Name||Column ID||Type||Comments||
||EntryId||1||int||||
||PatientId||2||int||||
||DateofCatheter||3||date||||
||TimeofCatheter||4||time||||
||EntryStatus||5||varchar||||
||PreviousEntry||6||int||||
||NextEntry||7||int||||
||DateOfAdmission||8||date||||
||AgeAtCatheter||9||int||||
||DoneInMobileLab||10||varchar||||
||Consultant||11||varchar||||
||Operator||12||varchar||||
||SecondOperator||13||varchar||||
||Technician||14||varchar||||
||PatientType||15||varchar||||
||WasThePatientCatheterised||16||varchar||||
||ProcedureType||17||varchar||||
||GeneralAnaesthetics||18||varchar||||
||ProcedureSite||19||varchar||||
||BiopsyTaken||20||varchar||||
||BiopsySite||21||varchar||||
||OtherProcedure||22||varchar||||
||Arterial_1||23||varchar||||
||Vessel_1_Arterial||24||varchar||||
||Complicated_1_Arterial||25||varchar||||
||Arterial_2||26||varchar||||
||Vessel_2_Arterial||27||varchar||||
||Complicated2Arterial||28||varchar||||
||Arterial_3||29||varchar||||
||Vessel_3_Arterial||30||varchar||||
||Complicated_3_Arterial||31||varchar||||
||Venous_1||32||varchar||||
||Vessel_1_Venous||33||varchar||||
||Complicated_1_Venous||34||varchar||||
||Venous_2||35||varchar||||
||Vessel_2_Venous||36||varchar||||
||Complicated_2_Venous||37||varchar||||
||Venous_3||38||varchar||||
||Vessel_3_Venous||39||varchar||||
||Complicated_3_Venous||40||varchar||||
||Vessels||41||varchar||||
||ReturnedTo||42||varchar||||
||FurtherProcedure||43||varchar||||
||ImmediateComplications||44||varchar||||
||ProcedureAbandoned||45||varchar||||
||ReasonForAbandoningProcedure||46||varchar||||
||OtherComplications||47||varchar||||
||DiedInCathLab||48||varchar||||
||CoronaryDisease||49||varchar||||
||SignificantValveDisease||50||varchar||||
||SignificantLvDisease||51||varchar||||
||Outcome||52||varchar||||
||ReturnToCathLab||53||varchar||||
||EmbolicSequelae||54||varchar||||
||NonEmergencySurgery||55||varchar||||
||GroinComplication||56||varchar||||
||Death||57||varchar||||
||DischargeComplications||58||varchar||||
||OutcomeOfCatheter||59||varchar||||
||DateOfDischarge||60||date||||
||DateOfDeath||61||date||||
||DischargeTo||62||varchar||||
||PreopStay_days||63||int||||
||PostOpStay_days||64||int||||
||TotalHospitalStay||65||int||||
||IhdScore_cardwl||66||int||||
||NihdScore_cardwl||67||int||||
||OtherComplicationsPreDischarge||68||varchar||||
||DateOfDeathPostDischarge||69||date||||
||PostProcedureDeathInterval_days||70||int||||
||FormsVerified||71||varchar||||
||Contract||72||varchar||||
||Pcg||73||varchar||||
||AuditLoopClosed||74||varchar||||
||DateAuditLoopClosed||75||date||||
||ReasonAuditLoopClosed||76||varchar||||
||IntervalBetweenProc_LoopClosed_days||77||int||||
||DateOnWaitingList||78||date||||
||DaysOnList||79||int||||
||GpPracticeCode||80||varchar||||
||Pct||81||varchar||||
||MedicalRecordNumber||82||varchar||||
||AdministrativeCategory||83||varchar||||
||AuditTrail||84||text||||
||DateAndTimeOfProcedure||85||varchar||||
||IsThisAcs||86||varchar||||
||Sub_Xiphoid||87||varchar||||
||PreDischargeComplications||88||varchar||||
||IfOtherPreDischargeComplicationsPleaseState||89||varchar||||
||Height||90||float||||
||Weight||91||float||||
||Bmi||92||float||||
||ScreeningTime||93||float||||
||ScreeningDose||94||float||||
||ExceededDrl||95||varchar||||
||Radiographer||96||varchar||||
||ReasonForExceedingDrl||97||varchar||||
||CatheterProcedureReport||98||varchar||||
||ConsultantCode||99||varchar||||
||OperatorCode||100||varchar||||
||SecondOperatorCode||101||varchar||||
||TroponinPositive||102||varchar||||
||DateOfCurrentStatus||103||date||||
||DateOfEndStatus||104||date||||
||DateTimeRecordCreated||105||varchar||||
||DateTimeRecordLastChanged||106||varchar||||
||EnteredByTag||107||varchar||||
||EntryCurrentStatus||108||varchar||||
||EntryEndStatus||109||varchar||||
||HospitalTag||110||varchar||||
||ImportLinkId||111||int||||

=== CS2003F_PostProcedure

||Field Name||Column ID||Type||Comments||
||EntryId||1||int||||
||PatientId||2||int||||
||Pre_OperativeStayInDays||3||int||||
||Post_OperativeStayInDays||4||int||||
||TotalStayInDays||5||int||||
||ParsonnetScoreFromHardData||6||int||||
||CardiopulmonaryBypass||7||varchar||||
||ParsonnetScoreWithCatastrophicStatesAndRareConditi||8||int||||
||PredominantMyocardialProtection||9||varchar||||
||Parsonnet_AdditionsForCatastrophicStates||10||int||||
||Parsonnet_AdditionsForRareConditions||11||int||||
||Euroscore||12||int||||
||Cs1999ComplexCabgBayesScore||13||float||||
||LogisticEuroscore||14||float||||
||Cardioplegia_Solution||15||varchar||||
||Cardioplegia_Temperature||16||varchar||||
||Cardioplegia_Timing||17||varchar||||
||Non_CardioplegiaMyocardialProtection||18||varchar||||
||Intra_AorticBalloonPumpUsed||19||varchar||||
||ReaonForIabpUse||20||varchar||||
||HeightInCm||21||int||||
||WeightInKg||22||float||||
||CumulativeBypassTimeInMin||23||int||||
||CumulativeCrossClampTimeInMin||24||int||||
||TotalCirculatoryArrestTimeInMin||25||int||||
||Re_Operation||26||varchar||||
||NewPost_OperativeStroke||27||varchar||||
||NewHaemofiltration_DialysisPost_Operatively||28||varchar||||
||DischargeDestination_FromCardiothoracicWard||29||varchar||||
||DateOfDischargeOrDeath||30||datetime||||
||BodySurfaceArea||31||float||||
||BodyMassIndex||32||float||||
||Cardioplegia_Infusion||33||varchar||||
||EuroscoreMinumumDatasetCheck||34||varchar||||
||ParsonnetMinumumDatasetCheck||35||varchar||||
||NameOfGpAtTimeOfSurgery||36||varchar||||
||GpPracticeCodeAtTimeOfSurgery||37||varchar||||
||PctAtTimeOfSurgery||38||varchar||||
||NameOfReferringGpAtTimeOfSurgeryType8||39||varchar||||
||ToePerformed||40||varchar||||
||Sonographer||41||varchar||||
||Sonographist||42||varchar||||
||PrimaryPerfusionist||43||varchar||||
||PcuPatient_pcu||44||varchar||||
||DoesPatientMeetInterOperativeCriteria_pcu||45||varchar||||
||AreaPatientAdmittedTo_pcu||46||varchar||||
||AdmissionTimeToRecovery_cicu_pcu||47||varchar||||
||ExtubationDateAndTime_pcu||48||varchar||||
||WhatO2SystemWasUsed_pcu||49||varchar||||
||TotalBloodLostOnDischargeFromRecovery_pcu||50||varchar||||
||WereClottingProductsUsed_pcu||51||varchar||||
||WhatProductsWereUsed_pcu||52||varchar||||
||HowMuchColloidUsedInRecovery_pcu||53||varchar||||
||TypeOfColloidUsed_pcu||54||varchar||||
||PainScoreOnWaking_pcu||55||varchar||||
||AnalgesiaUsedPcu||56||varchar||||
||TotalMorphineDoseUsedIncludingBolus_pcu||57||varchar||||
||InotropesUsed_pcu||58||varchar||||
||Dosage_pcu||59||varchar||||
||WereThereAnyArrhythmias_pcu||60||varchar||||
||PleaseStateArrhythmias_pcu||61||varchar||||
||TreatmentOfArrhythmias_pcu||62||varchar||||
||PotassiumUsed_pcu||63||varchar||||
||PotassiumDoseInMmols_pcu||64||varchar||||
||TemperatureOnAdmission_pcu||65||float||||
||BairhuggerWithPatient_pcu||66||varchar||||
||TimeOfDischarge_pcu||67||varchar||||
||PlaceOfDischarge_pcu||68||varchar||||
||DoesPatientMeetDischargeCriteria_pcu||69||varchar||||
||WasPatientDischargedFromPcuToHdu_pcu||70||varchar||||
||LowUrineOutput_pcu||71||varchar||||
||IfNoStateWhy_pcu||72||varchar||||
||IfNoWhy_pcu||73||varchar||||
||AmountOfTimeIntubated_pcu||74||float||||
||AmountOfTimeInRecovery_cicu_pcu||75||float||||
||OverallComments_sa||76||varchar||||
||TeachingOfOtherStaffComments_sa||77||varchar||||
||TeachingOfOtherStaffCommentsMade_sa||78||varchar||||
||TeachingOfOtherStaffBySa_sa||79||varchar||||
||IabpRemovalComments_sa||80||varchar||||
||IabpRemovalCommentsMade_sa||81||varchar||||
||IabpRemovalBySa_sa||82||varchar||||
||IabpInsertionComments_sa||83||varchar||||
||IabpInsertionCommentsMade_sa||84||varchar||||
||IabpInsertionBySa_sa||85||varchar||||
||SternotomyClosureComments_sa||86||varchar||||
||SternotomyClosureCommentsMade_sa||87||varchar||||
||SternotomyClosureBySa_sa||88||varchar||||
||SternotomyComments_sa||89||varchar||||
||SternotomyCommentsMade_sa||90||varchar||||
||SternotomyPerformedBySa_sa||91||varchar||||
||ThirdSiteComments_sa||92||varchar||||
||ThirdSiteCommentsMade_sa||93||varchar||||
||ThirdSiteConduit_location_sa||94||varchar||||
||SecondSiteComments_sa||95||varchar||||
||SecondSiteCommentsMade_sa||96||varchar||||
||SecondSiteConduit_location_sa||97||varchar||||
||FirstSiteComments_sa||98||varchar||||
||FirstSiteCommentsMade_sa||99||varchar||||
||FirstSiteConduei_location_sa||100||varchar||||
||ThirdAssistant_sa||101||varchar||||
||SecondAssistant_sa||102||varchar||||
||FirstAssistant_sa||103||varchar||||
||SurgicalAssistant_sa||104||varchar||||
||ReferralToOperation_days||105||float||||
||Arrhythmia_S||106||varchar||||
||LowCardiacOutput||107||varchar||||
||Ventilation||108||varchar||||
||PulmonaryComplications||109||varchar||||
||RenalComplications||110||varchar||||
||GastrointestinalComplications||111||varchar||||
||InfectiveComplications||112||varchar||||
||CauseOfDeath||113||varchar||||
||AdmittedFrom_hospitalNameOrWard||114||varchar||||
||AdmittedToCardiacSurgery||115||datetime||||
||DischargedFromCardiacSurgery||116||datetime||||
||TotalCardiacSurgeryLosDays||117||float||||
||DateOfFollowUp||118||datetime||||
||BloodUsed||119||varchar||||
||MutisystemFailure||120||varchar||||
||DateFirstAdmittedToCicu||121||datetime||||
||DateFirstDischargedFromCicu||122||datetime||||
||TotalFirstStayOnCicu||123||float||||
||ReAdmittedToCicu||124||varchar||||
||DateOfSecondAdmissionToCicu||125||datetime||||
||DateOfSecondDischargeFromCicu||126||datetime||||
||SecondAdmissionTotalStay_nignts||127||float||||
||DateOfThirdAdmissionToCicu||128||datetime||||
||DateOfThirdDischargeFromCicu||129||datetime||||
||ThirdAdmissionToCicuTotalStay_nights||130||float||||
||InsertionOfPacemakerWiresViaVatsProcedure||131||varchar||||
||IntubationTimeInHours||132||int||||
||AuditTrail||133||varchar||||
||NameOfDoctorCompletingBooklet||134||varchar||||
||SecondPrimaryPerfusionist||135||varchar||||
||SecondBypass||136||varchar||||
||SecondMyocardialProtection||137||varchar||||
||SecondCardioplegiaSolution||138||varchar||||
||SecondCardioplegiaInfusion||139||varchar||||
||SecondCardioplegiaTemperature||140||varchar||||
||SecondCardioplegiaTiming||141||varchar||||
||SecondNon_CardioplegiaMyocardialProtection||142||varchar||||
||DoesPatientNeedAFollowUpAppiontment||143||varchar||||
||Comments||144||varchar||||
||MedicalRecordNumber||145||varchar||||
||DateAddedToW_l||146||datetime||||
||AddedToW_l||147||varchar||||
||DateOfFourthAdmissionToCicu||148||datetime||||
||DateOfFourthDischargeFromCicu||149||datetime||||
||DateOfFifthAdmissionToCicu||150||datetime||||
||DateOfFifthDischargeFromCicu||151||datetime||||
||CumulativeStayFirstAndSecondAdmissionToCicu||152||float||||
||Cumulative1st2ndAnd3rdStayInCicu||153||float||||
||FourthAdmissionToCicuTotalStay_nights||154||float||||
||Cumulative1st2nd3rd4thStayInCicu||155||float||||
||FifthAdmissionToCicuTotalStay_nights||156||float||||
||Cumulative1sr2nd3rd4th5thStayInCicu||157||float||||
||PatientIdentifiedForSamedayAdmission||158||varchar||||
||ProposedDateOfAdmission||159||datetime||||
||IfNotOperatedOnSamedayGiveReason||160||varchar||||
||SecondBypassTotal||161||int||||
||SecondCrossClampTotal||162||int||||
||SecondCiculatoryArrestTotal||163||int||||
||CouncilCase||164||varchar||||
||InitialConsultantInJointCase||165||varchar||||
||ArrhythmiaOtherComplicationFreeText||166||varchar||||
||LowCardiacOutputOtherComplicationFreeText||167||varchar||||
||PulmonaryOtherComplicationFreeText||168||varchar||||
||RenalOtherComplicationFreeText||169||varchar||||
||GastrointestinalOtherComplicationFreeText||170||varchar||||
||InfectiveOtherComplicationFreeText||171||varchar||||
||SickNoteOffered||172||varchar||||
||IfSickNoteOfferedDurationInDays||173||int||||
||AdviceToGpAndAnyMedicationChangedOrStopped||174||varchar||||
||NameOfDischargingDoctor||175||varchar||||
||GradeOfDischargingDoctor||176||varchar||||
||PagerNumber||177||varchar||||
||DrugSensitivity||178||varchar||||
||Drug1||179||varchar||||
||DrugRoute1||180||varchar||||
||NumberOfDays1||181||int||||
||Continue1||182||varchar||||
||Drug2||183||varchar||||
||DrugRoute2||184||varchar||||
||NumberOfDays2||185||int||||
||Continue2||186||varchar||||
||Drug3||187||varchar||||
||DrugRoute3||188||varchar||||
||NumberOfDays3||189||int||||
||Continue3||190||varchar||||
||Drug4||191||varchar||||
||DrugRoute4||192||varchar||||
||NumberOfDays4||193||int||||
||Continue4||194||varchar||||
||Drug5||195||varchar||||
||DrugRoute5||196||varchar||||
||NumberOfDays5||197||int||||
||Continue5||198||varchar||||
||Drug6||199||varchar||||
||DrugRoute6||200||varchar||||
||NumberOfDays6||201||int||||
||Continue6||202||varchar||||
||Drug7||203||varchar||||
||DrugRoute7||204||varchar||||
||NumberOfDays7||205||int||||
||Continue7||206||varchar||||
||Drug8||207||varchar||||
||DrugRoute8||208||varchar||||
||NumberOfDays8||209||int||||
||Continue8||210||varchar||||
||Drug9||211||varchar||||
||DrugRoute9||212||varchar||||
||NumberOfDays9||213||int||||
||Continue9||214||varchar||||
||Drug10||215||varchar||||
||DrugRoute10||216||varchar||||
||NumberOfDays10||217||int||||
||Continue10||218||varchar||||
||Drug11||219||varchar||||
||DrugRoute11||220||varchar||||
||NumberOfDays11||221||int||||
||Continue11||222||varchar||||
||Drug12||223||varchar||||
||DrugRoute12||224||varchar||||
||NumberOfDays12||225||int||||
||Continue12||226||varchar||||
||Drug13||227||varchar||||
||DrugRoute13||228||varchar||||
||NumberOfDays13||229||int||||
||Continue13||230||varchar||||
||Drug14||231||varchar||||
||DrugRoute14||232||varchar||||
||NumberOfDays14||233||int||||
||Continue14||234||varchar||||
||Drug15||235||varchar||||
||DrugRoute15||236||varchar||||
||NumberOfDays15||237||int||||
||Continue15||238||varchar||||
||Drug16||239||varchar||||
||DrugRoute16||240||varchar||||
||NumberOfDays16||241||int||||
||Continue16||242||varchar||||
||Drug17||243||varchar||||
||DrugRoute17||244||varchar||||
||NumberOfDays17||245||int||||
||Continue17||246||varchar||||
||Drug18||247||varchar||||
||DrugRoute18||248||varchar||||
||NumberOfDays18||249||int||||
||Continue18||250||varchar||||
||DrugNameAndStrength19||251||varchar||||
||DrugForm19||252||varchar||||
||DrugDose19||253||varchar||||
||DrugRoute19||254||varchar||||
||DrugFrequency19||255||varchar||||
||NumberOfDays19||256||int||||
||Continue19||257||varchar||||
||DrugNameAndStrength20||258||varchar||||
||DrugForm20||259||varchar||||
||DrugDose20||260||varchar||||
||DrugRoute20||261||varchar||||
||DrugFrequency20||262||varchar||||
||NumberOfDays20||263||int||||
||Continue20||264||varchar||||
||DrugNameAndStrength21||265||varchar||||
||DrugForm21||266||varchar||||
||DrugDose21||267||varchar||||
||DrugRoute21||268||varchar||||
||DrugFrequency21||269||varchar||||
||NumberOfDays21||270||int||||
||Continue21||271||varchar||||
||DrugNameAndStrength22||272||varchar||||
||DrugForm22||273||varchar||||
||DrugDose22||274||varchar||||
||DrugRoute22||275||varchar||||
||DrugFrequency22||276||varchar||||
||NumberOfDays22||277||int||||
||Continue22||278||varchar||||
||DrugNameAndStrength23||279||varchar||||
||DrugForm23||280||varchar||||
||DrugDose23||281||varchar||||
||DrugRoute23||282||varchar||||
||DrugFrequency23||283||varchar||||
||NumberOfDays23||284||int||||
||Continue23||285||varchar||||
||DrugNameAndStrength24||286||varchar||||
||DrugForm24||287||varchar||||
||DrugDose24||288||varchar||||
||DrugRoute24||289||varchar||||
||DrugFrequency24||290||varchar||||
||NumberOfDays24||291||int||||
||Continue24||292||varchar||||
||DischargeWard||293||varchar||||
||Pharmacist||294||varchar||||
||ManagementPlan||295||varchar||||
||FollowUpRequired||296||varchar||||
||FollowUpTimeInWeeks_months||297||varchar||||
||MedicationChangedByPharmacist||298||varchar||||
||StatePharmacistChanges||299||varchar||||
||InformationGivenToPatient||300||varchar||||
||DateTimeRecordCreated||301||datetime||||
||DateTimeRecordLastChanged||302||datetime||||
||EnteredByTag||303||varchar||||
||HospitalTag||304||varchar||||
||WHO_REGISTRY_INDICATOR||305||varchar||||
||WHO_POSSIBLE_DUPLICATE||306||char||||

=== CS2003F_PreProcedure

||Field Name||Column ID||Type||Comments||
||EntryId||1||int||||
||PatientId||2||int||||
||DateOfOperation_ccad||3||datetime||||
||TimeOfOperation_ccad||4||datetime||||
||EntryStatus||5||varchar||||
||PreviousEntry||6||int||||
||NextEntry||7||int||||
||AgeAtSurgery||8||int||||
||Gender||9||varchar||||
||DateOfAdmission||10||datetime||||
||AnginaStatusPre_Surgery||11||varchar||||
||DyspnoeaStatusPre_Surgery||12||varchar||||
||NumberOfPreviousMis||13||varchar||||
||IntervalBetweenOperationAndLastMi||14||varchar||||
||PreviousPci||15||varchar||||
||DateOfLastPci||16||datetime||||
||PreviousCardiac_VascularOrThoracicSurgicalInterven||17||varchar||||
||DateOfLastCardiacOperation||18||datetime||||
||DiabetesManagement||19||varchar||||
||Hypertension||20||varchar||||
||CigaretteSmokingHistory||21||varchar||||
||RenalDiseaseAtTheTimeOfSurgery||22||varchar||||
||HistoryOfPulmonaryDisease||23||varchar||||
||HistoryOfNeurologicalDisease||24||varchar||||
||Pre_OperativeHeartRhythm||25||varchar||||
||DateOfCatheterisation||26||datetime||||
||PaSystolic_ifKnown||27||int||||
||AvGradient_ifKnown||28||int||||
||Lvedp_ifKnown||29||int||||
||MeanPawp_la_ifKnown||30||int||||
||IvNitrates_HeparinOfAnyKind||31||varchar||||
||IvInotropesPriorToAnaesthesia||32||varchar||||
||Ventilated||33||varchar||||
||CardiogenicShock||34||varchar||||
||OperativePriority||35||varchar||||
||FirstOperatorGrade||36||varchar||||
||FirstOperator_CalmanYearOfTrainee||37||varchar||||
||CardiacProcedures||38||varchar||||
||NumberOfDistalCoronaryAnastomoses||39||int||||
||NumberOfValvesReplaced_Repaired||40||int||||
||NumberOfSegmentsOfTheAorta||41||int||||
||OtherCardiacProcedures||42||varchar||||
||OtherThoracicAndVascularProcedures||43||varchar||||
||NeurologicalDysfunction_euroscore||44||varchar||||
||LeftMainStemDisease||45||varchar||||
||ExtentOfCoronaryArteryDisease||46||varchar||||
||ExtracardiacArteriopathy||47||varchar||||
||EjectionFractionCategory||48||varchar||||
||AdmissionCategory||49||varchar||||
||CarotidBruits||50||varchar||||
||LeftOrRightHeartCatheterisation||51||varchar||||
||EjectionFractionValue_ifKnown||52||int||||
||DateAndTimeOfOperation||53||varchar||||
||NumberOfPreviousHeartOperations||54||int||||
||ResponsibleConsultantSurgeon||55||varchar||||
||FirstOperator||56||varchar||||
||FirstAssistant||57||varchar||||
||FirstAssistantGrade||58||varchar||||
||FirstAssistant_CalmanYearOfTrainee||59||varchar||||
||ResponsibleConsultantAnaesthetist||60||varchar||||
||OperationFindings||61||varchar||||
||ReferringCardiologist||62||varchar||||
||DateOfReferral||63||datetime||||
||DrugsOnAdmission||64||varchar||||
||Allergies||65||varchar||||
||AllOtherAssistants||66||varchar||||
||WaitingListStatusUpdated||67||varchar||||
||SprCases||68||varchar||||
||DateOfCurrentStatus||69||datetime||||
||DateOfEndStatus||70||datetime||||
||DateTimeRecordCreated||71||datetime||||
||DateTimeRecordLastChanged||72||datetime||||
||EnteredByTag||73||varchar||||
||EntryCurrentStatus||74||varchar||||
||EntryEndStatus||75||varchar||||
||HospitalTag||76||varchar||||
||WHO_RESPONSIBLE_CONSULTANT_SURGEON||77||varchar||||
||WHO_AGE_AT_OPERATION||78||int||||
||WHO_REGISTRY_INDICATOR||79||varchar||||
||WHO_POSSIBLE_DUPLICATE||80||char||||

=== CS2010F_PostProcedure

||Field Name||Column ID||Type||Comments||
||EntryId||1||int||||
||PatientId||2||int||||
||PreOperativeStayInDays||3||int||||
||PostOperativeStayInDays||4||int||||
||TotalStayInDays||5||int||||
||ParsonnetScoreFromHardData||6||int||||
||CardiopulmonaryBypass||7||varchar||||
||ParsonnetScoreWithCatastrophicStatesAndRareConditi||8||int||||
||PredominantMethodOfMyocardialProtection||9||varchar||||
||Parsonnet_AdditionsForCatastrophicStates||10||int||||
||Parsonnet_AdditionsForRareConditions||11||int||||
||AdditiveEuroscore||12||int||||
||SctsComplexCabgBayesScore||13||float||||
||LogisticEuroscore||14||float||||
||Cardioplegia_Solution||15||varchar||||
||Cardioplegia_Temperature||16||varchar||||
||Cardioplegia_Timing||17||varchar||||
||Non_CardioplegicMyocardialProtection||18||varchar||||
||IntraAorticBalloonPumpUsed||19||varchar||||
||ReasonForIntra_OperativeIntra_AorticBalloonPumpUse||20||varchar||||
||HeightInCm||21||int||||
||WeightInKg||22||float||||
||CumulativeBypassTime||23||int||||
||CumulativeCrossClampTime||24||int||||
||TotalCirculatoryArrestTime||25||int||||
||NewPost_OperativeNeurologicalDysfunction||26||varchar||||
||NewHaemofiltrationOrDialysis||27||varchar||||
||DischargeDestinationFromCardiothoracicWard||28||varchar||||
||DateOfDischargeOrDeath||29||date||||
||BodySurfaceArea||30||float||||
||BodyMassIndex||31||float||||
||Cardioplegia_InfusionMode||32||varchar||||
||EuroscoreMinumumDatasetCheck||33||varchar||||
||ParsonnetMinumumDatasetCheck||34||varchar||||
||NameOfGpAtTimeOfSurgery||35||varchar||||
||GpPracticeCodeAtTimeOfSurgery||36||varchar||||
||PctAtTimeOfSurgery||37||varchar||||
||NameOfReferringGpAtTimeOfSurgeryType8||38||varchar||||
||ToePerformed||39||varchar||||
||Sonographer||40||varchar||||
||Sonographist||41||varchar||||
||PrimaryPerfusionist||42||varchar||||
||PcuPatient_pcu||43||varchar||||
||DoesPatientMeetInterOperativeCriteria_pcu||44||varchar||||
||AreaPatientAdmittedTo_pcu||45||varchar||||
||AdmissionTimeToRecovery_cicu_pcu||46||varchar||||
||ExtubationDateAndTime_pcu||47||varchar||||
||WhatO2SystemWasUsed_pcu||48||varchar||||
||TotalBloodLostOnDischargeFromRecovery_pcu||49||varchar||||
||WereClottingProductsUsed_pcu||50||varchar||||
||WhatProductsWereUsed_pcu||51||varchar||||
||HowMuchColloidUsedInRecovery_pcu||52||varchar||||
||TypeOfColloidUsed_pcu||53||varchar||||
||PainScoreOnWaking_pcu||54||varchar||||
||AnalgesiaUsedPcu||55||varchar||||
||TotalMorphineDoseUsedIncludingBolus_pcu||56||varchar||||
||InotropesUsed_pcu||57||varchar||||
||Dosage_pcu||58||varchar||||
||WereThereAnyArrhythmias_pcu||59||varchar||||
||PleaseStateArrhythmias_pcu||60||varchar||||
||TreatmentOfArrhythmias_pcu||61||varchar||||
||PotassiumUsed_pcu||62||varchar||||
||PotassiumDoseInMmols_pcu||63||varchar||||
||TemperatureOnAdmission_pcu||64||float||||
||BairhuggerWithPatient_pcu||65||varchar||||
||TimeOfDischarge_pcu||66||varchar||||
||PlaceOfDischarge_pcu||67||varchar||||
||DoesPatientMeetDischargeCriteria_pcu||68||varchar||||
||WasPatientDischargedFromPcuToHdu_pcu||69||varchar||||
||LowUrineOutput_pcu||70||varchar||||
||IfNoStateWhy_pcu||71||varchar||||
||IfNoWhy_pcu||72||varchar||||
||AmountOfTimeIntubated_pcu||73||float||||
||AmountOfTimeInRecovery_cicu_pcu||74||float||||
||OverallComments_sa||75||text||||
||TeachingOfOtherStaffComments_sa||76||varchar||||
||TeachingOfOtherStaffCommentsMade_sa||77||varchar||||
||TeachingOfOtherStaffBySa_sa||78||varchar||||
||IabpRemovalComments_sa||79||text||||
||IabpRemovalCommentsMade_sa||80||varchar||||
||IabpRemovalBySa_sa||81||varchar||||
||IabpInsertionComments_sa||82||text||||
||IabpInsertionCommentsMade_sa||83||varchar||||
||IabpInsertionBySa_sa||84||varchar||||
||SternotomyClosureComments_sa||85||text||||
||SternotomyClosureCommentsMade_sa||86||varchar||||
||SternotomyClosureBySa_sa||87||varchar||||
||SternotomyComments_sa||88||varchar||||
||SternotomyCommentsMade_sa||89||varchar||||
||SternotomyPerformedBySa_sa||90||varchar||||
||ThirdSiteComments_sa||91||varchar||||
||ThirdSiteCommentsMade_sa||92||varchar||||
||ThirdSiteConduit_location_sa||93||varchar||||
||SecondSiteComments_sa||94||varchar||||
||SecondSiteCommentsMade_sa||95||varchar||||
||SecondSiteConduit_location_sa||96||varchar||||
||FirstSiteComments_sa||97||varchar||||
||FirstSiteCommentsMade_sa||98||varchar||||
||FirstSiteConduei_location_sa||99||varchar||||
||ThirdAssistant_sa||100||varchar||||
||SecondAssistant_sa||101||varchar||||
||FirstAssistant_sa||102||varchar||||
||SurgicalAssistant_sa||103||varchar||||
||ReferralToOperation_days||104||float||||
||Arrhythmia_S||105||varchar||||
||LowCardiacOutput||106||varchar||||
||Ventilation||107||varchar||||
||PulmonaryComplications||108||varchar||||
||RenalComplications||109||varchar||||
||GastrointestinalComplications||110||varchar||||
||InfectiveComplications||111||varchar||||
||CauseOfDeath||112||varchar||||
||AdmittedFrom_hospitalNameOrWard||113||varchar||||
||AdmittedToCardiacSurgery||114||date||||
||DischargedFromCardiacSurgery||115||date||||
||TotalCardiacSurgeryLosDays||116||float||||
||DateOfFollowUp||117||date||||
||BloodUsed||118||varchar||||
||MutisystemFailure||119||varchar||||
||DateFirstAdmittedToCicu||120||date||||
||DateFirstDischargedFromCicu||121||date||||
||TotalFirstStayOnCicu||122||float||||
||ReAdmittedToCicu||123||varchar||||
||DateOfSecondAdmissionToCicu||124||date||||
||DateOfSecondDischargeFromCicu||125||date||||
||SecondAdmissionTotalStay_nignts||126||float||||
||DateOfThirdAdmissionToCicu||127||date||||
||DateOfThirdDischargeFromCicu||128||date||||
||ThirdAdmissionToCicuTotalStay_nights||129||float||||
||InsertionOfPacemakerWiresViaVatsProcedure||130||varchar||||
||IntubationTimeInHours||131||int||||
||AuditTrail||132||text||||
||NameOfDoctorCompletingBooklet||133||varchar||||
||SecondPrimaryPerfusionist||134||varchar||||
||SecondBypass||135||varchar||||
||SecondMyocardialProtection||136||varchar||||
||SecondCardioplegiaSolution||137||varchar||||
||SecondCardioplegiaInfusion||138||varchar||||
||SecondCardioplegiaTemperature||139||varchar||||
||SecondCardioplegiaTiming||140||varchar||||
||SecondNon_CardioplegiaMyocardialProtection||141||varchar||||
||DoesPatientNeedAFollowUpAppiontment||142||varchar||||
||Comments||143||varchar||||
||MedicalRecordNumber||144||varchar||||
||DateAddedToW_l||145||date||||
||AddedToW_l||146||varchar||||
||DateOfFourthAdmissionToCicu||147||date||||
||DateOfFourthDischargeFromCicu||148||date||||
||DateOfFifthAdmissionToCicu||149||date||||
||DateOfFifthDischargeFromCicu||150||date||||
||CumulativeStayFirstAndSecondAdmissionToCicu||151||float||||
||Cumulative1st2ndAnd3rdStayInCicu||152||float||||
||FourthAdmissionToCicuTotalStay_nights||153||float||||
||Cumulative1st2nd3rd4thStayInCicu||154||float||||
||FifthAdmissionToCicuTotalStay_nights||155||float||||
||Cumulative1sr2nd3rd4th5thStayInCicu||156||float||||
||PatientIdentifiedForSamedayAdmission||157||varchar||||
||ProposedDateOfAdmission||158||date||||
||SecondBypassTotal||159||int||||
||SecondCrossClampTotal||160||int||||
||SecondCiculatoryArrestTotal||161||int||||
||CouncilCase||162||varchar||||
||InitialConsultantInJointCase||163||varchar||||
||ArrhythmiaOtherComplicationFreeText||164||text||||
||LowCardiacOutputOtherComplicationFreeText||165||text||||
||PulmonaryOtherComplicationFreeText||166||text||||
||RenalOtherComplicationFreeText||167||text||||
||GastrointestinalOtherComplicationFreeText||168||text||||
||InfectiveOtherComplicationFreeText||169||varchar||||
||SickNoteOffered||170||varchar||||
||IfSickNoteOfferedDurationInDays||171||int||||
||AdviceToGp||172||varchar||||
||NameOfDischargingDoctor||173||varchar||||
||GradeOfDischargingDoctor||174||varchar||||
||PagerNumber||175||varchar||||
||DrugSensitivity||176||varchar||||
||Drug1||177||varchar||||
||DrugRoute1||178||varchar||||
||NumberOfDays1||179||int||||
||Continue1||180||varchar||||
||Drug2||181||varchar||||
||DrugRoute2||182||varchar||||
||NumberOfDays2||183||int||||
||Continue2||184||varchar||||
||Drug3||185||varchar||||
||DrugRoute3||186||varchar||||
||NumberOfDays3||187||int||||
||Continue3||188||varchar||||
||Drug4||189||varchar||||
||DrugRoute4||190||varchar||||
||NumberOfDays4||191||int||||
||Continue4||192||varchar||||
||Drug5||193||varchar||||
||DrugRoute5||194||varchar||||
||NumberOfDays5||195||int||||
||Continue5||196||varchar||||
||Drug6||197||varchar||||
||DrugRoute6||198||varchar||||
||NumberOfDays6||199||int||||
||Continue6||200||varchar||||
||Drug7||201||varchar||||
||DrugRoute7||202||varchar||||
||NumberOfDays7||203||int||||
||Continue7||204||varchar||||
||Drug8||205||varchar||||
||DrugRoute8||206||varchar||||
||NumberOfDays8||207||int||||
||Continue8||208||varchar||||
||Drug9||209||varchar||||
||DrugRoute9||210||varchar||||
||NumberOfDays9||211||int||||
||Continue9||212||varchar||||
||Drug10||213||varchar||||
||DrugRoute10||214||varchar||||
||NumberOfDays10||215||int||||
||Continue10||216||varchar||||
||Drug11||217||varchar||||
||DrugRoute11||218||varchar||||
||NumberOfDays11||219||int||||
||Continue11||220||varchar||||
||Drug12||221||varchar||||
||DrugRoute12||222||varchar||||
||NumberOfDays12||223||int||||
||Continue12||224||varchar||||
||Drug13||225||varchar||||
||DrugRoute13||226||varchar||||
||NumberOfDays13||227||int||||
||Continue13||228||varchar||||
||Drug14||229||varchar||||
||DrugRoute14||230||varchar||||
||NumberOfDays14||231||int||||
||Continue14||232||varchar||||
||Drug15||233||varchar||||
||DrugRoute15||234||varchar||||
||NumberOfDays15||235||int||||
||Continue15||236||varchar||||
||Drug16||237||varchar||||
||DrugRoute16||238||varchar||||
||NumberOfDays16||239||int||||
||Continue16||240||varchar||||
||Drug17||241||varchar||||
||DrugRoute17||242||varchar||||
||NumberOfDays17||243||int||||
||Continue17||244||varchar||||
||Drug18||245||varchar||||
||DrugRoute18||246||varchar||||
||NumberOfDays18||247||int||||
||Continue18||248||varchar||||
||DrugNameAndStrength19||249||varchar||||
||DrugForm19||250||varchar||||
||DrugDose19||251||varchar||||
||DrugRoute19||252||varchar||||
||DrugFrequency19||253||varchar||||
||NumberOfDays19||254||int||||
||Continue19||255||varchar||||
||DrugNameAndStrength20||256||varchar||||
||DrugForm20||257||varchar||||
||DrugDose20||258||varchar||||
||DrugRoute20||259||varchar||||
||DrugFrequency20||260||varchar||||
||NumberOfDays20||261||int||||
||Continue20||262||varchar||||
||DrugNameAndStrength21||263||varchar||||
||DrugForm21||264||varchar||||
||DrugDose21||265||varchar||||
||DrugRoute21||266||varchar||||
||DrugFrequency21||267||varchar||||
||NumberOfDays21||268||int||||
||Continue21||269||varchar||||
||DrugNameAndStrength22||270||varchar||||
||DrugForm22||271||varchar||||
||DrugDose22||272||varchar||||
||DrugRoute22||273||varchar||||
||DrugFrequency22||274||varchar||||
||NumberOfDays22||275||int||||
||Continue22||276||varchar||||
||DrugNameAndStrength23||277||varchar||||
||DrugForm23||278||varchar||||
||DrugDose23||279||varchar||||
||DrugRoute23||280||varchar||||
||DrugFrequency23||281||varchar||||
||NumberOfDays23||282||int||||
||Continue23||283||varchar||||
||DrugNameAndStrength24||284||varchar||||
||DrugForm24||285||varchar||||
||DrugDose24||286||varchar||||
||DrugRoute24||287||varchar||||
||DrugFrequency24||288||varchar||||
||NumberOfDays24||289||int||||
||Continue24||290||varchar||||
||DischargeWard||291||varchar||||
||Pharmacist||292||varchar||||
||ManagementPlan||293||varchar||||
||FollowUpRequired||294||varchar||||
||FollowUpTimeInWeeks_months||295||varchar||||
||MedicationChangedByPharmacist||296||varchar||||
||StatePharmacistChanges||297||text||||
||InformationGivenToPatient||298||varchar||||
||DateTimeRecordCreated||299||varchar||||
||DateTimeRecordLastChanged||300||varchar||||
||EnteredByTag||301||varchar||||
||HospitalTag||302||varchar||||

=== CS2010F_PreProcedure

||Field Name||Column ID||Type||Comments||
||EntryId||1||int||||
||PatientId||2||int||||
||DateOfOperation||3||date||||
||TimeOfEntry||4||time||||
||EntryStatus||5||varchar||||
||PreviousEntry||6||int||||
||NextEntry||7||int||||
||AgeAtOperation||8||int||||
||Gender||9||varchar||||
||DateOfAdmission||10||date||||
||AnginaStatusPre_Surgery||11||varchar||||
||DyspnoeaStatusPre_Surgery||12||varchar||||
||NumberOfPreviousMis||13||varchar||||
||IntervalBetweenSurgeryAndLastMi||14||varchar||||
||PreviousPci||15||varchar||||
||PreviousCardiacSurgery||16||varchar||||
||DateOfLastCardiacOperation||17||date||||
||DiabetesManagement||18||varchar||||
||HistoryOfHypertension||19||varchar||||
||CigaretteSmokingHistory||20||varchar||||
||HistoryOfPulmonaryDisease||21||varchar||||
||HistoryOfNeurologicalDisease||22||varchar||||
||Pre_OperativeHeartRhythm||23||varchar||||
||DateOfLastCatheterisation||24||date||||
||PaSystolic||25||int||||
||IntravenousNitratesOrAnyHeparin||26||varchar||||
||IntravenousInotropesPriorToAnaesthesia||27||varchar||||
||VentilatedPreOperation||28||varchar||||
||CardiogenicShock_pre_Operation||29||varchar||||
||OperativeUrgency||30||varchar||||
||FirstOperatorGrade||31||varchar||||
||FirstOperator_CalmanYearOfTrainee||32||varchar||||
||CardiacProcedures||33||varchar||||
||OtherCardiacProcedures||34||varchar||||
||OtherThoracicAndVascularProcedures||35||varchar||||
||LeftMainStemDisease||36||varchar||||
||ExtentOfCoronaryVesselDisease||37||varchar||||
||ExtracardiacArteriopathy||38||varchar||||
||EjectionFractionCategory||39||varchar||||
||AdministrativeCategory||40||varchar||||
||DateAndTimeOfOperation||41||varchar||||
||NumberOfPreviousHeartOperations||42||int||||
||ResponsibleConsultantSurgeon||43||varchar||||
||FirstOperator||44||varchar||||
||FirstAssistant||45||varchar||||
||FirstAssistantGrade||46||varchar||||
||FirstAssistant_CalmanYearOfTrainee||47||varchar||||
||ResponsibleConsultantAnaesthetist||48||varchar||||
||OperationFindings||49||varchar||||
||ReferringCardiologist||50||varchar||||
||DateOfReferral||51||date||||
||DrugsOnAdmission||52||varchar||||
||Allergies||53||varchar||||
||AllOtherAssistants||54||varchar||||
||WaitingListStatusUpdated||55||varchar||||
||SprCases||56||varchar||||
||DateOfCurrentStatus||57||date||||
||DateOfEndStatus||58||date||||
||DateTimeRecordCreated||59||varchar||||
||DateTimeRecordLastChanged||60||varchar||||
||EnteredByTag||61||varchar||||
||EntryCurrentStatus||62||varchar||||
||EntryEndStatus||63||varchar||||
||HospitalTag||64||varchar||||

=== EPS_EPSINIVW
=== GGHMINAP_GGHMINAP
=== GGHMINAPNEW
=== GGHMINAPNEW_GGHMINAPINIVW
=== GGHPACEICD_GGHPACEICDINIALVW
=== GGHPCI_FLWGGHPCIVIEW
=== GGHPCI_INITIALGGHPCIVIEW
=== LRIMINAPNEW
=== LRIMINAPNEW_LRIMINAPNEWINITIALVW
=== VERTED_VERTEDINIALVW