vwBAUS_PROSTATECTOMY_GENERIC


Columns

Column Type Size Nulls Auto Default Children Parents Comments
pid int 4 null
CARE_ID int 4 null
SURGERY_ID int 4 null
URO_SURG_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
L_DEATH_STATUS int 4 √ null
N15_2_DEATH_LOCATION int 4 √ null
OrganisationTreatment varchar 5 √ null
L_METHOD_DIAG varchar 50 √ null
R_P_REASON_PROSTATECTOMY int 4 √ null
R_P_PREVIOUS_ACTIVE_REASON int 4 √ null
R_P_PREVIOUS_MANAGEMENT int 4 √ null
PRE_TREAT_PSA real 4 √ null
R_BIOPSY_SCORE_1 int 4 √ null
R_BIOPSY_SCORE_2 int 4 √ null
R_BIOPSY_TERT_SCORE int 4 √ null
R_STAGING_INVESTIGATIONS_NONE bit 1 √ null
R_STAGING_INVESTIGATIONS_MRI bit 1 √ null
R_STAGING_INVESTIGATIONS_BONESCAN bit 1 √ null
R_STAGING_INVESTIGATIONS_CT bit 1 √ 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
N7_9_SURGERY_DATE smalldatetime 16 √ null
FUNDING_CATEGORY int 4 √ 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
ASAGrade int 4 √ null
R_P_SPARING varchar 50 √ null
R_C_SURGICAL_TECHNIQUE int 4 √ null
R_P_CONVERTED varchar 3 √ null
R_DISSECTION int 4 √ null
OpDuration 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_P_INTRA_COMP_DIFFICULT 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_P_INTRA_COMP_URETERIC bit 1 √ null
R_INTRA_COMP_PORT bit 1 √ null
R_INTRA_COMP_ROBOTIC bit 1 √ null
RECTAL_INJURY int 4 √ null
IF_RECTAL_INJURY int 4 √ null
R_POST_COMP_NONE bit 1 √ null
R_POST_COMP_WOUND bit 1 √ null
R_POST_COMP_CHEST bit 1 √ null
R_P_POST_COMP_SEPSIS bit 1 √ null
R_P_POST_COMP_HAEMATURIA bit 1 √ null
R_POST_COMP_URINE bit 1 √ null
R_N_POST_COMP_PAIN bit 1 √ null
R_POST_COMP_ANASTOMATIC bit 1 √ null
R_POST_COMP_BLEEDING bit 1 √ null
R_P_POST_COMP_PE bit 1 √ null
R_POST_COMP_ILEUS bit 1 √ null
R_P_POST_COMP_PELVIC bit 1 √ null
R_P_POST_COMP_RENAL bit 1 √ null
R_POST_COMP_OTHER bit 1 √ null
POST_COMP_RETURN_TO_THEATRE bit 1 √ null
POST_COMP_LYMPHOCOEL bit 1 √ null
ClavienDindoID int 4 √ null
ltblClavienDindo.ClavienDindoID Implied ConstraintR
N7_12_DISCHARGE_DATE smalldatetime 16 √ null
N7_13_DISCHARGE_DESTINATION int 4 √ null
DIED_ON_TABLE bit 1 √ null
N15_1_DATE_DEATH date 20 √ null
N15_3_DEATH_CAUSE int 4 √ null
OTHER_DEATH_CAUSE_UROLOGY varchar 255 √ null
UNPLANNED_READMISSION_TO_HOSPITAL int 4 √ null
R_GLEASON_SCORE_1 int 4 √ null
R_GLEASON_SCORE_2 int 4 √ null
R_GLEASON_TERT_SCORE int 4 √ null
R_WEIGHT real 4 √ null
N8_14_NODES int 4 √ null
N8_15_POSITIVE_NODES int 4 √ null
PROST_EXCISION_MARGINS int 4 √ null
R_APICAL varchar 3 √ null
R_POS_RADIAL varchar 3 √ null
R_BASE varchar 3 √ null
R_POS_OTHER varchar 3 √ 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
L_NSTS_STATUS int 4 √ null
BAUS_CONSENT int 4 √ null
L_POST_COMP varchar 255 √ null

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views