Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| ASSESSMENT_ID | int | 4 | null |
|
|
Links record to Main Assessment |
||||
| L_PLAN_PROCEDURES | int | 4 | √ | null |
|
|
No. Planned Procedures |
|||
| L_PLAN_STENT | bit | 1 | ((0)) |
|
|
Stent Insertion (Planned) |
||||
| L_PLAN_LASER | bit | 1 | ((0)) |
|
|
Laser Therapy (Planned) |
||||
| L_PLAN_ARGON | bit | 1 | ((0)) |
|
|
Argon Plasma Coagulation (Planned) |
||||
| L_PLAN_PHOTO | bit | 1 | ((0)) |
|
|
Photodynamic Therapy (Planned) |
||||
| L_PLAN_GASTROSTOMY | bit | 1 | ((0)) |
|
|
Gastrostomy (Planned) |
||||
| L_PLAN_BRACHY | bit | 1 | ((0)) |
|
|
Brachytherapy (Planned) |
||||
| L_PLAN_DILATION | bit | 1 | ((0)) |
|
|
Dilation (Planned) |
||||
| L_PLAN_OTHER | bit | 1 | ((0)) |
|
|
Other (Planned) |
||||
| L_ASPIRATION | bit | 1 | ((0)) |
|
|
Aspiration |
||||
| L_PERFORATION | bit | 1 | ((0)) |
|
|
Perforation |
||||
| L_HAEMORRHAGE | bit | 1 | ((0)) |
|
|
Haemorrhage |
||||
| L_MIGATION | bit | 1 | ((0)) |
|
|
Stent Migation |
||||
| L_BOLUS | bit | 1 | ((0)) |
|
|
Bolus Obstruction |
||||
| L_OVERGROWTH | bit | 1 | ((0)) |
|
|
Tumour Overgrowth |
||||
| L_DEATH | bit | 1 | ((0)) |
|
|
Death in Hospital |
||||
| L_OTHER_COMP | bit | 1 | ((0)) |
|
|
Other Endoscopic Complications |
||||
| L_UNPLAN_PROCEDURES | int | 4 | √ | null |
|
|
No. Unplanned Procedures |
|||
| L_UNPLAN_STENT | bit | 1 | ((0)) |
|
|
Stent Insertion (Unplanned) |
||||
| L_UNPLAN_LASER | bit | 1 | ((0)) |
|
|
Laser Therapy (Unplanned) |
||||
| L_UNPLAN_ARGON | bit | 1 | ((0)) |
|
|
Argon Plasma Coagulation (Unplanned) |
||||
| L_UNPLAN_PHOTO | bit | 1 | ((0)) |
|
|
Photodynamic Therapy (Unplanned) |
||||
| L_UNPLAN_GASTROSTOMY | bit | 1 | ((0)) |
|
|
Gastrostomy (Unplanned) |
||||
| L_UNPLAN_BRACHY | bit | 1 | ((0)) |
|
|
Brachytherapy (Unplanned) |
||||
| L_UNPLAN_DILATION | bit | 1 | ((0)) |
|
|
Dilation (Unplanned) |
||||
| L_UNPLAN_OTHER | bit | 1 | ((0)) |
|
|
Other (Unplanned) |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_tblASSESSMENT_UPPER_GI_1 | Primary key | Asc | ASSESSMENT_ID |
| IX_tblASSESSMENT_UPPER_GI | Performance | Asc | ASSESSMENT_ID |