Changes between Version 3 and Version 4 of i2b2 - UHL clinical informatics system integration PATS CATH Combined


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

--

Legend:

Unmodified
Added
Removed
Modified

  • i2b2 - UHL clinical informatics system integration PATS CATH Combined

    v3 v4  
    44
    55||= Table =||= Date Range =||= Start Date Field =||= Records =||
    6 ||EPS_EPS||2003-2007||!DateOfAdmission||2170||
    7 ||EPS_EPSINIVW||2007-2012||!DateOfAdmission||5116||
     6||CATH_CATH||2000-2007||!DateOfCatheter||31150||
     7||CATH_CATHINITIALVW||1899(sic)-2013||!DateOfCatheter||51325||
    88
    99== Columns
    1010
    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||
     11||= Column =||= CATH_CATH =||= CATH_CATHINITIALVW =||
     12||!AdministrativeCategory||Y||Y||
     13||!AgeAtCatheter||Y||Y||
     14||Arterial_1||Y||Y||
     15||Arterial_2||Y||Y||
     16||Arterial_3||Y||Y||
     17||!AuditLoopClosed||Y||Y||
    2118||!AuditTrail||Y||Y||
    22 ||!AvBlock||Y||Y||
     19||!BiopsySite||Y||Y||
     20||!BiopsyTaken||Y||Y||
    2321||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||
     22||!CatheterProcedureReport|| ||Y||
     23||Complicated_1_Arterial||Y||Y||
     24||Complicated_1_Venous||Y||Y||
     25||Complicated_2_Venous||Y||Y||
     26||Complicated_3_Arterial||Y||Y||
     27||Complicated_3_Venous||Y||Y||
     28||Complicated2Arterial||Y||Y||
     29||Consultant||Y||Y||
     30||!ConsultantCode|| ||Y||
     31||Contract||Y||Y||
     32||!CoronaryDisease||Y||Y||
     33||!DateAndTimeOfProcedure||Y||Y||
     34||!DateAuditLoopClosed||Y||Y||
    3335||!DateOfAdmission||Y||Y||
     36||!DateofCatheter||Y||Y||
    3437||!DateOfCurrentStatus||Y||Y||
     38||!DateOfDeath||Y||Y||
     39||!DateOfDeathPostDischarge||Y||Y||
    3540||!DateOfDischarge||Y||Y||
    3641||!DateOfEndStatus||Y||Y||
    37 ||!DateOfEntry|| ||Y||
    38 ||DateofEPSRFA||Y|| ||
     42||!DateOnWaitingList||Y||Y||
    3943||!DateTimeRecordCreated||Y||Y||
    4044||!DateTimeRecordLastChanged||Y||Y||
    41 ||!DeathOnSameAdmission||Y||Y||
    42 ||!DeviceImplanted||Y||Y||
    43 ||Early_24hrs_Recurrence||Y||Y||
     45||!DaysOnList||Y||Y||
     46||Death||Y||Y||
     47||!DiedInCathLab||Y||Y||
     48||!DischargeComplications||Y||Y||
     49||!DischargeTo||Y||Y||
     50||!DoneInMobileLab||Y||Y||
     51||!EmbolicSequelae||Y||Y||
    4452||!EnteredByTag||Y||Y||
    4553||!EntryCurrentStatus||Y||Y||
    … …  
    4755||!EntryId||Y||Y||
    4856||!EntryStatus||Y||Y||
    49 ||Eps_ablationIndicationForIntervention||Y||Y||
    5057||!ExceededDrl|| ||Y||
    51 ||!FirstOperatorStatus||Y||Y||
    52 ||Ga||Y||Y||
    53 ||!GeneratorPacingMode||Y||Y||
     58||!FormsVerified||Y||Y||
     59||!FurtherProcedure||Y||Y||
     60||!GeneralAnaesthetics||Y||Y||
    5461||!GpPracticeCode||Y||Y||
     62||!GroinComplication||Y||Y||
    5563||Height|| ||Y||
    56 ||HeparinDose_iu||Y||Y||
    57 ||!HospitalIdentifier||Y||Y||
    5864||!HospitalTag||Y||Y||
     65||!IfOtherPreDischargeComplicationsPleaseState|| ||Y||
     66||IhdScore_cardwl||Y||Y||
     67||!ImmediateComplications||Y||Y||
    5968||!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||
     69||IntervalBetweenProc_LoopClosed_days||Y||Y||
     70||!IsThisAcs|| ||Y||
     71||!MedicalRecordNumber||Y||Y||
    6672||!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||NihdScore_cardwl||Y||Y||
     74||!NonEmergencySurgery||Y||Y||
     75||Operator||Y||Y||
     76||!OperatorCode|| ||Y||
     77||!OtherComplications||Y||Y||
     78||!OtherComplicationsPreDischarge||Y||Y||
     79||!OtherProcedure||Y||Y||
     80||Outcome||Y||Y||
     81||!OutcomeOfCatheter||Y||Y||
    7382||!PatientId||Y||Y||
     83||!PatientType||Y||Y||
     84||Pcg||Y||Y||
    7485||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||
     86||PostOpStay_days||Y||Y||
     87||PostProcedureDeathInterval_days||Y||Y||
     88||!PreDischargeComplications|| ||Y||
     89||PreopStay_days||Y||Y||
    8490||!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||!ProcedureAbandoned||Y||Y||
     92||!ProcedureSite||Y||Y||
     93||!ProcedureType||Y||Y||
    9194||Radiographer|| ||Y||
     95||!ReasonAuditLoopClosed||Y||Y||
     96||!ReasonForAbandoningProcedure||Y||Y||
    9297||!ReasonForExceedingDrl|| ||Y||
    93 ||!ReferringGpOrDentist||Y||Y||
    94 ||Score||Y||Y||
     98||!ReturnedTo||Y||Y||
     99||!ReturnToCathLab||Y||Y||
    95100||!ScreeningDose|| ||Y||
     101||!ScreeningTime|| ||Y||
    96102||!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||
     103||!SecondOperatorCode|| ||Y||
     104||Shunt_baffle||Y|| ||
     105||!SignificantLvDisease||Y||Y||
     106||!SignificantValveDisease||Y||Y||
     107||Sub_Xiphoid|| ||Y||
     108||Technician||Y||Y||
     109||!TimeofCatheter||Y||Y||
    104110||!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||!TroponinPositive|| ||Y||
     112||Venous_1||Y||Y||
     113||Venous_2||Y||Y||
     114||Venous_3||Y||Y||
     115||Vessel_1_Arterial||Y||Y||
     116||Vessel_1_Venous||Y||Y||
     117||Vessel_2_Arterial||Y||Y||
     118||Vessel_2_Venous||Y||Y||
     119||Vessel_3_Arterial||Y||Y||
     120||Vessel_3_Venous||Y||Y||
     121||Vessels||Y||Y||
     122||!WasThePatientCatheterised||Y||Y||
    111123||Weight|| ||Y||
    112 ||!WhichPulmonaryVeinsAblated||Y||Y||
    113 ||!WhyAblationNotAttempted||Y||Y||