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