[[i2b2 - UHL clinical informatics system integration PATS Mappings v1|back]]

== Tables

||= Table =||= Date Range =||= Start Date Field =||= Records =||
||GGHPCI_GGHPCI||2004-2010||DateofprocedureCCAD||9939||
||GGHPCI_INITIALGGHPCIVIEW||2004-2013||DateofprocedureCCAD||14513||

== Columns

||Column Name||GGHPCI_GGHPCI||GGHPCI_INITIALGGHPCIVIEW||
||!AdministrativeCategory|| || ||
||!AdministrativeCategoryCcad||Y|| ||
||!AdmissionCategory|| || ||
||AdmissionRoute_acs_Ccad||Y|| ||
||!AgeAtOperation|| || ||
||!AgeAtSurgery|| || ||
||Allergies|| || ||
||!AllOtherAssistants|| || ||
||AnginaStatusPre_Surgery|| || ||
||ArrivalInPciHospital_acs_Ccad||Y|| ||
||!ArterialAccessCcad||Y|| ||
||!ArterialComplicationsCcad||Y|| ||
||!ArterialManagementCcad||Y|| ||
||Athero_ThrombusRemovalDevice_s_UsedCcad||Y|| ||
||!AuditTrail||Y|| ||
||AvGradient_ifKnown|| || ||
||BifurcationQuestion1||Y|| ||
||BifurcationQuestion2||Y|| ||
||!BmsSize||Y|| ||
||BrachytherapyDevice_s_UsedCcad||Y|| ||
||CardiacEnzymes_markersRaisedCcad||Y|| ||
||!CardiacProcedures|| || ||
||!CardiogenicShock|| || ||
||CardiogenicShock_pre_Operation|| || ||
||CardiogenicShockPre_Anaesthesia_pre_Pci_Ccad||Y|| ||
||!CarotidBruits|| || ||
||Ccco||Y|| ||
||!CcsClassificationForStableAnginaCcad||Y|| ||
||!CholesterolCcad||Y|| ||
||!ChronicTotalOcclusion||Y|| ||
||!CigaretteSmokingHistory|| || ||
||!CirculatorySupportCcad||Y|| ||
||!ClinicalSyndromeCcad||Y|| ||
||!ConsultantResponsibleForProcedureCcad||Y|| ||
||CxStenosis_postPci_Ccad||Y|| ||
||CxStenosis_pre_Pci_Ccad||Y|| ||
||Date_timeOfFirstBalloonInflation_pci_Ccad||Y|| ||
||DateAndTimeArrivalAtHospital_acsOnly_ccad||Y|| ||
||!DateAndTimeOfOperation||Y|| ||
||DateAndTimeOfSymptomOnset_acs_Ccad||Y|| ||
||!DateOfAdmission||Y|| ||
||!DateOfCatheterisation|| || ||
||!DateOfCurrentStatus||Y|| ||
||!DateOfDeathPostProcedure||Y|| ||
||!DateOfEndStatus||Y|| ||
||!DateOfLastCardiacOperation|| || ||
||!DateOfLastCatheterisation|| || ||
||!DateOfLastPci|| || ||
||!DateOfOperation|| || ||
||DateOfOperation_ccad|| || ||
||DateofProcedureCCAD||Y|| ||
||!DateOfReferral|| || ||
||!DateTimeRecordCreated||Y|| ||
||!DateTimeRecordLastChanged||Y|| ||
||!DesSize||Y|| ||
||!DeviceFailureCcad||Y|| ||
||!DiabetesCcad||Y|| ||
||!DiabetesManagement|| || ||
||DiagnosticDevice_s_UsedDuringProcedureCcad||Y|| ||
||!DischargeDateCcad||Y|| ||
||Drug_s_ElutedByStent_s_Ccad||Y|| ||
||!DrugsOnAdmission|| || ||
||!DrugTherapyPreopCcad||Y|| ||
||DyspnoeaStatusPre_Surgery|| || ||
||!EcgIschaemiaCcad||Y|| ||
||!EjectionFractionCategory|| || ||
||EjectionFractionValue_ifKnown|| || ||
||EmboliProtectionDevice_s_UsedCcad||Y|| ||
||!EnteredByTag||Y|| ||
||!EntryCurrentStatus||Y|| ||
||!EntryEndStatus||Y|| ||
||!EntryId||Y|| ||
||!EntryStatus||Y|| ||
||!EnzymesPostopCcad||Y|| ||
||!ExtentOfCoronaryArteryDisease|| || ||
||!ExtentOfCoronaryVesselDisease|| || ||
||!ExtracardiacArteriopathy|| || ||
||!FamilyHistoryOfCadCcad||Y|| ||
||!FirstAssistant|| || ||
||FirstAssistant_CalmanYearOfTrainee|| || ||
||!FirstAssistantGrade|| || ||
||!FirstOperator|| || ||
||FirstOperator_CalmanYearOfTrainee|| || ||
||!FirstOperatorCcad||Y|| ||
||!FirstOperatorGrade|| || ||
||FlowInIraPostop_acs_Ccad||Y|| ||
||FlowInIraPreop_acs_Ccad||Y|| ||
||FollowOn_adhoc_ProcedureCcad||Y|| ||
||Gender|| || ||
||Gp||Y|| ||
||GpIib_iiiaDrug_s_UsedDuringProcedureCcad||Y|| ||
||!GraftType||Y|| ||
||Height_cm_Ccad||Y|| ||
||!HistoryOfHypertension|| || ||
||!HistoryOfNeurologicalDisease|| || ||
||!HistoryOfPulmonaryDisease|| || ||
||!HistoryOfRenalDiseaseCcad||Y|| ||
||!HospitalIdentifierCcad||Y|| ||
||!HospitalTag||Y|| ||
||Hypertension|| || ||
||!IndicationForInterventionCcad||Y|| ||
||!IndicationForStentCcad||Y|| ||
||!InstentRestenosisDecribe||Y|| ||
||!InstentRestenosisType||Y|| ||
||!IntervalBetweenOperationAndLastMi|| || ||
||!IntervalBetweenProcedureAndDeath||Y|| ||
||!IntervalBetweenSurgeryAndLastMi|| || ||
||!IntravenousInotropesPriorToAnaesthesia|| || ||
||!IntravenousNitratesOrAnyHeparin|| || ||
||!IvInotropesPriorToAnaesthesia|| || ||
||IvNitrates_HeparinOfAnyKind|| || ||
||LadOtherStenosis_postPci_Ccad||Y|| ||
||LadOtherStenosis_pre_Pci_Ccad||Y|| ||
||LadProximalStenosis_postPci_Ccad||Y|| ||
||LadProximalStenosis_pre_Pci_Ccad||Y|| ||
||LargestBalloon_stentUsedCcad||Y|| ||
||!LeftMainStemDisease|| || ||
||!LeftMainStemProtectedCcad||Y|| ||
||LeftMainStemStenosis_postPci_Ccad||Y|| ||
||LeftMainStemStenosis_pre_Pci_Ccad||Y|| ||
||!LeftOrRightHeartCatheterisation|| || ||
||LmsQuestion1||Y|| ||
||LmsQuestion2||Y|| ||
||LmsQuestion3||Y|| ||
||!LocalProcedureIdentifierCcad||Y|| ||
||LongestStented_TreatedSegmentCcad||Y|| ||
||Lvedp_ifKnown|| || ||
||!LvEjectionFractionCategoryCcad||Y|| ||
||!LvEjectionFractionCcad||Y|| ||
||MeanPawp_la_ifKnown|| || ||
||!MedicalHistoryCcad||Y|| ||
||!MedicalRecordNumberAtTimeOfEntry||Y|| ||
||!NameOfReferringGp||Y|| ||
||NeurologicalDysfunction_euroscore|| || ||
||!NextEntry||Y|| ||
||!NumberCoronaryGraftsPatentPostopCcad||Y|| ||
||NumberDrug_ElutingStentsUsedCcad||Y|| ||
||NumberGraftsPatent_pre_Operation_Ccad||Y|| ||
||NumberGraftsPresent_pre_Operation_Ccad||Y|| ||
||!NumberInstentStenosesAttemptedCcad||Y|| ||
||!NumberLesionsSuccessfulCcad||Y|| ||
||!NumberOfChronicOcclusionsAttemptedCcad||Y|| ||
||!NumberOfDistalCoronaryAnastomoses|| || ||
||!NumberOfLesionsAttemptedCcad||Y|| ||
||!NumberOfPreviousHeartOperations|| || ||
||!NumberOfPreviousMis|| || ||
||!NumberOfSegmentsOfTheAorta|| || ||
||NumberOfValvesReplaced_Repaired|| || ||
||NumberOfVesselsAttempted_notEpicardialTerritories_||Y|| ||
||!NumberRestenosesAttemptedCcad||Y|| ||
||!NumberStentsUsedCcad||Y|| ||
||NyhaDyspnoeaStatus_pre_Procedure_StableOnly_Ccad||Y|| ||
||!OcclusionSuccess||Y|| ||
||!OperationFindings|| || ||
||!OperativePriority|| || ||
||!OperativeUrgency|| || ||
||!OtherCardiacProcedures|| || ||
||OtherStenosis_postPci||Y|| ||
||OtherStenosis_prePci||Y|| ||
||!OtherThoracicAndVascularProcedures|| || ||
||!PaSystolic|| || ||
||PaSystolic_ifKnown|| || ||
||!PatientEthnicGroupCcad||Y|| ||
||!PatientGenderCcad||Y|| ||
||!PatientId||Y|| ||
||!PatientStatusDuringTransferToTheatreCcad||Y|| ||
||!PciHospitalOutcomeCcad||Y|| ||
||Pct||Y|| ||
||!PracticeCode||Y|| ||
||Pre_OperativeHeartRhythm|| || ||
||PresentingEcg_acsOnly_Ccad||Y|| ||
||!PreviousCabgCcad||Y|| ||
||PreviousCardiac_VascularOrThoracicSurgicalInterven|| || ||
||!PreviousCardiacSurgery|| || ||
||!PreviousEntry||Y|| ||
||!PreviousMiCcad||Y|| ||
||!PreviousPci|| || ||
||!PreviousPciCcad||Y|| ||
||!PrimaryOperatorStatusCcad||Y|| ||
||!ProceduralComplicationCcad||Y|| ||
||ProceduralDevice_s_UsedCcad||Y|| ||
||ProcedureReport_commentCcad||Y|| ||
||!ProcedureUrgencyCcad||Y|| ||
||QWaveOnEcgCcad||Y|| ||
||RcaStenosis_postPci_Ccad||Y|| ||
||RcaStenosis_pre_Pci_Ccad||Y|| ||
||RecentLysis_acs_Ccad||Y|| ||
||!ReferringCardiologist|| || ||
||!RenalDiseaseAtTheTimeOfSurgery|| || ||
||!ResearchProcedureCcad||Y|| ||
||!ResearchTitleCcad||Y|| ||
||!ResponsibleConsultantAnaesthetist|| || ||
||!ResponsibleConsultantSurgeon|| || ||
||Restenosis||Y|| ||
||!SecondOperatorCcad||Y|| ||
||!SecondOperatorStatusCcad||Y|| ||
||!SmokingStatusCcad||Y|| ||
||!SprCases|| || ||
||!StatusAtDischargeCcad||Y|| ||
||!SurgicalCoverCcad||Y|| ||
||!ThirdOperatorCcad||Y|| ||
||!ThirdOperatorStatusCcad||Y|| ||
||!TimeOfEntry|| || ||
||TimeOfOperation_ccad|| || ||
||TimeofProcedureCCAD||Y|| ||
||!TimeToBypassCcad||Y|| ||
||!TotalInpatientStay||Y|| ||
||!TrainingProcedureCcad||Y|| ||
||!TypeOfLesionCx||Y|| ||
||!TypeOfLesionIra||Y|| ||
||!TypeOfLesionLadOther||Y|| ||
||!TypeOfLesionLadProximal||Y|| ||
||!TypeOfLesionLeftMainStem||Y|| ||
||!TypeOfLesionOther||Y|| ||
||!TypeOfLesionRca||Y|| ||
||!TypeOfOcclusion||Y|| ||
||Ventilated|| || ||
||!VentilatedPreopCcad||Y|| ||
||!VentilatedPreOperation|| || ||
||!VesselsAttemptedCcad||Y|| ||
||!VesselWithChronicTotalOcclusion||Y|| ||
||!WaitingListStatusUpdated|| || ||
||Weight_kg_Ccad||Y|| ||
||WHO_AGE_AT_OPERATION|| || ||
||WHO_POSSIBLE_DUPLICATE|| || ||
||WHO_REGISTRY_INDICATOR|| || ||
||WHO_RESPONSIBLE_CONSULTANT_SURGEON|| || ||
||WhyNoIib_iiiaDuringProcedureCcad||Y|| ||