wiki:i2b2 - UHL clinical informatics system integration PATS CS2003F_PreProcedure

back

Start Date Field: DateOfOperation_ccad

Field NameColumn IDTypeComments
EntryId1intIgnored For Field Name
PatientId2intIgnored For Field Name
DateOfOperation_ccad3datetimeIgnored For Datatype
TimeOfOperation_ccad4datetimeIgnored For Datatype
EntryStatus5varchar
PreviousEntry6intIgnored For Field Name
NextEntry7intIgnored For Field Name
AgeAtSurgery8int
Gender9varchar
DateOfAdmission10datetimeIgnored For Datatype
AnginaStatusPre_Surgery11varchar
DyspnoeaStatusPre_Surgery12varchar
NumberOfPreviousMis13varchar
IntervalBetweenOperationAndLastMi14varchar
PreviousPci15varchar
DateOfLastPci16datetimeIgnored For Datatype
PreviousCardiac_VascularOrThoracicSurgicalInterven17varchar
DateOfLastCardiacOperation18datetimeIgnored For Datatype
DiabetesManagement19varchar
Hypertension20varchar
CigaretteSmokingHistory21varchar
RenalDiseaseAtTheTimeOfSurgery22varchar
HistoryOfPulmonaryDisease23varchar
HistoryOfNeurologicalDisease24varchar
Pre_OperativeHeartRhythm25varchar
DateOfCatheterisation26datetimeIgnored For Datatype
PaSystolic_ifKnown27int
AvGradient_ifKnown28int
Lvedp_ifKnown29int
MeanPawp_la_ifKnown30int
IvNitrates_HeparinOfAnyKind31varchar
IvInotropesPriorToAnaesthesia32varchar
Ventilated33varchar
CardiogenicShock34varchar
OperativePriority35varchar
FirstOperatorGrade36varchar
FirstOperator_CalmanYearOfTrainee37varchar
CardiacProcedures38varchar
NumberOfDistalCoronaryAnastomoses39int
NumberOfValvesReplaced_Repaired40int
NumberOfSegmentsOfTheAorta41int
OtherCardiacProcedures42varchar
OtherThoracicAndVascularProcedures43varchar
NeurologicalDysfunction_euroscore44varchar
LeftMainStemDisease45varchar
ExtentOfCoronaryArteryDisease46varchar
ExtracardiacArteriopathy47varchar
EjectionFractionCategory48varchar
AdmissionCategory49varchar
CarotidBruits50varchar
LeftOrRightHeartCatheterisation51varchar
EjectionFractionValue_ifKnown52int
DateAndTimeOfOperation53varcharIgnored For No Enum
NumberOfPreviousHeartOperations54int
ResponsibleConsultantSurgeon55varchar
FirstOperator56varcharIgnored For No Enum
FirstAssistant57varcharIgnored For No Enum
FirstAssistantGrade58varchar
FirstAssistant_CalmanYearOfTrainee59varchar
ResponsibleConsultantAnaesthetist60varcharIgnored For No Enum
OperationFindings61varcharIgnored For No Enum
ReferringCardiologist62varcharIgnored For No Enum
DateOfReferral63datetimeIgnored For Datatype
DrugsOnAdmission64varcharIgnored For No Enum
Allergies65varcharIgnored For No Enum
AllOtherAssistants66varcharIgnored For No Enum
WaitingListStatusUpdated67varchar
SprCases68varchar
DateOfCurrentStatus69datetimeIgnored For Datatype
DateOfEndStatus70datetimeIgnored For Datatype
DateTimeRecordCreated71datetimeIgnored For Datatype
DateTimeRecordLastChanged72datetimeIgnored For Datatype
EnteredByTag73varchar
EntryCurrentStatus74varchar
EntryEndStatus75varchar
HospitalTag76varchar
WHO_RESPONSIBLE_CONSULTANT_SURGEON77varchar
WHO_AGE_AT_OPERATION78int
WHO_REGISTRY_INDICATOR79varchar
WHO_POSSIBLE_DUPLICATE80charIgnored For Datatype
Last modified 11 years ago Last modified on 03/15/13 08:51:27
Note: See TracWiki for help on using the wiki.