Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| CARE_ID | int | 4 | null |
|
|
|||
| Cancer Site | varchar | 50 | √ | null |
|
|
||
| NHS Number | varchar | 10 | √ | null |
|
|
||
| Hospital Number | varchar | 20 | √ | null |
|
|
||
| Full Name | varchar | 111 | √ | null |
|
|
||
| Date of Receipt | smalldatetime | 16 | √ | null |
|
|
||
| Date of Reporting | smalldatetime | 16 | √ | null |
|
|
||
| Report No | varchar | 50 | √ | null |
|
|
||
| Investigation Type | varchar | 50 | √ | null |
|
|
||
| Nature of Specimen | varchar | 50 | √ | null |
|
|
||
| Report Status | varchar | 50 | √ | null |
|
|
||
| Surgeon | varchar | 59 | √ | null |
|
|
||
| Requesting Organisation | nvarchar | 500 | √ | null |
|
|
||
| Pathologist | varchar | 59 | √ | null |
|
|
||
| Reporting Organisation | nvarchar | 500 | √ | null |
|
|
||
| Diagnosis Site (ICD) | varchar | 203 | √ | null |
|
|
||
| Diagnosis Site (SNOMED) | nvarchar | 566 | √ | null |
|
|
||
| Laterality | varchar | 50 | √ | null |
|
|
||
| Max Tumour Diameter (mm) | real | 4 | √ | null |
|
|
||
| No of Nodes Examined | int | 4 | √ | null |
|
|
||
| No of Positive Nodes | int | 4 | √ | null |
|
|
||
| Type (SNOMed) | varchar | 133 | √ | null |
|
|
||
| Grade of Differentiation | varchar | 105 | √ | null |
|
|
||
| Excision Margins | varchar | 100 | √ | null |
|
|
||
| Vascular/Lymphatic Invasion | varchar | 100 | √ | null |
|
|
||
| Synchronous Tumour | varchar | 9 | √ | null |
|
|
||
| Pathological Staging | varchar | 41 | √ | null |
|
|
||
| Comments | text | 2147483647 | √ | null |
|
|