Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| PLAN_ID | int identity | 4 | null |
|
|
|||||
| CARE_ID | int | 4 | null |
|
|
|||||
| TEMP_ID | varchar | 255 | √ | null |
|
|
||||
| N5_1_MDT_MEETING_YN | char | 1 | √ | null |
|
|
||||
| N5_2_MDT_DATE | smalldatetime | 16 | √ | null |
|
|
||||
| N5_3_PLAN_AGREE_DATE | smalldatetime | 16 | √ | null |
|
|
||||
| N1_3_ORG_CODE_DECISION | varchar | 5 | √ | null |
|
|
||||
| N5_5_CARE_INTENT | char | 1 | √ | null |
|
|
||||
| N5_6_TREATMENT_TYPE_1 | varchar | 3 | √ | null |
|
|
||||
| N5_6_TREATMENT_TYPE_2 | varchar | 3 | √ | null |
|
|
||||
| N5_6_TREATMENT_TYPE_3 | varchar | 3 | √ | null |
|
|
||||
| N5_6_TREATMENT_TYPE_4 | varchar | 3 | √ | null |
|
|
||||
| N5_8_NO_TREATMENT | varchar | 2 | √ | null |
|
|
||||
| N5_9_CO_MORBIDITY | int | 4 | √ | null |
|
|
||||
| N5_10_WHO_STATUS | int | 4 | √ | null |
|
|
||||
| N_HN20_PC_DATE | smalldatetime | 16 | √ | null |
|
|
||||
| N_L19_PCI | varchar | 1 | √ | null |
|
|
||||
| N_L28_PLAN_TYPE | varchar | 2 | √ | null |
|
|
||||
| N_L32_CHOICE | varchar | 2 | √ | null |
|
|
||||
| L_LOCATION | varchar | 50 | √ | null |
|
|
||||
| L_PRE_POST_OP | varchar | 5 | √ | null |
|
|
||||
| L_ONCOLOGIST | varchar | 255 | √ | null |
|
|
||||
| L_MDT_ACTION_BY | varchar | 255 | √ | null |
|
|
||||
| L_PATH_REVIEW | varchar | 5 | √ | null |
|
|
||||
| L_REVIEW_WHO | varchar | 50 | √ | null |
|
|
||||
| L_REFERRED_TO | varchar | 50 | √ | null |
|
|
||||
| L_WHO_REFERRED_TO | varchar | 8 | √ | null |
|
|
||||
| L_LETTER_CC | varchar | 255 | √ | null |
|
|
||||
| L_OTHER_TRUST | varchar | 5 | √ | null |
|
|
||||
| L_TERTIARY_REASON | int | 4 | √ | null |
|
|
||||
| L_NETWORK | varchar | 5 | √ | null |
|
|
||||
| L_DATE_NETWORK_MEETING | smalldatetime | 16 | √ | null |
|
|
||||
| L_NETWORK_ACTIONED | varchar | 255 | √ | null |
|
|
||||
| L_PLANNED_TRANSPLANT | int | 4 | √ | null |
|
|
||||
| R_TYPE_REC | varchar | 10 | √ | null |
|
|
||||
| R_DIAG_BY | varchar | 15 | √ | null |
|
|
||||
| R_NOT_CUR | varchar | 2 | √ | null |
|
|
||||
| L_SEIZURES | int | 4 | √ | null |
|
|
||||
| L_SURGERY | int | 4 | √ | null |
|
|
||||
| L_CARE_PLAN_AGREED | char | 1 | √ | null |
|
|
||||
| L_MDT_SITE | varchar | 2 | √ | null |
|
|
||||
| L_RESECTIVE_PATHOLOGY | int | 4 | √ | null |
|
|
||||
| L_MDT_COMMENTS | text | 2147483647 | √ | null |
|
|
||||
| L_NETWORK_FEEDBACK | text | 2147483647 | √ | null |
|
|
||||
| L_NETWORK_COMMENTS | text | 2147483647 | √ | null |
|
|
||||
| L_REASON_NOT_DISCUSSED | int | 4 | √ | null |
|
|
||||
| R_NOT_DISCUSSED_COMMENTS | text | 2147483647 | √ | null |
|
|
||||
| LANSKY_ID | int | 4 | √ | null |
|
|
||||
| ROOT_CAUSE_COMMENTS | text | 2147483647 | √ | null |
|
|
||||
| ASA_PROSTATE | int | 4 | √ | null |
|
|
||||
| MULTIPARA_MRI_PERF | int | 4 | √ | null |
|
|
||||
| SPECIALIST_REF_APPTS | int | 4 | √ | null |
|
|
||||
| PLANNED_PROS_TREAT_1 | varchar | 3 | √ | null |
|
|
||||
| PLANNED_PROS_TREAT_2 | varchar | 3 | √ | null |
|
|
||||
| PLANNED_RADIO_INTENT | int | 4 | √ | null |
|
|
||||
| PLANNED_RADIO_TYPE | int | 4 | √ | null |
|
|
||||
| PLANNED_IMAGE_GUIDANCE | int | 4 | √ | null |
|
|
||||
| PLANNED_RADIO_FIELD | int | 4 | √ | null |
|
|
||||
| PLANNED_BRACHY_TYPE | int | 4 | √ | null |
|
|
||||
| PLANNED_BRACHY_TOTAL_DOSE | int | 4 | √ | null |
|
|
||||
| PLANNED_BRACHY_TOTAL_FRACTIONS | int | 4 | √ | null |
|
|
||||
| PLANNED_DUR_NEOADJ_AND_DEP_THERAPY | int | 4 | √ | null |
|
|
||||
| PLANNED_TOT_DUR_ADJ_ANDR_DEPR | int | 4 | √ | null |
|
|
||||
| TERTIARY_REFERRAL_ID | int | 4 | √ | null |
|
|