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

Version 2 (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 GGHPCI_GGHPCI GGHPCI_INITIALGGHPCIVIEW
AdministrativeCategoryCcadYY
AdmissionRoute_acs_CcadYY
AngioNumber Y
ApproachToCto Y
ArrivalInPciHospital_acs_CcadYY
ArterialAccessCcadYY
ArterialComplicationsCcadYY
ArterialManagementCcadYY
Athero_ThrombusRemovalDevice_s_UsedCcadYY
AuditTrailYY
BifurcationQuestion1YY
BifurcationQuestion2YY
BlueCathLabForm Y
Bmi Y
BmsSizeYY
BrachytherapyDevice_s_UsedCcadYY
CardiacEnzymes_markersRaisedCcadYY
CardiogenicShockPre_Anaesthesia_pre_Pci_CcadYY
CccoYY
CcsClassificationForStableAnginaCcadYY
CholesterolCcadYY
ChronicTotalOcclusionYY
CirculatorySupportCcadYY
ClinicalSyndromeCcadYY
ClopidogrelDose Y
ConsultantResponsibleForProcedureCcadYY
ConsultantResponsibleForProcedureGmcNumberCcad Y
Creatinine Y
CxStenosis_postPci_CcadYY
CxStenosis_pre_Pci_CcadYY
Date_timeOfFirstBalloonInflation_pci_CcadYY
DateAndTimeArrivalAtHospital_acsOnly_ccadYY
DateAndTimeOfCallForHelp_stemiOnly_Ccad Y
DateAndTimeOfEcgTriggeringPpciPathwayCcad Y
DateAndTimeOfOperationYY
DateAndTimeOfStemiAlert_stemiOnly Y
DateAndTimeOfSymptomOnset_acs_CcadYY
DateOfAdmissionYY
DateOfCholesterolResult Y
DateOfCurrentStatusYY
DateOfDeathPostProcedureYY
DateOfEndStatusYY
DateofProcedureCCADYY
DateTimeRecordCreatedYY
DateTimeRecordLastChangedYY
DesSizeYY
DeviceFailureCcadYY
DiabetesCcadYY
DiagnosticDevice_s_UsedDuringProcedureCcadYY
DiagnosticDeviceUsedDuringProcedure Y
DischargeDateCcadYY
Drug_s_ElutedByStent_s_CcadYY
DrugTherapyPreopCcadYY
EcgIschaemiaCcadYY
EmboliProtectionDevice_s_UsedCcadYY
EnteredByTagYY
EntryCurrentStatusYY
EntryEndStatusYY
EntryIdYY
EntryStatusYY
EnzymesPostopCcadYY
ExceededDrl Y
FamilyHistoryOfCadCcadYY
FirstOperatorCcadYY
FlowInIraPostop_acs_CcadYY
FlowInIraPreop_acs_CcadYY
FollowOn_adhoc_ProcedureCcadYY
FollowOnFromCatheterAtSameTime Y
GpYY
GpIib_iiiaDrug_s_UsedDuringProcedureCcadYY
GraftTypeYY
Height_cm_CcadYY
HistoryOfRenalDiseaseCcadYY
HospitalIdentifierCcadYY
HospitalTagYY
IfAntegradeWereRetrogradeInjectionsUsed Y
ImportLinkId Y
IndicationForInterventionCcadYY
IndicationForStentCcadYY
InstentRestenosisDecribeYY
InstentRestenosisTypeYY
IntervalBetweenProcedureAndDeathYY
LadOtherStenosis_postPci_CcadYY
LadOtherStenosis_pre_Pci_CcadYY
LadProximalStenosis_postPci_CcadYY
LadProximalStenosis_pre_Pci_CcadYY
LargestBalloon_stentUsedCcadYY
LeftMainStemProtectedCcadYY
LeftMainStemStenosis_postPci_CcadYY
LeftMainStemStenosis_pre_Pci_CcadYY
LmsQuestion1YY
LmsQuestion2YY
LmsQuestion3YY
LocalProcedureIdentifierCcadYY
LongestStented_TreatedSegmentCcadYY
LvEjectionFractionCategoryCcadYY
LvEjectionFractionCcadYY
MedicalHistoryCcadYY
MedicalRecordNumberAtTimeOfEntryYY
MedinaClassification Y
NameOfDoctorResponsibleForCompletingForm Y
NameOfInfarctRelatedArtery_ira Y
NameOfReferringGpYY
NextEntryYY
NumberCoronaryGraftsPatentPostopCcadYY
NumberDrug_ElutingStentsUsedCcadYY
NumberGraftsPatent_pre_Operation_CcadYY
NumberGraftsPresent_pre_Operation_CcadYY
NumberInstentStenosesAttemptedCcadYY
NumberLesionsSuccessfulCcadYY
NumberOfChronicOcclusionsAttemptedCcadYY
NumberOfLesionsAttemptedCcadYY
NumberOfVesselsAttempted_notEpicardialTerritories_YY
NumberRestenosesAttemptedCcadYY
NumberStentsUsedCcadYY
NyhaDyspnoeaStatus_pre_Procedure_StableOnly_CcadYY
OcclusionSuccessYY
OtherStenosis_postPciYY
OtherStenosis_prePciYY
PatientEthnicGroupCcadYY
PatientGenderCcadYY
PatientIdYY
PatientLocationAtTimeOfStemiOnset_forPatientsTreat Y
PatientStatusDuringTransferToTheatreCcadYY
PciHospitalOutcomeCcadYY
PctYY
PinkClerkingForm Y
PracticeCodeYY
PresentingEcg_acsOnly_CcadYY
PreviousCabgCcadYY
PreviousEntryYY
PreviousMiCcadYY
PreviousPciCcadYY
PrimaryOperatorGmcNumberCcad Y
PrimaryOperatorStatusCcadYY
ProceduralComplicationCcadYY
ProceduralDevice_s_UsedCcadYY
ProcedureReport_commentCcadYY
ProcedureUrgencyCcadYY
QWaveOnEcgCcadYY
Radiographer Y
RcaStenosis_postPci_CcadYY
RcaStenosis_pre_Pci_CcadYY
ReasonFoExceedingDrl Y
ReasonForDelaysInLab Y
RecentLysis_acs_CcadYY
ReferringHospitalCcad Y
ResearchProcedureCcadYY
ResearchTitleCcadYY
RestenosisYY
ScreeningDose Y
ScreeningTime Y
SecondOperatorCcadYY
SecondOperatorGmcNumberCcad Y
SecondOperatorStatusCcadYY
SmokingStatusCcadYY
StatusAtDischargeCcadYY
SurgicalCoverCcadYY
ThirdOperatorCcadYY
ThirdOperatorGmcNumberCcad Y
ThirdOperatorStatusCcadYY
TimeOfArrivalInLab Y
TimeOffTable Y
TimeofProcedureCCADYY
TimeOfSheathInsertion Y
TimeOfWireAcrossFirstLesion Y
TimeOnTable Y
TimeToBypassCcadYY
TotalInpatientStayYY
TrainingProcedureCcadYY
TypeOfLesionCxYY
TypeOfLesionIraYY
TypeOfLesionLadOtherYY
TypeOfLesionLadProximalYY
TypeOfLesionLeftMainStemYY
TypeOfLesionOtherYY
TypeOfLesionRcaYY
TypeOfOcclusionYY
VentilatedPreopCcadYY
VesselsAttemptedCcadYY
VesselWithChronicTotalOcclusionYY
WardConsultant Y
WasPatientPre_LoadedWithClopidogrel Y
Weight_kg_CcadYY
WhiteHospitalOutcome Y
WhyNoIib_iiiaDuringProcedureCcadYY
Note: See TracWiki for help on using the wiki.