tblSURGERY_UROLOGY


Columns

Column Type Size Nulls Auto Default Children Parents Comments
URO_SURG_ID int identity 4 √ null
tblSURGERY_UROLOGY_CHARLSON_MAPPING.UrologySurgeryID FK_tblSURGERY_UROLOGY_CHARLSON_MAPPING_tblSURGERY_UROLOGYC

Record ID
SURGERY_ID int 4 null
tblMAIN_SURGERY.SURGERY_ID FK_tblSURGERY_UROLOGY_tblMAIN_SURGERYC

Surgery Record ID
R_ENDO_RESECTION varchar 50 √ null

Endoscopic Resection
R_ENDO_CHEMO varchar 50 √ null

Endoscopic Resection + 1 Shot Intra-Vesical Chemo
R_ABLATIVE_SURGERY varchar 50 √ null

Radical Ablative
R_ORGAN_CONSERVING varchar 50 √ null

Organ Conserving
R_OTHER_SURGERY varchar 50 √ null

Other Surgery
R_LAP_SURGERY varchar 50 √ null

Laparoscopic Surgery
R_SPECIFY_SURGERY varchar 255 √ null

Other Surgery - Specify
R_SPECIFY_LAP varchar 255 √ null

Laparoscopic Surgery - Specify
R_SUPERVISED varchar 3 √ null

Supervised by Consultant
R_DISSECTION int 4 √ null

Lymph Node Dissection
R_DURATION int 4 √ null

Field not in use
R_TRANSFUSION int 4 √ null

No. Units Blood Transfused
R_BLOOD_LOSS real 4 √ null

Measured Blood Loss
R_IN_COMPLICATIONS varchar 255 √ null

Intra-op Complications
R_SIGNIFICANCE varchar 50 √ null

Significance of Complication
R_POTENCY varchar 50 √ null

Pre-op Potency
R_CONTINENCE varchar 50 √ null

Pre-op Continence
R_P_PRESENTATION varchar 50 √ null

Presentation
R_P_TURP varchar 3 √ null

Previous TURP
R_P_SPARING varchar 50 √ null

Nerve Sparing
R_P_APPROACH int 4 √ null

Approach
R_P_CONVERTED varchar 3 √ null

Conversion To Open Required
R_P_CONVERTED_REASON varchar 255 √ null

Conversion Reason
R_C_INDICATION int 4 √ null

Indication for Cystectomy
R_C_OTHER_INDICATION varchar 255 √ null

txt_Other_Indication
R_C_SERUM real 4 √ null

Serum Creatinine
R_C_PROCEDURE int 4 √ null

Diversion Procedure
R_C_ORTHOTOPIC varchar 255 √ null

Type of Diversion
R_C_OTHER varchar 255 √ null

Other Diversion
R_C_CONVERTED varchar 3 √ null

Converted
R_C_CONVERTED_REASON varchar 255 √ null

Reason Converted
R_C_URETHRECTOMY varchar 3 √ null

Combined Synchronous Urethrectomy
R_C_NEPHROURECTERECTOMY varchar 3 √ null

Combined Synchronous Nephroureterectomy
R_C_UPPER_TRACT varchar 3 √ null

Upper Tract Disease
R_C_STATUS int 4 √ null

Status Upper Tracts
R_C_OTHER_TRACT varchar 255 √ null

Other Status
R_N_PRESENTATION varchar 50 √ null

Presentation (Nephrectomy)
R_N_OTHER_PRES varchar 255 √ null

Other Presentation (Nephrectomy)
R_N_SERUM real 4 √ null

Serum Creatinine
R_N_eGFR int 4 √ null

eGFR
R_N_METS varchar 50 √ null

Clinical Evidence of Mets
R_N_MET_SITES varchar 255 √ null

Field not in use
R_N_NUMBER_METS int 4 √ null

No. Met Sites
R_N_HB varchar 10 √ null

txt_Hb
R_N_LYMPHOCYTES varchar 10 √ null

Lymphocytes
R_N_WBC varchar 10 √ null

Total WBC
R_N_PLATELETS varchar 10 √ null

Platelets
R_N_NEUTROPHILS varchar 10 √ null

Neutrophils
R_N_WHO int 4 √ null

WHO Status
R_N_BIOPSY varchar 3 √ null

Field not in use
R_N_VENA_CAVA varchar 3 √ null

Exploration Vena Cava
R_N_SITE_VC varchar 50 √ null

Field not in use
R_N_LEVEL int 4 √ null

Level
R_N_LIVER varchar 3 √ null

Liver Mobilisation
R_N_CARDIOPULMONARY varchar 3 √ null

Cardiopulmonary Bypass
R_N_CIRCULATORY varchar 3 √ null

Circulatory Arrest
R_N_IVC varchar 3 √ null

Complete Excision from IVC
R_N_OPEN varchar 50 √ null

Open Approach
R_N_LAPAROSCOPIC varchar 50 √ null

Laparoscopic Approach
R_N_CONVERTED varchar 3 √ null

Conversion
R_N_REASON int 4 √ null

Conversion Reason
R_N_CONVERTED_REASON varchar 255 √ null

Other Reason
R_N_RETRIEVAL int 4 √ null

Kidney Retrieval
R_N_ISCHAEMIC int 4 √ null

Ischaemic Time (minutes)
R_N_COOLING varchar 3 √ null

Renal Cooling
R_N_COMPS int 4 √ null

Severity of Complications
L_NOT_OP varchar 3 √ null

Operation not performed
L_NO_OP_REASON int 4 √ null

Reason operation not performed
L_START_TIME char 5 √ null

Start Time
L_END_TIME char 5 √ null

End Time (Wound Closure)
L_INDICATION varchar 255 √ null

Indication for Surgery
L_INCISION varchar 255 √ null

Incision
L_CLOSURE varchar 255 √ null

Closure
L_LATERALITY varchar 9 √ null

Primary Procedure - Laterality
L_LATERALITY2 varchar 9 √ null

Sub-Procedure 1 - Laterality
L_LATERALITY3 varchar 9 √ null

Sub-Procedure 2 - Laterality
R_P_RAD_PROST varchar 9 √ null

Radical Ablative
L_FINDINGS text 2147483647 √ null

Findings
L_SPECIMENS text 2147483647 √ null

Specimens
L_DRAINS text 2147483647 √ null

Drains
L_POST_OP text 2147483647 √ null

Post-Op Instructions
L_COMMENTS text 2147483647 √ null

Procedure
R_P_REASON_PROSTATECTOMY int 4 √ null

Reason For Prostatectomy
R_P_PREVIOUS_MANAGEMENT int 4 √ null

Previous Management
R_P_PREVIOUS_ACTIVE_REASON int 4 √ null

Reason If Previous Active Surveillance
R_JOINT_PROCEDURE varchar 5 √ null

Was This Procedure Performed Jointly With Another Consultant?
R_JOINT_CONSULTANT varchar 50 √ null

Joint Surgeon
R_P_REASON_CONVERTED int 4 √ null

Conversion Reason
R_INTRA_COMP_NONE bit 1 √ null

Intra-op Complications - None
R_INTRA_COMP_BLEEDING bit 1 √ null

Intra-op Complications - Problematic Bleeding
R_INTRA_COMP_RECTAL bit 1 √ null

Intra-op Complications - Rectal Injury
R_INTRA_COMP_BOWEL bit 1 √ null

Intra-op Complications - Small Bowel Injury
R_INTRA_COMP_VASCULAR bit 1 √ null

Intra-op Complications - Vascular Injury
R_INTRA_COMP_ADHESIONS bit 1 √ null

Intra-op Complications - Adhesions
R_INTRA_COMP_NERVE bit 1 √ null

Intra-op Complications - Nerve Injury
R_INTRA_COMP_PORT bit 1 √ null

Intra-op Complications - Port complications
R_INTRA_COMP_ROBOTIC bit 1 √ null

Intra-op Complications - Robotic device failure
R_P_INTRA_COMP_DIFFICULT bit 1 √ null

Intra-op Complications - Difficult Dissection
R_P_INTRA_COMP_URETERIC bit 1 √ null

Intra-op Complications - Ureteric injury
R_N_INTRA_COMP_PANCREATIC bit 1 √ null

Intra-op Complications - Pancreatic Injury
R_N_INTRA_COMP_SPLENECTOMY bit 1 √ null

Intra-op Complications - Splenectomy
R_N_INTRA_COMP_LIVER bit 1 √ null

Intra-op Complications - Liver injury
R_N_INTRA_COMP_PNEUMOTHORAX bit 1 √ null

Intra-op Complications - Pneumothorax
R_N_INTRA_COMP_OTHER bit 1 √ null

Intra-op Complications - Other
R_C_INTRA_COMP_UNRESECTABLE bit 1 √ null

Intra-op Complications - Unresectable Tumour
R_POST_COMP_NONE bit 1 √ null

Postoperative Complications - None
R_POST_COMP_WOUND bit 1 √ null

Postoperative Complications - Wound Infection
R_POST_COMP_CHEST bit 1 √ null

Postoperative Complications - Chest Infection
R_POST_COMP_URINE bit 1 √ null

Postoperative Complications - Urine Leak
R_POST_COMP_ANASTOMATIC bit 1 √ null

Postoperative Complications - Anastomotic Leak
R_POST_COMP_BLEEDING bit 1 √ null

Postoperative Complications - Haemorrhage / Bleeding
R_POST_COMP_ILEUS bit 1 √ null

Postoperative Complications - Ileus
R_POST_COMP_OTHER bit 1 √ null

Postoperative Complications - Other
R_P_POST_COMP_SEPSIS bit 1 √ null

Postoperative Complications - Sepsis
R_P_POST_COMP_HAEMATURIA bit 1 √ null

Postoperative Complications - Haematuria
R_P_POST_COMP_PE bit 1 √ null

Postoperative Complications - PE / DVT
R_P_POST_COMP_PELVIC bit 1 √ null

Postoperative Complications - Pelvic Haematoma
R_N_POST_COMP_PAIN bit 1 √ null

Postoperative Complications - Problematic Pain Control
R_P_POST_COMP_RENAL bit 1 √ null

Postoperative Complications - Renal Failure
R_C_POST_COMP_INTRA_AB bit 1 √ null

Postoperative Complications - Intra-Abdominal Infection
R_C_POST_COMP_LYMPHOCOELE bit 1 √ null

Postoperative Complications - Lymphocoele
R_C_POST_COMP_WOUND bit 1 √ null

Postoperative Complications - Wound Infection
R_C_POST_COMP_BOWEL bit 1 √ null

Postoperative Complications - Bowel Obstruction
R_CLAVIEN_DINDO_I bit 1 √ null

Clavien Dindo Grade I
R_CLAVIEN_DINDO_II bit 1 √ null

Clavien Dindo Grade II
R_CLAVIEN_DINDO_IIIa bit 1 √ null

Clavien Dindo Grade IIIa
R_CLAVIEN_DINDO_IIIb bit 1 √ null

Clavien Dindo Grade IIIb
R_CLAVIEN_DINDO_IVa bit 1 √ null

Clavien Dindo Grade IVa
R_CLAVIEN_DINDO_IVb bit 1 √ null

Clavien Dindo Grade IVb
R_CLAVIEN_DINDO_V bit 1 √ null

Clavien Dindo Grade V
R_LATE_COMP_NONE bit 1 √ null

Field not in use
R_LATE_COMP_OTHER bit 1 √ null

Field not in use
R_P_LATE_COMP_UTI bit 1 √ null

Field not in use
R_P_LATE_COMP_BLADDER bit 1 √ null

Field not in use
R_P_LATE_COMP_URETRAL bit 1 √ null

Field not in use
R_P_LATE_COMP_URINARY bit 1 √ null

Field not in use
R_P_LATE_COMP_HERNIA bit 1 √ null

Field not in use
R_N_LATE_COMP_WOUND bit 1 √ null

Field not in use
R_N_LATE_COMP_HERNIA bit 1 √ null

Field not in use
R_N_LATE_COMP_PAIN bit 1 √ null

Field not in use
R_N_LATE_COMP_DVT bit 1 √ null

Field not in use
R_N_LATE_COMP_RENAL bit 1 √ null

Field not in use
R_C_LATE_COMP_URETERO bit 1 √ null

Field not in use
R_C_LATE_COMP_STOMAL bit 1 √ null

Field not in use
R_C_LATE_COMP_NEOBLADDER bit 1 √ null

Field not in use
R_C_LATE_COMP_INCISIONAL bit 1 √ null

Field not in use
R_C_LATE_COMP_PARASTOMAL bit 1 √ null

Field not in use
R_C_LATE_COMP_BOWEL bit 1 √ null

Field not in use
R_N_OTHER_PRESENTATION_WEIGHTLOSS bit 1 √ null

Presentation Other - Weight Loss
R_N_OTHER_PRESENTATION_ANAEMIA bit 1 √ null

Presentation Other - Anaemia
R_N_OTHER_PRESENTATION_PAIN bit 1 √ null

Presentation Other - Pain
R_N_OTHER_PRESENTATION_UTI bit 1 √ null

Presentation Other - Recurrent UTI
R_N_OTHER_PRESENTATION_LUTS bit 1 √ null

Presentation Other - LUTS
R_N_OTHER_PRESENTATION_LETHARGY bit 1 √ null

Presentation Other - Lethargy
R_N_OTHER_PRESENTATION_OTHER bit 1 √ null

Presentation Other - Other
R_N_OTHER_PROCEDURE int 4 √ null

Other Procedure
R_N_CYTOREDUCTIVE varchar 3 √ null

Cytoreductive
R_N_TKI_INHIBITORS varchar 3 √ null

Pre-op TKI Inhibitors
R_N_PARTIAL_INDICATION int 4 √ null

Partial Indication
R_N_RENOGRAM varchar 5 √ null

Pre-Op Renogram For Split Function?
R_N_ISCHAEMIA int 4 √ null

Ischaemia
R_C_SURGICAL_TECHNIQUE int 4 √ null

Surgical Technique
R_C_LYMPH_NODE_NONE bit 1 √ null

Lymph Node Dissection - None
R_C_LYMPH_NODE_OBTURATOR bit 1 √ null

Lymph Node Dissection - Obturator
R_C_LYMPH_NODE_EXT_ILIAC bit 1 √ null

Lymph Node Dissection - External Iliac
R_C_LYMPH_NODE_INT_ILIAC bit 1 √ null

Lymph Node Dissection - Internal Iliac
R_C_LYMPH_NODE_PRESACRAL bit 1 √ null

Lymph Node Dissection - Presacral
R_C_LYMPH_NODE_BIFURCATION bit 1 √ null

Lymph Node Dissection - Above Iliac Bifuraction
R_C_RETURN_THEATRE_HAEMORRHAGE bit 1 √ null

Reason For Return To Theatre - Haemorrhage
R_C_RETURN_THEATRE_ANASTOMOTIC bit 1 √ null

Reason For Return To Theatre - Anastomotic Leak
R_C_RETURN_THEATRE_BOWEL bit 1 √ null

Reason For Return To Theatre - Bowel Leak
R_C_RETURN_THEATRE_WOUND bit 1 √ null

Reason For Return To Theatre - Wound dehiscence
R_C_ADJUVANT_NONE bit 1 √ null

Field not in use
R_C_ADJUVANT_RADIO bit 1 √ null

Field not in use
R_C_ADJUVANT_CHEMO bit 1 √ null

Field not in use
R_C_ADJUVANT_OTHER bit 1 √ null

Field not in use
R_N_ADJUVANT_IMMUNOTHERAPY bit 1 √ null

Field not in use
R_N_ADJUVANT_HORMONE bit 1 √ null

Field not in use
R_N_ADJUVANT_RADIATION bit 1 √ null

Field not in use
R_N_ADJUVANT_EXCISION bit 1 √ null

Field not in use
R_N_ADJUVANT_METATASECTOMY bit 1 √ null

Field not in use
R_N_ADJUVANT_OTHER bit 1 √ null

Field not in use
R_N_METS_LUNG bit 1 √ null

Site(s) of Mets - Lung
R_N_METS_LYMPH bit 1 √ null

Site(s) of Mets - Lymph Nodes
R_N_METS_LIVER bit 1 √ null

Site(s) of Mets - Liver
R_N_METS_BONE bit 1 √ null

Site(s) of Mets - Bone
R_N_METS_ADRENAL bit 1 √ null

Site(s) of Mets - Adrenal
R_N_METS_BRAIN bit 1 √ null

Site(s) of Mets - Brain
R_N_METS_SKIN bit 1 √ null

Site(s) of Mets - Skin
R_N_METS_OTHER bit 1 √ null

Site(s) of Mets - Other
R_P_TOTAL_TRANSFUSION varchar 5 √ null

Total Blood Transfused (During Entire Admission)
R_N_PROCEDURE_OTHER_SPECIFY varchar 255 √ null

Other Procedure (Specify)
R_C_CONCOMITANT_PROCEDURE varchar 255 √ null

Concomitant Procedures
R_N_NON_MALIGNANT int 4 √ null

Non-malignant Diagnosis
PRE_TREAT_PSA real 4 √ null

Pre-Treatment PSA
ANAEROBIC_THRESHOLD real 4 √ null

Anaerobic Threshold
CPEX_TESTING int 4 √ null

CPEX Testing
DIVERSION_PROCEDURE int 4 √ null

Field not in use
OFFERED_PREOP_NEOADJ_CHEMO int 4 √ null

Patient offered Pre-operative Neoadjuvant Chemotherapy?
PREOP_HB int 4 √ null

Pre-Op Hb (g/L)
URETHAL_BIOPSY_PERFORMED int 4 √ null

Urethral Biopsy performed?
URETHAL_BIOPSY_RESULTS int 4 √ null

Urethral Biopsy Result
ENHANCED_RECOVERY_PATHWAY int 4 √ null

Enhanced Recovery Pathway
IF_RECTAL_INJURY int 4 √ null

Rectal Injury
RADIOLOGICAL_INTERVENTION int 4 √ null

Radiological Intervention
RADIOLOGICAL_INTERVENTION_TYPE int 4 √ null

Radiological Intervention Type
UNPLANNED_READMISSION_TO_HOSPITAL int 4 √ null

Unplanned Readmission to Hospital
CRP int 4 √ null

CRP
ESR int 4 √ null

ESR
IVC_REPLACEMENT int 4 √ null

IVC Replacement
PRE_OPERATIVE_DIAGNOSIS int 4 √ null

Pre-operative Diagnosis
REFERRAL_TYPE int 4 √ null

Referral Type
SERUM_ALBUMIN int 4 √ null

Serum Albumin
SURGICAL_HISTORY int 4 √ null

Surgial History
PLANNED_ITU_ADMISSION int 4 √ null

Planned ITU admission
GENETIC_SYNDROME int 4 √ null

Genetic Syndrome
GENETIC_SYNDROME_OTHER varchar 255 √ null

Genetic Syndrome - Other (Specify)
OTHER_ADDITIONAL_SYNC_PROCEDURES int 4 √ null

Other additional synchronous procedures
RECTAL_INJURY int 4 √ null

Field not in use
OTHER_ADDITIONAL_PROCEDURES_SPECIFY varchar 255 √ null

Other additional procedures - Specify
HEIGHT real 4 √ null

Height
WEIGHT real 4 √ null

Weight
R_N_OTHER_PRESENTATION_SYMP_METS bit 1 √ null

Presentation Other - Symptomatic Metastases
R_N_OTHER_ADD_PROCS_LIVER bit 1 √ null

Other additional procedures - Liver Resection
R_N_OTHER_ADD_PROCS_CONT_NEPH bit 1 √ null

Other additional procedures - Contralateral Nephrectomy
R_N_OTHER_ADD_PROCS_SPLENECTOMY bit 1 √ null

Other additional procedures - Splenectomy
R_N_OTHER_ADD_PROCS_BOWEL bit 1 √ null

Other additional procedures - Bowel Resection
R_N_OTHER_ADD_PROCS_PANCREATIC bit 1 √ null

Other additional procedures - Pancreatic Resection
R_N_OTHER_ADD_PROCS_CONT_ADRENAL bit 1 √ null

Other additional procedures - Contralateral Adrenalectomy
R_N_OTHER_ADD_PROCS_OTHER_METS bit 1 √ null

Other additional procedures - Resection of Other Metastases
R_N_OTHER_ADD_PROCS_OTHER bit 1 √ null

Other additional procedures - Other
R_C_LYMPH_NODE_LEVEL_1 bit 1 √ null

Lymph Node Dissection - Level I
R_C_LYMPH_NODE_LEVEL_2 bit 1 √ null

Lymph Node Dissection - Level II
R_C_LYMPH_NODE_LEVEL_3 bit 1 √ null

Lymph Node Dissection - Level III
MINIMALLY_INVASIVE int 4 √ null

If minimally invasive
ABSOLUTE_BILATERAL bit 1 √ null

If Absolute - Bilateral
ABSOLUTE_SINGLE_KIDNEY bit 1 √ null

If Absolute - Single Kidney
ABSOLUTE_RENAL_IMPAIRMENT bit 1 √ null

If Absolute - Renal Impairment
POST_COMP_RETURN_TO_THEATRE bit 1 √ null

Postoperative Complications - Return to Theatre
POST_COMP_LYMPHOCOEL bit 1 √ null

Postoperative Complications - Lymphocoele
CYTOLOGY_RESULT int 4 √ null

Cytology Result
INTRA_COMP_DEATH_ON_TABLE bit 1 √ null

Intra-op Complications - Death on table
POST_COMP_DVT_PE bit 1 √ null

Postoperative Complications - DVT/PE (Nephrectomy)
POST_COMP_MI bit 1 √ null

Postoperative Complications - MI (Cystectomy)
PREV_TEMPLATE_BIOPSY int 4 √ null

Previous Template Biopsy
FUNDING_CATEGORY int 4 √ null

Funding Category
DIED_ON_TABLE bit 1 √ null

Patient died on table
RETURN_TO_THEATRE bit 1 √ null

Return to Theatre
BAUS_CONSENT int 4 √ null

Has the patient consented to their data being entered? (BAUS Proforma)
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
PADUA_LONGITUDINAL int 4 √ null
PADUA_EXOPHYTIC int 4 √ null
PADUA_RENALRIM int 4 √ null
PADUA_RENALSINUS int 4 √ null
PADUA_URINARY int 4 √ null
PADUA_TUMOUR int 4 √ null
PADUA_FACE int 4 √ null
DIFF_PROC_COMMENTS varchar 1024 √ null

If procedure or technique for contralateral nephrectomy different, specify here
ClavienDindoID int 4 √ null
ltblClavienDindo.ClavienDindoID Implied ConstraintR
POST_COMP_PROBLEMATIC_PAIN_CONTROL bit 1 √ null
UreterRemoved int 4 √ null
ReasonUreter int 4 √ null
TotalPelvicExenteration int 4 √ null
PreviousLaparotomy bit 1 √ null
BAUSSiteOfMainTumour int 4 √ null
BAUSSynchronous bit 1 ((0))
BAUSPrevRec bit 1 ((0))
DEPRECATED_20_02_ProstateBiopsyTechnique int 4 √ null
DEPRECATED_20_02_ltblProstateBiopsyTechnique2.ID FK_tblSURGERY_UROLOGY_ltblProstateBiopsyTechnique2R
DEPRECATED_20_02_BiopsyAnaesthetic int 4 √ null
ltblBiopsyAnaesthetic.ID FK_tblSURGERY_UROLOGY_ltblBiopsyAnaestheticR

Indexes

Constraint Name Type Sort Column(s)
PK_tblSURGERY_UROLOGY Primary key Asc URO_SURG_ID

Relationships

Close relationships within degrees of separation