Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ASSESSMENT_ID | int identity | 4 | null |
|
|
|||
| CARE_ID | int | 4 | null |
|
|
|||
| N14_1_ASSESSMENT_DATE | smalldatetime | 16 | √ | null |
|
|
||
| N14_2_TUMOUR_STATUS | int | 4 | √ | null |
|
|
||
| N14_3_NODE_STATUS | int | 4 | √ | null |
|
|
||
| N14_4_METS_STATUS | int | 4 | √ | null |
|
|
||
| N14_5_MARKER_RESPONSE | int | 4 | √ | null |
|
|
||
| N14_6_WHO_STATUS | int | 4 | √ | null |
|
|
||
| N14_7_MORBIDITY_TYPE | int | 4 | √ | null |
|
|
||
| N14_8_MORBIDITY_CODE | varchar | 5 | √ | null |
|
|
||
| N14_9_FOLLOW_UP | int | 4 | √ | null |
|
|
||
| N14_10_CHEMO_MORBIDITY | int | 4 | √ | null |
|
|
||
| N14_11_RADIO_MORBIDITY | int | 4 | √ | null |
|
|
||
| N14_12_COMB_MORBIDITY | int | 4 | √ | null |
|
|
||
| N_SK24_TUMOUR_STATUS | int | 4 | √ | null |
|
|
||
| N_L21_RECEIVED_PCI | varchar | 1 | √ | null |
|
|
||
| N_L30_PLAN | varchar | 1 | √ | null |
|
|
||
| N_L31_FAILURE | varchar | 2 | √ | null |
|
|
||
| R_ORG_CODE | varchar | 5 | √ | null |
|
|
||
| R_ALIVE_DATE | smalldatetime | 16 | √ | null |
|
|
||
| R_ABROAD_DATE | smalldatetime | 16 | √ | null |
|
|
||
| R_MODE_FOLLOWUP | int | 4 | √ | null |
|
|
||
| R_RECURRENCE_BY | int | 4 | √ | null |
|
|
||
| R_DATE_RECURRENCE | smalldatetime | 16 | √ | null |
|
|
||
| R_POTENCY | varchar | 50 | √ | null |
|
|
||
| R_CONTINENCE | varchar | 50 | √ | null |
|
|
||
| R_INTERVENTION | int | 4 | √ | null |
|
|
||
| R_OTHER_INTERVENTION | varchar | 255 | √ | null |
|
|
||
| R_COMPLICATIONS | int | 4 | √ | null |
|
|
||
| R_OTHER_COMPLICATIONS | varchar | 255 | √ | null |
|
|
||
| R_CURRENT_STATUS | int | 4 | √ | null |
|
|
||
| R_DATE_STATUS | smalldatetime | 16 | √ | null |
|
|
||
| R_STATUS | int | 4 | √ | null |
|
|
||
| R_OTHER_TRACT | varchar | 255 | √ | null |
|
|
||
| R_SERUM | real | 4 | √ | null |
|
|
||
| R_FBC | int | 4 | √ | null |
|
|
||
| R_LFT | int | 4 | √ | null |
|
|
||
| R_CT | int | 4 | √ | null |
|
|
||
| R_USS | int | 4 | √ | null |
|
|
||
| R_CXR | int | 4 | √ | null |
|
|
||
| R_OTHER_TESTS | varchar | 255 | √ | null |
|
|
||
| R_PSA | real | 4 | √ | null |
|
|
||
| R_DATE_METATASECTOMY | smalldatetime | 16 | √ | null |
|
|
||
| L_HEIGHT | real | 4 | √ | null |
|
|
||
| L_WEIGHT | real | 4 | √ | null |
|
|
||
| L_FOLLOWUP | varchar | 25 | √ | null |
|
|
||
| L_REF_ONCOLOGIST | int | 4 | √ | null |
|
|
||
| L_WHOLE_IMAGED | int | 4 | √ | null |
|
|
||
| L_COLO_REQUEST | int | 4 | √ | null |
|
|
||
| L_BA_REQUEST | int | 4 | √ | null |
|
|
||
| L_ASYMPTOMATIC | int | 4 | √ | null |
|
|
||
| L_SYMPTOMATIC | int | 4 | √ | null |
|
|
||
| L_DETAILS | varchar | 255 | √ | null |
|
|
||
| L_RECURRENCE | int | 4 | √ | null |
|
|
||
| L_REC_SITE | varchar | 15 | √ | null |
|
|
||
| L_ERECTILE | varchar | 50 | √ | null |
|
|
||
| L_BLADDER | varchar | 50 | √ | null |
|
|
||
| L_RESOLUTION_ERECTILE | varchar | 25 | √ | null |
|
|
||
| L_RESOLUTION_BLADDER | varchar | 25 | √ | null |
|
|
||
| L_CT_REQUEST | int | 4 | √ | null |
|
|
||
| L_MRI_REQUEST | int | 4 | √ | null |
|
|
||
| L_INCISIONAL_HERNIA | int | 4 | √ | null |
|
|
||
| L_STRICTURE | int | 4 | √ | null |
|
|
||
| L_SCREENING | int | 4 | √ | null |
|
|
||
| L_LOCATION | int | 4 | √ | null |
|
|
||
| L_REASON | varchar | 255 | √ | null |
|
|
||
| L_MAMMOGRAM | int | 4 | √ | null |
|
|
||
| L_OUTSIDE_FOLLOWUP | int | 4 | √ | null |
|
|
||
| L_OUTSIDE_DETAILS | varchar | 255 | √ | null |
|
|
||
| L_METS | varchar | 255 | √ | null |
|
|
||
| L_PLANNED | int | 4 | √ | null |
|
|
||
| L_LYMPHOEDEMA | int | 4 | √ | null |
|
|
||
| L_DIARY | int | 4 | √ | null |
|
|
||
| L_SEIZURES | varchar | 255 | √ | null |
|
|
||
| L_INVESTIGATIONS | text | 2147483647 | √ | null |
|
|
||
| L_COMPLICATIONS | text | 2147483647 | √ | null |
|
|
||
| L_PLAN | text | 2147483647 | √ | null |
|
|