Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| BRACHY_ID | int identity | 4 | √ | null |
|
|
Brachytherapy Record ID |
|||
| CARE_ID | int | 4 | null |
|
|
Referral Record ID |
||||
| TEMP_ID | varchar | 255 | √ | null |
|
|
||||
| N11_1_SITE_CODE | varchar | 5 | √ | null |
|
|
Organisation (Treatment) |
|||
| N_SITE_CODE_DTT | varchar | 5 | √ | null |
|
|
Organisation (DTT) |
|||
| N11_2_CONSULTANT | varchar | 8 | √ | null |
|
|
Consultant |
|||
| N11_3_DECISION_DATE | smalldatetime | 16 | √ | null |
|
|
Date Decision to Treat |
|||
| N11_6_TREATMENT_INTENT | int | 4 | √ | null |
|
|
Treatment Intent |
|||
| N11_7_TYPE | varchar | 2 | √ | null |
|
|
Brachytherapy Type |
|||
| N11_8_TREATMENT_SITE | varchar | 5 | √ | null |
|
|
Anatomical Site |
|||
| N11_9_START_DATE | smalldatetime | 16 | √ | null |
|
|
Date Start of Treatment |
|||
| N11_10_END_DATE | smalldatetime | 16 | √ | null |
|
|
End Date |
|||
| N11_11_DOSE | real | 4 | √ | null |
|
|
Prescribed Dose (Gy) |
|||
| N11_12_DURATION | int | 4 | √ | null |
|
|
Prescribed Duration |
|||
| N11_13_FRACTIONS | real | 4 | √ | null |
|
|
Prescribed Fractions |
|||
| N11_14_ACTUAL_DOSE | real | 4 | √ | null |
|
|
Actual Dose (Gy) |
|||
| N11_15_DOSE_RATE | varchar | 1 | √ | null |
|
|
Dose Rate |
|||
| N11_16_ACTUAL_DURATION | int | 4 | √ | null |
|
|
Actual Duration |
|||
| L_TYPE_OF_DOSE | int | 4 | √ | null |
|
|
Type Of Dose |
|||
| N11_17_ISOTOPE_TYPE | varchar | 1 | √ | null |
|
|
Isotope Type |
|||
| N11_18_ANAESTHETIC | varchar | 5 | √ | null |
|
|
Anaesthetic Required |
|||
| N11_19_UNSEALED | varchar | 1 | √ | null |
|
|
Unsealed Source Pt Type |
|||
| N11_20_DELIVERY_TYPE | varchar | 1 | √ | null |
|
|
Delivery Type |
|||
| N11_22_STATUS | int | 4 | √ | null |
|
|
Treatment Outcome |
|||
| N_TREATMENT_EVENT | varchar | 2 | √ | null |
|
|
Treatment Event Type |
|||
| N_TREATMENT_SETTING | varchar | 2 | √ | null |
|
|
Treatment Setting |
|||
| L_NAMED_COMP | varchar | 50 | √ | null |
|
|
Severe Complications |
|||
| L_COMP_3MTH | varchar | 50 | √ | null |
|
|
Complications > 3mths |
|||
| L_SHORT_LONG | varchar | 5 | √ | null |
|
|
Short/Long Course |
|||
| R_INSERTIONS | int | 4 | √ | null |
|
|
No of Insertions |
|||
| R_DOSE_INSERTION | real | 4 | √ | null |
|
|
Dose per Insertion |
|||
| R_TREAT_TO | varchar | 2 | √ | null |
|
|
Treatment Site |
|||
| L_TRIAL | int | 4 | √ | null |
|
|
lst_Clinical_Trial |
|||
| ENDOSCOPIC | bit | 1 | √ | null |
|
|
Endoscopic |
|||
| DEFINITIVE_TREATMENT | int | 4 | √ | null |
|
|
Is a definitive treatment? (Derived) |
|||
| CWT_PROFORMA | int | 4 | √ | null |
|
|
Added via CWT Proforma? (Derived) |
|||
| L_COMMENTS | text | 2147483647 | √ | null |
|
|
Comments |
|||
| PRE_TREAT_PSA | real | 4 | √ | null |
|
|
Pre-Treatment PSA |
|||
| ROOT_START_DATE_COMMENTS | text | 2147483647 | √ | null |
|
|
Root Cause Analysis Comments - Start Date |
|||
| ROOT_END_DATE_COMMENTS | text | 2147483647 | √ | null |
|
|
Root Cause Analysis Comments - End Date |
|||
| ACTION_ID | int | 4 | √ | null |
|
|
Latest Audit Entry ID |
|||
| ROOT_DECISION_DATE_COMMENTS | text | 2147483647 | √ | null |
|
|
||||
| AdjunctiveTherapyID | int | 4 | √ | null |
|
|
||||
| OtherTreatmentIntent | varchar | 255 | √ | null |
|
|
||||
| HCCEmbolisation | int | 4 | √ | null |
|
|
||||
| HCCEmbolisationModality | int | 4 | √ | null |
|
|
||||
| NotCompleteReasonID | int | 4 | √ | null |
|
|
||||
| TreatmentCompletedAsPlanned | int | 4 | √ | null |
|
|
||||
| TertiaryReferralKey | uniqueidentifier | 16 | √ | null |
|
|
||||
| ROOT_PRIM_ADJUSTMENT_COMMENTS | text | 2147483647 | √ | null |
|
|
||||
| ROOT_SUBPRIM_ADJUSTMENT_COMMENTS | text | 2147483647 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_tblMAIN_BRACHYTHERAPY | Primary key | Asc | BRACHY_ID |
| IX_tblMAIN_BRACHYTHERAPY | Performance | Asc | CARE_ID |
| IX_tblMAIN_BRACHYTHERAPY_CARE_ID | Performance | Asc | CARE_ID |
| UQ_tblMAIN_BRACHYTHERAPY_CareID_TertiaryReferralKey | Must be unique | Asc/Asc | CARE_ID + TertiaryReferralKey |