vwNOGCA_PROCEDURES


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
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
N_UG1_PHYSIO_SCORE real 4 √ null
N_UG2_OP_SCORE real 4 √ null
R_OUTCOME varchar 20 √ null
R_DELAY int 4 √ null
R_DELAY_REASON varchar 50 √ null
R_NODAL varchar 50 √ null
R_RECONSTRUCTION varchar 50 √ null
R_ENDO_MORB varchar 50 √ null
L_NUTRITIONAL_SUP varchar 50 √ null
L_MORBIDITY real 4 √ null
L_MORTALITY real 4 √ null
ASAGrade 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_PAIN int 4 √ null
L_PAIN_DETAIL varchar 255 √ null
L_THORACIC int 4 √ null
L_ABDOMINAL int 4 √ null
L_LIVER int 4 √ null
L_PANCREAS int 4 √ null
L_SPLEEN int 4 √ null
L_COLON int 4 √ null
L_OTHER_ORGAN int 4 √ null
L_ANAESTHETIC int 4 √ null
L_STENT_MULTIPLE varchar 1 √ null
L_STENT_TYPE int 4 √ null
L_STENT_PLACEMENT int 4 √ null
L_STENT_JUNCTION varchar 1 √ null
L_STENT_DEPLOYED varchar 1 √ 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

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views