Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| MEETING_ID | int identity | 4 | √ | null |
|
|
Unique Record ID |
|||
| MEETING_TYPE_ID | int | 4 | null |
|
|
MDT Meeting Type |
||||
| SUB_SITE | int | 4 | √ | null |
|
|
MDT Meeting Type (Sub-Site) |
|||
| LOCATION | varchar | 50 | √ | null |
|
|
Location |
|||
| LOCAL_NETWORK | int | 4 | √ | null |
|
|
Local/Network |
|||
| PRINT_PRESENTATION | bit | 1 | ((-1)) |
|
|
Whether to Print Presentation Section on form for this MDT |
||||
| PRINT_INVESTIGATIONS | bit | 1 | ((-1)) |
|
|
Whether to Print Investigations Section on form for this MDT |
||||
| PRINT_DIAGNOSIS | bit | 1 | ((-1)) |
|
|
Whether to Print Diagnosis Section on form for this MDT |
||||
| PRINT_STAGING | bit | 1 | ((-1)) |
|
|
Print Staging |
||||
| PRINT_TREATMENTS | bit | 1 | ((-1)) |
|
|
Whether to Print Treatments Section on form for this MDT |
||||
| PRINT_PATHOLOGY | bit | 1 | ((-1)) |
|
|
Whether to Print Pathology Section on form for this MDT |
||||
| PRINT_PREV_CARE | bit | 1 | ((-1)) |
|
|
Whether to Print Previous Care Plan Section on form for this MDT |
||||
| IS_DELETED | bit | 1 | ((0)) |
|
|
Record deleted indicator |
||||
| SAVE_MDT_COMMENTS | bit | 1 | null |
|
|
Save MDT Comments to CWT Tracking Notes |
||||
| COSD_Type_ID | int | 4 | √ | null |
|
|
COSD MDT Meeting Type |
|||
| COSD_Comments | varchar | 60 | √ | null |
|
|
COSD MDT Meeting Type Comments |
|||
| Organisation1 | varchar | 5 | √ | null |
|
|
Organisation(s) (1st in list) |
|||
| Organisation2 | varchar | 5 | √ | null |
|
|
Organisation(s) (2nd in list) |
|||
| Organisation3 | varchar | 5 | √ | null |
|
|
Organisation(s) (3rd in list) |
|||
| Organisation4 | varchar | 5 | √ | null |
|
|
Organisation(s) (4th in list) |
|||
| Organisation5 | varchar | 5 | √ | null |
|
|
Organisation(s) (5th in list) |
|||
| Organisation6 | varchar | 5 | √ | null |
|
|
Organisation(s) (6th in list) |
|||
| MDTLeadID | int | 4 | √ | null |
|
|
||||
| PrimaryMDTSite | bit | 1 | ((0)) |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_tblMDT_MEETINGS | Primary key | Asc | MEETING_ID |