wiki:i2b2 - UHL clinical informatics system integration PATS CS2010F_PreProcedure

back

Start Date Field: DateOfOperation

Field NameColumn IDTypeComments
EntryId1intIgnored For Field Name
PatientId2intIgnored For Field Name
DateOfOperation3dateIgnored For Datatype
TimeOfEntry4timeIgnored For Datatype
EntryStatus5varchar
PreviousEntry6intIgnored For Field Name
NextEntry7intIgnored For Field Name
AgeAtOperation8int
Gender9varchar
DateOfAdmission10dateIgnored For Datatype
AnginaStatusPre_Surgery11varchar
DyspnoeaStatusPre_Surgery12varchar
NumberOfPreviousMis13varchar
IntervalBetweenSurgeryAndLastMi14varchar
PreviousPci15varchar
PreviousCardiacSurgery16varchar
DateOfLastCardiacOperation17dateIgnored For Datatype
DiabetesManagement18varchar
HistoryOfHypertension19varchar
CigaretteSmokingHistory20varchar
HistoryOfPulmonaryDisease21varchar
HistoryOfNeurologicalDisease22varchar
Pre_OperativeHeartRhythm23varchar
DateOfLastCatheterisation24dateIgnored For Datatype
PaSystolic25int
IntravenousNitratesOrAnyHeparin26varchar
IntravenousInotropesPriorToAnaesthesia27varchar
VentilatedPreOperation28varchar
CardiogenicShock_pre_Operation29varchar
OperativeUrgency30varchar
FirstOperatorGrade31varchar
FirstOperator_CalmanYearOfTrainee32varchar
CardiacProcedures33varchar
OtherCardiacProcedures34varchar
OtherThoracicAndVascularProcedures35varchar
LeftMainStemDisease36varchar
ExtentOfCoronaryVesselDisease37varchar
ExtracardiacArteriopathy38varchar
EjectionFractionCategory39varchar
AdministrativeCategory40varchar
DateAndTimeOfOperation41varcharIgnored For No Enum
NumberOfPreviousHeartOperations42int
ResponsibleConsultantSurgeon43varchar
FirstOperator44varchar
FirstAssistant45varchar
FirstAssistantGrade46varchar
FirstAssistant_CalmanYearOfTrainee47varchar
ResponsibleConsultantAnaesthetist48varchar
OperationFindings49varcharIgnored For No Enum
ReferringCardiologist50varchar
DateOfReferral51dateIgnored For Datatype
DrugsOnAdmission52varchar
Allergies53varchar
AllOtherAssistants54varchar
WaitingListStatusUpdated55varchar
SprCases56varchar
DateOfCurrentStatus57dateIgnored For Datatype
DateOfEndStatus58dateIgnored For Datatype
DateTimeRecordCreated59varcharIgnored For No Enum
DateTimeRecordLastChanged60varcharIgnored For No Enum
EnteredByTag61varchar
EntryCurrentStatus62varchar
EntryEndStatus63varchar
HospitalTag64varchar
Last modified 11 years ago Last modified on 03/15/13 08:54:03
Note: See TracWiki for help on using the wiki.