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


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

--

Legend:

Unmodified
Added
Removed
Modified

  • i2b2 - UHL clinical informatics system integration PATS CS2010F_PreProcedure

    v1 v1  
     1[[i2b2 - UHL clinical informatics system integration PATS Mappings v1|back]]
     2
     3Start Date Field: !DateOfOperation
     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||~~!DateOfOperation~~||3||date||Ignored For Datatype||
     9||~~!TimeOfEntry~~||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||!AgeAtOperation||8||int||||
     14||Gender||9||varchar||||
     15||~~!DateOfAdmission~~||10||date||Ignored For Datatype||
     16||AnginaStatusPre_Surgery||11||varchar||||
     17||DyspnoeaStatusPre_Surgery||12||varchar||||
     18||!NumberOfPreviousMis||13||varchar||||
     19||!IntervalBetweenSurgeryAndLastMi||14||varchar||||
     20||!PreviousPci||15||varchar||||
     21||!PreviousCardiacSurgery||16||varchar||||
     22||~~!DateOfLastCardiacOperation~~||17||date||Ignored For Datatype||
     23||!DiabetesManagement||18||varchar||||
     24||!HistoryOfHypertension||19||varchar||||
     25||!CigaretteSmokingHistory||20||varchar||||
     26||!HistoryOfPulmonaryDisease||21||varchar||||
     27||!HistoryOfNeurologicalDisease||22||varchar||||
     28||Pre_OperativeHeartRhythm||23||varchar||||
     29||~~!DateOfLastCatheterisation~~||24||date||Ignored For Datatype||
     30||!PaSystolic||25||int||||
     31||!IntravenousNitratesOrAnyHeparin||26||varchar||||
     32||!IntravenousInotropesPriorToAnaesthesia||27||varchar||||
     33||!VentilatedPreOperation||28||varchar||||
     34||CardiogenicShock_pre_Operation||29||varchar||||
     35||!OperativeUrgency||30||varchar||||
     36||!FirstOperatorGrade||31||varchar||||
     37||FirstOperator_CalmanYearOfTrainee||32||varchar||||
     38||!CardiacProcedures||33||varchar||||
     39||!OtherCardiacProcedures||34||varchar||||
     40||!OtherThoracicAndVascularProcedures||35||varchar||||
     41||!LeftMainStemDisease||36||varchar||||
     42||!ExtentOfCoronaryVesselDisease||37||varchar||||
     43||!ExtracardiacArteriopathy||38||varchar||||
     44||!EjectionFractionCategory||39||varchar||||
     45||!AdministrativeCategory||40||varchar||||
     46||~~!DateAndTimeOfOperation~~||41||varchar||Ignored For No Enum||
     47||!NumberOfPreviousHeartOperations||42||int||||
     48||!ResponsibleConsultantSurgeon||43||varchar||||
     49||!FirstOperator||44||varchar||||
     50||!FirstAssistant||45||varchar||||
     51||!FirstAssistantGrade||46||varchar||||
     52||FirstAssistant_CalmanYearOfTrainee||47||varchar||||
     53||!ResponsibleConsultantAnaesthetist||48||varchar||||
     54||~~!OperationFindings~~||49||varchar||Ignored For No Enum||
     55||!ReferringCardiologist||50||varchar||||
     56||~~!DateOfReferral~~||51||date||Ignored For Datatype||
     57||!DrugsOnAdmission||52||varchar||||
     58||Allergies||53||varchar||||
     59||!AllOtherAssistants||54||varchar||||
     60||!WaitingListStatusUpdated||55||varchar||||
     61||!SprCases||56||varchar||||
     62||~~!DateOfCurrentStatus~~||57||date||Ignored For Datatype||
     63||~~!DateOfEndStatus~~||58||date||Ignored For Datatype||
     64||~~!DateTimeRecordCreated~~||59||varchar||Ignored For No Enum||
     65||~~!DateTimeRecordLastChanged~~||60||varchar||Ignored For No Enum||
     66||!EnteredByTag||61||varchar||||
     67||!EntryCurrentStatus||62||varchar||||
     68||!EntryEndStatus||63||varchar||||
     69||!HospitalTag||64||varchar||||