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


Ignore:
Timestamp:
03/15/13 08:49:32 (13 years ago)
Author:
Richard Bramley
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

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