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


Ignore:
Timestamp:
04/02/13 14:28:37 (11 years ago)
Author:
Richard Bramley
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • i2b2 - UHL clinical informatics system integration PATS Combined Minap

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