Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| CON_ID | int identity | 4 | √ | null |
|
|
||||
| PALLIATIVE_ID | int | 4 | √ | null |
|
|
||||
| TEMP_ID | varchar | 255 | √ | null |
|
|
||||
| L_CONTACT_DATE | smalldatetime | 16 | √ | null |
|
|
||||
| L_RESIDENCE | int | 4 | √ | null |
|
|
||||
| L_LOCATION | int | 4 | √ | null |
|
|
||||
| L_OTHER_LOCATION | varchar | 255 | √ | null |
|
|
||||
| L_HOSPITAL | varchar | 5 | √ | null |
|
|
||||
| L_CLINIC | varchar | 255 | √ | null |
|
|
||||
| L_CONTACT_TYPE | int | 4 | √ | null |
|
|
||||
| L_TIME | int | 4 | √ | null |
|
|
||||
| L_CONTACT_PAT | int | 4 | √ | null |
|
|
||||
| L_CONTACT_REL | int | 4 | √ | null |
|
|
||||
| L_CONTACT_CARER | int | 4 | √ | null |
|
|
||||
| L_CONTACT_PROF | int | 4 | √ | null |
|
|
||||
| L_PROF_WHO | varchar | 255 | √ | null |
|
|
||||
| L_SEEN_BY | int | 4 | √ | null |
|
|
||||
| L_SEEN_NAME | varchar | 50 | √ | null |
|
|
||||
| L_SEEN_BY_2 | int | 4 | √ | null |
|
|
||||
| L_SEEN_NAME_2 | varchar | 50 | √ | null |
|
|
||||
| L_PAIN_CONTROL | int | 4 | √ | null |
|
|
||||
| L_OTHER_SYMP_MAN | int | 4 | √ | null |
|
|
||||
| L_TEL_SUPP | int | 4 | √ | null |
|
|
||||
| L_PSYC_SUPP | int | 4 | √ | null |
|
|
||||
| L_INFO_GIVE | int | 4 | √ | null |
|
|
||||
| L_PAL_TREAT | int | 4 | √ | null |
|
|
||||
| L_TERM_CARE | int | 4 | √ | null |
|
|
||||
| L_STAFF_SUPP | int | 4 | √ | null |
|
|
||||
| L_FAM_SUPP | int | 4 | √ | null |
|
|
||||
| L_DISCH_LIASON | int | 4 | √ | null |
|
|
||||
| L_PLN_RAPID_DISCH | int | 4 | √ | null |
|
|
||||
| L_HOME_VISIT | int | 4 | √ | null |
|
|
||||
| L_BEREAV_SUPP | int | 4 | √ | null |
|
|
||||
| L_INT_INVEST | int | 4 | √ | null |
|
|
||||
| L_PAT_REL_ADMIN | int | 4 | √ | null |
|
|
||||
| L_REF_COMP_INT | int | 4 | √ | null |
|
|
||||
| L_INT_BLOOD | int | 4 | √ | null |
|
|
||||
| L_INT_PARA | int | 4 | √ | null |
|
|
||||
| L_INT_NEURAL | int | 4 | √ | null |
|
|
||||
| L_INT_INFUSE | int | 4 | √ | null |
|
|
||||
| L_CURRENT_MEDICATION | varchar | 255 | √ | null |
|
|
||||
| L_CURRENT_THERAPIES | varchar | 255 | √ | null |
|
|
||||
| L_CURRENT_DIET | varchar | 255 | √ | null |
|
|
||||
| L_CURRENT_EXCERCISE | varchar | 255 | √ | null |
|
|
||||
| L_COMMENTS | text | 2147483647 | √ | null |
|
|
||||
| CONTACT_NAME_ID_1 | int | 4 | √ | null |
|
|
||||
| CONTACT_NAME_ID_2 | int | 4 | √ | null |
|
|
||||
| L_SOCIAL_SUPP | int | 4 | √ | null |
|
|
||||
| L_SPIRITUAL_SUPP | int | 4 | √ | null |
|
|
||||
| L_ADVANCE_CARE | int | 4 | √ | null |
|
|
||||
| L_FINANCIAL_PLANNING | int | 4 | √ | null |
|
|
||||
| L_NEW_TREATMENT | int | 4 | √ | null |
|
|
||||
| L_PERSONAL_CARE | int | 4 | √ | null |
|
|
||||
| L_PERMANENT_RECORD | int | 4 | √ | null |
|
|
||||
| L_WRITTEN_INFO | int | 4 | √ | null |
|
|
||||
| L_EPACGs | int | 4 | √ | null |
|
|
||||
| PREVENTS_FACE_TO_FACE | int | 4 | √ | null |
|
|
||||
| CONTACT_COMMENTS | text | 2147483647 | √ | null |
|
|
||||
| ACTION_ID | int | 4 | √ | null |
|
|
||||
| L_RESIDENCE_OTHER | varchar | 200 | √ | null |
|
|
||||
| CNS_INTERVENTION_LEVEL | int | 4 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_tblPALLIATIVE_CONTACT_BACK_UP | Primary key | Asc | CON_ID |