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


Ignore:
Timestamp:
03/15/13 09:07:06 (11 years ago)
Author:
Richard Bramley
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • i2b2 - UHL clinical informatics system integration PATS VERTED_VERTEDINIALVW

    v1 v1  
     1[[i2b2 - UHL clinical informatics system integration PATS Mappings v1|back]]
     2
     3Start Date Field: !DateOfCardioversion
     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||~~!DateOfCardioversion~~||3||date||Ignored For Datatype||
     9||~~!TimeOfCardioversion~~||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||~~!DateOnWaitingList~~||8||date||Ignored For Datatype||
     14||!AgeAtCardioversion||9||int||||
     15||~~!BloodPressure~~||10||varchar||Ignored For No Enum||
     16||~~Height~~||11||varchar||Ignored For No Enum||
     17||Rhythm||12||varchar||||
     18||~~!DrugsOnAdmission~~||13||varchar||Ignored For No Enum||
     19||~~!DateOfEcho~~||14||date||Ignored For Datatype||
     20||Pacemaker||15||varchar||||
     21||Weight||16||float||||
     22||Inr||17||float||||
     23||JoulesDelivered_1||18||int||||
     24||~~Rhythm_1~~||19||varchar||Ignored For No Enum||
     25||JoulesDelivered_2||20||int||||
     26||~~Rhythm_2~~||21||varchar||Ignored For No Enum||
     27||JoulesDelivered_3||22||int||||
     28||Rhythm_3||23||varchar||||
     29||JoulesDelivered_4||24||int||||
     30||Rhythm_4||25||varchar||||
     31||JoulesDelivered_5||26||int||||
     32||Rhythm_5||27||varchar||||
     33||JoulesDelivered_6||28||int||||
     34||Rhythm_6||29||varchar||||
     35||!InternalCardioversion||30||varchar||||
     36||!ExternalCardioversion||31||varchar||||
     37||!OutcomeSucces||32||varchar||||
     38||Death||33||varchar||||
     39||!CardioversionCancelled||34||varchar||||
     40||~~Reason~~||35||varchar||Ignored For No Enum||
     41||~~!DateOfDischarge~~||36||date||Ignored For Datatype||
     42||~~!DateOfAdmission~~||37||date||Ignored For Datatype||
     43||!RhythmAfterCardioversion||38||varchar||||
     44||!AdmissionType||39||varchar||||
     45||~~!DateOfFollowUp~~||40||date||Ignored For Datatype||
     46||Ap_2||41||varchar||||
     47||Ap_3||42||varchar||||
     48||Ap_4||43||varchar||||
     49||Ap_5||44||varchar||||
     50||Ap_6||45||varchar||||
     51||Consultant||46||varchar||||
     52||!ContractDetails||47||varchar||||
     53||Pcg||48||varchar||||
     54||~~MedicationOnDischarge1~~||49||varchar||Ignored For No Enum||
     55||~~MedicationOnDischarge2~~||50||varchar||Ignored For No Enum||
     56||~~MedicationOnDischarge3~~||51||varchar||Ignored For No Enum||
     57||~~MedicationOnDischarge4~~||52||varchar||Ignored For No Enum||
     58||~~MedicationOnDischarge5~~||53||varchar||Ignored For No Enum||
     59||~~MedicationOnDischarge6~~||54||varchar||Ignored For No Enum||
     60||~~MedicationOnDischarge7~~||55||varchar||Ignored For No Enum||
     61||~~MedicationOnDischarge8~~||56||varchar||Ignored For No Enum||
     62||~~MedicationOnDischarge9~~||57||varchar||Ignored For No Enum||
     63||!AuditLoopClosed||58||varchar||||
     64||~~!DateAuditLoopClosed~~||59||date||Ignored For Datatype||
     65||!ReasonAuditLoopClosed||60||varchar||||
     66||~~!DateOfDeathPostDischarge~~||61||date||Ignored For Datatype||
     67||PostDischargeDeathInterval_days||62||int||||
     68||!ReasonForCancellation||63||varchar||||
     69||IntervalBetweenProc_LoopClosed_days||64||int||||
     70||PreOpStay_days||65||int||||
     71||PostOpStay_days||66||int||||
     72||TotalLos_days||67||int||||
     73||ReferralToOp_days||68||int||||
     74||DischargeToFollow_Up_days||69||int||||
     75||!EchoPerformed||70||varchar||||
     76||ImmeadiateReinitiationOfAf_iraf||71||varchar||||
     77||!PacemakerMode||72||varchar||||
     78||EcgResultAt1Week||73||varchar||||
     79||EcgResultAt1Month||74||varchar||||
     80||!ReCardiovert||75||varchar||||
     81||!ReasonWhyYesOrNo||76||varchar||||
     82||Anaesthetic_sedation||77||varchar||||
     83||~~!IfSedationDose~~||78||varchar||Ignored For No Enum||
     84||Reversal||79||varchar||||
     85||!ComplicationsPreDischarge||80||varchar||||
     86||!DoseOfFlumazenil||81||varchar||||
     87||!TypeOfDefibUsed||82||varchar||||
     88||!DoesPatientRememberShocks||83||varchar||||
     89||!WasProcedureUnpleasant||84||varchar||||
     90||~~!AnyOtherComments~~||85||varchar||Ignored For No Enum||
     91||!BurnMarks||86||varchar||||
     92||~~HeartRate_priorToDischarge~~||87||varchar||Ignored For No Enum||
     93||Anaesthetist||88||varchar||||
     94||!MedicalAssistant||89||varchar||||
     95||~~!UnderlyingCardiacDiagnosisForAf~~||90||varchar||Ignored For No Enum||
     96||~~!DrugListOnDischarge~~||91||varchar||Ignored For No Enum||
     97||!FreeThyroxine||92||float||||
     98||!ThyroidStimulatingHormone||93||float||||
     99||~~Operator~~||94||varchar||Ignored For No Enum||
     100||DoctorReading1WeekEcg||95||varchar||||
     101||DoctorReading1MonthEcg||96||varchar||||
     102||!PadsOrPaddles||97||varchar||||
     103||!IfRevertsToAf||98||varchar||||
     104||~~!AnyUntowardsEvents~~||99||varchar||Ignored For No Enum||
     105||!DurationOfAf||100||varchar||||
     106||FollowUpAt_Hospital||101||varchar||||
     107||!TotalDoseOfSedation||102||varchar||||
     108||!TotalJulesDelivered||103||float||||
     109||!NumberOfPreviousCardioversion||104||varchar||||
     110||~~!GpPracticeCode~~||105||varchar||Ignored For No Enum||
     111||Pct||106||varchar||||
     112||!TotalNumberOfShocks||107||int||||
     113||~~!MedicalRecordNumber~~||108||varchar||Ignored For No Enum||
     114||!HasPatientHadPreviousCardioversion||109||varchar||||
     115||~~!DateOfLastCardioversion~~||110||date||Ignored For Datatype||
     116||!IsProcedureForRecuurrenceOfAfOfFailure||111||varchar||||
     117||~~MedicationOnDischarge10~~||112||varchar||Ignored For No Enum||
     118||~~MedicationOnDischarge11~~||113||varchar||Ignored For No Enum||
     119||~~MedicationOnDischarge12~~||114||varchar||Ignored For No Enum||
     120||MedicationOnDischarge13||115||varchar||||
     121||~~!DateAndTimeOfCardioversion~~||116||varchar||Ignored For No Enum||
     122||~~UnderlyingCardiacDiagnosis2~~||117||varchar||Ignored For No Enum||
     123||~~UnderlyingCardiacDiagnosis3~~||118||varchar||Ignored For No Enum||
     124||~~UnderlyingCardiacDiagnosis4~~||119||varchar||Ignored For No Enum||
     125||~~UnderlyingCardiacDiagnosis5~~||120||varchar||Ignored For No Enum||
     126||UnderlyingCardiacDiagnosis6||121||varchar||||
     127||!ConsultantTitle||122||varchar||||
     128||!ConsultantsHospitalBase||123||varchar||||
     129||!SickNoteOfferedToPatient||124||varchar||||
     130||IfAccepted_DurationInDays||125||int||||
     131||!ManagementPlan||126||varchar||||
     132||!DoctorSigningLetter||127||varchar||||
     133||!TitleOfDoctorSigning||128||varchar||||
     134||~~!DateOfCurrentStatus~~||129||date||Ignored For Datatype||
     135||~~!DateOfEndStatus~~||130||date||Ignored For Datatype||
     136||!DateTimeRecordCreated||131||varchar||||
     137||!DateTimeRecordLastChanged||132||varchar||||
     138||!EnteredByTag||133||varchar||||
     139||!EntryCurrentStatus||134||varchar||||
     140||!EntryEndStatus||135||varchar||||
     141||!HospitalTag||136||varchar||||
     142||!ImportLinkId||137||int||||