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

Version 6 (modified by Richard Bramley, 11 years ago) ( diff )

--

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
DateOfAdmissionYY (ignored)Y
DateOfCatheterisation Y (ignored)
DateOfCatheterisation_echoY
DateOfCurrentStatus Y (ignored)Y
DateOfEndStatus Y (ignored)Y
DateOfLastCardiacOperationYY (ignored)Y
DateOfLastCatheterisation Y
DateOfLastInterventionY
DateOfLastPci Y (ignored)
DateOfOperationY Y
DateOfOperation_ccad Y (ignored)
DateOfReferralYY (ignored)Y
DateTimeRecordCreated Y (ignored)Y
DateTimeRecordLastChanged Y (ignored)Y
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
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
No_OfDistalCoronaryAnastomosesY
No_OfValveProceduresY
No_OfVascularProceduresY
NumberOfDistalCoronaryAnastomoses Y
NumberOfGrafts_ValvesAndVascularProceduresCombinedY
NumberOfPreviousHeartOperations YY
NumberOfPreviousMis YY
NumberOfSegmentsOfTheAorta Y
NumberOfValvesReplaced_Repaired Y
OffPump_midcabY
OperationFindingsYY (ignored)Y
OperationPerformedByY
OperationSequenceY
OperativePriorityYY
OperativeUrgency Y
OtherCardiacProceduresYYY
OtherProceduresY
OtherThoracicAndVascularProcedures YY
PacemakerY
PaSystolic Y
PaSystolic_ifKnown Y
PaSystolic_mmhgY
PatientIdYY (ignored)Y
PatientSeenOnWard_clinicBySeniorAnaesthetistY
Pawp_la_mmhgY
PeripheralVascularDiseaseY
Pre_OpArrythmiasY
Pre_OperativeHeartRhythm YY
Previous_Q_WaveMi_SY
PreviousCardiac_VascularOrThoracicSurgicalInterven Y
PreviousCardiacSurgery Y
PreviousCardiologicalInterventionY
PreviousEntryYY (ignored)Y
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
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
Note: See TracWiki for help on using the wiki.