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


Ignore:
Timestamp:
04/05/13 15:39:01 (11 years ago)
Author:
Richard Bramley
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • i2b2 - UHL clinical informatics system integration PATS EPS Combined

    v1 v1  
     1[[i2b2 - UHL clinical informatics system integration PATS Mappings v1|back]]
     2
     3== Tables
     4
     5||= Table =||= Date Range =||= Start Date Field =||= Records =||
     6||EPS_EPS||2003-2007||!DateOfAdmission||2170||
     7||EPS_EPSINIVW||2007-2012||!DateOfAdmission||5116||
     8
     9== Columns
     10
     11||= Column =||= EPS_EPS =||= EPS_EPSINIVW =||
     12||!AblationAttempted||Y||Y||
     13||!AblationComplications||Y||Y||
     14||!AblationEnergySource||Y||Y||
     15||AblationProcedure_s||Y||Y||
     16||!AccessoryPathway||Y||Y||
     17||!AfAblationStrategies||Y||Y||
     18||!AgeAtOperation||Y||Y||
     19||Anticoagulation||Y||Y||
     20||!ArterialRepair||Y||Y||
     21||!AuditTrail||Y||Y||
     22||!AvBlock||Y||Y||
     23||Bmi|| ||Y||
     24||Catheter||Y||Y||
     25||!CatheterCcad||Y||Y||
     26||!CatheterReach||Y||Y||
     27||!CatheterReachCcad||Y||Y||
     28||Ccso||Y||Y||
     29||!ChestDrain||Y||Y||
     30||Date_timeOfProcedure||Y||Y||
     31||!DateAddedToWaitingList||Y||Y||
     32||DateLastFollow_Up||Y||Y||
     33||!DateOfAdmission||Y||Y||
     34||!DateOfCurrentStatus||Y||Y||
     35||!DateOfDischarge||Y||Y||
     36||!DateOfEndStatus||Y||Y||
     37||!DateOfEntry|| ||Y||
     38||DateofEPSRFA||Y|| ||
     39||!DateTimeRecordCreated||Y||Y||
     40||!DateTimeRecordLastChanged||Y||Y||
     41||!DeathOnSameAdmission||Y||Y||
     42||!DeviceImplanted||Y||Y||
     43||Early_24hrs_Recurrence||Y||Y||
     44||!EnteredByTag||Y||Y||
     45||!EntryCurrentStatus||Y||Y||
     46||!EntryEndStatus||Y||Y||
     47||!EntryId||Y||Y||
     48||!EntryStatus||Y||Y||
     49||Eps_ablationIndicationForIntervention||Y||Y||
     50||!ExceededDrl|| ||Y||
     51||!FirstOperatorStatus||Y||Y||
     52||Ga||Y||Y||
     53||!GeneratorPacingMode||Y||Y||
     54||!GpPracticeCode||Y||Y||
     55||Height|| ||Y||
     56||HeparinDose_iu||Y||Y||
     57||!HospitalIdentifier||Y||Y||
     58||!HospitalTag||Y||Y||
     59||!ImportLinkId|| ||Y||
     60||IntraopDrugs2||Y||Y||
     61||IsThisARe_Do||Y||Y||
     62||!LateRecurrenceOfArrhythmia||Y||Y||
     63||!MappingTechnique||Y||Y||
     64||!MedicalRecordNumberAtTimeOfEntry||Y||Y||
     65||!NameOfReferringGpOrDentist||Y||Y||
     66||!NextEntry||Y||Y||
     67||!NumberOfElectrodeCatheters||Y||Y||
     68||!NumberOfEnergyApplications||Y||Y||
     69||!OperativeUrgency||Y||Y||
     70||!PatientAdminStatus||Y||Y||
     71||!PatientEthnicGroup||Y||Y||
     72||!PatientGender||Y||Y||
     73||!PatientId||Y||Y||
     74||Pct||Y||Y||
     75||!PericardialTap||Y||Y||
     76||!PostOpStay||Y||Y||
     77||Preeps_ablationAetiology2||Y||Y||
     78||Preeps_ablationArrhythmia||Y||Y||
     79||Preeps_ablationEcg||Y||Y||
     80||Preeps_ablationPreviousIntervention||Y||Y||
     81||Preicd_ablationQrsDuration||Y||Y||
     82||!PreOpStay||Y||Y||
     83||Prepacing_eps_ablationPresentingSymptom||Y||Y||
     84||!PreviousEntry||Y||Y||
     85||!PrimaryOperator||Y||Y||
     86||!ProcedureDuration||Y||Y||
     87||!ProcedureEndTime||Y||Y||
     88||ProcedureReport_comment||Y||Y||
     89||!ProcedureStartTime||Y||Y||
     90||!ProcedureUrgency||Y||Y||
     91||Radiographer|| ||Y||
     92||!ReasonForExceedingDrl|| ||Y||
     93||!ReferringGpOrDentist||Y||Y||
     94||Score||Y||Y||
     95||!ScreeningDose|| ||Y||
     96||!SecondOperator||Y||Y||
     97||!SecondOperatorStatus||Y||Y||
     98||Success||Y||Y||
     99||!ThirdOperator||Y||Y||
     100||!ThirdOperatorStatus||Y||Y||
     101||TimeofEPSRFA||Y||Y||
     102||TimeToRecurrence_months||Y||Y||
     103||!TotalFluoroscopyTime||Y||Y||
     104||!TotalHospitalStay||Y||Y||
     105||!TotalTimeOfEnergyApplication||Y||Y||
     106||!TotalTimeOnWaitingList||Y||Y||
     107||!TransientHeartBlock||Y||Y||
     108||!TransseptalApproach||Y||Y||
     109||Tvac_pvac|| ||Y||
     110||!WaitingTime||Y||Y||
     111||Weight|| ||Y||
     112||!WhichPulmonaryVeinsAblated||Y||Y||
     113||!WhyAblationNotAttempted||Y||Y||