Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| PATHOLOGY_ID | int | 4 | null |
|
|
Links record to Pathology |
||||
| R_MARGINS | varchar | 50 | √ | null |
|
|
Margins (Microscopic Resection) |
|||
| R_LYMPH_SPREAD | varchar | 50 | √ | null |
|
|
Extracapsular Spread |
|||
| R_INVASIVE_FRONT | varchar | 50 | √ | null |
|
|
Invasive Front |
|||
| R_PERINEURAL_INV | varchar | 50 | √ | null |
|
|
Perineural Invasion |
|||
| R_CARTILAGE | varchar | 50 | √ | null |
|
|
||||
| R_BONE | varchar | 50 | √ | null |
|
|
||||
| R_THYROID | varchar | 50 | √ | null |
|
|
Extrathyroid Invasion |
|||
| R_NECK_NODES | varchar | 50 | √ | null |
|
|
Neck Nodes (not used) |
|||
| R_RESECTION | int | 4 | √ | null |
|
|
Complete Resection at all Margins |
|||
| R_PRE_RAD | varchar | 3 | √ | null |
|
|
Previous Radiotherapy |
|||
| R_PRE_CHEMO | varchar | 3 | √ | null |
|
|
Previous Chemotherapy |
|||
| R_DEPTH | real | 4 | √ | null |
|
|
Max Depth of Invasion |
|||
| R_MUSCOSAL | real | 4 | √ | null |
|
|
Distance from Invasive Tumour to Muscosal Margins |
|||
| R_DEEP | real | 4 | √ | null |
|
|
Distance from Invasive Tumour to Deep Margins |
|||
| R_NERVE | varchar | 50 | √ | null |
|
|
Nerve Invasion |
|||
| R_DYS_P | varchar | 50 | √ | null |
|
|
Severe Dysplasia Present |
|||
| R_DYS_M | varchar | 50 | √ | null |
|
|
Severe Dysplasia at Margins |
|||
| R_NECK | varchar | 50 | √ | null |
|
|
Neck Dissection |
|||
| R_TIVE | varchar | 50 | √ | null |
|
|
Comprehensive/Selective |
|||
| R_1 | int | 4 | √ | null |
|
|
Node Levels Present 1 |
|||
| R_2 | int | 4 | √ | null |
|
|
Node Levels Present 2 |
|||
| R_3 | int | 4 | √ | null |
|
|
Node Levels Present 3 |
|||
| R_4 | int | 4 | √ | null |
|
|
Node Levels Present 4 |
|||
| R_5 | int | 4 | √ | null |
|
|
Node Levels Present 5 |
|||
| R_6 | int | 4 | √ | null |
|
|
Node Levels Present 6 |
|||
| R_OTHER | int | 4 | √ | null |
|
|
Node Levels Present Other |
|||
| R_M1 | int | 4 | √ | null |
|
|
Levels with Metastases 1 |
|||
| R_M2 | int | 4 | √ | null |
|
|
Levels with Metastases 2 |
|||
| R_M3 | int | 4 | √ | null |
|
|
Levels with Metastases 3 |
|||
| R_M4 | int | 4 | √ | null |
|
|
Levels with Metastases 4 |
|||
| R_M5 | int | 4 | √ | null |
|
|
Levels with Metastases 5 |
|||
| R_M6 | int | 4 | √ | null |
|
|
Levels with Metastases 6 |
|||
| R_M_OTHER | int | 4 | √ | null |
|
|
Levels with Metastases Other |
|||
| R_LARGEST_MET | real | 4 | √ | null |
|
|
Largest Metastasis |
|||
| R_E1 | int | 4 | √ | null |
|
|
Levels with ECS 1 |
|||
| R_E2 | int | 4 | √ | null |
|
|
Levels with ECS 2 |
|||
| R_E3 | int | 4 | √ | null |
|
|
Levels with ECS 3 |
|||
| R_E4 | int | 4 | √ | null |
|
|
Levels with ECS 4 |
|||
| R_E5 | int | 4 | √ | null |
|
|
Levels with ECS 5 |
|||
| R_E6 | int | 4 | √ | null |
|
|
Levels with ECS 6 |
|||
| R_E_OTHER | int | 4 | √ | null |
|
|
Levels with ECS Other |
|||
| R_LYMPH_SPREAD_2 | varchar | 50 | √ | null |
|
|
Extracapsular Spread |
|||
| R_NECK_2 | varchar | 50 | √ | null |
|
|
Neck Dissection |
|||
| R_TIVE_2 | varchar | 50 | √ | null |
|
|
Comprehensive/Selective |
|||
| R_1_2 | int | 4 | √ | null |
|
|
Node Levels Present 1 |
|||
| R_2_2 | int | 4 | √ | null |
|
|
Node Levels Present 2 |
|||
| R_3_2 | int | 4 | √ | null |
|
|
Node Levels Present 3 |
|||
| R_4_2 | int | 4 | √ | null |
|
|
Node Levels Present 4 |
|||
| R_5_2 | int | 4 | √ | null |
|
|
Node Levels Present 5 |
|||
| R_6_2 | int | 4 | √ | null |
|
|
Node Levels Present 6 |
|||
| R_OTHER_2 | int | 4 | √ | null |
|
|
Node Levels Present Other |
|||
| R_M1_2 | int | 4 | √ | null |
|
|
Levels with Metastases 1 |
|||
| R_M2_2 | int | 4 | √ | null |
|
|
Levels with Metastases 2 |
|||
| R_M3_2 | int | 4 | √ | null |
|
|
Levels with Metastases 3 |
|||
| R_M4_2 | int | 4 | √ | null |
|
|
Levels with Metastases 4 |
|||
| R_M5_2 | int | 4 | √ | null |
|
|
Levels with Metastases 5 |
|||
| R_M6_2 | int | 4 | √ | null |
|
|
Levels with Metastases 6 |
|||
| R_M_OTHER_2 | int | 4 | √ | null |
|
|
Levels with Metastases Other |
|||
| R_LARGEST_MET_2 | real | 4 | √ | null |
|
|
Largest Metastasis |
|||
| R_E1_2 | int | 4 | √ | null |
|
|
Levels with ECS 1 |
|||
| R_E2_2 | int | 4 | √ | null |
|
|
Levels with ECS 2 |
|||
| R_E3_2 | int | 4 | √ | null |
|
|
Levels with ECS 3 |
|||
| R_E4_2 | int | 4 | √ | null |
|
|
Levels with ECS 4 |
|||
| R_E5_2 | int | 4 | √ | null |
|
|
Levels with ECS 5 |
|||
| R_E6_2 | int | 4 | √ | null |
|
|
Levels with ECS 6 |
|||
| R_E_OTHER_2 | int | 4 | √ | null |
|
|
Levels with ECS Other |
|||
| R_RESECTION_MAR | varchar | 50 | √ | null |
|
|
||||
| INSS_ID | int | 4 | √ | null |
|
|
||||
| HPV_TEST_COMPLETE | varchar | 1 | √ | null |
|
|
||||
| HPV_TEST | int | 4 | √ | null |
|
|
||||
| HPV_STATUS | int | 4 | √ | null |
|
|
||||
| DAHNO_FIRST_TISSUE_BIOPSY | int | 4 | √ | null |
|
|
||||
| PositiveNodesLaterality | int | 4 | √ | null |
|
|
||||
| HistologicalGradeSalivary | int | 4 | √ | null |
|
|
||||
| MacroscopicExtraglandularExtension | int | 4 | √ | null |
|
|
||||
| HANASiteSyncTumour | int | 4 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_tblPATHOLOGY_HEAD_NECK_1 | Primary key | Asc | PATHOLOGY_ID |
| IX_tblPATHOLOGY_HEAD_NECK | Performance | Asc | PATHOLOGY_ID |