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 |
|
|
||
Organisation | nvarchar | 500 | √ | null |
|
|
||
Consultant (First Appointment) | varchar | 59 | √ | null |
|
|
||
Was initial referral made to appropriate specialist | varchar | 3 | √ | null |
|
|
||
Reason No Appointment | varchar | 50 | √ | 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 |
|
|
View Definition
Possibly Referenced Tables/Views
- lnkNICEReferringSymptoms
- ltblSYMPTOMS_GYNAECOLOGY
- lnkReferralSymptoms
- tblMAIN_REFERRALS
- tblDEMOGRAPHICS
- ltblOUT_PATIENT_REFERRAL
- ltblPRIORITY_TYPE
- ltblCANCER_TYPE
- GP
- Practice
- Branch
- ltblNATIONAL_CCG_INFO
- ltblSTATUS
- OrganisationSites
- ConsultantsByCode
- ltblAPP_TYPE
- ltblSPECIALTIES
- ltblREF_METHOD
- ltblAPPROPRIATE
- ltblCANCELLATION
- ltblDELAY_REASON
- tblDEFINITIVE_TREATMENT
- CancerReferralSubsites
- ltblNATIONAL_CCG_PracticeCode
- ltblReferralRoute
- ltblNO_APP