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

Start Date Field: DateofProcedureCCAD

||Field Name||Column ID||Type||Comments||
||~~!EntryId~~||1||int||Ignored For Field Name||
||~~!PatientId~~||2||int||Ignored For Field Name||
||~~!DateofProcedureCCAD~~||3||date||Ignored For Datatype||
||~~!TimeofProcedureCCAD~~||4||time||Ignored For Datatype||
||!EntryStatus||5||varchar||||
||~~!PreviousEntry~~||6||int||Ignored For Field Name||
||~~!NextEntry~~||7||int||Ignored For Field Name||
||!PatientGenderCcad||8||varchar||||
||!PatientEthnicGroupCcad||9||varchar||||
||!AdministrativeCategoryCcad||10||varchar||||
||!HospitalIdentifierCcad||11||varchar||||
||!ClinicalSyndromeCcad||12||varchar||||
||!IndicationForInterventionCcad||13||varchar||||
||!ProcedureUrgencyCcad||14||varchar||||
||CardiogenicShockPre_Anaesthesia_pre_Pci_Ccad||15||varchar||||
||!CcsClassificationForStableAnginaCcad||16||varchar||||
||NyhaDyspnoeaStatus_pre_Procedure_StableOnly_Ccad||17||varchar||||
||~~DateAndTimeOfSymptomOnset_acs_Ccad~~||18||varchar||Ignored For No Enum||
||~~DateAndTimeArrivalAtHospital_acsOnly_ccad~~||19||varchar||Ignored For No Enum||
||AdmissionRoute_acs_Ccad||20||varchar||||
||PresentingEcg_acsOnly_Ccad||21||varchar||||
||RecentLysis_acs_Ccad||22||varchar||||
||CardiacEnzymes_markersRaisedCcad||23||varchar||||
||!PreviousMiCcad||24||varchar||||
||!PreviousCabgCcad||25||varchar||||
||!PreviousPciCcad||26||varchar||||
||!DiabetesCcad||27||varchar||||
||Height_cm_Ccad||28||int||||
||Weight_kg_Ccad||29||float||||
||!LvEjectionFractionCategoryCcad||30||varchar||||
||!LvEjectionFractionCcad||31||int||||
||NumberGraftsPresent_pre_Operation_Ccad||32||int||||
||NumberGraftsPatent_pre_Operation_Ccad||33||int||||
||LeftMainStemStenosis_pre_Pci_Ccad||34||varchar||||
||LadProximalStenosis_pre_Pci_Ccad||35||varchar||||
||LadOtherStenosis_pre_Pci_Ccad||36||varchar||||
||RcaStenosis_pre_Pci_Ccad||37||varchar||||
||CxStenosis_pre_Pci_Ccad||38||varchar||||
||OtherStenosis_prePci||39||varchar||||
||FlowInIraPreop_acs_Ccad||40||varchar||||
||~~!DateAndTimeOfOperation~~||41||varchar||Ignored For No Enum||
||!ConsultantResponsibleForProcedureCcad||42||varchar||||
||~~!FirstOperatorCcad~~||43||varchar||Ignored For No Enum||
||!PrimaryOperatorStatusCcad||44||varchar||||
||~~!SecondOperatorCcad~~||45||varchar||Ignored For No Enum||
||!SecondOperatorStatusCcad||46||varchar||||
||~~!ThirdOperatorCcad~~||47||varchar||Ignored For No Enum||
||!ThirdOperatorStatusCcad||48||varchar||||
||~~!VesselsAttemptedCcad~~||49||varchar||Ignored For No Enum||
||NumberOfVesselsAttempted_notEpicardialTerritories_||50||int||||
||!NumberOfLesionsAttemptedCcad||51||int||||
||!NumberOfChronicOcclusionsAttemptedCcad||52||int||||
||!NumberRestenosesAttemptedCcad||53||int||||
||!NumberInstentStenosesAttemptedCcad||54||int||||
||!NumberStentsUsedCcad||55||int||||
||NumberDrug_ElutingStentsUsedCcad||56||int||||
||~~Drug_s_ElutedByStent_s_Ccad~~||57||varchar||Ignored For No Enum||
||GpIib_iiiaDrug_s_UsedDuringProcedureCcad||58||varchar||||
||DiagnosticDevice_s_UsedDuringProcedureCcad||59||varchar||||
||ProceduralDevice_s_UsedCcad||60||varchar||||
||Athero_ThrombusRemovalDevice_s_UsedCcad||61||varchar||||
||BrachytherapyDevice_s_UsedCcad||62||varchar||||
||EmboliProtectionDevice_s_UsedCcad||63||varchar||||
||!CirculatorySupportCcad||64||varchar||||
||!ArterialManagementCcad||65||varchar||||
||~~Date_timeOfFirstBalloonInflation_pci_Ccad~~||66||varchar||Ignored For No Enum||
||LeftMainStemStenosis_postPci_Ccad||67||varchar||||
||LadProximalStenosis_postPci_Ccad||68||varchar||||
||LadOtherStenosis_postPci_Ccad||69||varchar||||
||RcaStenosis_postPci_Ccad||70||varchar||||
||CxStenosis_postPci_Ccad||71||varchar||||
||OtherStenosis_postPci||72||varchar||||
||!NumberLesionsSuccessfulCcad||73||int||||
||!NumberCoronaryGraftsPatentPostopCcad||74||int||||
||FlowInIraPostop_acs_Ccad||75||varchar||||
||~~ProcedureReport_commentCcad~~||76||varchar||Ignored For No Enum||
||!DeviceFailureCcad||77||varchar||||
||~~!PciHospitalOutcomeCcad~~||78||varchar||Ignored For No Enum||
||!EnzymesPostopCcad||79||varchar||||
||!StatusAtDischargeCcad||80||varchar||||
||~~!DischargeDateCcad~~||81||date||Ignored For Datatype||
||!LocalProcedureIdentifierCcad||82||varchar||||
||!CholesterolCcad||83||float||||
||!SmokingStatusCcad||84||varchar||||
||!FamilyHistoryOfCadCcad||85||varchar||||
||!MedicalHistoryCcad||86||varchar||||
||!HistoryOfRenalDiseaseCcad||87||varchar||||
||!VentilatedPreopCcad||88||varchar||||
||!QWaveOnEcgCcad||89||varchar||||
||!EcgIschaemiaCcad||90||varchar||||
||~~!DrugTherapyPreopCcad~~||91||varchar||Ignored For No Enum||
||FollowOn_adhoc_ProcedureCcad||92||varchar||||
||!TrainingProcedureCcad||93||varchar||||
||!ResearchProcedureCcad||94||varchar||||
||~~!ResearchTitleCcad~~||95||varchar||Ignored For No Enum||
||!ArterialAccessCcad||96||varchar||||
||LargestBalloon_stentUsedCcad||97||float||||
||LongestStented_TreatedSegmentCcad||98||int||||
||~~!ProceduralComplicationCcad~~||99||varchar||Ignored For No Enum||
||!ArterialComplicationsCcad||100||varchar||||
||!TimeToBypassCcad||101||int||||
||!PatientStatusDuringTransferToTheatreCcad||102||varchar||||
||WhyNoIib_iiiaDuringProcedureCcad||103||varchar||||
||!IndicationForStentCcad||104||varchar||||
||!SurgicalCoverCcad||105||varchar||||
||!LeftMainStemProtectedCcad||106||varchar||||
||LmsQuestion1||107||varchar||||
||LmsQuestion2||108||varchar||||
||LmsQuestion3||109||varchar||||
||BifurcationQuestion1||110||varchar||||
||BifurcationQuestion2||111||varchar||||
||!ChronicTotalOcclusion||112||varchar||||
||!VesselWithChronicTotalOcclusion||113||varchar||||
||!TypeOfOcclusion||114||varchar||||
||!OcclusionSuccess||115||varchar||||
||!InstentRestenosisDecribe||116||varchar||||
||~~!BmsSize~~||117||varchar||Ignored For No Enum||
||~~!DesSize~~||118||varchar||Ignored For No Enum||
||!InstentRestenosisType||119||varchar||||
||!GraftType||120||varchar||||
||!TypeOfLesionLeftMainStem||121||varchar||||
||!TypeOfLesionLadProximal||122||varchar||||
||!TypeOfLesionLadOther||123||varchar||||
||!TypeOfLesionRca||124||varchar||||
||!TypeOfLesionCx||125||varchar||||
||!TypeOfLesionOther||126||varchar||||
||!TypeOfLesionIra||127||varchar||||
||Restenosis||128||varchar||||
||~~Ccco~~||129||varchar||Ignored For No Enum||
||~~!MedicalRecordNumberAtTimeOfEntry~~||130||varchar||Ignored For No Enum||
||~~!NameOfReferringGp~~||131||varchar||Ignored For No Enum||
||~~Gp~~||132||varchar||Ignored For No Enum||
||~~Pct~~||133||varchar||Ignored For No Enum||
||~~!PracticeCode~~||134||varchar||Ignored For No Enum||
||~~!DateOfDeathPostProcedure~~||135||date||Ignored For Datatype||
||!IntervalBetweenProcedureAndDeath||136||int||||
||~~!AuditTrail~~||137||text||Ignored For Datatype||
||~~!DateOfAdmission~~||138||date||Ignored For Datatype||
||!TotalInpatientStay||139||float||||
||~~ArrivalInPciHospital_acs_Ccad~~||140||varchar||Ignored For No Enum||
||~~DateAndTimeOfCallForHelp_stemiOnly_Ccad~~||141||varchar||Ignored For No Enum||
||!ReferringHospitalCcad||142||varchar||||
||~~!DateAndTimeOfEcgTriggeringPpciPathwayCcad~~||143||varchar||Ignored For No Enum||
||PatientLocationAtTimeOfStemiOnset_forPatientsTreat||144||varchar||||
||!ConsultantResponsibleForProcedureGmcNumberCcad||145||varchar||||
||!PrimaryOperatorGmcNumberCcad||146||varchar||||
||!SecondOperatorGmcNumberCcad||147||varchar||||
||!ThirdOperatorGmcNumberCcad||148||varchar||||
||Creatinine||149||float||||
||!WardConsultant||150||varchar||||
||!PinkClerkingForm||151||varchar||||
||~~!BlueCathLabForm~~||152||varchar||Ignored For No Enum||
||!WhiteHospitalOutcome||153||varchar||||
||!AngioNumber||154||int||||
||~~!TimeOfArrivalInLab~~||155||varchar||Ignored For No Enum||
||~~!TimeOnTable~~||156||varchar||Ignored For No Enum||
||~~!TimeOfSheathInsertion~~||157||varchar||Ignored For No Enum||
||~~!TimeOfWireAcrossFirstLesion~~||158||varchar||Ignored For No Enum||
||~~!TimeOffTable~~||159||varchar||Ignored For No Enum||
||~~DateAndTimeOfStemiAlert_stemiOnly~~||160||varchar||Ignored For No Enum||
||!NameOfDoctorResponsibleForCompletingForm||161||varchar||||
||~~!ReasonForDelaysInLab~~||162||varchar||Ignored For No Enum||
||~~!DateOfCholesterolResult~~||163||date||Ignored For Datatype||
||WasPatientPre_LoadedWithClopidogrel||164||varchar||||
||!ClopidogrelDose||165||varchar||||
||!DiagnosticDeviceUsedDuringProcedure||166||varchar||||
||~~NameOfInfarctRelatedArtery_ira~~||167||varchar||Ignored For No Enum||
||!MedinaClassification||168||float||||
||!ApproachToCto||169||varchar||||
||!IfAntegradeWereRetrogradeInjectionsUsed||170||varchar||||
||Bmi||171||float||||
||!ScreeningTime||172||float||||
||!ScreeningDose||173||float||||
||!ExceededDrl||174||varchar||||
||Radiographer||175||varchar||||
||!FollowOnFromCatheterAtSameTime||176||varchar||||
||!ReasonFoExceedingDrl||177||varchar||||
||~~!DateOfCurrentStatus~~||178||date||Ignored For Datatype||
||~~!DateOfEndStatus~~||179||date||Ignored For Datatype||
||~~!DateTimeRecordCreated~~||180||varchar||Ignored For No Enum||
||~~!DateTimeRecordLastChanged~~||181||varchar||Ignored For No Enum||
||!EnteredByTag||182||varchar||||
||!EntryCurrentStatus||183||varchar||||
||!EntryEndStatus||184||varchar||||
||!HospitalTag||185||varchar||||
||!ImportLinkId||186||int||||