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


Ignore:
Timestamp:
03/15/13 08:57:05 (11 years ago)
Author:
Richard Bramley
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • i2b2 - UHL clinical informatics system integration PATS GGHMINAP_GGHMINAP

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