Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| CARE_ID | int | 4 | null |
|
|
Referral Record ID |
||||
| CHANG_ID | int | 4 | √ | null |
|
|
Chang Stage |
|||
| LESION_LOCATION_ID | int | 4 | √ | null |
|
|
Lesion Location (Radiological) |
|||
| LESION_NO_RADIOLOGICAL | int | 4 | √ | null |
|
|
Number of Lesions (Radiological) |
|||
| LESION_SIZE_RADIOLOGICAL | real | 4 | √ | null |
|
|
Lesion Size (Radiological) |
|||
| DIAGNOSTIC_IMAGING_TYPE | int | 4 | √ | null |
|
|
Principal Diagnositic Imaging Type |
|||
| DIAGNOSIS_MDT_PROVISIONAL | varchar | 5 | √ | null |
|
|
MDT Provisional Diagnosis (ICD) |
|||
| DIAGNOSIS_RADIOLOGICAL | varchar | 5 | √ | null |
|
|
Primary Diagnosis (ICD Radiological) |
|||
| CONTRAST_ENHANCEMENT | bit | 1 | ((0)) |
|
|
Features of Largest Lesion (Radiological) - contrast-enhancement |
||||
| CALCIFICATION | bit | 1 | ((0)) |
|
|
Features of Largest Lesion (Radiological) - Calcification |
||||
| MASS_EFFECT | bit | 1 | ((0)) |
|
|
Features of Largest Lesion (Radiological) - Mass effect |
||||
| HYDROCEPHALUS | bit | 1 | ((0)) |
|
|
Features of Largest Lesion (Radiological) - Hydrocephalus |
||||
| HAEMORRHAGE | bit | 1 | ((0)) |
|
|
Features of Largest Lesion (Radiological) - Haemorrhage |
||||
| CYSTIC | bit | 1 | ((0)) |
|
|
Features of Largest Lesion (Radiological) - Cystic/multi-cystic |
||||
| DURAL_TAIL | bit | 1 | ((0)) |
|
|
Features of Largest Lesion (Radiological) - Dural tail |
||||
| BRAIN_OEDEMA | bit | 1 | ((0)) |
|
|
Features of Largest Lesion (Radiological) - Brain oedema |
||||
| CORD_SIGNAL_CHANGE | bit | 1 | ((0)) |
|
|
Features of Largest Lesion (Radiological) - Cord signal change |
||||
| CORD_COMPRESSION | bit | 1 | ((0)) |
|
|
Features of Largest Lesion (Radiological) - Cord compression |
||||
| INSS_ID | int | 4 | √ | null |
|
|
||||
| INSS_DATE | datetime | 16,3 | √ | null |
|
|
||||
| INPC_ID | int | 4 | √ | null |
|
|
||||
| VisualAcuityLeft | int | 4 | √ | null |
|
|
||||
| VisualAcuityRight | int | 4 | √ | null |
|
|
||||
| VisualFieldsLeft | int | 4 | √ | null |
|
|
||||
| VisualFieldsRight | int | 4 | √ | null |
|
|
||||
| INRGStagingSystem | int | 4 | √ | null |
|
|
||||
| UrineVMACreatinineRatio | real | 4 | √ | null |
|
|
||||
| StageBrainReportDate | smalldatetime | 16 | √ | null |
|
|
||||
| StageBrainOrgID | int | 4 | √ | null |
|
|
||||
| LabReportDate | smalldatetime | 16 | √ | null |
|
|
||||
| LabReportOrgID | int | 4 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_tblREFERRAL_BRAIN_1 | Primary key | Asc | CARE_ID |
| IX_tblREFERRAL_BRAIN | Performance | Asc | CARE_ID |