Changes between Initial Version and Version 1 of i2b2 - UHL clinical informatics system integration PATS CS2010F_PostProcedure


Ignore:
Timestamp:
03/15/13 08:52:48 (12 years ago)
Author:
Richard Bramley
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • i2b2 - UHL clinical informatics system integration PATS CS2010F_PostProcedure

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