[[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||
||!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||||