vwBAUS_NEPHRECTOMY_GENERIC


Columns

Column Type Size Nulls Auto Default Children Parents Comments
pid int 4 null
CARE_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
OTHER_DEATH_CAUSE_UROLOGY varchar 255 √ null
OrganisationTreatment varchar 5 √ null
SURGERY_ID int 4 null
N7_8_ADMISSION_DATE smalldatetime 16 √ null
URO_SURG_ID int 4 null
R_N_PRESENTATION varchar 50 √ 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_PRESENTATION_SYMP_METS bit 1 √ null
SURGICAL_HISTORY int 4 √ null
ASAGrade int 4 √ null
R_N_WHO int 4 √ null
BMI float 8 √ null
HEIGHT real 4 √ null
WEIGHT real 4 √ null
N7_9_SURGERY_DATE smalldatetime 16 √ null
PRE_OPERATIVE_DIAGNOSIS int 4 √ null
N4_5_HISTOLOGY varchar 10 √ null
R_N_NON_MALIGNANT 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
R_N_HB varchar 10 √ null
CYTOLOGY_RESULT int 4 √ null
R_N_SERUM real 4 √ null
R_N_eGFR int 4 √ null
CRP int 4 √ null
ESR int 4 √ null
SERUM_ALBUMIN int 4 √ 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
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
REFERRAL_TYPE int 4 √ null
L_PROCEDURE int 4 √ null
L_PROCEDURE2 int 4 √ null
L_PROCEDURE3 int 4 √ null
L_PROCEDURE4 int 4 √ null
R_N_OTHER_PROCEDURE int 4 √ null
R_N_PROCEDURE_OTHER_SPECIFY varchar 255 √ null
OTHER_ADDITIONAL_SYNC_PROCEDURES int 4 √ 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
OTHER_ADDITIONAL_PROCEDURES_SPECIFY varchar 255 √ null
L_LATERALITY varchar 9 √ 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
GENETIC_SYNDROME int 4 √ null
GENETIC_SYNDROME_OTHER varchar 255 √ null
ABSOLUTE_BILATERAL bit 1 √ null
ABSOLUTE_SINGLE_KIDNEY bit 1 √ null
ABSOLUTE_RENAL_IMPAIRMENT bit 1 √ null
R_DISSECTION int 4 √ null
R_N_VENA_CAVA varchar 3 √ null
R_N_LEVEL int 4 √ null
R_N_CARDIOPULMONARY varchar 3 √ null
R_N_CIRCULATORY varchar 3 √ null
R_N_IVC varchar 3 √ null
IVC_REPLACEMENT int 4 √ null
R_C_SURGICAL_TECHNIQUE int 4 √ 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_RETRIEVAL int 4 √ null
R_N_ISCHAEMIA int 4 √ null
R_N_ISCHAEMIC int 4 √ null
OperatingTime 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_BOWEL 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
INTRA_COMP_DEATH_ON_TABLE bit 1 √ null
R_N_INTRA_COMP_OTHER bit 1 √ null
R_POST_COMP_NONE bit 1 √ null
R_POST_COMP_CHEST bit 1 √ null
R_POST_COMP_WOUND bit 1 √ null
POST_COMP_PROBLEMATIC_PAIN_CONTROL bit 1 √ null
R_POST_COMP_ILEUS bit 1 √ null
R_POST_COMP_BLEEDING bit 1 √ null
R_P_POST_COMP_RENAL bit 1 √ null
R_POST_COMP_OTHER bit 1 √ null
POST_COMP_DVT_PE bit 1 √ null
ClavienDindoID int 4 √ null
ltblClavienDindo.ClavienDindoID Implied ConstraintR
DIED_ON_TABLE bit 1 √ null
L_DEATH_STATUS int 4 √ null
N15_1_DATE_DEATH date 20 √ null
N15_2_DEATH_LOCATION int 4 √ null
CAUSE_OF_DEATH_UROLOGY int 4 √ null
AVOIDABLE_DEATH bit 1 √ null
AVOIDABLE_DETAILS varchar 255 √ null
TransferredToITU int 4 null
PLANNED_ITU_ADMISSION int 4 √ null
N7_12_DISCHARGE_DATE smalldatetime 16 √ null
N7_13_DISCHARGE_DESTINATION int 4 √ null
PATH_BIOPSY_SAMPLE_DATE smalldatetime 16 √ null
PATH_BIOPSY_BIOPSY_RESULT int 4 √ null
PATH_BIOPSY_N8_11_GRADE_DIFF varchar 2 √ null
PATH_BIOPSY_R_SIZE_TUMOUR_RCC real 4 √ null
L_NSTS_STATUS int 4 √ null
N4_2_DIAGNOSIS_CODE varchar 5 √ null
FUNDING_CATEGORY int 4 √ null
PADUA_LONGITUDINAL int 4 √ null
PADUA_EXOPHYTIC int 4 √ null
PADUA_RENALRIM int 4 √ null
PADUA_RENALSINUS int 4 √ null
PADUA_TUMOUR int 4 √ null
PADUA_FACE int 4 √ null
PADUA_URINARY int 4 √ null
UreterRemoved int 4 √ null
ReasonUreter int 4 √ null
UreterTechnique int 4 √ null
BAUSSiteOfMainTumour int 4 √ null
BAUSSynchronous int 4 √ null
BAUSPrevRec int 4 √ null
POST_OP_HIST_DIAGNOSIS_LEFT int 4 √ null
POST_OP_HIST_DIAGNOSIS_RIGHT int 4 √ null
TUMOUR_DIAMETER_LEFT real 4 √ null
TUMOUR_DIAMETER_RIGHT real 4 √ null
NECROSIS_LEFT varchar 3 √ null
NECROSIS_RIGHT varchar 3 √ null
NUCLEAR_GRADE_LEFT int 4 √ null
NUCLEAR_GRADE_RIGHT int 4 √ null
MARGINS_LEFT varchar 2 √ null
MARGINS_RIGHT varchar 2 √ null
NO_OF_TUMOURS_LEFT int 4 √ null
NO_OF_TUMOURS_RIGHT int 4 √ null
CIS_LEFT varchar 3 √ null
CIS_RIGHT varchar 3 √ null
GRADE_OF_TUMOUR_LEFT char 2 √ null
GRADE_OF_TUMOUR_RIGHT char 2 √ null
MULTI_TUMOUR_COMMENTS_LEFT varchar 2147483647 √ null
MULTI_TUMOUR_COMMENTS_RIGHT varchar 2147483647 √ null
T_STAGE_LEFT varchar 8 null
T_STAGE_RIGHT varchar 8 null
N_STAGE_LEFT varchar 5 null
N_STAGE_RIGHT varchar 5 null
M_STAGE_LEFT varchar 5 null
M_STAGE_RIGHT varchar 5 null
BAUS_CONSENT int 4 √ null
DIFF_PROC_COMMENTS varchar 1024 √ null

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views