Changes between Initial Version and Version 1 of i2b2 - UHL clinical informatics system integration PATS GGHPCI_INITIALGGHPCIVIEW


Ignore:
Timestamp:
03/15/13 09:03:27 (11 years ago)
Author:
Richard Bramley
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • i2b2 - UHL clinical informatics system integration PATS GGHPCI_INITIALGGHPCIVIEW

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