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


Ignore:
Timestamp:
04/02/13 14:27:26 (13 years ago)
Author:
Richard Bramley
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • i2b2 - UHL clinical informatics system integration PATS Combined Minap

    v2 v3  
    11[[i2b2 - UHL clinical informatics system integration PATS Mappings v1|back]]
    22
     3Start Date Field: !DateofHospitalAdmission
     4
     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||||