wiki:i2b2 - UHL clinical informatics system integration PATS CS PreProcedure Combined

back

Tables

Table Date Range Start Date Field Records
CS_PreProcedure1998-2005DateOfOperation7901
CS2003F_PreProcedure2004-2013DateOfOperation_ccad9383
CS2010F_PreProcedure2011-2013DateOfOperation2007

Columns

Column CS_PreProcedure CS2003F_PreProcedure CS2010F_PreProcedure
ActiveEndocarditisY
AdministrativeCategory Y
AdmissionCategory Y
Age_parsonnetY
AgeAtOperation Y
AgeAtSurgeryYY
AllergiesYY (ignored)Y
AllOtherAssistants Y (ignored)Y
AnginaStatusY
AnginaStatusPre_Surgery YY
AssistantSurgeonY
AvGradient_ifKnown Y
AvGradient_mmhgY
CalmanYearTraineeY
CardiacProceduresYYY
CardiogenicShockYY
CardiogenicShock_pre_Operation Y
CarotidBruits Y
CatheterisedSameAdmissionAsSurgeryY
CerebrovascularDiseaseY
ChronicPulmonaryDiseaseY
CigaretteSmokingHistory YY
CongenitalDiseaseY
CongestiveCardiacFailureY
ConsultantY
CriticalPre_OpStateY
DateAndTimeOfOperation Y (ignored)Y (ignored)
DateOfAdmissionYY (ignored)Y (ignored)
DateOfCatheterisation Y (ignored)
DateOfCatheterisation_echoY
DateOfCurrentStatus Y (ignored)Y (ignored)
DateOfEndStatus Y (ignored)Y (ignored)
DateOfLastCardiacOperationYY (ignored)Y (ignored)
DateOfLastCatheterisation Y (ignored)
DateOfLastInterventionY
DateOfLastPci Y (ignored)
DateOfOperationY Y (ignored)
DateOfOperation_ccad Y (ignored)
DateOfReferralYY (ignored)Y (ignored)
DateTimeRecordCreated Y (ignored)Y (ignored)
DateTimeRecordLastChanged Y (ignored)Y (ignored)
DiabetesY
DiabetesManagement YY
DrugOnAdmissionY
DrugsOnAdmission Y (ignored)Y
DyspnoeaStatusY
DyspnoeaStatusPre_Surgery YY
EjectionFractionY
EjectionFractionCategory YY
EjectionFractionMethodY
EjectionFractionValue_ifKnown Y
EnteredByTag YY
EntryCurrentStatusYYY
EntryEndStatusYYY
EntryIdYY (ignored)Y (ignored)
EntryStatusYYY
ExtentOfCoronaryArteryDisease Y
ExtentOfCoronaryDiseaseY
ExtentOfCoronaryVesselDisease Y
Extra_CardiacArteriopathyY
ExtracardiacArteriopathy YY
FamilyHxOfIhdY
FirstAnaesthetistY
FirstAssistant Y (ignored)Y
FirstAssistant_CalmanYearOfTrainee YY
FirstAssistantGrade YY
FirstOperator Y (ignored)Y
FirstOperator_CalmanYearOfTrainee YY
FirstOperatorGrade YY
Gender YY
Gender_parsonnetY
GiTractY
GraftHarvestY
HistoryOfHypertension Y
HistoryOfNeurologicalDisease YY
HistoryOfPulmonaryDisease YY
HospitalTag YY
HypercholesterolaemiaY
HypertensionYY
IabpY
IntervalBetweenOperationAndLastMi Y
IntervalBetweenSurgeryAndLastMi Y
IntravenousInotropesPriorToAnaesthesia Y
IntravenousNitratesOrAnyHeparin Y
IvInotropesY
IvInotropesPriorToAnaesthesia Y
IvNitratesY
IvNitrates_HeparinOfAnyKind Y
Last_Q_WaveMiY
LeftMainStemDiseaseYYY
LeftOrRightHeartCatheterisation Y
Lvedp_ifKnown Y
Lvedp_mmhgY
MeanPawp_la_ifKnown Y
NeurologicalDysfunctionY
NeurologicalDysfunction_euroscore Y
NextEntryYY (ignored)Y (ignored)
No_OfDistalCoronaryAnastomosesY
No_OfValveProceduresY
No_OfVascularProceduresY
NumberOfDistalCoronaryAnastomoses Y
NumberOfGrafts_ValvesAndVascularProceduresCombinedY
NumberOfPreviousHeartOperations YY
NumberOfPreviousMis YY
NumberOfSegmentsOfTheAorta Y
NumberOfValvesReplaced_Repaired Y
OffPump_midcabY
OperationFindingsYY (ignored)Y (ignored)
OperationPerformedByY
OperationSequenceY
OperativePriorityYY
OperativeUrgency Y
OtherCardiacProceduresYYY
OtherProceduresY
OtherThoracicAndVascularProcedures YY
PacemakerY
PaSystolic Y
PaSystolic_ifKnown Y
PaSystolic_mmhgY
PatientIdYY (ignored)Y (ignored)
PatientSeenOnWard_clinicBySeniorAnaesthetistY
Pawp_la_mmhgY
PeripheralVascularDiseaseY
Pre_OpArrythmiasY
Pre_OperativeHeartRhythm YY
Previous_Q_WaveMi_SY
PreviousCardiac_VascularOrThoracicSurgicalInterven Y
PreviousCardiacSurgery Y
PreviousCardiologicalInterventionY
PreviousEntryYY (ignored)Y (ignored)
PreviousPci YY
PreviousPtca_stentY
PreviousSurgicalInterventionY
PreviousSurgicalProcedureY
RecentlyFailedInterventionY
ReferringCardiologistYY (ignored)Y
ReferringPhysicianY
RenalY
RenalDiseaseAtTheTimeOfSurgery Y
ResponsibleConsultantAnaesthetist Y (ignored)Y
ResponsibleConsultantSurgeon YY
SmokingY
SprCases YY
SurgeonY
SymptomStatusY
ThrombolysisWithin24HoursY
TimeOfEntryY Y (ignored)
TimeOfOperation_ccad Y (ignored)
TypeOfTraineeY
VentilatedYY
VentilatedPreOperation Y
WaitingListParsonnetScoreY
WaitingListStatusUpdated YY
WasThePatientCatheterisedY
WHO_AGE_AT_OPERATION Y
WHO_POSSIBLE_DUPLICATE Y (ignored)
WHO_REGISTRY_INDICATOR Y
WHO_RESPONSIBLE_CONSULTANT_SURGEON Y
Last modified 10 years ago Last modified on 04/11/13 14:55:58
Note: See TracWiki for help on using the wiki.