Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| CARE_ID | int | 4 | null |
|
|
|||
| Patient ID | int | 4 | null |
|
|
|||
| Cancer Site | varchar | 50 | √ | null |
|
|
||
| Subtype | nvarchar | 100 | √ | null |
|
|
||
| NHS Number | varchar | 10 | √ | null |
|
|
||
| Hospital Number | varchar | 20 | √ | null |
|
|
||
| Full Name | varchar | 111 | √ | null |
|
|
||
| Source of Referral | varchar | 100 | √ | null |
|
|
||
| Priority Type | varchar | 60 | √ | null |
|
|
||
| Referral Route | nvarchar | 200 | √ | null |
|
|
||
| Other Route | nvarchar | 100 | √ | null |
|
|
||
| Rapid Diagnostic Centre Pathway | varchar | 3 | √ | null |
|
|
||
| Upgrade Date | smalldatetime | 16 | √ | null |
|
|
||
| Referral Type | varchar | 100 | √ | null |
|
|
||
| GP Code | varchar | 8 | √ | null |
|
|
||
| GP Name | varchar | 100 | √ | null |
|
|
||
| Practice Code | varchar | 20 | √ | null |
|
|
||
| Branch Code | varchar | 10 | √ | null |
|
|
||
| CCG | varchar | 100 | √ | null |
|
|
||
| CCG Code | varchar | 5 | √ | null |
|
|
||
| Patient Status | varchar | 100 | √ | null |
|
|
||
| Date Decision to Refer | smalldatetime | 16 | √ | null |
|
|
||
| Date Receipt of Referral | smalldatetime | 16 | √ | null |
|
|
||
| Date First Appointment | smalldatetime | 16 | √ | null |
|
|
||
| Was this the first appt offered | varchar | 3 | √ | null |
|
|
||
| Reason No Appointment | varchar | 50 | √ | null |
|
|
||
| Organisation | nvarchar | 500 | √ | null |
|
|
||
| Consultant (First Appointment) | varchar | 59 | √ | null |
|
|
||
| Was initial referral made to appropriate specialist | varchar | 3 | √ | null |
|
|
||
| First Appointment Type | varchar | 50 | √ | null |
|
|
||
| Date Referred to Specialist | smalldatetime | 16 | √ | null |
|
|
||
| Organisation (Referred From) | nvarchar | 500 | √ | null |
|
|
||
| Date First Appt with Specialist | smalldatetime | 16 | √ | null |
|
|
||
| Organisation (First Appt Specialist) | nvarchar | 500 | √ | null |
|
|
||
| Consultant | varchar | 59 | √ | null |
|
|
||
| Specialty | varchar | 150 | √ | null |
|
|
||
| NICE Referring symptoms | nvarchar | 1073741823 | √ | null |
|
|
||
| Referring Symptoms | nvarchar | 1073741823 | √ | null |
|
|
||
| Other Symptoms | text | 2147483647 | √ | null |
|
|
||
| Method of Referral | varchar | 50 | √ | null |
|
|
||
| Appropriateness of Referral | varchar | 50 | √ | null |
|
|
||
| Reason Inappropriate | varchar | 2147483647 | √ | null |
|
|
||
| Additional Comments | text | 2147483647 | √ | null |
|
|
||
| Date DNA Appt Re-Booked | smalldatetime | 16 | √ | null |
|
|
||
| Adjustment Reason | varchar | 150 | √ | null |
|
|
||
| Waiting Time Adj | int | 4 | √ | null |
|
|
||
| Delay Reason | varchar | 100 | √ | null |
|
|
||
| Delay Reason Comments | text | 2147483647 | √ | null |
|
|
||
| Waiting Time Adj DTT (Days) | int | 4 | √ | null |
|
|
||
| ADT Referral ID | varchar | 50 | √ | null |
|
|
||
| Referring Organisation | nvarchar | 500 | √ | null |
|
|
||
| Validated For Upload | varchar | 3 | null |
|
|