Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| TERT_ID | int identity | 4 | √ | null |
|
|
||||
| CARE_ID | int | 4 | null |
|
|
|||||
| REF_CLINICIAN_CODE | varchar | 10 | √ | null |
|
|
||||
| REF_CLINICIAN | varchar | 50 | √ | null |
|
|
||||
| REF_CONTACT_NAME | varchar | 50 | √ | null |
|
|
||||
| REF_CONTACT_PHONE | varchar | 20 | √ | null |
|
|
||||
| REF_CONTACT_EMAIL | varchar | 50 | √ | null |
|
|
||||
| USE_PATIENT_DETAILS | bit | 1 | √ | null |
|
|
||||
| LEAD_CONTACT | varchar | 50 | √ | null |
|
|
||||
| CONTACT_HOME_TEL | varchar | 20 | √ | null |
|
|
||||
| CONTACT_MOB_TEL | varchar | 20 | √ | null |
|
|
||||
| CONTACT_WORK_TEL | varchar | 20 | √ | null |
|
|
||||
| CONTACT_EMAIL | varchar | 20 | √ | null |
|
|
||||
| ON_PATHWAY | varchar | 20 | √ | null |
|
|
||||
| RTT_STATUS | varchar | 200 | √ | null |
|
|
||||
| ALLOCATED_BY | varchar | 50 | √ | null |
|
|
||||
| CLOCK_START_DATE | datetime | 16,3 | √ | null |
|
|
||||
| DATE_DECISION | datetime | 16,3 | √ | null |
|
|
||||
| REC_ORGANISATION | varchar | 5 | √ | null |
|
|
||||
| REC_CLINICIAN | varchar | 50 | √ | null |
|
|
||||
| SPECIALITY | int | 4 | √ | null |
|
|
||||
| DATE_SENT | datetime | 16,3 | √ | null |
|
|
||||
| NOTES | varchar | 2147483647 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_tblTERTIARY_REFERRAL | Primary key | Asc | TERT_ID |
| IX_tblTERTIARY_REFERRAL_CARE_ID | Performance | Asc | CARE_ID |