vwBAUS_PROSTATECTOMY


Columns

Column Type Size Nulls Auto Default Children Parents Comments
SURGERY_ID int 4 null
CARE_ID int 4 null
TEMP_ID varchar 255 √ null
ltblTEMP_NHS_NUMBERS.TEMP_ID Implied ConstraintR
N7_1_SITE_CODE varchar 5 √ null
N_SITE_CODE_DTT varchar 5 √ null
N7_2_CONSULTANT varchar 8 √ null
N7_3_SPECIALTY int 4 √ null
N7_4_TREATMENT_INTENT int 4 √ null
N7_5_DECISION_DATE smalldatetime 16 √ null
N7_8_ADMISSION_DATE smalldatetime 16 √ null
N7_9_SURGERY_DATE smalldatetime 16 √ null
L_PROCEDURE_SITE int 4 √ null
L_PROCEDURE_TYPE int 4 √ null
L_PROCEDURE int 4 √ null
L_PROCEDURE_SITE2 int 4 √ null
L_PROCEDURE_TYPE2 int 4 √ null
L_PROCEDURE2 int 4 √ null
L_PROCEDURE_SITE3 int 4 √ null
L_PROCEDURE_TYPE3 int 4 √ null
L_PROCEDURE3 int 4 √ null
L_PROCEDURE_SITE4 int 4 √ null
L_PROCEDURE_TYPE4 int 4 √ null
L_PROCEDURE4 int 4 √ null
N7_10_PROCEDURE_1 varchar 5 √ null
N7_11_PROCEDURE_2 varchar 5 √ null
N7_11_PROCEDURE_3 varchar 5 √ null
N7_11_PROCEDURE_4 varchar 5 √ null
N7_12_DISCHARGE_DATE smalldatetime 16 √ null
N7_13_DISCHARGE_DESTINATION int 4 √ null
N_TREATMENT_EVENT varchar 2 √ null
N_TREATMENT_SETTING varchar 2 √ null
L_TRIAL int 4 √ null
L_SURGEON varchar 8 √ null
L_SURGEON_NAME varchar 50 √ null
L_GRADE varchar 50 √ null
L_ASSISTANT_1 varchar 8 √ null
L_ASSISTANT_NAME_1 varchar 50 √ null
L_GRADE_1 varchar 50 √ null
L_ASSISTANT_2 varchar 8 √ null
L_ASSISTANT_NAME_2 varchar 50 √ null
L_GRADE_2 varchar 50 √ null
L_ANAESTHETIST_NAME varchar 50 √ null
L_ANAESTHETIST varchar 50 √ null
L_ANAESTHETIST_NAME_2 varchar 50 √ null
L_ANAESTHETIST_2 varchar 50 √ null
L_URGENCY varchar 50 √ null
L_ANASTOMOSIS varchar 50 √ null
L_BLOOD_LOSS real 4 √ null
L_SUPPORT varchar 50 √ null
L_COMPLICATIONS int 4 √ null
L_COMPLICATIONS2 int 4 √ null
L_COMPLICATIONS3 int 4 √ null
L_OTHER_COMP varchar 255 √ null
L_POST_COMP varchar 255 √ null
L_TRANSFER varchar 20 √ null
L_DAYS int 4 √ null
L_RETURN_ITU varchar 50 √ null
L_REASON_RETURN varchar 255 √ null
L_DAYS_BACK int 4 √ null
DEFINITIVE_TREATMENT int 4 √ null
CWT_PROFORMA int 4 √ null
L_DISCHARGE_COMMENTS text 2147483647 √ null
STEM_CELL_INFUSION_SOURCE_ID int 4 √ null
STEM_CELL_INFUSION_SOURCE_ID2 int 4 √ null
STEM_CELL_INFUSION_SOURCE_ID3 int 4 √ null
STEM_CELL_INFUSION_DONOR_ID int 4 √ null
STEM_CELL_INFUSION_DONOR_ID2 int 4 √ null
STEM_CELL_INFUSION_DONOR_ID3 int 4 √ null
SURGEON_3 varchar 8 √ null
SURGEON_3_GRADE varchar 50 √ null
SURGEON_3_NAME varchar 50 √ null
SURGEON_4 varchar 8 √ null
SURGEON_4_GRADE varchar 50 √ null
SURGEON_4_NAME varchar 50 √ null
ROOT_ADMISSION_DATE_COMMENTS text 2147483647 √ null
ROOT_PERFORMED_DATE_COMMENTS text 2147483647 √ null
GMC_CODE1 varchar 8 √ null
GMC_CODE2 varchar 8 √ null
GMC_CODE3 varchar 8 √ null
GMC_CODE4 varchar 8 √ null
GMC_CODE5 varchar 8 √ null
GMC_CODE6 varchar 8 √ null
URO_SURG_ID int 4 null
R_ENDO_RESECTION varchar 50 √ null
R_ENDO_CHEMO varchar 50 √ null
R_ABLATIVE_SURGERY varchar 50 √ null
R_ORGAN_CONSERVING varchar 50 √ null
R_OTHER_SURGERY varchar 50 √ null
R_LAP_SURGERY varchar 50 √ null
R_SPECIFY_SURGERY varchar 255 √ null
R_SPECIFY_LAP varchar 255 √ null
ASAGrade int 4 √ null
R_SUPERVISED varchar 3 √ null
R_DISSECTION int 4 √ null
R_DURATION int 4 √ null
R_TRANSFUSION int 4 √ null
R_BLOOD_LOSS real 4 √ null
R_IN_COMPLICATIONS varchar 255 √ null
R_SIGNIFICANCE varchar 50 √ null
R_POTENCY varchar 50 √ null
R_CONTINENCE varchar 50 √ null
R_P_PRESENTATION varchar 50 √ null
R_P_TURP varchar 3 √ null
R_P_SPARING varchar 50 √ null
R_P_APPROACH int 4 √ null
R_P_CONVERTED varchar 3 √ null
R_P_CONVERTED_REASON varchar 255 √ null
R_C_INDICATION int 4 √ null
R_C_OTHER_INDICATION varchar 255 √ null
R_C_SERUM real 4 √ null
R_C_PROCEDURE int 4 √ null
R_C_ORTHOTOPIC varchar 255 √ null
R_C_OTHER varchar 255 √ 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_UPPER_TRACT varchar 3 √ null
R_C_STATUS int 4 √ null
R_C_OTHER_TRACT varchar 255 √ null
R_N_PRESENTATION varchar 50 √ null
R_N_OTHER_PRES varchar 255 √ null
R_N_SERUM real 4 √ null
R_N_eGFR int 4 √ null
R_N_METS varchar 50 √ null
R_N_MET_SITES varchar 255 √ null
R_N_NUMBER_METS int 4 √ null
R_N_HB varchar 10 √ null
R_N_LYMPHOCYTES varchar 10 √ null
R_N_WBC varchar 10 √ null
R_N_PLATELETS varchar 10 √ null
R_N_NEUTROPHILS varchar 10 √ null
R_N_WHO int 4 √ null
R_N_BIOPSY varchar 3 √ null
R_N_VENA_CAVA varchar 3 √ null
R_N_SITE_VC varchar 50 √ null
R_N_LEVEL int 4 √ null
R_N_LIVER varchar 3 √ null
R_N_CARDIOPULMONARY varchar 3 √ null
R_N_CIRCULATORY varchar 3 √ null
R_N_IVC varchar 3 √ null
R_N_OPEN varchar 50 √ null
R_N_LAPAROSCOPIC varchar 50 √ null
R_N_CONVERTED varchar 3 √ null
R_N_REASON int 4 √ null
R_N_CONVERTED_REASON varchar 255 √ null
R_N_RETRIEVAL int 4 √ null
R_N_ISCHAEMIC int 4 √ null
R_N_COOLING varchar 3 √ null
R_N_COMPS int 4 √ null
L_NOT_OP varchar 3 √ null
L_NO_OP_REASON int 4 √ null
L_START_TIME char 5 √ null
L_END_TIME char 5 √ null
L_INDICATION varchar 255 √ null
L_INCISION varchar 255 √ null
L_CLOSURE varchar 255 √ null
L_LATERALITY varchar 9 √ null
L_LATERALITY2 varchar 9 √ null
L_LATERALITY3 varchar 9 √ null
R_P_RAD_PROST varchar 9 √ null
L_FINDINGS text 2147483647 √ null
L_SPECIMENS text 2147483647 √ null
L_DRAINS text 2147483647 √ null
L_POST_OP text 2147483647 √ null
L_COMMENTS text 2147483647 √ null
R_P_REASON_PROSTATECTOMY int 4 √ null
R_P_PREVIOUS_MANAGEMENT int 4 √ null
R_P_PREVIOUS_ACTIVE_REASON int 4 √ null
R_JOINT_PROCEDURE varchar 5 √ null
R_JOINT_CONSULTANT varchar 50 √ null
R_P_REASON_CONVERTED 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_INTRA_COMP_PORT bit 1 √ null
R_INTRA_COMP_ROBOTIC bit 1 √ null
R_P_INTRA_COMP_DIFFICULT bit 1 √ null
R_P_INTRA_COMP_URETERIC bit 1 √ null
R_N_INTRA_COMP_PANCREATIC bit 1 √ null
R_N_INTRA_COMP_SPLENECTOMY bit 1 √ null
R_N_INTRA_COMP_LIVER bit 1 √ null
R_N_INTRA_COMP_PNEUMOTHORAX bit 1 √ null
R_N_INTRA_COMP_OTHER bit 1 √ null
R_C_INTRA_COMP_UNRESECTABLE bit 1 √ null
R_POST_COMP_NONE bit 1 √ null
R_POST_COMP_WOUND bit 1 √ null
R_POST_COMP_CHEST bit 1 √ null
R_POST_COMP_URINE bit 1 √ null
R_POST_COMP_ANASTOMATIC bit 1 √ null
R_POST_COMP_BLEEDING bit 1 √ null
R_POST_COMP_ILEUS bit 1 √ null
R_POST_COMP_OTHER bit 1 √ null
R_P_POST_COMP_SEPSIS bit 1 √ null
R_P_POST_COMP_HAEMATURIA bit 1 √ null
R_P_POST_COMP_PE bit 1 √ null
R_P_POST_COMP_PELVIC bit 1 √ null
R_N_POST_COMP_PAIN bit 1 √ null
R_P_POST_COMP_RENAL bit 1 √ null
R_C_POST_COMP_INTRA_AB bit 1 √ null
R_C_POST_COMP_LYMPHOCOELE bit 1 √ null
R_C_POST_COMP_WOUND bit 1 √ null
R_C_POST_COMP_BOWEL bit 1 √ null
ClavienDindoID int 4 √ null
ltblClavienDindo.ClavienDindoID Implied ConstraintR
R_LATE_COMP_NONE bit 1 √ null
R_LATE_COMP_OTHER bit 1 √ null
R_P_LATE_COMP_UTI bit 1 √ null
R_P_LATE_COMP_BLADDER bit 1 √ null
R_P_LATE_COMP_URETRAL bit 1 √ null
R_P_LATE_COMP_URINARY bit 1 √ null
R_P_LATE_COMP_HERNIA bit 1 √ null
R_N_LATE_COMP_WOUND bit 1 √ null
R_N_LATE_COMP_HERNIA bit 1 √ null
R_N_LATE_COMP_PAIN bit 1 √ null
R_N_LATE_COMP_DVT bit 1 √ null
R_N_LATE_COMP_RENAL bit 1 √ null
R_C_LATE_COMP_URETERO bit 1 √ null
R_C_LATE_COMP_STOMAL bit 1 √ null
R_C_LATE_COMP_NEOBLADDER bit 1 √ null
R_C_LATE_COMP_INCISIONAL bit 1 √ null
R_C_LATE_COMP_PARASTOMAL bit 1 √ null
R_C_LATE_COMP_BOWEL bit 1 √ null
R_N_OTHER_PRESENTATION_WEIGHTLOSS bit 1 √ null
R_N_OTHER_PRESENTATION_ANAEMIA bit 1 √ null
R_N_OTHER_PRESENTATION_PAIN bit 1 √ null
R_N_OTHER_PRESENTATION_UTI bit 1 √ null
R_N_OTHER_PRESENTATION_LUTS bit 1 √ null
R_N_OTHER_PRESENTATION_LETHARGY bit 1 √ null
R_N_OTHER_PRESENTATION_OTHER bit 1 √ null
R_N_OTHER_PROCEDURE int 4 √ null
R_N_CYTOREDUCTIVE varchar 3 √ null
R_N_TKI_INHIBITORS varchar 3 √ null
R_N_PARTIAL_INDICATION int 4 √ null
R_N_RENOGRAM varchar 5 √ null
R_N_ISCHAEMIA int 4 √ null
R_C_SURGICAL_TECHNIQUE int 4 √ null
R_C_LYMPH_NODE_NONE bit 1 √ null
R_C_LYMPH_NODE_OBTURATOR bit 1 √ null
R_C_LYMPH_NODE_EXT_ILIAC bit 1 √ null
R_C_LYMPH_NODE_INT_ILIAC bit 1 √ null
R_C_LYMPH_NODE_PRESACRAL bit 1 √ null
R_C_LYMPH_NODE_BIFURCATION bit 1 √ null
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
R_C_ADJUVANT_NONE bit 1 √ null
R_C_ADJUVANT_RADIO bit 1 √ null
R_C_ADJUVANT_CHEMO bit 1 √ null
R_C_ADJUVANT_OTHER bit 1 √ null
R_N_ADJUVANT_IMMUNOTHERAPY bit 1 √ null
R_N_ADJUVANT_HORMONE bit 1 √ null
R_N_ADJUVANT_RADIATION bit 1 √ null
R_N_ADJUVANT_EXCISION bit 1 √ null
R_N_ADJUVANT_METATASECTOMY bit 1 √ null
R_N_ADJUVANT_OTHER bit 1 √ null
R_N_METS_LUNG bit 1 √ null
R_N_METS_LYMPH bit 1 √ null
R_N_METS_LIVER bit 1 √ null
R_N_METS_BONE bit 1 √ null
R_N_METS_ADRENAL bit 1 √ null
R_N_METS_BRAIN bit 1 √ null
R_N_METS_SKIN bit 1 √ null
R_N_METS_OTHER bit 1 √ null
R_P_TOTAL_TRANSFUSION varchar 5 √ null
R_N_PROCEDURE_OTHER_SPECIFY varchar 255 √ null
R_C_CONCOMITANT_PROCEDURE varchar 255 √ null
R_N_NON_MALIGNANT int 4 √ null
PRE_TREAT_PSA real 4 √ null
ANAEROBIC_THRESHOLD real 4 √ null
CPEX_TESTING int 4 √ null
DIVERSION_PROCEDURE int 4 √ null
OFFERED_PREOP_NEOADJ_CHEMO int 4 √ null
PREOP_HB int 4 √ null
URETHAL_BIOPSY_PERFORMED int 4 √ null
URETHAL_BIOPSY_RESULTS int 4 √ null
ENHANCED_RECOVERY_PATHWAY int 4 √ null
IF_RECTAL_INJURY int 4 √ null
RADIOLOGICAL_INTERVENTION int 4 √ null
RADIOLOGICAL_INTERVENTION_TYPE int 4 √ null
UNPLANNED_READMISSION_TO_HOSPITAL int 4 √ null
CRP int 4 √ null
ESR int 4 √ null
IVC_REPLACEMENT int 4 √ null
PRE_OPERATIVE_DIAGNOSIS int 4 √ null
REFERRAL_TYPE int 4 √ null
SERUM_ALBUMIN int 4 √ null
SURGICAL_HISTORY int 4 √ null
PLANNED_ITU_ADMISSION int 4 √ null
GENETIC_SYNDROME int 4 √ null
GENETIC_SYNDROME_OTHER varchar 255 √ null
OTHER_ADDITIONAL_SYNC_PROCEDURES int 4 √ null
RECTAL_INJURY int 4 √ null
OTHER_ADDITIONAL_PROCEDURES_SPECIFY varchar 255 √ null
HEIGHT real 4 √ null
WEIGHT real 4 √ null
R_N_OTHER_PRESENTATION_SYMP_METS bit 1 √ null
R_N_OTHER_ADD_PROCS_LIVER bit 1 √ null
R_N_OTHER_ADD_PROCS_CONT_NEPH bit 1 √ null
R_N_OTHER_ADD_PROCS_SPLENECTOMY bit 1 √ null
R_N_OTHER_ADD_PROCS_BOWEL bit 1 √ null
R_N_OTHER_ADD_PROCS_PANCREATIC bit 1 √ null
R_N_OTHER_ADD_PROCS_CONT_ADRENAL bit 1 √ null
R_N_OTHER_ADD_PROCS_OTHER_METS bit 1 √ null
R_N_OTHER_ADD_PROCS_OTHER bit 1 √ 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
MINIMALLY_INVASIVE int 4 √ null
ABSOLUTE_BILATERAL bit 1 √ null
ABSOLUTE_SINGLE_KIDNEY bit 1 √ null
ABSOLUTE_RENAL_IMPAIRMENT bit 1 √ null
POST_COMP_RETURN_TO_THEATRE bit 1 √ null
POST_COMP_LYMPHOCOEL bit 1 √ null
CYTOLOGY_RESULT int 4 √ null
INTRA_COMP_DEATH_ON_TABLE bit 1 √ null
POST_COMP_DVT_PE bit 1 √ null
POST_COMP_MI bit 1 √ null
FUNDING_CATEGORY int 4 √ null
DIED_ON_TABLE bit 1 √ null
BAUS_CONSENT int 4 √ null

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views