wiki:i2b2 - UHL clinical informatics system integration PATS GGHPCI_INITIALGGHPCIVIEW

back

Start Date Field: DateofProcedureCCAD

Field NameColumn IDTypeComments
EntryId1intIgnored For Field Name
PatientId2intIgnored For Field Name
!DateofProcedureCCAD3dateIgnored For Datatype
!TimeofProcedureCCAD4timeIgnored For Datatype
EntryStatus5varchar
PreviousEntry6intIgnored For Field Name
NextEntry7intIgnored For Field Name
PatientGenderCcad8varchar
PatientEthnicGroupCcad9varchar
AdministrativeCategoryCcad10varchar
HospitalIdentifierCcad11varchar
ClinicalSyndromeCcad12varchar
IndicationForInterventionCcad13varchar
ProcedureUrgencyCcad14varchar
CardiogenicShockPre_Anaesthesia_pre_Pci_Ccad15varchar
CcsClassificationForStableAnginaCcad16varchar
NyhaDyspnoeaStatus_pre_Procedure_StableOnly_Ccad17varchar
DateAndTimeOfSymptomOnset_acs_Ccad18varcharIgnored For No Enum
DateAndTimeArrivalAtHospital_acsOnly_ccad19varcharIgnored For No Enum
AdmissionRoute_acs_Ccad20varchar
PresentingEcg_acsOnly_Ccad21varchar
RecentLysis_acs_Ccad22varchar
CardiacEnzymes_markersRaisedCcad23varchar
PreviousMiCcad24varchar
PreviousCabgCcad25varchar
PreviousPciCcad26varchar
DiabetesCcad27varchar
Height_cm_Ccad28int
Weight_kg_Ccad29float
LvEjectionFractionCategoryCcad30varchar
LvEjectionFractionCcad31int
NumberGraftsPresent_pre_Operation_Ccad32int
NumberGraftsPatent_pre_Operation_Ccad33int
LeftMainStemStenosis_pre_Pci_Ccad34varchar
LadProximalStenosis_pre_Pci_Ccad35varchar
LadOtherStenosis_pre_Pci_Ccad36varchar
RcaStenosis_pre_Pci_Ccad37varchar
CxStenosis_pre_Pci_Ccad38varchar
OtherStenosis_prePci39varchar
FlowInIraPreop_acs_Ccad40varchar
DateAndTimeOfOperation41varcharIgnored For No Enum
ConsultantResponsibleForProcedureCcad42varchar
FirstOperatorCcad43varcharIgnored For No Enum
PrimaryOperatorStatusCcad44varchar
SecondOperatorCcad45varcharIgnored For No Enum
SecondOperatorStatusCcad46varchar
ThirdOperatorCcad47varcharIgnored For No Enum
ThirdOperatorStatusCcad48varchar
VesselsAttemptedCcad49varcharIgnored For No Enum
NumberOfVesselsAttempted_notEpicardialTerritories_50int
NumberOfLesionsAttemptedCcad51int
NumberOfChronicOcclusionsAttemptedCcad52int
NumberRestenosesAttemptedCcad53int
NumberInstentStenosesAttemptedCcad54int
NumberStentsUsedCcad55int
NumberDrug_ElutingStentsUsedCcad56int
Drug_s_ElutedByStent_s_Ccad57varcharIgnored For No Enum
GpIib_iiiaDrug_s_UsedDuringProcedureCcad58varchar
DiagnosticDevice_s_UsedDuringProcedureCcad59varchar
ProceduralDevice_s_UsedCcad60varchar
Athero_ThrombusRemovalDevice_s_UsedCcad61varchar
BrachytherapyDevice_s_UsedCcad62varchar
EmboliProtectionDevice_s_UsedCcad63varchar
CirculatorySupportCcad64varchar
ArterialManagementCcad65varchar
Date_timeOfFirstBalloonInflation_pci_Ccad66varcharIgnored For No Enum
LeftMainStemStenosis_postPci_Ccad67varchar
LadProximalStenosis_postPci_Ccad68varchar
LadOtherStenosis_postPci_Ccad69varchar
RcaStenosis_postPci_Ccad70varchar
CxStenosis_postPci_Ccad71varchar
OtherStenosis_postPci72varchar
NumberLesionsSuccessfulCcad73int
NumberCoronaryGraftsPatentPostopCcad74int
FlowInIraPostop_acs_Ccad75varchar
ProcedureReport_commentCcad76varcharIgnored For No Enum
DeviceFailureCcad77varchar
PciHospitalOutcomeCcad78varcharIgnored For No Enum
EnzymesPostopCcad79varchar
StatusAtDischargeCcad80varchar
DischargeDateCcad81dateIgnored For Datatype
LocalProcedureIdentifierCcad82varchar
CholesterolCcad83float
SmokingStatusCcad84varchar
FamilyHistoryOfCadCcad85varchar
MedicalHistoryCcad86varchar
HistoryOfRenalDiseaseCcad87varchar
VentilatedPreopCcad88varchar
!QWaveOnEcgCcad89varchar
EcgIschaemiaCcad90varchar
DrugTherapyPreopCcad91varcharIgnored For No Enum
FollowOn_adhoc_ProcedureCcad92varchar
TrainingProcedureCcad93varchar
ResearchProcedureCcad94varchar
ResearchTitleCcad95varcharIgnored For No Enum
ArterialAccessCcad96varchar
LargestBalloon_stentUsedCcad97float
LongestStented_TreatedSegmentCcad98int
ProceduralComplicationCcad99varcharIgnored For No Enum
ArterialComplicationsCcad100varchar
TimeToBypassCcad101int
PatientStatusDuringTransferToTheatreCcad102varchar
WhyNoIib_iiiaDuringProcedureCcad103varchar
IndicationForStentCcad104varchar
SurgicalCoverCcad105varchar
LeftMainStemProtectedCcad106varchar
LmsQuestion1107varchar
LmsQuestion2108varchar
LmsQuestion3109varchar
BifurcationQuestion1110varchar
BifurcationQuestion2111varchar
ChronicTotalOcclusion112varchar
VesselWithChronicTotalOcclusion113varchar
TypeOfOcclusion114varchar
OcclusionSuccess115varchar
InstentRestenosisDecribe116varchar
BmsSize117varcharIgnored For No Enum
DesSize118varcharIgnored For No Enum
InstentRestenosisType119varchar
GraftType120varchar
TypeOfLesionLeftMainStem121varchar
TypeOfLesionLadProximal122varchar
TypeOfLesionLadOther123varchar
TypeOfLesionRca124varchar
TypeOfLesionCx125varchar
TypeOfLesionOther126varchar
TypeOfLesionIra127varchar
Restenosis128varchar
Ccco129varcharIgnored For No Enum
MedicalRecordNumberAtTimeOfEntry130varcharIgnored For No Enum
NameOfReferringGp131varcharIgnored For No Enum
Gp132varcharIgnored For No Enum
Pct133varcharIgnored For No Enum
PracticeCode134varcharIgnored For No Enum
DateOfDeathPostProcedure135dateIgnored For Datatype
IntervalBetweenProcedureAndDeath136int
AuditTrail137textIgnored For Datatype
DateOfAdmission138dateIgnored For Datatype
TotalInpatientStay139float
ArrivalInPciHospital_acs_Ccad140varcharIgnored For No Enum
DateAndTimeOfCallForHelp_stemiOnly_Ccad141varcharIgnored For No Enum
ReferringHospitalCcad142varchar
DateAndTimeOfEcgTriggeringPpciPathwayCcad143varcharIgnored For No Enum
PatientLocationAtTimeOfStemiOnset_forPatientsTreat144varchar
ConsultantResponsibleForProcedureGmcNumberCcad145varchar
PrimaryOperatorGmcNumberCcad146varchar
SecondOperatorGmcNumberCcad147varchar
ThirdOperatorGmcNumberCcad148varchar
Creatinine149float
WardConsultant150varchar
PinkClerkingForm151varchar
BlueCathLabForm152varcharIgnored For No Enum
WhiteHospitalOutcome153varchar
AngioNumber154int
TimeOfArrivalInLab155varcharIgnored For No Enum
TimeOnTable156varcharIgnored For No Enum
TimeOfSheathInsertion157varcharIgnored For No Enum
TimeOfWireAcrossFirstLesion158varcharIgnored For No Enum
TimeOffTable159varcharIgnored For No Enum
DateAndTimeOfStemiAlert_stemiOnly160varcharIgnored For No Enum
NameOfDoctorResponsibleForCompletingForm161varchar
ReasonForDelaysInLab162varcharIgnored For No Enum
DateOfCholesterolResult163dateIgnored For Datatype
WasPatientPre_LoadedWithClopidogrel164varchar
ClopidogrelDose165varchar
DiagnosticDeviceUsedDuringProcedure166varchar
NameOfInfarctRelatedArtery_ira167varcharIgnored For No Enum
MedinaClassification168float
ApproachToCto169varchar
IfAntegradeWereRetrogradeInjectionsUsed170varchar
Bmi171float
ScreeningTime172float
ScreeningDose173float
ExceededDrl174varchar
Radiographer175varchar
FollowOnFromCatheterAtSameTime176varchar
ReasonFoExceedingDrl177varchar
DateOfCurrentStatus178dateIgnored For Datatype
DateOfEndStatus179dateIgnored For Datatype
DateTimeRecordCreated180varcharIgnored For No Enum
DateTimeRecordLastChanged181varcharIgnored For No Enum
EnteredByTag182varchar
EntryCurrentStatus183varchar
EntryEndStatus184varchar
HospitalTag185varchar
ImportLinkId186int
Last modified 10 years ago Last modified on 03/15/13 09:03:27
Note: See TracWiki for help on using the wiki.