Changes between Version 4 and Version 5 of i2b2 - UHL clinical informatics system integration PATS Combined Minap


Ignore:
Timestamp:
04/02/13 14:30:58 (12 years ago)
Author:
Richard Bramley
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • i2b2 - UHL clinical informatics system integration PATS Combined Minap

    v4 v5  
    33Start Date Field: !DateofHospitalAdmission
    44
    5 ||'''Field Name'''||'''Type'''||'''Comments'''||GGHMINAP_GGHMINAP||
    65||~~!EntryId~~||int||Ignored For Field Name||Y||
    76||~~!PatientId~~||int||Ignored For Field Name||Y||
    87||~~!DateofHospitalAdmission~~||datetime||Ignored For Datatype||Y||
    98||~~!TimeofHospitalAdmission~~||datetime||Ignored For Datatype||Y||
    10 ||!EntryStatus||varchar||||Y||
     9||!EntryStatus||varchar|| ||Y||
    1110||~~!PreviousEntry~~||int||Ignored For Field Name||Y||
    1211||~~!NextEntry~~||int||Ignored For Field Name||Y||
    13 ||Age||int||||Y||
     12||Age||int|| ||Y||
    1413||~~!DateOfAdmissionToCcu~~||datetime||Ignored For Datatype||Y||
    15 ||!DirectAdmission||varchar||||Y||
    16 ||!GenderCcad||varchar||||Y||
    17 ||!EthnicOriginCcad||varchar||||Y||
    18 ||!PatientAdminStatusCcad||varchar||||Y||
    19 ||!HospitalCentreCode||varchar||||Y||
     14||!DirectAdmission||varchar|| ||Y||
     15||!GenderCcad||varchar|| ||Y||
     16||!EthnicOriginCcad||varchar|| ||Y||
     17||!PatientAdminStatusCcad||varchar|| ||Y||
     18||!HospitalCentreCode||varchar|| ||Y||
    2019||~~!GpPracticeCodeCcad~~||varchar||Ignored For No Enum||Y||
    21 ||!InitialDiagnosisCcad||varchar||||Y||
    22 ||!OtherAdmissionDiagnosis||varchar||||Y||
    23 ||!MethodOfAdmissionCcad||varchar||||Y||
    24 ||!EcgDeterminingTreatmentCcad||varchar||||Y||
    25 ||WhereWasAspirin_otherAntiplateletGivenCcad||varchar||||Y||
    26 ||!PreviousAmiCcad||varchar||||Y||
    27 ||!PreviousAnginaCcad||varchar||||Y||
    28 ||!HypertensionCcad||varchar||||Y||
    29 ||!HypercholesterolaemiaCcad||varchar||||Y||
    30 ||!PeripheralVascularDiseaseCcad||varchar||||Y||
    31 ||!CerebrovascularDiseaseCcad||varchar||||Y||
    32 ||!AsthmaOrCopdCcad||varchar||||Y||
    33 ||!ChronicRenalFailureCcad||varchar||||Y||
    34 ||!HeartFailureCcad||varchar||||Y||
    35 ||CardiacEnzymes_markersRaisedCcad||varchar||||Y||
    36 ||!SerumCholesterolCcad||float||||Y||
    37 ||!SmokingStatusCcad||varchar||||Y||
    38 ||!DiabetesCcad||varchar||||Y||
    39 ||!PreviousPciCcad||varchar||||Y||
    40 ||!PreviousCabgCcad||varchar||||Y||
    41 ||!SystolicBpCcad||int||||Y||
    42 ||!HeartRateCcad||int||||Y||
    43 ||!AdmittingConsultantCcad||varchar||||Y||
    44 ||PlaceFirst12LeadEcgPerformedCcad||varchar||||Y||
    45 ||!BetaBlockerUseCcad||varchar||||Y||
    46 ||Ace1OrArbUseCcad||varchar||||Y||
    47 ||!StatinUseCcad||varchar||||Y||
    48 ||!ClopidogrelUseCcad||varchar||||Y||
    49 ||!HeightCcad||float||||Y||
    50 ||!WeightCcad||float||||Y||
    51 ||!LeftVentricularEjectionFractionCcad||varchar||||Y||
    52 ||!FamilyHistoryOfChdCcad||varchar||||Y||
    53 ||!AmbulanceDriver||varchar||||Y||
    54 ||!AmbulanceAttendant||varchar||||Y||
    55 ||!AmbulanceResponder||varchar||||Y||
     20||!InitialDiagnosisCcad||varchar|| ||Y||
     21||!OtherAdmissionDiagnosis||varchar|| ||Y||
     22||!MethodOfAdmissionCcad||varchar|| ||Y||
     23||!EcgDeterminingTreatmentCcad||varchar|| ||Y||
     24||WhereWasAspirin_otherAntiplateletGivenCcad||varchar|| ||Y||
     25||!PreviousAmiCcad||varchar|| ||Y||
     26||!PreviousAnginaCcad||varchar|| ||Y||
     27||!HypertensionCcad||varchar|| ||Y||
     28||!HypercholesterolaemiaCcad||varchar|| ||Y||
     29||!PeripheralVascularDiseaseCcad||varchar|| ||Y||
     30||!CerebrovascularDiseaseCcad||varchar|| ||Y||
     31||!AsthmaOrCopdCcad||varchar|| ||Y||
     32||!ChronicRenalFailureCcad||varchar|| ||Y||
     33||!HeartFailureCcad||varchar|| ||Y||
     34||CardiacEnzymes_markersRaisedCcad||varchar|| ||Y||
     35||!SerumCholesterolCcad||float|| ||Y||
     36||!SmokingStatusCcad||varchar|| ||Y||
     37||!DiabetesCcad||varchar|| ||Y||
     38||!PreviousPciCcad||varchar|| ||Y||
     39||!PreviousCabgCcad||varchar|| ||Y||
     40||!SystolicBpCcad||int|| ||Y||
     41||!HeartRateCcad||int|| ||Y||
     42||!AdmittingConsultantCcad||varchar|| ||Y||
     43||PlaceFirst12LeadEcgPerformedCcad||varchar|| ||Y||
     44||!BetaBlockerUseCcad||varchar|| ||Y||
     45||Ace1OrArbUseCcad||varchar|| ||Y||
     46||!StatinUseCcad||varchar|| ||Y||
     47||!ClopidogrelUseCcad||varchar|| ||Y||
     48||!HeightCcad||float|| ||Y||
     49||!WeightCcad||float|| ||Y||
     50||!LeftVentricularEjectionFractionCcad||varchar|| ||Y||
     51||!FamilyHistoryOfChdCcad||varchar|| ||Y||
     52||!AmbulanceDriver||varchar|| ||Y||
     53||!AmbulanceAttendant||varchar|| ||Y||
     54||!AmbulanceResponder||varchar|| ||Y||
    5655||~~!TimeLeftScene~~||varchar||Ignored For No Enum||Y||
    5756||~~!OnsetOfSymptomsCcad~~||varchar||Ignored For No Enum||Y||
    … …  
    6160||~~!AmbulanceJobNumberCcad~~||varchar||Ignored For No Enum||Y||
    6261||~~!ArrivalAtHospitalCcad~~||varchar||Ignored For No Enum||Y||
    63 ||WasReperfusionAttempted_Ccad||varchar||||Y||
    64 ||!ReasonThrombolyticTreatmentNotGivenCcad||varchar||||Y||
     62||WasReperfusionAttempted_Ccad||varchar|| ||Y||
     63||!ReasonThrombolyticTreatmentNotGivenCcad||varchar|| ||Y||
    6564||~~!StartOfReperfusionTreatmentCcad~~||varchar||Ignored For No Enum||Y||
    66 ||!DelayBeforeTreatmentCcad||varchar||||Y||
    67 ||WhereWasInitialReperfusionTreatmentGiven_Ccad||varchar||||Y||
    68 ||WhoTookTheInitialDecisionToAttemptReperfusion_Ccad||varchar||||Y||
     65||!DelayBeforeTreatmentCcad||varchar|| ||Y||
     66||WhereWasInitialReperfusionTreatmentGiven_Ccad||varchar|| ||Y||
     67||WhoTookTheInitialDecisionToAttemptReperfusion_Ccad||varchar|| ||Y||
    6968||~~!FirstCardiacArrestCcad~~||varchar||Ignored For No Enum||Y||
    70 ||!CardiacArrestCcad||varchar||||Y||
    71 ||!ArrestPresentingRhythmCcad||varchar||||Y||
    72 ||!OutcomeOfArrestCcad||varchar||||Y||
    73 ||!AdmissionWardCcad||varchar||||Y||
    74 ||PeakCreatinineKinase_ck_Ccad||float||||Y||
    75 ||!PeakTroponinCcad||float||||Y||
    76 ||!TroponinAssayCcad||varchar||||Y||
    77 ||!TroponinReferenceValue||varchar||||Y||
    78 ||!UnfractionatedHeparinCcad||varchar||||Y||
    79 ||!LowMolecularWeightHeparinCcad||varchar||||Y||
    80 ||!ThienopyridinePlateletInhibitorCcad||varchar||||Y||
    81 ||!OtherOralAntiplateletAgentCcad||varchar||||Y||
    82 ||Iv2b_3aAgentCcad||varchar||||Y||
    83 ||!IvBetaBlockerCcad||varchar||||Y||
    84 ||!CalciumChannelBlockerCcad||varchar||||Y||
    85 ||!IvNitrateCcad||varchar||||Y||
    86 ||!OralNitratesCcad||varchar||||Y||
    87 ||!PotassiumChannelModulatorCcad||varchar||||Y||
    88 ||!WarfarinCcad||varchar||||Y||
    89 ||AngiotensinIiBlocker_arb_Ccad||varchar||||Y||
    90 ||!ThiazideDiureticCcad||varchar||||Y||
    91 ||!AdmissionPlasmaGlucoseCcad||float||||Y||
    92 ||!LoopDiureticCcad||varchar||||Y||
    93 ||!SpironolactoneCcad||varchar||||Y||
    94 ||!ThrombolyticDrugCcad||varchar||||Y||
     69||!CardiacArrestCcad||varchar|| ||Y||
     70||!ArrestPresentingRhythmCcad||varchar|| ||Y||
     71||!OutcomeOfArrestCcad||varchar|| ||Y||
     72||!AdmissionWardCcad||varchar|| ||Y||
     73||PeakCreatinineKinase_ck_Ccad||float|| ||Y||
     74||!PeakTroponinCcad||float|| ||Y||
     75||!TroponinAssayCcad||varchar|| ||Y||
     76||!TroponinReferenceValue||varchar|| ||Y||
     77||!UnfractionatedHeparinCcad||varchar|| ||Y||
     78||!LowMolecularWeightHeparinCcad||varchar|| ||Y||
     79||!ThienopyridinePlateletInhibitorCcad||varchar|| ||Y||
     80||!OtherOralAntiplateletAgentCcad||varchar|| ||Y||
     81||Iv2b_3aAgentCcad||varchar|| ||Y||
     82||!IvBetaBlockerCcad||varchar|| ||Y||
     83||!CalciumChannelBlockerCcad||varchar|| ||Y||
     84||!IvNitrateCcad||varchar|| ||Y||
     85||!OralNitratesCcad||varchar|| ||Y||
     86||!PotassiumChannelModulatorCcad||varchar|| ||Y||
     87||!WarfarinCcad||varchar|| ||Y||
     88||AngiotensinIiBlocker_arb_Ccad||varchar|| ||Y||
     89||!ThiazideDiureticCcad||varchar|| ||Y||
     90||!AdmissionPlasmaGlucoseCcad||float|| ||Y||
     91||!LoopDiureticCcad||varchar|| ||Y||
     92||!SpironolactoneCcad||varchar|| ||Y||
     93||!ThrombolyticDrugCcad||varchar|| ||Y||
    9594||~~!DateOfDischargeOrDeathCcad~~||datetime||Ignored For Datatype||Y||
    9695||~~!DateOfDischargeFromCcu~~||datetime||Ignored For Datatype||Y||
    97 ||!DischargedFromCcuDestination||varchar||||Y||
    98 ||!DischargeDiagnosisCcad||varchar||||Y||
    99 ||!OtherDischargeDiagnosis||varchar||||Y||
    100 ||!DiagamiCcad||varchar||||Y||
    101 ||!RecommendedTherapyAtDischargeCcad||varchar||||Y||
    102 ||!DaysInHospital||int||||Y||
    103 ||!DaysInCcu||int||||Y||
    104 ||!BleedingComplicationsCcad||varchar||||Y||
    105 ||!DeathInHospitalCcad||varchar||||Y||
    106 ||!DischargedOnBetaBlockerCcad||varchar||||Y||
    107 ||!AceInhibitorCcad||varchar||||Y||
    108 ||!DischargedOnStatinCcad||varchar||||Y||
    109 ||!DischargedOnAspirinOrOtherPlateletDrugCcad||varchar||||Y||
    110 ||!CardiacRehabilitationCcad||varchar||||Y||
    111 ||!ExerciseTestPerformedCcad||varchar||||Y||
    112 ||!EchocardiographyCcad||varchar||||Y||
    113 ||!RadionuclideStudyCcad||varchar||||Y||
    114 ||!CoronaryAngiographyAtThisAdmissionCcad||varchar||||Y||
    115 ||!CoronaryInterventionPerformedAtThisAdmissionCcad||varchar||||Y||
     96||!DischargedFromCcuDestination||varchar|| ||Y||
     97||!DischargeDiagnosisCcad||varchar|| ||Y||
     98||!OtherDischargeDiagnosis||varchar|| ||Y||
     99||!DiagamiCcad||varchar|| ||Y||
     100||!RecommendedTherapyAtDischargeCcad||varchar|| ||Y||
     101||!DaysInHospital||int|| ||Y||
     102||!DaysInCcu||int|| ||Y||
     103||!BleedingComplicationsCcad||varchar|| ||Y||
     104||!DeathInHospitalCcad||varchar|| ||Y||
     105||!DischargedOnBetaBlockerCcad||varchar|| ||Y||
     106||!AceInhibitorCcad||varchar|| ||Y||
     107||!DischargedOnStatinCcad||varchar|| ||Y||
     108||!DischargedOnAspirinOrOtherPlateletDrugCcad||varchar|| ||Y||
     109||!CardiacRehabilitationCcad||varchar|| ||Y||
     110||!ExerciseTestPerformedCcad||varchar|| ||Y||
     111||!EchocardiographyCcad||varchar|| ||Y||
     112||!RadionuclideStudyCcad||varchar|| ||Y||
     113||!CoronaryAngiographyAtThisAdmissionCcad||varchar|| ||Y||
     114||!CoronaryInterventionPerformedAtThisAdmissionCcad||varchar|| ||Y||
    116115||~~DateOfReferralForInvestigation_intervention~~||datetime||Ignored For Datatype||Y||
    117 ||!ModeOfDischargeCcad||varchar||||Y||
     116||!ModeOfDischargeCcad||varchar|| ||Y||
    118117||~~!DateOfTransferForDayCaseInvestigationCcad~~||datetime||Ignored For Datatype||Y||
    119118||~~!DateOfAngioPerformedLocallyCcad~~||datetime||Ignored For Datatype||Y||
    120119||~~!DateOfFirstInterventionOrSurgeryPerformedLocallyCc~~||datetime||Ignored For Datatype||Y||
    121 ||!ReferralCentreCcad||varchar||||Y||
    122 ||!ReferringHospitalCcad||varchar||||Y||
     120||!ReferralCentreCcad||varchar|| ||Y||
     121||!ReferringHospitalCcad||varchar|| ||Y||
    123122||~~!PatientCaseRecordNumberAtReferralCentreCcad~~||varchar||Ignored For No Enum||Y||
    124 ||!FollowedUpByCcad||varchar||||Y||
    125 ||!ReinfarctionCcad||varchar||||Y||
    126 ||!DischargedOnClopidogrelCcad||varchar||||Y||
    127 ||!DelayFromOnsetOfSymptomsToCallForHelp||float||||Y||
    128 ||!DelayFromCallForHelpToArrivalOfEmergencyServices||float||||Y||
    129 ||!DelayFromCallForHelpToArrivalInHospital||float||||Y||
    130 ||!DelayFromArrivalInHospitalToReperfusionTreatment||float||||Y||
    131 ||!DelayFromCallForHelpToReperfusionTreatment||float||||Y||
    132 ||!DelayFromOnsetOfSymptomsToReperfusionTreatment||float||||Y||
    133 ||!TotalTimeOnScene||float||||Y||
    134 ||DelayFromReferralForInvestigation_interventionToTr||float||||Y||
     123||!FollowedUpByCcad||varchar|| ||Y||
     124||!ReinfarctionCcad||varchar|| ||Y||
     125||!DischargedOnClopidogrelCcad||varchar|| ||Y||
     126||!DelayFromOnsetOfSymptomsToCallForHelp||float|| ||Y||
     127||!DelayFromCallForHelpToArrivalOfEmergencyServices||float|| ||Y||
     128||!DelayFromCallForHelpToArrivalInHospital||float|| ||Y||
     129||!DelayFromArrivalInHospitalToReperfusionTreatment||float|| ||Y||
     130||!DelayFromCallForHelpToReperfusionTreatment||float|| ||Y||
     131||!DelayFromOnsetOfSymptomsToReperfusionTreatment||float|| ||Y||
     132||!TotalTimeOnScene||float|| ||Y||
     133||DelayFromReferralForInvestigation_interventionToTr||float|| ||Y||
    135134||~~!PctCode~~||varchar||Ignored For No Enum||Y||
    136135||~~!MedicalRecordNumberAtTimeOfEntryCcad~~||varchar||Ignored For No Enum||Y||
    137136||~~Comments~~||varchar||Ignored For No Enum||Y||
    138 ||!PreAlertCall||varchar||||Y||
     137||!PreAlertCall||varchar|| ||Y||
    139138||~~!PickUpPostCode~~||varchar||Ignored For No Enum||Y||
    140 ||!CardiacNurseInAttendance||varchar||||Y||
    141 ||Cox_2InhibitorUse||varchar||||Y||
    142 ||!NsaidUse||varchar||||Y||
    143 ||!NitrateUse||varchar||||Y||
    144 ||!CalciumChannelBlockerUse||varchar||||Y||
    145 ||Spironolactone||varchar||||Y||
    146 ||Eplerenone||varchar||||Y||
    147 ||Nitrates||varchar||||Y||
    148 ||Warfarin||varchar||||Y||
    149 ||Other||varchar||||Y||
    150 ||!DateAndTimeOfFirstDiagnosticEcg||varchar||||Y||
    151 ||!AuditTrail||varchar||||Y||
    152 ||!DaysFromAdmissionToDeath||int||||Y||
     139||!CardiacNurseInAttendance||varchar|| ||Y||
     140||Cox_2InhibitorUse||varchar|| ||Y||
     141||!NsaidUse||varchar|| ||Y||
     142||!NitrateUse||varchar|| ||Y||
     143||!CalciumChannelBlockerUse||varchar|| ||Y||
     144||Spironolactone||varchar|| ||Y||
     145||Eplerenone||varchar|| ||Y||
     146||Nitrates||varchar|| ||Y||
     147||Warfarin||varchar|| ||Y||
     148||Other||varchar|| ||Y||
     149||!DateAndTimeOfFirstDiagnosticEcg||varchar|| ||Y||
     150||!AuditTrail||varchar|| ||Y||
     151||!DaysFromAdmissionToDeath||int|| ||Y||
    153152||~~!DateOfCurrentStatus~~||datetime||Ignored For Datatype||Y||
    154153||~~!DateOfEndStatus~~||datetime||Ignored For Datatype||Y||
    155154||~~!DateTimeRecordCreated~~||datetime||Ignored For Datatype||Y||
    156155||~~!DateTimeRecordLastChanged~~||datetime||Ignored For Datatype||Y||
    157 ||!EnteredByTag||varchar||||Y||
    158 ||!EntryCurrentStatus||varchar||||Y||
    159 ||!EntryEndStatus||varchar||||Y||
    160 ||!HospitalTag||varchar||||Y||
     156||!EnteredByTag||varchar|| ||Y||
     157||!EntryCurrentStatus||varchar|| ||Y||
     158||!EntryEndStatus||varchar|| ||Y||
     159||!HospitalTag||varchar|| ||Y||