tblMAIN_ASSESSMENT


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ASSESSMENT_ID int identity 4 √ null
tblASSESSMENT_GYNAECOLOGY.ASSESSMENT_ID FK_tblASSESSMENT_GYNAECOLOGY_tblMAIN_ASSESSMENTC
tblASSESSMENT_HEAD_NECK.ASSESSMENT_ID FK_tblASSESSMENT_HEAD_NECK_tblMAIN_ASSESSMENTC
tblASSESSMENT_UPPER_GI.ASSESSMENT_ID FK_tblASSESSMENT_UPPER_GI_tblMAIN_ASSESSMENTC
tblASSESSMENT_UROLOGY.ASSESSMENT_ID FK_tblASSESSMENT_UROLOGY_tblMAIN_ASSESSMENTC

Unique Record ID (Auto)
CARE_ID int 4 null
tblMAIN_REFERRALS.CARE_ID FK_tblMAIN_ASSESSMENT_tblMAIN_REFERRALSC

Referral Record ID
TEMP_ID varchar 255 √ null
ltblTEMP_NHS_NUMBERS.TEMP_ID Implied ConstraintR

System ID
N14_1_ASSESSMENT_DATE smalldatetime 16 √ null

Date of Follow-up
N14_2_TUMOUR_STATUS int 4 √ null

Primary Tumour Status
N14_3_NODE_STATUS int 4 √ null

Nodal Status
N14_4_METS_STATUS int 4 √ null

Metastatic Status
N14_5_MARKER_RESPONSE int 4 √ null

Marker Response Status
N14_6_WHO_STATUS int 4 √ null

Performance Status (WHO)
N14_7_MORBIDITY_TYPE int 4 √ null

Treatment Morbidity
N14_8_MORBIDITY_CODE varchar 5 √ null

Morbidity - Surgery
N14_9_FOLLOW_UP int 4 √ null

Follow-up Status
N14_10_CHEMO_MORBIDITY int 4 √ null

Morbidity - Chemotherapy
N14_11_RADIO_MORBIDITY int 4 √ null

Morbidity - Radiotherapy
N14_12_COMB_MORBIDITY int 4 √ null

Morbidity - Combination
N_SK24_TUMOUR_STATUS int 4 √ null

Tumour Status (Skin only)
N_L21_RECEIVED_PCI varchar 1 √ null

Did patient receive Prophylactic Cranial Irradiation (Lung only)
N_L30_PLAN varchar 1 √ null

Original treatment plan carried out (Lung only)
N_L31_FAILURE varchar 2 √ null

Reason original treatment plan failed (Lung only)
R_ORG_CODE varchar 5 √ null

Organisation
R_ALIVE_DATE smalldatetime 16 √ null

Date Last Known Alive (Head and Neck only)
R_ABROAD_DATE smalldatetime 16 √ null

Date Gone Abroad (Head and Neck only)
R_MODE_FOLLOWUP int 4 √ null

Mode of Follow-up (Colorectal only)
L_OTHER_MODE varchar 255 √ null

Other Mode of Follow-up
R_RECURRENCE_BY int 4 √ null

Diagnosed By (Colorectal only)
R_DATE_RECURRENCE smalldatetime 16 √ null

Date Diagnosed (Colorectal only)
R_POTENCY varchar 50 √ null

Post-op Potency (Urology only)
R_CONTINENCE varchar 50 √ null

Post-op Continence (Urology only)
R_INTERVENTION int 4 √ null

Intervention/Adjuvent Treatment (Urology only)
R_OTHER_INTERVENTION varchar 255 √ null

Other Intervention/Treatment (Urology only)
R_COMPLICATIONS int 4 √ null

Complications (Urology only)
R_OTHER_COMPLICATIONS varchar 255 √ null

Other Complications (Urology only)
R_CURRENT_STATUS int 4 √ null

Current Status (Urology only)
R_DATE_STATUS smalldatetime 16 √ null

Status Date (Urology only)
R_STATUS int 4 √ null

Status Upper Tracts (Urology only)
R_OTHER_TRACT varchar 255 √ null

Other Status (Urology only)
R_SERUM real 4 √ null

Serum Creatinine (Urology only)
R_FBC bit 1 ((0))

Full Blood Count (Urology only)
R_LFT bit 1 ((0))

LFT’s (Urology only)
R_CT bit 1 ((0))

CT Scan (Urology only)
R_USS bit 1 ((0))

Ultrasound (Urology only)
R_CXR bit 1 ((0))

Chest X Ray (Urology only)
R_OTHER_TESTS varchar 255 √ null

Other (Urology only)
R_PSA real 4 √ null

PSA (Urology only)
R_DATE_METATASECTOMY smalldatetime 16 √ null

Date of Metatasectomy (Urology only)
L_HEIGHT real 4 √ null

Height
L_WEIGHT real 4 √ null

Weight
L_FOLLOWUP varchar 25 √ null

Follow-up Period
L_REF_ONCOLOGIST bit 1 ((0))

Has patient been referred to Oncologist (Colorectal only)
L_WHOLE_IMAGED bit 1 ((0))

Has whole of colon been imaged (Colorectal only)
L_COLO_REQUEST bit 1 ((0))

Colonoscopy Requested (Colorectal only)
L_BA_REQUEST bit 1 ((0))

Barium Enema Requested (Colorectal only)
L_ASYMPTOMATIC bit 1 ((0))

Asymptomatic (Colorectal only)
L_SYMPTOMATIC bit 1 ((0))

Symptomatic (Colorectal only)
L_DETAILS varchar 255 √ null

Details (Colorectal only)
L_RECURRENCE bit 1 ((0))

Sign of Recurrence/Spread (Colorectal only)
L_REC_SITE varchar 15 √ null

Site of Recurrence/Spread (Colorectal only)
L_REC_SITE_2 varchar 15 √ null

2nd Site of Recurrence
L_ERECTILE varchar 50 √ null

Sexual Function (Colorectal only)
L_BLADDER varchar 50 √ null

Bladder Function (Colorectal only)
L_RESOLUTION_ERECTILE varchar 25 √ null

Sexual Resolution (Colorectal only)
L_RESOLUTION_BLADDER varchar 25 √ null

Bladder Resolution (Colorectal only)
L_CT_REQUEST bit 1 ((0))

CT Scan Requested (Brain & Colorectal only)
L_MRI_REQUEST bit 1 ((0))

MRI Scan Requested (Colorectal only)
L_INCISIONAL_HERNIA bit 1 ((0))

Incisional Hernia (Colorectal only)
L_STRICTURE bit 1 ((0))

Anastomotic Stricture (Colorectal only)
L_SCREENING bit 1 ((0))

Colonic Screening (Colorectal only)
L_LOCATION int 4 √ null

Location (Paediatrics only)
L_REASON varchar 255 √ null

Reason (Paediatrics only)
L_MAMMOGRAM int 4 √ null

Follow-up Mammogram (Breast only)
L_OUTSIDE_FOLLOWUP int 4 √ null

Outside planned follow-up (Breast only)
L_OUTSIDE_DETAILS varchar 255 √ null

Reason outside planned follow-up (Breast only)
L_METS varchar 255 √ null

Metastatic Site
L_PLANNED int 4 √ null

Next Planned Follow-up (Breast only)
L_LYMPHOEDEMA int 4 √ null

Lymphoedema (Breast only)
L_DIARY int 4 √ null

Patient given diary (Breast only)
L_SEIZURES varchar 2147483647 √ null

Seizure Status (Brain only)
L_OUTCOME int 4 √ null

Outcome of Follow-up
L_OTHER_OUTCOME varchar 255 √ null

Other Outcome
L_RE_BX varchar 255 √ null

Reason for Early Biopsy
L_DISCHARGE int 4 √ null

Reason for Change from Active Surveillance
L_OTHER_DISCHARGE varchar 255 √ null

Other Reason
L_SALT_ASSESSMENT int 4 √ null

Was Patient SALT Assessed Post Treatment
L_SALT_ASSESSMENT_DATE smalldatetime 16 √ null

Date SALT Assessed
L_INVESTIGATIONS text 2147483647 √ null

Clinical Examination & Investigation (Colorectal only)
L_COMPLICATIONS text 2147483647 √ null

Complications
L_PLAN text 2147483647 √ null

Plan/Comments (Brain only)
ACTION_ID int 4 √ null

Latest Audit ID for Referral Data
StratifiedFollowupType int 4 √ null
StratifiedFollowupType.ID FK_tblMAIN_ASSESSMENT_StratifiedFollowupTypeR

Indexes

Constraint Name Type Sort Column(s)
PK_tblMAIN_ASSESSMENT Primary key Asc ASSESSMENT_ID
IX_tblMAIN_ASSESSMENT Performance Asc CARE_ID

Check Constraints

Constraint Name Constraint
CHK_StratifiedOnly ([N14_9_FOLLOW_UP]=(5) OR [StratifiedFollowupType] IS NULL)

Relationships

Close relationships within degrees of separation