Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
PATIENT_ID | int | 4 | null |
|
|
|||
N1_9_SEX | int | 4 | √ | null |
|
|
||
N1_10_DATE_BIRTH | datetime | 16,3 | √ | null |
|
|
||
N1_15_ETHNICITY | varchar | 50 | √ | null |
|
|
||
L_REG_DATE | smalldatetime | 16 | √ | null |
|
|
||
L_CANCER_SITE1 | varchar | 50 | √ | null |
|
|
||
L_PRIMARY_DIAGNOSIS | varchar | 10 | √ | null |
|
|
||
L_DATE_DISCHARGE | smalldatetime | 16 | √ | null |
|
|
||
PALLIATIVE_ID | int | 4 | √ | null |
|
|
||
CON_ID | int | 4 | null |
|
|
|||
L_CONTACT_DATE | smalldatetime | 16 | √ | null |
|
|
||
L_LOCATION | int | 4 | √ | null |
|
|
||
LOCATION_DESC | varchar | 50 | √ | null |
|
|
||
L_CONTACT_TYPE | int | 4 | √ | null |
|
|
||
CONTACTTYPE_DESC | varchar | 50 | √ | 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_SEEN_BY | int | 4 | √ | null |
|
|
||
SEEN_BY1 | varchar | 50 | √ | null |
|
|
||
L_SEEN_NAME | varchar | 50 | √ | null |
|
|
||
L_SEEN_BY_2 | int | 4 | √ | null |
|
|
||
SEEN_BY2 | varchar | 50 | √ | 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 |
|
|