wiki:i2b2 - UHL clinical informatics system integration PATS PCI Combined

Version 1 (modified by Richard Bramley, 12 years ago) ( diff )

--

back

Tables

Table Date Range Start Date Field Records
GGHPCI_GGHPCI2004-2010DateofprocedureCCAD9939
GGHPCI_INITIALGGHPCIVIEW2004-2013DateofprocedureCCAD14513

Columns

Column NameGGHPCI_GGHPCIGGHPCI_INITIALGGHPCIVIEW
AdministrativeCategory
AdministrativeCategoryCcadY
AdmissionCategory
AdmissionRoute_acs_CcadY
AgeAtOperation
AgeAtSurgery
Allergies
AllOtherAssistants
AnginaStatusPre_Surgery
ArrivalInPciHospital_acs_CcadY
ArterialAccessCcadY
ArterialComplicationsCcadY
ArterialManagementCcadY
Athero_ThrombusRemovalDevice_s_UsedCcadY
AuditTrailY
AvGradient_ifKnown
BifurcationQuestion1Y
BifurcationQuestion2Y
BmsSizeY
BrachytherapyDevice_s_UsedCcadY
CardiacEnzymes_markersRaisedCcadY
CardiacProcedures
CardiogenicShock
CardiogenicShock_pre_Operation
CardiogenicShockPre_Anaesthesia_pre_Pci_CcadY
CarotidBruits
CccoY
CcsClassificationForStableAnginaCcadY
CholesterolCcadY
ChronicTotalOcclusionY
CigaretteSmokingHistory
CirculatorySupportCcadY
ClinicalSyndromeCcadY
ConsultantResponsibleForProcedureCcadY
CxStenosis_postPci_CcadY
CxStenosis_pre_Pci_CcadY
Date_timeOfFirstBalloonInflation_pci_CcadY
DateAndTimeArrivalAtHospital_acsOnly_ccadY
DateAndTimeOfOperationY
DateAndTimeOfSymptomOnset_acs_CcadY
DateOfAdmissionY
DateOfCatheterisation
DateOfCurrentStatusY
DateOfDeathPostProcedureY
DateOfEndStatusY
DateOfLastCardiacOperation
DateOfLastCatheterisation
DateOfLastPci
DateOfOperation
DateOfOperation_ccad
DateofProcedureCCADY
DateOfReferral
DateTimeRecordCreatedY
DateTimeRecordLastChangedY
DesSizeY
DeviceFailureCcadY
DiabetesCcadY
DiabetesManagement
DiagnosticDevice_s_UsedDuringProcedureCcadY
DischargeDateCcadY
Drug_s_ElutedByStent_s_CcadY
DrugsOnAdmission
DrugTherapyPreopCcadY
DyspnoeaStatusPre_Surgery
EcgIschaemiaCcadY
EjectionFractionCategory
EjectionFractionValue_ifKnown
EmboliProtectionDevice_s_UsedCcadY
EnteredByTagY
EntryCurrentStatusY
EntryEndStatusY
EntryIdY
EntryStatusY
EnzymesPostopCcadY
ExtentOfCoronaryArteryDisease
ExtentOfCoronaryVesselDisease
ExtracardiacArteriopathy
FamilyHistoryOfCadCcadY
FirstAssistant
FirstAssistant_CalmanYearOfTrainee
FirstAssistantGrade
FirstOperator
FirstOperator_CalmanYearOfTrainee
FirstOperatorCcadY
FirstOperatorGrade
FlowInIraPostop_acs_CcadY
FlowInIraPreop_acs_CcadY
FollowOn_adhoc_ProcedureCcadY
Gender
GpY
GpIib_iiiaDrug_s_UsedDuringProcedureCcadY
GraftTypeY
Height_cm_CcadY
HistoryOfHypertension
HistoryOfNeurologicalDisease
HistoryOfPulmonaryDisease
HistoryOfRenalDiseaseCcadY
HospitalIdentifierCcadY
HospitalTagY
Hypertension
IndicationForInterventionCcadY
IndicationForStentCcadY
InstentRestenosisDecribeY
InstentRestenosisTypeY
IntervalBetweenOperationAndLastMi
IntervalBetweenProcedureAndDeathY
IntervalBetweenSurgeryAndLastMi
IntravenousInotropesPriorToAnaesthesia
IntravenousNitratesOrAnyHeparin
IvInotropesPriorToAnaesthesia
IvNitrates_HeparinOfAnyKind
LadOtherStenosis_postPci_CcadY
LadOtherStenosis_pre_Pci_CcadY
LadProximalStenosis_postPci_CcadY
LadProximalStenosis_pre_Pci_CcadY
LargestBalloon_stentUsedCcadY
LeftMainStemDisease
LeftMainStemProtectedCcadY
LeftMainStemStenosis_postPci_CcadY
LeftMainStemStenosis_pre_Pci_CcadY
LeftOrRightHeartCatheterisation
LmsQuestion1Y
LmsQuestion2Y
LmsQuestion3Y
LocalProcedureIdentifierCcadY
LongestStented_TreatedSegmentCcadY
Lvedp_ifKnown
LvEjectionFractionCategoryCcadY
LvEjectionFractionCcadY
MeanPawp_la_ifKnown
MedicalHistoryCcadY
MedicalRecordNumberAtTimeOfEntryY
NameOfReferringGpY
NeurologicalDysfunction_euroscore
NextEntryY
NumberCoronaryGraftsPatentPostopCcadY
NumberDrug_ElutingStentsUsedCcadY
NumberGraftsPatent_pre_Operation_CcadY
NumberGraftsPresent_pre_Operation_CcadY
NumberInstentStenosesAttemptedCcadY
NumberLesionsSuccessfulCcadY
NumberOfChronicOcclusionsAttemptedCcadY
NumberOfDistalCoronaryAnastomoses
NumberOfLesionsAttemptedCcadY
NumberOfPreviousHeartOperations
NumberOfPreviousMis
NumberOfSegmentsOfTheAorta
NumberOfValvesReplaced_Repaired
NumberOfVesselsAttempted_notEpicardialTerritories_Y
NumberRestenosesAttemptedCcadY
NumberStentsUsedCcadY
NyhaDyspnoeaStatus_pre_Procedure_StableOnly_CcadY
OcclusionSuccessY
OperationFindings
OperativePriority
OperativeUrgency
OtherCardiacProcedures
OtherStenosis_postPciY
OtherStenosis_prePciY
OtherThoracicAndVascularProcedures
PaSystolic
PaSystolic_ifKnown
PatientEthnicGroupCcadY
PatientGenderCcadY
PatientIdY
PatientStatusDuringTransferToTheatreCcadY
PciHospitalOutcomeCcadY
PctY
PracticeCodeY
Pre_OperativeHeartRhythm
PresentingEcg_acsOnly_CcadY
PreviousCabgCcadY
PreviousCardiac_VascularOrThoracicSurgicalInterven
PreviousCardiacSurgery
PreviousEntryY
PreviousMiCcadY
PreviousPci
PreviousPciCcadY
PrimaryOperatorStatusCcadY
ProceduralComplicationCcadY
ProceduralDevice_s_UsedCcadY
ProcedureReport_commentCcadY
ProcedureUrgencyCcadY
QWaveOnEcgCcadY
RcaStenosis_postPci_CcadY
RcaStenosis_pre_Pci_CcadY
RecentLysis_acs_CcadY
ReferringCardiologist
RenalDiseaseAtTheTimeOfSurgery
ResearchProcedureCcadY
ResearchTitleCcadY
ResponsibleConsultantAnaesthetist
ResponsibleConsultantSurgeon
RestenosisY
SecondOperatorCcadY
SecondOperatorStatusCcadY
SmokingStatusCcadY
SprCases
StatusAtDischargeCcadY
SurgicalCoverCcadY
ThirdOperatorCcadY
ThirdOperatorStatusCcadY
TimeOfEntry
TimeOfOperation_ccad
TimeofProcedureCCADY
TimeToBypassCcadY
TotalInpatientStayY
TrainingProcedureCcadY
TypeOfLesionCxY
TypeOfLesionIraY
TypeOfLesionLadOtherY
TypeOfLesionLadProximalY
TypeOfLesionLeftMainStemY
TypeOfLesionOtherY
TypeOfLesionRcaY
TypeOfOcclusionY
Ventilated
VentilatedPreopCcadY
VentilatedPreOperation
VesselsAttemptedCcadY
VesselWithChronicTotalOcclusionY
WaitingListStatusUpdated
Weight_kg_CcadY
WHO_AGE_AT_OPERATION
WHO_POSSIBLE_DUPLICATE
WHO_REGISTRY_INDICATOR
WHO_RESPONSIBLE_CONSULTANT_SURGEON
WhyNoIib_iiiaDuringProcedureCcadY
Note: See TracWiki for help on using the wiki.