vwBAUS_CYSTECTOMY_GENERIC


Columns

Column Type Size Nulls Auto Default Children Parents Comments
pid int 4 null
CARE_ID int 4 null
URO_SURG_ID int 4 null
SURGERY_ID int 4 null
nhs_num varchar 10 null
hosp_num varchar 20 √ null
dob date 20 √ null
forename varchar 50 √ null
surname varchar 60 √ null
sex char 1 √ null
user_id int 4 √ null
date_of_death date 20 √ null
cause_of_death int 4 √ null
OrganisationTreatment varchar 5 √ null
N4_1_DIAGNOSIS_DATE smalldatetime 16 √ null
R_C_INDICATION int 4 √ null
ClinicalTStage varchar 5 √ null
ClinicalTLetter varchar 5 √ null
ClinicalNStage varchar 5 √ null
ClinicalNLetter varchar 5 √ null
ClinicalMStage varchar 5 √ null
ClinicalMLetter varchar 5 √ null
URETHAL_BIOPSY_PERFORMED int 4 √ null
URETHAL_BIOPSY_RESULTS int 4 √ null
R_C_SERUM real 4 √ null
R_N_eGFR int 4 √ null
PREOP_HB int 4 √ null
OFFERED_PREOP_NEOADJ_CHEMO int 4 √ null
R_C_STATUS int 4 √ null
N7_9_SURGERY_DATE smalldatetime 16 √ null
L_SURGEON varchar 8 √ null
L_GRADE varchar 50 √ null
R_SUPERVISED varchar 3 √ null
R_JOINT_PROCEDURE varchar 5 √ null
R_JOINT_CONSULTANT varchar 50 √ null
BMI float 8 √ null
HEIGHT real 4 √ null
WEIGHT real 4 √ null
CPEX_TESTING int 4 √ null
ANAEROBIC_THRESHOLD real 4 √ null
R_C_SURGICAL_TECHNIQUE int 4 √ null
MINIMALLY_INVASIVE int 4 √ null
R_C_PROCEDURE int 4 √ null
R_C_CONVERTED varchar 3 √ null
R_C_CONVERTED_REASON varchar 255 √ null
R_C_URETHRECTOMY varchar 3 √ null
R_C_NEPHROURECTERECTOMY varchar 3 √ null
R_C_CONCOMITANT_PROCEDURE varchar 255 √ null
R_C_LYMPH_NODE_LEVEL_1 bit 1 √ null
R_C_LYMPH_NODE_LEVEL_2 bit 1 √ null
R_C_LYMPH_NODE_LEVEL_3 bit 1 √ null
OperationDuration int 4 √ null
R_BLOOD_LOSS real 4 √ null
R_TRANSFUSION int 4 √ null
R_INTRA_COMP_NONE bit 1 √ null
R_INTRA_COMP_BLEEDING bit 1 √ null
R_INTRA_COMP_RECTAL bit 1 √ null
R_INTRA_COMP_BOWEL bit 1 √ null
R_INTRA_COMP_VASCULAR bit 1 √ null
R_INTRA_COMP_ADHESIONS bit 1 √ null
R_INTRA_COMP_NERVE bit 1 √ null
R_C_INTRA_COMP_UNRESECTABLE bit 1 √ null
R_INTRA_COMP_PORT bit 1 √ null
R_INTRA_COMP_ROBOTIC bit 1 √ null
R_P_INTRA_COMP_DIFFICULT bit 1 √ null
IF_RECTAL_INJURY int 4 √ null
ENHANCED_RECOVERY_PATHWAY int 4 √ null
R_POST_COMP_NONE bit 1 √ null
R_POST_COMP_CHEST bit 1 √ null
R_POST_COMP_WOUND bit 1 √ null
R_C_POST_COMP_INTRA_AB bit 1 √ null
R_POST_COMP_ILEUS bit 1 √ null
R_POST_COMP_BLEEDING bit 1 √ null
R_POST_COMP_URINE bit 1 √ null
R_C_POST_COMP_LYMPHOCOELE bit 1 √ null
R_C_POST_COMP_WOUND bit 1 √ null
R_POST_COMP_ANASTOMATIC bit 1 √ null
R_C_POST_COMP_BOWEL bit 1 √ null
POST_COMP_DVT_PE bit 1 √ null
POST_COMP_MI bit 1 √ null
ClavienDindoID int 4 √ null
ltblClavienDindo.ClavienDindoID Implied ConstraintR
R_C_RETURN_THEATRE_HAEMORRHAGE bit 1 √ null
R_C_RETURN_THEATRE_ANASTOMOTIC bit 1 √ null
R_C_RETURN_THEATRE_BOWEL bit 1 √ null
R_C_RETURN_THEATRE_WOUND bit 1 √ null
L_TRANSFER varchar 20 √ null
PLANNED_ITU_ADMISSION int 4 √ null
RADIOLOGICAL_INTERVENTION int 4 √ null
RADIOLOGICAL_INTERVENTION_TYPE int 4 √ null
N7_12_DISCHARGE_DATE smalldatetime 16 √ null
N7_13_DISCHARGE_DESTINATION int 4 √ null
N15_1_DATE_DEATH date 20 √ null
N15_2_DEATH_LOCATION int 4 √ null
CAUSE_OF_DEATH_UROLOGY int 4 √ null
OTHER_DEATH_CAUSE_UROLOGY varchar 255 √ null
AVOIDABLE_DEATH bit 1 √ null
AVOIDABLE_DETAILS varchar 255 √ null
UNPLANNED_READMISSION_TO_HOSPITAL int 4 √ null
R_HISTOLOGY int 4 √ null
R_OTHER_HISTOLOGY varchar 255 √ null
R_TUMOUR_GRADE char 2 √ null
N8_14_NODES int 4 √ null
N8_15_POSITIVE_NODES int 4 √ null
N8_16_PATH_T_STAGE varchar 5 √ null
L_PATH_T_LETTER varchar 3 √ null
N8_17_PATH_N_STAGE varchar 5 √ null
L_PATH_N_LETTER varchar 6 √ null
N8_18_PATH_M_STAGE varchar 5 √ null
L_PATH_M_LETTER varchar 3 √ null
N8_13_EXCISION_MARGINS varchar 2 √ null
MARGIN_SITE int 4 √ null
L_NSTS_STATUS int 4 √ null
FUNDING_CATEGORY int 4 √ null
L_DEATH_STATUS int 4 √ null
DIED_ON_TABLE bit 1 √ null
RETURN_TO_THEATRE bit 1 √ null
BAUS_UNRESECTABLE_TUMOR int 4 √ null
BAUS_REASON_UNRESECTABLE int 4 √ null
BAUS_OTHER_REASON_UNRESECTABLE varchar 1024 √ null
BAUS_PROC_ABANDONED int 4 √ null
BAUS_REASON_PROC_ABANDONED varchar 1024 √ null
PROSTATE_CONFIRMED int 4 √ null
BAUS_CONSENT int 4 √ null
TotalPelvicExenteration int 4 √ null
PreviousLaparotomy bit 1 √ null

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views