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


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

--

Legend:

Unmodified
Added
Removed
Modified

  • i2b2 - UHL clinical informatics system integration PATS GGHMINAPNEW

    v1 v1  
     1[[i2b2 - UHL clinical informatics system integration PATS Mappings v1|back]]
     2
     3Start Date Field: !DateofAdmissiontoCCU
     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||~~!DateofAdmissiontoCCU~~||3||datetime||Ignored For Datatype||
     9||~~!TimeofAdmissiontoCCU~~||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||~~!OnsetOfSymptomsCcad~~||8||varchar||Ignored For No Enum||
     14||!MethodOfAdmissionCcad||9||varchar||||
     15||~~!CallForHelpCcad~~||10||varchar||Ignored For No Enum||
     16||~~!ArrivalOfEmergencyServiceCcad~~||11||varchar||Ignored For No Enum||
     17||~~!ArrivalAtHospitalCcad~~||12||varchar||Ignored For No Enum||
     18||~~!DateAndTimeOfReperfusionTreatmentCcad~~||13||varchar||Ignored For No Enum||
     19||~~!FirstCardiacArrestCcad~~||14||varchar||Ignored For No Enum||
     20||!CardiacArrestLocationCcad||15||varchar||||
     21||!ArrestPresentingRhythmCcad||16||varchar||||
     22||!OutcomeOfArrestCcad||17||varchar||||
     23||!InitialDiagnosisCcad||18||varchar||||
     24||!EcgDeterminingTreatmentCcad||19||varchar||||
     25||!AdditionalReperfusionTreatmentCcad||20||varchar||||
     26||WhereWasInitialReperfusionTreatmentGiven_Ccad||21||varchar||||
     27||WhoTookTheInitialDecisionToAttemptReperfusion_Ccad||22||varchar||||
     28||!ReasonReperfusionTreatmentNotGivenCcad||23||varchar||||
     29||Age||24||int||||
     30||WhereWasAspirin_otherAntiplateletGivenCcad||25||varchar||||
     31||!AdmissionWardCcad||26||varchar||||
     32||!AdmittingConsultantCcad||27||varchar||||
     33||!DischargeDiagnosisCcad||28||varchar||||
     34||!DeathInHospitalCcad||29||varchar||||
     35||~~!DateOfDischargeOrDeathCcad~~||30||datetime||Ignored For Datatype||
     36||!DischargedOnBetaBlockerCcad||31||varchar||||
     37||!AceInhibitorCcad||32||varchar||||
     38||!DischargedOnStatinCcad||33||varchar||||
     39||!DischargedOnAspirinOrOtherPlateletDrugCcad||34||varchar||||
     40||!CardiacRehabilitationCcad||35||varchar||||
     41||!ExerciseTestPerformedCcad||36||varchar||||
     42||!EchocardiographyCcad||37||varchar||||
     43||!RadionuclideStudyCcad||38||varchar||||
     44||!CoronaryAngiographyCcad||39||varchar||||
     45||!CoronaryInterventionCcad||40||varchar||||
     46||!GenderCcad||41||varchar||||
     47||!DelayBeforeTreatmentCcad||42||varchar||||
     48||!DaysInHospital||43||int||||
     49||!DelayFromOnsetOfSymptomsToCallForHelp||44||float||||
     50||!DelayFromCallForHelpToArrivalOfEmergencyServices||45||float||||
     51||!DelayFromCallForHelpToArrivalInHospital||46||float||||
     52||!DelayFromArrivalInHospitalToReperfusionTreatment||47||float||||
     53||!DelayFromCallForHelpToReperfusionTreatment||48||float||||
     54||!DelayFromOnsetOfSymptomsToReperfusionTreatment||49||float||||
     55||~~!AmbulanceJobNumberCcad~~||50||varchar||Ignored For No Enum||
     56||PeakCreatinineKinase_ck_Ccad||51||float||||
     57||!PeakTroponinCcad||52||float||||
     58||!TroponinAssayCcad||53||varchar||||
     59||!TroponinReferenceValue||54||varchar||||
     60||!PatientAdminStatusCcad||55||varchar||||
     61||!PreviousAmiCcad||56||varchar||||
     62||!PreviousAnginaCcad||57||varchar||||
     63||!HypertensionCcad||58||varchar||||
     64||!HypercholesterolaemiaCcad||59||varchar||||
     65||!PeripheralVascularDiseaseCcad||60||varchar||||
     66||!CerebrovascularDiseaseCcad||61||varchar||||
     67||!AsthmaOrCopdCcad||62||varchar||||
     68||!ChronicRenalFailureCcad||63||varchar||||
     69||!HeartFailureCcad||64||varchar||||
     70||CardiacEnzymes_markersRaisedCcad||65||varchar||||
     71||!SerumCholesterolCcad||66||float||||
     72||!SmokingStatusCcad||67||varchar||||
     73||!DiabetesCcad||68||varchar||||
     74||!PreviousPciCcad||69||varchar||||
     75||!PreviousCabgCcad||70||varchar||||
     76||!SystolicBpCcad||71||int||||
     77||!HeartRateCcad||72||int||||
     78||~~!ArrivalOfFirstProfessionalHelpCcad~~||73||varchar||Ignored For No Enum||
     79||!UnfractionatedHeparinCcad||74||varchar||||
     80||!LowMolecularWeightHeparinCcad||75||varchar||||
     81||!ThienopyridinePlateletInhibitorCcad||76||varchar||||
     82||!OtherOralAntiplateletAgentCcad||77||varchar||||
     83||Iv2b_3aAgentCcad||78||varchar||||
     84||!IvBetaBlockerCcad||79||varchar||||
     85||!CalciumChannelBlockerCcad||80||varchar||||
     86||!IvNitrateCcad||81||varchar||||
     87||!OralNitratesCcad||82||varchar||||
     88||!PotassiumChannelModulatorCcad||83||varchar||||
     89||!WarfarinCcad||84||varchar||||
     90||AngiotensinIiBlocker_arb_Ccad||85||varchar||||
     91||!ThiazideDiureticCcad||86||varchar||||
     92||!LoopDiureticCcad||87||varchar||||
     93||!SpironolactoneCcad||88||varchar||||
     94||!ThrombolyticDrugCcad||89||varchar||||
     95||!BleedingComplicationsCcad||90||varchar||||
     96||!DischargeDestinationCcad||91||varchar||||
     97||~~DateOfReferralForInvestigation_intervention~~||92||datetime||Ignored For Datatype||
     98||~~!DaycaseTransferDateCcad~~||93||datetime||Ignored For Datatype||
     99||~~!LocalAngioDateCcad~~||94||datetime||Ignored For Datatype||
     100||~~!LocalInterventionDateCcad~~||95||datetime||Ignored For Datatype||
     101||!InterventionalCentreCodeCcad||96||varchar||||
     102||!OtherAdmissionDiagnosis||97||varchar||||
     103||!OtherDischargeDiagnosis||98||varchar||||
     104||!DischargedFromCcuDestination||99||varchar||||
     105||~~Gp_pctCodeCcad~~||100||varchar||Ignored For No Enum||
     106||DelayFromReferralForInvestigation_interventionToTr||101||float||||
     107||~~!PctCode~~||102||varchar||Ignored For No Enum||
     108||~~!MedicalRecordNumberAtTimeOfEntryCcad~~||103||varchar||Ignored For No Enum||
     109||!SerumGlucoseCcad||104||float||||
     110||!DiabeticTherapyAtDischargeCcad||105||varchar||||
     111||!AuditTrail||106||varchar||||
     112||PlaceFirst12LeadEcgPerformedCcad||107||varchar||||
     113||!BetaBlockerUseCcad||108||varchar||||
     114||Ace1OrArbUseCcad||109||varchar||||
     115||!StatinUseCcad||110||varchar||||
     116||!ClopidogrelUseCcad||111||varchar||||
     117||!HeightCcad||112||float||||
     118||!WeightCcad||113||float||||
     119||!LeftVentricularEjectionFractionCcad||114||varchar||||
     120||!FamilyHistoryOfChdCcad||115||varchar||||
     121||!FollowedUpByCcad||116||varchar||||
     122||!ReinfarctionCcad||117||varchar||||
     123||!DischargedOnClopidogrelCcad||118||varchar||||
     124||!ReferringHospitalCodeCcad||119||varchar||||
     125||~~!PatientCaseRecordNumberAtReferringHospitalCcad~~||120||varchar||Ignored For No Enum||
     126||!AmbulanceDriver||121||varchar||||
     127||!AmbulanceAttendant||122||varchar||||
     128||!AmbulanceResponder||123||varchar||||
     129||Comments||124||varchar||||
     130||!PreAlertCall||125||varchar||||
     131||~~!PickUpPostCode~~||126||varchar||Ignored For No Enum||
     132||!CardiacNurseInAttendance||127||varchar||||
     133||Cox_2InhibitorUse||128||varchar||||
     134||!NsaidUse||129||varchar||||
     135||!NitrateUse||130||varchar||||
     136||!CalciumChannelBlockerUse||131||varchar||||
     137||Spironolactone||132||varchar||||
     138||Eplerenone||133||varchar||||
     139||Nitrates||134||varchar||||
     140||Warfarin||135||varchar||||
     141||Other||136||varchar||||
     142||~~!TimeLeftScene~~||137||varchar||Ignored For No Enum||
     143||!HospitalCentreCode||138||varchar||||
     144||!TotalTimeOnScene||139||float||||
     145||~~!DateAndTimeOfFirstDiagnosticEcg~~||140||varchar||Ignored For No Enum||
     146||!CardiologicalCareDuringAdmissionCcad||141||varchar||||
     147||!CreatinineCcad||142||float||||
     148||!HaemoglobinCcad||143||float||||
     149||!SiteOfInfarctionCcad||144||varchar||||
     150||!FondaparinuxCcad||145||varchar||||
     151||!InitialReperfusionTreatmentCcad||146||varchar||||
     152||InPatientManagementOfHyperglycaemia_diabetesCcad||147||varchar||||
     153||~~!DateOfReturnToReferringHospital~~||148||datetime||Ignored For Datatype||
     154||!DelayForCallToFrv||149||float||||
     155||!DelayFrvToFullCrew||150||float||||
     156||!DelayCallToDepart||151||float||||
     157||!PatientEthnicGroup||152||varchar||||
     158||IncludeInD2n||153||varchar||||
     159||~~!OtherComments~~||154||varchar||Ignored For No Enum||
     160||!CathLabArrivalTime||155||varchar||||
     161||!BalloonTime||156||varchar||||
     162||!DelayCcuToLab||157||float||||
     163||!DelayCallToBalloon||158||float||||
     164||!DelayDoorToBalloon||159||float||||
     165||!DelayLabToBalloon||160||float||||
     166||!IncludeInCallToNeedle||161||varchar||||
     167||!HospitalRefferedFrom||162||varchar||||
     168||FirstMustafa1||163||int||||
     169||SecondMustafa2||164||int||||
     170||!DaysFromAdmissionToDeath||165||int||||
     171||~~!DateOfCurrentStatus~~||166||datetime||Ignored For Datatype||
     172||~~!DateOfEndStatus~~||167||datetime||Ignored For Datatype||
     173||~~!DateTimeRecordCreated~~||168||datetime||Ignored For Datatype||
     174||~~!DateTimeRecordLastChanged~~||169||datetime||Ignored For Datatype||
     175||!EnteredByTag||170||varchar||||
     176||!EntryCurrentStatus||171||varchar||||
     177||!EntryEndStatus||172||varchar||||
     178||!HospitalTag||173||varchar||||