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

Version 5 (modified by Richard Bramley, 12 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
AllergiesYYY
AllOtherAssistants YY
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 YY
DateOfAdmissionYYY
DateOfCatheterisation Y
DateOfCatheterisation_echoY
DateOfCurrentStatus YY
DateOfEndStatus YY
DateOfLastCardiacOperationYYY
DateOfLastCatheterisation Y
DateOfLastInterventionY
DateOfLastPci Y
DateOfOperationY Y
DateOfOperation_ccad Y
DateOfReferralYYY
DateTimeRecordCreated YY
DateTimeRecordLastChanged YY
DiabetesY
DiabetesManagement YY
DrugOnAdmissionY
DrugsOnAdmission YY
DyspnoeaStatusY
DyspnoeaStatusPre_Surgery YY
EjectionFractionY
EjectionFractionCategory YY
EjectionFractionMethodY
EjectionFractionValue_ifKnown Y
EnteredByTag YY
EntryCurrentStatusYYY
EntryEndStatusYYY
EntryIdYYY
EntryStatusYYY
ExtentOfCoronaryArteryDisease Y
ExtentOfCoronaryDiseaseY
ExtentOfCoronaryVesselDisease Y
Extra_CardiacArteriopathyY
ExtracardiacArteriopathy YY
FamilyHxOfIhdY
FirstAnaesthetistY
FirstAssistant YY
FirstAssistant_CalmanYearOfTrainee YY
FirstAssistantGrade YY
FirstOperator YY
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
NextEntryYYY
No_OfDistalCoronaryAnastomosesY
No_OfValveProceduresY
No_OfVascularProceduresY
NumberOfDistalCoronaryAnastomoses Y
NumberOfGrafts_ValvesAndVascularProceduresCombinedY
NumberOfPreviousHeartOperations YY
NumberOfPreviousMis YY
NumberOfSegmentsOfTheAorta Y
NumberOfValvesReplaced_Repaired Y
OffPump_midcabY
OperationFindingsYYY
OperationPerformedByY
OperationSequenceY
OperativePriorityYY
OperativeUrgency Y
OtherCardiacProceduresYYY
OtherProceduresY
OtherThoracicAndVascularProcedures YY
PacemakerY
PaSystolic Y
PaSystolic_ifKnown Y
PaSystolic_mmhgY
PatientIdYYY
PatientSeenOnWard_clinicBySeniorAnaesthetistY
Pawp_la_mmhgY
PeripheralVascularDiseaseY
Pre_OpArrythmiasY
Pre_OperativeHeartRhythm YY
Previous_Q_WaveMi_SY
PreviousCardiac_VascularOrThoracicSurgicalInterven Y
PreviousCardiacSurgery Y
PreviousCardiologicalInterventionY
PreviousEntryYYY
PreviousPci YY
PreviousPtca_stentY
PreviousSurgicalInterventionY
PreviousSurgicalProcedureY
RecentlyFailedInterventionY
ReferringCardiologistYYY
ReferringPhysicianY
RenalY
RenalDiseaseAtTheTimeOfSurgery Y
ResponsibleConsultantAnaesthetist YY
ResponsibleConsultantSurgeon YY
SmokingY
SprCases YY
SurgeonY
SymptomStatusY
ThrombolysisWithin24HoursY
TimeOfEntryY Y
TimeOfOperation_ccad Y
TypeOfTraineeY
VentilatedYY
VentilatedPreOperation Y
WaitingListParsonnetScoreY
WaitingListStatusUpdated YY
WasThePatientCatheterisedY
WHO_AGE_AT_OPERATION Y
WHO_POSSIBLE_DUPLICATE Y
WHO_REGISTRY_INDICATOR Y
WHO_RESPONSIBLE_CONSULTANT_SURGEON Y
Note: See TracWiki for help on using the wiki.