Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| PLAN_ID | int identity | 4 | √ | null |
|
|
Care Plan Record ID |
|||
| CARE_ID | int | 4 | null |
|
|
Referral Record ID |
||||
| TEMP_ID | varchar | 255 | √ | null |
|
|
||||
| N5_1_MDT_MEETING_YN | char | 1 | √ | null |
|
|
Was patient discussed at MDT? |
|||
| N5_2_MDT_DATE | smalldatetime | 16 | √ | null |
|
|
MDT Meeting Date |
|||
| N5_3_PLAN_AGREE_DATE | smalldatetime | 16 | √ | null |
|
|
Care Plan Agreed Date |
|||
| N1_3_ORG_CODE_DECISION | varchar | 5 | √ | null |
|
|
Organisation |
|||
| N5_5_CARE_INTENT | char | 1 | √ | null |
|
|
Cancer Care Plan Intent |
|||
| N5_6_TREATMENT_TYPE_1 | varchar | 3 | √ | null |
|
|
Planned Treatment Type - First |
|||
| N5_6_TREATMENT_TYPE_2 | varchar | 3 | √ | null |
|
|
Planned Treatment Type - Second |
|||
| N5_6_TREATMENT_TYPE_3 | varchar | 3 | √ | null |
|
|
Planned Treatment Type - Third |
|||
| N5_6_TREATMENT_TYPE_4 | varchar | 3 | √ | null |
|
|
Planned Treatment Type - Fourth |
|||
| 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 | nvarchar | 1073741823 | √ | 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 |
|
|
||||
| COSDMeetingTypeID | int | 4 | √ | null |
|
|
||||
| COSDMeetingTypeComments | varchar | 60 | √ | 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 |
|
|
||||
| CON_RES_DENTIST_ASKED_MDT | int | 4 | √ | null |
|
|
||||
| DENTAL_ASSESS_NECESSARY | int | 4 | √ | null |
|
|
||||
| TertiaryReferralKey | uniqueidentifier | 16 | √ | null |
|
|
||||
| MDTDiscussionType | int | 4 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_tblMAIN_CARE_PLAN | Primary key | Asc | PLAN_ID |
| IX_CareID | Performance | Asc | CARE_ID |
| IX_CWTTreatment | Performance | Asc/Asc | L_CARE_PLAN_AGREED + N5_2_MDT_DATE |
| IX_MostRecentMDT | Performance | Asc/Asc/Asc | CARE_ID + N5_1_MDT_MEETING_YN + N5_2_MDT_DATE |
| UQ_tblMAIN_CARE_PLAN_CareID_TertiaryReferralKey | Must be unique | Asc/Asc | CARE_ID + TertiaryReferralKey |