Changes between Version 3 and Version 4 of i2b2 - UHL clinical informatics system integration PATS CS PreProcedure Combined


Ignore:
Timestamp:
04/05/13 11:56:46 (13 years ago)
Author:
Richard Bramley
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • i2b2 - UHL clinical informatics system integration PATS CS PreProcedure Combined

    v3 v4  
    77||CS2003F_PreProcedure||2004-2013||DateOfOperation_ccad||9383||
    88||CS2010F_PreProcedure||2011-2013||!DateOfOperation||2007||
     9
     10== Columns
     11
     12||= Column =||= CS_PreProcedure =||= CS2003F_PreProcedure =||= CS2010F_PreProcedure =||
     13||!ActiveEndocarditis||Y|| || ||
     14||!AdministrativeCategory|| || ||Y||
     15||!AdmissionCategory|| ||Y|| ||
     16||Age_parsonnet||Y|| || ||
     17||!AgeAtOperation|| || ||Y||
     18||!AgeAtSurgery||Y||Y|| ||
     19||Allergies||Y||Y||Y||
     20||!AllOtherAssistants|| ||Y||Y||
     21||!AnginaStatus||Y|| || ||
     22||AnginaStatusPre_Surgery|| ||Y||Y||
     23||!AssistantSurgeon||Y|| || ||
     24||AvGradient_ifKnown|| ||Y|| ||
     25||AvGradient_mmhg||Y|| || ||
     26||!CalmanYearTrainee||Y|| || ||
     27||!CardiacProcedures||Y||Y||Y||
     28||!CardiogenicShock||Y||Y|| ||
     29||CardiogenicShock_pre_Operation|| || ||Y||
     30||!CarotidBruits|| ||Y|| ||
     31||!CatheterisedSameAdmissionAsSurgery||Y|| || ||
     32||!CerebrovascularDisease||Y|| || ||
     33||!ChronicPulmonaryDisease||Y|| || ||
     34||!CigaretteSmokingHistory|| ||Y||Y||
     35||!CongenitalDisease||Y|| || ||
     36||!CongestiveCardiacFailure||Y|| || ||
     37||Consultant||Y|| || ||
     38||CriticalPre_OpState||Y|| || ||
     39||!DateAndTimeOfOperation|| ||Y||Y||
     40||!DateOfAdmission||Y||Y||Y||
     41||!DateOfCatheterisation|| ||Y|| ||
     42||DateOfCatheterisation_echo||Y|| || ||
     43||!DateOfCurrentStatus|| ||Y||Y||
     44||!DateOfEndStatus|| ||Y||Y||
     45||!DateOfLastCardiacOperation||Y||Y||Y||
     46||!DateOfLastCatheterisation|| || ||Y||
     47||!DateOfLastIntervention||Y|| || ||
     48||!DateOfLastPci|| ||Y|| ||
     49||!DateOfOperation||Y|| ||Y||
     50||DateOfOperation_ccad|| ||Y|| ||
     51||!DateOfReferral||Y||Y||Y||
     52||!DateTimeRecordCreated|| ||Y||Y||
     53||!DateTimeRecordLastChanged|| ||Y||Y||
     54||Diabetes||Y|| || ||
     55||!DiabetesManagement|| ||Y||Y||
     56||!DrugOnAdmission||Y|| || ||
     57||!DrugsOnAdmission|| ||Y||Y||
     58||!DyspnoeaStatus||Y|| || ||
     59||DyspnoeaStatusPre_Surgery|| ||Y||Y||
     60||EjectionFraction__||Y|| || ||
     61||!EjectionFractionCategory|| ||Y||Y||
     62||!EjectionFractionMethod||Y|| || ||
     63||EjectionFractionValue_ifKnown|| ||Y|| ||
     64||!EnteredByTag|| ||Y||Y||
     65||!EntryCurrentStatus||Y||Y||Y||
     66||!EntryEndStatus||Y||Y||Y||
     67||!EntryId||Y||Y||Y||
     68||!EntryStatus||Y||Y||Y||
     69||!ExtentOfCoronaryArteryDisease|| ||Y|| ||
     70||!ExtentOfCoronaryDisease||Y|| || ||
     71||!ExtentOfCoronaryVesselDisease|| || ||Y||
     72||Extra_CardiacArteriopathy||Y|| || ||
     73||!ExtracardiacArteriopathy|| ||Y||Y||
     74||!FamilyHxOfIhd||Y|| || ||
     75||!FirstAnaesthetist||Y|| || ||
     76||!FirstAssistant|| ||Y||Y||
     77||FirstAssistant_CalmanYearOfTrainee|| ||Y||Y||
     78||!FirstAssistantGrade|| ||Y||Y||
     79||!FirstOperator|| ||Y||Y||
     80||FirstOperator_CalmanYearOfTrainee|| ||Y||Y||
     81||!FirstOperatorGrade|| ||Y||Y||
     82||Gender|| ||Y||Y||
     83||Gender_parsonnet||Y|| || ||
     84||!GiTract||Y|| || ||
     85||!GraftHarvest||Y|| || ||
     86||!HistoryOfHypertension|| || ||Y||
     87||!HistoryOfNeurologicalDisease|| ||Y||Y||
     88||!HistoryOfPulmonaryDisease|| ||Y||Y||
     89||!HospitalTag|| ||Y||Y||
     90||Hypercholesterolaemia||Y|| || ||
     91||Hypertension||Y||Y|| ||
     92||Iabp||Y|| || ||
     93||!IntervalBetweenOperationAndLastMi|| ||Y|| ||
     94||!IntervalBetweenSurgeryAndLastMi|| || ||Y||
     95||!IntravenousInotropesPriorToAnaesthesia|| || ||Y||
     96||!IntravenousNitratesOrAnyHeparin|| || ||Y||
     97||!IvInotropes||Y|| || ||
     98||!IvInotropesPriorToAnaesthesia|| ||Y|| ||
     99||!IvNitrates||Y|| || ||
     100||IvNitrates_HeparinOfAnyKind|| ||Y|| ||
     101||Last_Q_WaveMi||Y|| || ||
     102||!LeftMainStemDisease||Y||Y||Y||
     103||!LeftOrRightHeartCatheterisation|| ||Y|| ||
     104||Lvedp_ifKnown|| ||Y|| ||
     105||Lvedp_mmhg||Y|| || ||
     106||MeanPawp_la_ifKnown|| ||Y|| ||
     107||!NeurologicalDysfunction||Y|| || ||
     108||NeurologicalDysfunction_euroscore|| ||Y|| ||
     109||!NextEntry||Y||Y||Y||
     110||No_OfDistalCoronaryAnastomoses||Y|| || ||
     111||No_OfValveProcedures||Y|| || ||
     112||No_OfVascularProcedures||Y|| || ||
     113||!NumberOfDistalCoronaryAnastomoses|| ||Y|| ||
     114||NumberOfGrafts_ValvesAndVascularProceduresCombined||Y|| || ||
     115||!NumberOfPreviousHeartOperations|| ||Y||Y||
     116||!NumberOfPreviousMis|| ||Y||Y||
     117||!NumberOfSegmentsOfTheAorta|| ||Y|| ||
     118||NumberOfValvesReplaced_Repaired|| ||Y|| ||
     119||OffPump_midcab||Y|| || ||
     120||!OperationFindings||Y||Y||Y||
     121||!OperationPerformedBy||Y|| || ||
     122||!OperationSequence||Y|| || ||
     123||!OperativePriority||Y||Y|| ||
     124||!OperativeUrgency|| || ||Y||
     125||!OtherCardiacProcedures||Y||Y||Y||
     126||!OtherProcedures||Y|| || ||
     127||!OtherThoracicAndVascularProcedures|| ||Y||Y||
     128||Pacemaker||Y|| || ||
     129||!PaSystolic|| || ||Y||
     130||PaSystolic_ifKnown|| ||Y|| ||
     131||PaSystolic_mmhg||Y|| || ||
     132||!PatientId||Y||Y||Y||
     133||PatientSeenOnWard_clinicBySeniorAnaesthetist||Y|| || ||
     134||Pawp_la_mmhg||Y|| || ||
     135||!PeripheralVascularDisease||Y|| || ||
     136||Pre_OpArrythmias||Y|| || ||
     137||Pre_OperativeHeartRhythm|| ||Y||Y||
     138||Previous_Q_WaveMi_S||Y|| || ||
     139||PreviousCardiac_VascularOrThoracicSurgicalInterven|| ||Y|| ||
     140||!PreviousCardiacSurgery|| || ||Y||
     141||!PreviousCardiologicalIntervention||Y|| || ||
     142||!PreviousEntry||Y||Y||Y||
     143||!PreviousPci|| ||Y||Y||
     144||PreviousPtca_stent||Y|| || ||
     145||!PreviousSurgicalIntervention||Y|| || ||
     146||!PreviousSurgicalProcedure||Y|| || ||
     147||!RecentlyFailedIntervention||Y|| || ||
     148||!ReferringCardiologist||Y||Y||Y||
     149||!ReferringPhysician||Y|| || ||
     150||Renal||Y|| || ||
     151||!RenalDiseaseAtTheTimeOfSurgery|| ||Y|| ||
     152||!ResponsibleConsultantAnaesthetist|| ||Y||Y||
     153||!ResponsibleConsultantSurgeon|| ||Y||Y||
     154||Smoking||Y|| || ||
     155||!SprCases|| ||Y||Y||
     156||Surgeon||Y|| || ||
     157||!SymptomStatus||Y|| || ||
     158||ThrombolysisWithin24Hours||Y|| || ||
     159||!TimeOfEntry||Y|| ||Y||
     160||TimeOfOperation_ccad|| ||Y|| ||
     161||!TypeOfTrainee||Y|| || ||
     162||Ventilated||Y||Y|| ||
     163||!VentilatedPreOperation|| || ||Y||
     164||!WaitingListParsonnetScore||Y|| || ||
     165||!WaitingListStatusUpdated|| ||Y||Y||
     166||!WasThePatientCatheterised||Y|| || ||
     167||WHO_AGE_AT_OPERATION|| ||Y|| ||
     168||WHO_POSSIBLE_DUPLICATE|| ||Y|| ||
     169||WHO_REGISTRY_INDICATOR|| ||Y|| ||
     170||WHO_RESPONSIBLE_CONSULTANT_SURGEON|| ||Y||n