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


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

--

Legend:

Unmodified
Added
Removed
Modified

  • i2b2 - UHL clinical informatics system integration PATS CS2003F_PreProcedure

    v1 v1  
     1[[i2b2 - UHL clinical informatics system integration PATS Mappings v1|back]]
     2
     3Start Date Field: !DateOfOperation_ccad
     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_ccad~~||3||datetime||Ignored For Datatype||
     9||~~TimeOfOperation_ccad~~||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||!AgeAtSurgery||8||int||||
     14||Gender||9||varchar||||
     15||~~!DateOfAdmission~~||10||datetime||Ignored For Datatype||
     16||AnginaStatusPre_Surgery||11||varchar||||
     17||DyspnoeaStatusPre_Surgery||12||varchar||||
     18||!NumberOfPreviousMis||13||varchar||||
     19||!IntervalBetweenOperationAndLastMi||14||varchar||||
     20||!PreviousPci||15||varchar||||
     21||~~!DateOfLastPci~~||16||datetime||Ignored For Datatype||
     22||PreviousCardiac_VascularOrThoracicSurgicalInterven||17||varchar||||
     23||~~!DateOfLastCardiacOperation~~||18||datetime||Ignored For Datatype||
     24||!DiabetesManagement||19||varchar||||
     25||Hypertension||20||varchar||||
     26||!CigaretteSmokingHistory||21||varchar||||
     27||!RenalDiseaseAtTheTimeOfSurgery||22||varchar||||
     28||!HistoryOfPulmonaryDisease||23||varchar||||
     29||!HistoryOfNeurologicalDisease||24||varchar||||
     30||Pre_OperativeHeartRhythm||25||varchar||||
     31||~~!DateOfCatheterisation~~||26||datetime||Ignored For Datatype||
     32||PaSystolic_ifKnown||27||int||||
     33||AvGradient_ifKnown||28||int||||
     34||Lvedp_ifKnown||29||int||||
     35||MeanPawp_la_ifKnown||30||int||||
     36||IvNitrates_HeparinOfAnyKind||31||varchar||||
     37||!IvInotropesPriorToAnaesthesia||32||varchar||||
     38||Ventilated||33||varchar||||
     39||!CardiogenicShock||34||varchar||||
     40||!OperativePriority||35||varchar||||
     41||!FirstOperatorGrade||36||varchar||||
     42||FirstOperator_CalmanYearOfTrainee||37||varchar||||
     43||!CardiacProcedures||38||varchar||||
     44||!NumberOfDistalCoronaryAnastomoses||39||int||||
     45||NumberOfValvesReplaced_Repaired||40||int||||
     46||!NumberOfSegmentsOfTheAorta||41||int||||
     47||!OtherCardiacProcedures||42||varchar||||
     48||!OtherThoracicAndVascularProcedures||43||varchar||||
     49||NeurologicalDysfunction_euroscore||44||varchar||||
     50||!LeftMainStemDisease||45||varchar||||
     51||!ExtentOfCoronaryArteryDisease||46||varchar||||
     52||!ExtracardiacArteriopathy||47||varchar||||
     53||!EjectionFractionCategory||48||varchar||||
     54||!AdmissionCategory||49||varchar||||
     55||!CarotidBruits||50||varchar||||
     56||!LeftOrRightHeartCatheterisation||51||varchar||||
     57||EjectionFractionValue_ifKnown||52||int||||
     58||~~!DateAndTimeOfOperation~~||53||varchar||Ignored For No Enum||
     59||!NumberOfPreviousHeartOperations||54||int||||
     60||!ResponsibleConsultantSurgeon||55||varchar||||
     61||~~!FirstOperator~~||56||varchar||Ignored For No Enum||
     62||~~!FirstAssistant~~||57||varchar||Ignored For No Enum||
     63||!FirstAssistantGrade||58||varchar||||
     64||FirstAssistant_CalmanYearOfTrainee||59||varchar||||
     65||~~!ResponsibleConsultantAnaesthetist~~||60||varchar||Ignored For No Enum||
     66||~~!OperationFindings~~||61||varchar||Ignored For No Enum||
     67||~~!ReferringCardiologist~~||62||varchar||Ignored For No Enum||
     68||~~!DateOfReferral~~||63||datetime||Ignored For Datatype||
     69||~~!DrugsOnAdmission~~||64||varchar||Ignored For No Enum||
     70||~~Allergies~~||65||varchar||Ignored For No Enum||
     71||~~!AllOtherAssistants~~||66||varchar||Ignored For No Enum||
     72||!WaitingListStatusUpdated||67||varchar||||
     73||!SprCases||68||varchar||||
     74||~~!DateOfCurrentStatus~~||69||datetime||Ignored For Datatype||
     75||~~!DateOfEndStatus~~||70||datetime||Ignored For Datatype||
     76||~~!DateTimeRecordCreated~~||71||datetime||Ignored For Datatype||
     77||~~!DateTimeRecordLastChanged~~||72||datetime||Ignored For Datatype||
     78||!EnteredByTag||73||varchar||||
     79||!EntryCurrentStatus||74||varchar||||
     80||!EntryEndStatus||75||varchar||||
     81||!HospitalTag||76||varchar||||
     82||WHO_RESPONSIBLE_CONSULTANT_SURGEON||77||varchar||||
     83||WHO_AGE_AT_OPERATION||78||int||||
     84||WHO_REGISTRY_INDICATOR||79||varchar||||
     85||~~WHO_POSSIBLE_DUPLICATE~~||80||char||Ignored For Datatype||