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


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

--

Legend:

Unmodified
Added
Removed
Modified

  • i2b2 - UHL clinical informatics system integration PATS GGHMINAPNEW_GGHMINAPINIVW

    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||date||Ignored For Datatype||
     9||~~!TimeofAdmissiontoCCU~~||4||time||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||date||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||date||Ignored For Datatype||
     98||~~!DaycaseTransferDateCcad~~||93||date||Ignored For Datatype||
     99||~~!LocalAngioDateCcad~~||94||date||Ignored For Datatype||
     100||~~!LocalInterventionDateCcad~~||95||date||Ignored For Datatype||
     101||!OtherAdmissionDiagnosis||96||varchar||||
     102||!OtherDischargeDiagnosis||97||varchar||||
     103||!DischargedFromCcuDestination||98||varchar||||
     104||~~Gp_pctCodeCcad~~||99||varchar||Ignored For No Enum||
     105||DelayFromReferralForInvestigation_interventionToTr||100||float||||
     106||~~!PctCode~~||101||varchar||Ignored For No Enum||
     107||~~!MedicalRecordNumberAtTimeOfEntryCcad~~||102||varchar||Ignored For No Enum||
     108||!SerumGlucoseCcad||103||float||||
     109||!DiabeticTherapyAtDischargeCcad||104||varchar||||
     110||~~!AuditTrail~~||105||text||Ignored For Datatype||
     111||PlaceFirst12LeadEcgPerformedCcad||106||varchar||||
     112||!BetaBlockerUseCcad||107||varchar||||
     113||Ace1OrArbUseCcad||108||varchar||||
     114||!StatinUseCcad||109||varchar||||
     115||!ClopidogrelUseCcad||110||varchar||||
     116||!HeightCcad||111||float||||
     117||!WeightCcad||112||float||||
     118||!LeftVentricularEjectionFractionCcad||113||varchar||||
     119||!FamilyHistoryOfChdCcad||114||varchar||||
     120||!FollowedUpByCcad||115||varchar||||
     121||!ReinfarctionCcad||116||varchar||||
     122||!DischargedOnClopidogrelCcad||117||varchar||||
     123||~~!PatientCaseRecordNumberAtReferringHospitalCcad~~||118||varchar||Ignored For No Enum||
     124||!AmbulanceDriver||119||varchar||||
     125||!AmbulanceAttendant||120||varchar||||
     126||!AmbulanceResponder||121||varchar||||
     127||~~Comments~~||122||text||Ignored For Datatype||
     128||!PreAlertCall||123||varchar||||
     129||~~!PickUpPostCode~~||124||varchar||Ignored For No Enum||
     130||!CardiacNurseInAttendance||125||varchar||||
     131||Cox_2InhibitorUse||126||varchar||||
     132||!NsaidUse||127||varchar||||
     133||!NitrateUse||128||varchar||||
     134||!CalciumChannelBlockerUse||129||varchar||||
     135||Spironolactone||130||varchar||||
     136||Eplerenone||131||varchar||||
     137||Nitrates||132||varchar||||
     138||Warfarin||133||varchar||||
     139||Other||134||varchar||||
     140||~~!TimeLeftScene~~||135||varchar||Ignored For No Enum||
     141||!HospitalCentreCode||136||varchar||||
     142||!TotalTimeOnScene||137||float||||
     143||~~!DateAndTimeOfFirstDiagnosticEcg~~||138||varchar||Ignored For No Enum||
     144||!CardiologicalCareDuringAdmissionCcad||139||varchar||||
     145||!CreatinineCcad||140||float||||
     146||!HaemoglobinCcad||141||float||||
     147||!SiteOfInfarctionCcad||142||varchar||||
     148||!FondaparinuxCcad||143||varchar||||
     149||!InitialReperfusionTreatmentCcad||144||varchar||||
     150||InPatientManagementOfHyperglycaemia_diabetesCcad||145||varchar||||
     151||~~!DateOfReturnToReferringHospital~~||146||date||Ignored For Datatype||
     152||!DelayForCallToFrv||147||float||||
     153||!DelayFrvToFullCrew||148||float||||
     154||!DelayCallToDepart||149||float||||
     155||!PatientEthnicGroup||150||varchar||||
     156||IncludeInD2n||151||varchar||||
     157||~~!OtherComments~~||152||varchar||Ignored For No Enum||
     158||!CathLabArrivalTime||153||varchar||||
     159||!BalloonTime||154||varchar||||
     160||!DelayCcuToLab||155||float||||
     161||!DelayCallToBalloon||156||float||||
     162||!DelayDoorToBalloon||157||float||||
     163||!DelayLabToBalloon||158||float||||
     164||!IncludeInCallToNeedle||159||varchar||||
     165||!HospitalRefferedFrom||160||varchar||||
     166||FirstMustafa1||161||int||||
     167||SecondMustafa2||162||int||||
     168||!DaysFromAdmissionToDeath||163||int||||
     169||!InterventionalCentreCodeCcad||164||varchar||||
     170||!ReferringHospitalCodeCcad||165||varchar||||
     171||!TimeFromAdmissionToFirstEcg||166||float||||
     172||!EcgQrsComplexDurationCcad||167||varchar||||
     173||!AldosteroneAntagonistCcad||168||varchar||||
     174||!DischargedOnThienopyridineInhibitorCcad||169||varchar||||
     175||!DischargedOnAnAldosteroneAntagonistCcad||170||varchar||||
     176||!WhatProcedureWasPerformedAtTheInterventionalHospit||171||varchar||||
     177||!SmokingCessationAdviceGivenCcad||172||varchar||||
     178||!DietaryAdviceGivenDuringThisAdmissionCcad||173||varchar||||
     179||!OralBetaBlockerCcad||174||varchar||||
     180||~~!DateAndTimeArrivalAtNonInterventionalHospitalCcad~~||175||varchar||Ignored For No Enum||
     181||!AssessmentAtNonInterventionalHospitalCcad||176||varchar||||
     182||!AssessmentAtInterventionalCentreCcad||177||varchar||||
     183||!IntendedReprofusionProcedureCcad||178||varchar||||
     184||!ProcedurePerformedCcad||179||varchar||||
     185||WhyWasNoAngiogramPerformed_Ccad||180||varchar||||
     186||!WhyWasNoInterventionPerformedCcad||181||varchar||||
     187||!PatientLocationAtTimeOfStemiOnset||182||varchar||||
     188||!AcsAuditSite||183||varchar||||
     189||!AcsAuditWard||184||varchar||||
     190||!AcsAuditHowManyDosesOfLmwh||185||int||||
     191||!AcsAuditCardiologicalOpinionRequestedDuringAdmissi||186||varchar||||
     192||!AcsAuditAdmittedFrom||187||varchar||||
     193||!AcsAuditTimiScore||188||varchar||||
     194||!AcsAuditRiskStrarification||189||varchar||||
     195||!AcsAuditDateAndTimeOfEtt||190||varchar||||
     196||!AcsAuditDateAndTimeOfEcho||191||varchar||||
     197||!AcsAuditDateAndTimeOfAngiography||192||varchar||||
     198||AcsAuditDateAndTimeOfPci_Cabg||193||varchar||||
     199||!AcsAuditDischargedOnSublingualGtn||194||varchar||||
     200||~~!AcsAuditComments~~||195||text||Ignored For Datatype||
     201||~~!DateOfCurrentStatus~~||196||date||Ignored For Datatype||
     202||~~!DateOfEndStatus~~||197||date||Ignored For Datatype||
     203||~~!DateTimeRecordCreated~~||198||varchar||Ignored For No Enum||
     204||~~!DateTimeRecordLastChanged~~||199||varchar||Ignored For No Enum||
     205||!EnteredByTag||200||varchar||||
     206||!EntryCurrentStatus||201||varchar||||
     207||!EntryEndStatus||202||varchar||||
     208||!HospitalTag||203||varchar||||
     209||!ImportLinkId||204||int||||