Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
---|---|---|---|---|---|---|---|---|---|---|
PLAN_ID | int | 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_4_RECURRENCE | varchar | 2 | √ | 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 | 5 | √ | 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 |
|
|
||||
BIOPSY_TECH_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 |
|
|
||||
COSDMeetingTypeID | int | 4 | √ | null |
|
|
||||
COSDMeetingTypeComments | varchar | 30 | √ | null |
|
|
||||
NPCA_PLAN_AGREED_WITH_PAT | bit | 1 | √ | null |
|
|
||||
NEW_TERTIARY_REFERRAL_ID | int | 4 | √ | null |
|
|
||||
ACTION_ID | int | 4 | √ | null |
|
|
||||
COSDMeetingOrg1 | varchar | 5 | √ | null |
|
|
||||
COSDMeetingOrg2 | varchar | 5 | √ | null |
|
|
||||
COSDMeetingOrg3 | varchar | 5 | √ | null |
|
|
||||
REASON_PAT_DECLINED | bit | 1 | √ | null |
|
|
||||
REASON_UNFIT_PERFORMANCE | bit | 1 | √ | null |
|
|
||||
REASON_UNFIT_COMORBIDITY | bit | 1 | √ | null |
|
|
||||
REASON_UNFIT_ADVANCED | bit | 1 | √ | null |
|
|
||||
REASON_UNKNOWN_PRIMARY | bit | 1 | √ | null |
|
|
||||
REASON_DIED | bit | 1 | √ | null |
|
|
||||
REASON_NO_TREATMENT | bit | 1 | √ | null |
|
|
||||
REASON_OTHER | bit | 1 | √ | null |
|
|
||||
REASON_MONITORING | bit | 1 | √ | null |
|
|
||||
REASON_NOT_KNOWN | bit | 1 | √ | null |
|
|
||||
COSDMeetingOrg4 | varchar | 5 | √ | null |
|
|
||||
COSDMeetingOrg5 | varchar | 5 | √ | null |
|
|
||||
COSDMeetingOrg6 | varchar | 5 | √ | null |
|
|