Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| PALLIATIVE_ID | int | 4 | √ | null |
|
|
||
| PATIENT_ID | int | 4 | √ | null |
|
|
||
| NHS Number | varchar | 10 | √ | null |
|
|
||
| Hospital Number | varchar | 20 | √ | null |
|
|
||
| Full Name | varchar | 111 | √ | null |
|
|
||
| Referral Type | varchar | 50 | √ | null |
|
|
||
| Contact Date | smalldatetime | 16 | √ | null |
|
|
||
| Current Residence | varchar | 50 | √ | null |
|
|
||
| Seen By 1 | varchar | 50 | √ | null |
|
|
||
| Seen By 1 Name | varchar | 50 | √ | null |
|
|
||
| Seen By 2 | varchar | 50 | √ | null |
|
|
||
| Seen By 2 Name | varchar | 50 | √ | null |
|
|
||
| Contact With Patient | varchar | 3 | √ | null |
|
|
||
| Contact With Relative | varchar | 3 | √ | null |
|
|
||
| Contact With Carer | varchar | 3 | √ | null |
|
|
||
| Contact With HCP | varchar | 3 | √ | null |
|
|
||
| HCP Details | varchar | 255 | √ | null |
|
|
||
| Contact Type | varchar | 50 | √ | null |
|
|
||
| Contact Type - Free Text | text | 2147483647 | √ | null |
|
|
||
| Time Spent (mins) | int | 4 | √ | null |
|
|
||
| Contact Location | varchar | 50 | √ | null |
|
|
||
| Other Location | varchar | 255 | √ | null |
|
|
||
| Activity Level of Care: Pain Control | varchar | 3 | √ | null |
|
|
||
| Activity Level of Care: Other Symptom Mgmt | varchar | 3 | √ | null |
|
|
||
| Activity Level of Care: Telephone Support | varchar | 3 | √ | null |
|
|
||
| Activity Level of Care: Bereavement Support | varchar | 3 | √ | null |
|
|
||
| Activity Level of Care: Psychological Support | varchar | 3 | √ | null |
|
|
||
| Activity Level of Care: Information Giving | varchar | 3 | √ | null |
|
|
||
| Activity Level of Care: Palliative Treatments | varchar | 3 | √ | null |
|
|
||
| Activity Level of Care: Initiate Investigation | varchar | 3 | √ | null |
|
|
||
| Activity Level of Care: Terminal Care | varchar | 3 | √ | null |
|
|
||
| Activity Level of Care: Staff Support/Comms | varchar | 3 | √ | null |
|
|
||
| Activity Level of Care: Family Support | varchar | 3 | √ | null |
|
|
||
| Activity Level of Care: Patient Related Admin | varchar | 3 | √ | null |
|
|
||
| Activity Level of Care: Discharge Liason | varchar | 3 | √ | null |
|
|
||
| Activity Level of Care: Rapid Discharge Planning | varchar | 3 | √ | null |
|
|
||
| Activity Level of Care: Home Visit | varchar | 3 | √ | null |
|
|
||
| Activity Level of Care: Complex Intervention | varchar | 3 | √ | null |
|
|
||
| Social Support | varchar | 3 | √ | null |
|
|
||
| Spiritual Support | varchar | 3 | √ | null |
|
|
||
| Advance Care Planning | varchar | 3 | √ | null |
|
|
||
| Financial Planning | varchar | 3 | √ | null |
|
|
||
| New Treatment | varchar | 3 | √ | null |
|
|
||
| Personal Care | varchar | 3 | √ | null |
|
|
||
| Permanent Record Offered | varchar | 3 | √ | null |
|
|
||
| Written Information Given | varchar | 3 | √ | null |
|
|
||
| EPaCGs | varchar | 3 | √ | null |
|
|
||
| Medication | varchar | 255 | √ | null |
|
|
||
| Therapies | varchar | 255 | √ | null |
|
|
||
| Diet | varchar | 255 | √ | null |
|
|
||
| Exercise | varchar | 255 | √ | null |
|
|
||
| Comments | text | 2147483647 | √ | null |
|
|
||
| CNS Intervention Level | varchar | 7 | √ | null |
|
|