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


Ignore:
Timestamp:
04/08/13 07:56:07 (13 years ago)
Author:
Richard Bramley
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • i2b2 - UHL clinical informatics system integration PATS PCI Combined

    v1 v1  
     1[[i2b2 - UHL clinical informatics system integration PATS Mappings v1|back]]
     2
     3== Tables
     4
     5||= Table =||= Date Range =||= Start Date Field =||= Records =||
     6||GGHPCI_GGHPCI||2004-2010||DateofprocedureCCAD||9939||
     7||GGHPCI_INITIALGGHPCIVIEW||2004-2013||DateofprocedureCCAD||14513||
     8
     9== Columns
     10
     11||Column Name||GGHPCI_GGHPCI||GGHPCI_INITIALGGHPCIVIEW||
     12||!AdministrativeCategory|| || ||
     13||!AdministrativeCategoryCcad||Y|| ||
     14||!AdmissionCategory|| || ||
     15||AdmissionRoute_acs_Ccad||Y|| ||
     16||!AgeAtOperation|| || ||
     17||!AgeAtSurgery|| || ||
     18||Allergies|| || ||
     19||!AllOtherAssistants|| || ||
     20||AnginaStatusPre_Surgery|| || ||
     21||ArrivalInPciHospital_acs_Ccad||Y|| ||
     22||!ArterialAccessCcad||Y|| ||
     23||!ArterialComplicationsCcad||Y|| ||
     24||!ArterialManagementCcad||Y|| ||
     25||Athero_ThrombusRemovalDevice_s_UsedCcad||Y|| ||
     26||!AuditTrail||Y|| ||
     27||AvGradient_ifKnown|| || ||
     28||BifurcationQuestion1||Y|| ||
     29||BifurcationQuestion2||Y|| ||
     30||!BmsSize||Y|| ||
     31||BrachytherapyDevice_s_UsedCcad||Y|| ||
     32||CardiacEnzymes_markersRaisedCcad||Y|| ||
     33||!CardiacProcedures|| || ||
     34||!CardiogenicShock|| || ||
     35||CardiogenicShock_pre_Operation|| || ||
     36||CardiogenicShockPre_Anaesthesia_pre_Pci_Ccad||Y|| ||
     37||!CarotidBruits|| || ||
     38||Ccco||Y|| ||
     39||!CcsClassificationForStableAnginaCcad||Y|| ||
     40||!CholesterolCcad||Y|| ||
     41||!ChronicTotalOcclusion||Y|| ||
     42||!CigaretteSmokingHistory|| || ||
     43||!CirculatorySupportCcad||Y|| ||
     44||!ClinicalSyndromeCcad||Y|| ||
     45||!ConsultantResponsibleForProcedureCcad||Y|| ||
     46||CxStenosis_postPci_Ccad||Y|| ||
     47||CxStenosis_pre_Pci_Ccad||Y|| ||
     48||Date_timeOfFirstBalloonInflation_pci_Ccad||Y|| ||
     49||DateAndTimeArrivalAtHospital_acsOnly_ccad||Y|| ||
     50||!DateAndTimeOfOperation||Y|| ||
     51||DateAndTimeOfSymptomOnset_acs_Ccad||Y|| ||
     52||!DateOfAdmission||Y|| ||
     53||!DateOfCatheterisation|| || ||
     54||!DateOfCurrentStatus||Y|| ||
     55||!DateOfDeathPostProcedure||Y|| ||
     56||!DateOfEndStatus||Y|| ||
     57||!DateOfLastCardiacOperation|| || ||
     58||!DateOfLastCatheterisation|| || ||
     59||!DateOfLastPci|| || ||
     60||!DateOfOperation|| || ||
     61||DateOfOperation_ccad|| || ||
     62||DateofProcedureCCAD||Y|| ||
     63||!DateOfReferral|| || ||
     64||!DateTimeRecordCreated||Y|| ||
     65||!DateTimeRecordLastChanged||Y|| ||
     66||!DesSize||Y|| ||
     67||!DeviceFailureCcad||Y|| ||
     68||!DiabetesCcad||Y|| ||
     69||!DiabetesManagement|| || ||
     70||DiagnosticDevice_s_UsedDuringProcedureCcad||Y|| ||
     71||!DischargeDateCcad||Y|| ||
     72||Drug_s_ElutedByStent_s_Ccad||Y|| ||
     73||!DrugsOnAdmission|| || ||
     74||!DrugTherapyPreopCcad||Y|| ||
     75||DyspnoeaStatusPre_Surgery|| || ||
     76||!EcgIschaemiaCcad||Y|| ||
     77||!EjectionFractionCategory|| || ||
     78||EjectionFractionValue_ifKnown|| || ||
     79||EmboliProtectionDevice_s_UsedCcad||Y|| ||
     80||!EnteredByTag||Y|| ||
     81||!EntryCurrentStatus||Y|| ||
     82||!EntryEndStatus||Y|| ||
     83||!EntryId||Y|| ||
     84||!EntryStatus||Y|| ||
     85||!EnzymesPostopCcad||Y|| ||
     86||!ExtentOfCoronaryArteryDisease|| || ||
     87||!ExtentOfCoronaryVesselDisease|| || ||
     88||!ExtracardiacArteriopathy|| || ||
     89||!FamilyHistoryOfCadCcad||Y|| ||
     90||!FirstAssistant|| || ||
     91||FirstAssistant_CalmanYearOfTrainee|| || ||
     92||!FirstAssistantGrade|| || ||
     93||!FirstOperator|| || ||
     94||FirstOperator_CalmanYearOfTrainee|| || ||
     95||!FirstOperatorCcad||Y|| ||
     96||!FirstOperatorGrade|| || ||
     97||FlowInIraPostop_acs_Ccad||Y|| ||
     98||FlowInIraPreop_acs_Ccad||Y|| ||
     99||FollowOn_adhoc_ProcedureCcad||Y|| ||
     100||Gender|| || ||
     101||Gp||Y|| ||
     102||GpIib_iiiaDrug_s_UsedDuringProcedureCcad||Y|| ||
     103||!GraftType||Y|| ||
     104||Height_cm_Ccad||Y|| ||
     105||!HistoryOfHypertension|| || ||
     106||!HistoryOfNeurologicalDisease|| || ||
     107||!HistoryOfPulmonaryDisease|| || ||
     108||!HistoryOfRenalDiseaseCcad||Y|| ||
     109||!HospitalIdentifierCcad||Y|| ||
     110||!HospitalTag||Y|| ||
     111||Hypertension|| || ||
     112||!IndicationForInterventionCcad||Y|| ||
     113||!IndicationForStentCcad||Y|| ||
     114||!InstentRestenosisDecribe||Y|| ||
     115||!InstentRestenosisType||Y|| ||
     116||!IntervalBetweenOperationAndLastMi|| || ||
     117||!IntervalBetweenProcedureAndDeath||Y|| ||
     118||!IntervalBetweenSurgeryAndLastMi|| || ||
     119||!IntravenousInotropesPriorToAnaesthesia|| || ||
     120||!IntravenousNitratesOrAnyHeparin|| || ||
     121||!IvInotropesPriorToAnaesthesia|| || ||
     122||IvNitrates_HeparinOfAnyKind|| || ||
     123||LadOtherStenosis_postPci_Ccad||Y|| ||
     124||LadOtherStenosis_pre_Pci_Ccad||Y|| ||
     125||LadProximalStenosis_postPci_Ccad||Y|| ||
     126||LadProximalStenosis_pre_Pci_Ccad||Y|| ||
     127||LargestBalloon_stentUsedCcad||Y|| ||
     128||!LeftMainStemDisease|| || ||
     129||!LeftMainStemProtectedCcad||Y|| ||
     130||LeftMainStemStenosis_postPci_Ccad||Y|| ||
     131||LeftMainStemStenosis_pre_Pci_Ccad||Y|| ||
     132||!LeftOrRightHeartCatheterisation|| || ||
     133||LmsQuestion1||Y|| ||
     134||LmsQuestion2||Y|| ||
     135||LmsQuestion3||Y|| ||
     136||!LocalProcedureIdentifierCcad||Y|| ||
     137||LongestStented_TreatedSegmentCcad||Y|| ||
     138||Lvedp_ifKnown|| || ||
     139||!LvEjectionFractionCategoryCcad||Y|| ||
     140||!LvEjectionFractionCcad||Y|| ||
     141||MeanPawp_la_ifKnown|| || ||
     142||!MedicalHistoryCcad||Y|| ||
     143||!MedicalRecordNumberAtTimeOfEntry||Y|| ||
     144||!NameOfReferringGp||Y|| ||
     145||NeurologicalDysfunction_euroscore|| || ||
     146||!NextEntry||Y|| ||
     147||!NumberCoronaryGraftsPatentPostopCcad||Y|| ||
     148||NumberDrug_ElutingStentsUsedCcad||Y|| ||
     149||NumberGraftsPatent_pre_Operation_Ccad||Y|| ||
     150||NumberGraftsPresent_pre_Operation_Ccad||Y|| ||
     151||!NumberInstentStenosesAttemptedCcad||Y|| ||
     152||!NumberLesionsSuccessfulCcad||Y|| ||
     153||!NumberOfChronicOcclusionsAttemptedCcad||Y|| ||
     154||!NumberOfDistalCoronaryAnastomoses|| || ||
     155||!NumberOfLesionsAttemptedCcad||Y|| ||
     156||!NumberOfPreviousHeartOperations|| || ||
     157||!NumberOfPreviousMis|| || ||
     158||!NumberOfSegmentsOfTheAorta|| || ||
     159||NumberOfValvesReplaced_Repaired|| || ||
     160||NumberOfVesselsAttempted_notEpicardialTerritories_||Y|| ||
     161||!NumberRestenosesAttemptedCcad||Y|| ||
     162||!NumberStentsUsedCcad||Y|| ||
     163||NyhaDyspnoeaStatus_pre_Procedure_StableOnly_Ccad||Y|| ||
     164||!OcclusionSuccess||Y|| ||
     165||!OperationFindings|| || ||
     166||!OperativePriority|| || ||
     167||!OperativeUrgency|| || ||
     168||!OtherCardiacProcedures|| || ||
     169||OtherStenosis_postPci||Y|| ||
     170||OtherStenosis_prePci||Y|| ||
     171||!OtherThoracicAndVascularProcedures|| || ||
     172||!PaSystolic|| || ||
     173||PaSystolic_ifKnown|| || ||
     174||!PatientEthnicGroupCcad||Y|| ||
     175||!PatientGenderCcad||Y|| ||
     176||!PatientId||Y|| ||
     177||!PatientStatusDuringTransferToTheatreCcad||Y|| ||
     178||!PciHospitalOutcomeCcad||Y|| ||
     179||Pct||Y|| ||
     180||!PracticeCode||Y|| ||
     181||Pre_OperativeHeartRhythm|| || ||
     182||PresentingEcg_acsOnly_Ccad||Y|| ||
     183||!PreviousCabgCcad||Y|| ||
     184||PreviousCardiac_VascularOrThoracicSurgicalInterven|| || ||
     185||!PreviousCardiacSurgery|| || ||
     186||!PreviousEntry||Y|| ||
     187||!PreviousMiCcad||Y|| ||
     188||!PreviousPci|| || ||
     189||!PreviousPciCcad||Y|| ||
     190||!PrimaryOperatorStatusCcad||Y|| ||
     191||!ProceduralComplicationCcad||Y|| ||
     192||ProceduralDevice_s_UsedCcad||Y|| ||
     193||ProcedureReport_commentCcad||Y|| ||
     194||!ProcedureUrgencyCcad||Y|| ||
     195||QWaveOnEcgCcad||Y|| ||
     196||RcaStenosis_postPci_Ccad||Y|| ||
     197||RcaStenosis_pre_Pci_Ccad||Y|| ||
     198||RecentLysis_acs_Ccad||Y|| ||
     199||!ReferringCardiologist|| || ||
     200||!RenalDiseaseAtTheTimeOfSurgery|| || ||
     201||!ResearchProcedureCcad||Y|| ||
     202||!ResearchTitleCcad||Y|| ||
     203||!ResponsibleConsultantAnaesthetist|| || ||
     204||!ResponsibleConsultantSurgeon|| || ||
     205||Restenosis||Y|| ||
     206||!SecondOperatorCcad||Y|| ||
     207||!SecondOperatorStatusCcad||Y|| ||
     208||!SmokingStatusCcad||Y|| ||
     209||!SprCases|| || ||
     210||!StatusAtDischargeCcad||Y|| ||
     211||!SurgicalCoverCcad||Y|| ||
     212||!ThirdOperatorCcad||Y|| ||
     213||!ThirdOperatorStatusCcad||Y|| ||
     214||!TimeOfEntry|| || ||
     215||TimeOfOperation_ccad|| || ||
     216||TimeofProcedureCCAD||Y|| ||
     217||!TimeToBypassCcad||Y|| ||
     218||!TotalInpatientStay||Y|| ||
     219||!TrainingProcedureCcad||Y|| ||
     220||!TypeOfLesionCx||Y|| ||
     221||!TypeOfLesionIra||Y|| ||
     222||!TypeOfLesionLadOther||Y|| ||
     223||!TypeOfLesionLadProximal||Y|| ||
     224||!TypeOfLesionLeftMainStem||Y|| ||
     225||!TypeOfLesionOther||Y|| ||
     226||!TypeOfLesionRca||Y|| ||
     227||!TypeOfOcclusion||Y|| ||
     228||Ventilated|| || ||
     229||!VentilatedPreopCcad||Y|| ||
     230||!VentilatedPreOperation|| || ||
     231||!VesselsAttemptedCcad||Y|| ||
     232||!VesselWithChronicTotalOcclusion||Y|| ||
     233||!WaitingListStatusUpdated|| || ||
     234||Weight_kg_Ccad||Y|| ||
     235||WHO_AGE_AT_OPERATION|| || ||
     236||WHO_POSSIBLE_DUPLICATE|| || ||
     237||WHO_REGISTRY_INDICATOR|| || ||
     238||WHO_RESPONSIBLE_CONSULTANT_SURGEON|| || ||
     239||WhyNoIib_iiiaDuringProcedureCcad||Y|| ||