Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| PALLIATIVE_ID | int identity | 4 | null |
|
|
|||||
| PATIENT_ID | int | 4 | null |
|
|
|||||
| TEMP_ID | varchar | 255 | √ | null |
|
|
||||
| L_REG_DATE | smalldatetime | 16 | √ | null |
|
|
||||
| L_CONSULTANT | varchar | 8 | √ | null |
|
|
||||
| L_REFERRAL_SOURCE | int | 4 | √ | null |
|
|
||||
| L_REFERRAL_SOURCE_OTHER | varchar | 255 | √ | null |
|
|
||||
| L_REFERRER | int | 4 | √ | null |
|
|
||||
| L_TYPE_OF_REFERRER_OTHER | varchar | 255 | √ | null |
|
|
||||
| L_WARD | int | 4 | √ | null |
|
|
||||
| L_REFERRED | int | 4 | √ | null |
|
|
||||
| L_REF_REASON | int | 4 | √ | null |
|
|
||||
| L_REASON_FOR_REFERRAL_2 | int | 4 | √ | null |
|
|
||||
| L_REASON_FOR_REFERRAL_OTHER | varchar | 255 | √ | null |
|
|
||||
| L_PRIORITY | int | 4 | √ | null |
|
|
||||
| L_PREV_SPEC_SUPPORT | int | 4 | √ | null |
|
|
||||
| L_REFERRAL_OUTCOME | int | 4 | √ | null |
|
|
||||
| L_DATE_OF_FIRST_CONTACT | smalldatetime | 16 | √ | null |
|
|
||||
| L_KEY_WORKER | varchar | 50 | √ | null |
|
|
||||
| L_DATE_DIAGNOSIS | smalldatetime | 16 | √ | null |
|
|
||||
| L_CANCER_SITE1 | varchar | 50 | √ | null |
|
|
||||
| L_PRIMARY_DIAGNOSIS | varchar | 10 | √ | null |
|
|
||||
| L_PRIMARY_DIAGNOSIS_DET | varchar | 10 | √ | null |
|
|
||||
| L_CANCER_SITE_OTHER | varchar | 50 | √ | null |
|
|
||||
| L_OTHER_DIAGNOSIS | varchar | 10 | √ | null |
|
|
||||
| L_OTHER_DIAGNOSIS_DET | varchar | 10 | √ | null |
|
|
||||
| L_BONE | int | 4 | √ | null |
|
|
||||
| L_BRAIN | int | 4 | √ | null |
|
|
||||
| L_LUNG | int | 4 | √ | null |
|
|
||||
| L_LIVER | int | 4 | √ | null |
|
|
||||
| L_LYMPH | int | 4 | √ | null |
|
|
||||
| L_LOCAL | int | 4 | √ | null |
|
|
||||
| L_SKIN | int | 4 | √ | null |
|
|
||||
| L_OTHER | int | 4 | √ | null |
|
|
||||
| L_DATE_DISCHARGE | smalldatetime | 16 | √ | null |
|
|
||||
| L_DISCH_DESIRED_PLACE | int | 4 | √ | null |
|
|
||||
| L_DISCH_DESIRED_PLACE_OTH | varchar | 255 | √ | null |
|
|
||||
| L_RAPID_DISCH | int | 4 | √ | null |
|
|
||||
| L_DISCH_METHOD | int | 4 | √ | null |
|
|
||||
| L_DISCH_METHOD_IP_UNIT | varchar | 255 | √ | null |
|
|
||||
| L_RAPID_DISCH_ACHIEVED | int | 4 | √ | null |
|
|
||||
| L_DISCH_DEST | int | 4 | √ | null |
|
|
||||
| L_DISCH_DEST_OTH | varchar | 255 | √ | null |
|
|