Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| CARE_ID | int | 4 | null |
|
|
|||||
| N_SA1_TUMOUR_SITE_1 | varchar | 50 | √ | null |
|
|
Tumour Site (Bone) |
|||
| N_SA1_TUMOUR_SITE_2 | varchar | 50 | √ | null |
|
|
Tumour Site (Soft Tissue) |
|||
| N_SA2_LOCATION_1 | char | 1 | √ | null |
|
|
Location (Bone) |
|||
| N_SA2_LOCATION_2 | char | 1 | √ | null |
|
|
Location (Soft Tissue) |
|||
| N_SA3_PART_SITE | char | 2 | √ | null |
|
|
Tumour Sub-Site (Bone) |
|||
| N_SA4_DIAMETER | decimal | 16,4 | √ | null |
|
|
Largest Diameter |
|||
| IRS_CODE | int | 4 | √ | null |
|
|
IRS Post Surgical Group |
|||
| IRS_DATE | smalldatetime | 16 | √ | null |
|
|
IRS Post Surgical Group Date |
|||
| RHAB_CYTOGENETICS_ID | int | 4 | √ | null |
|
|
Cytogenetics for Alveolar Rhabdomyosarcoma |
|||
| RHAB_SITE_PROGNOSIS_CODE_ID | int | 4 | √ | null |
|
|
Rhabdomyosarcoma Site Prognosis Code |
|||
| PRIMARY_TUMOUR_SIZE | real | 4 | √ | null |
|
|
||||
| NECROSIS | int | 4 | √ | null |
|
|
Extent of Necrosis after Chemotherapy |
|||
| ADEQUACY_ID | int | 4 | √ | null |
|
|
Sarcoma Surgical Margin Adequacy |
|||
| EWINGS_VOLUME_ID | int | 4 | √ | null |
|
|
Tumour Volume at Diagnosis |
|||
| EWINGS_CYTOGENETIC_ID | int | 4 | √ | null |
|
|
Cytogenetics for Ewings Sarcoma |
|||
| SUBSITE_SOFT_TISSUE | int | 4 | √ | null |
|
|
Tumour Sub-Site (Soft Tissue) |
|||
| MULTIFOCAL_INDICATOR | varchar | 2 | √ | null |
|
|
Multi-Focal or Synchronous Tumour Indicator |
|||
| LabReportDate | smalldatetime | 16 | √ | null |
|
|
||||
| LabReportOrgID | int | 4 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_tblREFERRAL_SARCOMA_1 | Primary key | Asc | CARE_ID |
| IX_tblREFERRAL_SARCOMA | Performance | Asc | CARE_ID |