Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| TELE_ID | int | 4 | null |
|
|
|||||
| CARE_ID | int | 4 | null |
|
|
|||||
| TEMP_ID | varchar | 255 | √ | null |
|
|
||||
| N10_1_SITE_CODE | varchar | 5 | √ | null |
|
|
||||
| N_SITE_CODE_DTT | varchar | 5 | √ | null |
|
|
||||
| N10_2_CONSULTANT | varchar | 8 | √ | null |
|
|
||||
| N10_3_DECISION_DATE | smalldatetime | 16 | √ | null |
|
|
||||
| N10_6_TREATMENT_INTENT | varchar | 1 | √ | null |
|
|
||||
| N10_7_TREATMENT_SITE | varchar | 5 | √ | null |
|
|
||||
| N10_8_START_DATE | smalldatetime | 16 | √ | null |
|
|
||||
| N10_9_END_DATE | smalldatetime | 16 | √ | null |
|
|
||||
| N10_10_DOSE | real | 4 | √ | null |
|
|
||||
| N10_11_FRACTIONS | real | 4 | √ | null |
|
|
||||
| N10_12_DURATION | int | 4 | √ | null |
|
|
||||
| N10_13_ACTUAL_DOSE | real | 4 | √ | null |
|
|
||||
| N10_14_ACTUAL_FRACTIONS | real | 4 | √ | null |
|
|
||||
| N10_15_ACTUAL_DURATION | int | 4 | √ | null |
|
|
||||
| N10_16_BEAM_TYPE | varchar | 1 | √ | null |
|
|
||||
| N10_17_BEAM_ENERGY_1 | varchar | 1 | √ | null |
|
|
||||
| N10_17_BEAM_ENERGY_2 | varchar | 1 | √ | null |
|
|
||||
| N10_18_FIELDS | varchar | 1 | √ | null |
|
|
||||
| N10_19_COMPLEXITY | varchar | 1 | √ | null |
|
|
||||
| N10_20_ANAESTHETIC | varchar | 5 | √ | null |
|
|
||||
| N10_21_MULTIPLE_PLANNING | varchar | 5 | √ | null |
|
|
||||
| N10_23_STATUS | int | 4 | √ | null |
|
|
||||
| N_L26_RT_GIVEN | varchar | 2 | √ | null |
|
|
||||
| N_TREATMENT_EVENT | varchar | 2 | √ | null |
|
|
||||
| N_TREATMENT_SETTING | varchar | 2 | √ | null |
|
|
||||
| N_PRIORITY | varchar | 1 | √ | null |
|
|
||||
| N_CHEMORADIO | int | 4 | √ | null |
|
|
||||
| L_DOSE_FRACTIONS | real | 4 | √ | null |
|
|
||||
| L_FRACTIONS_WEEK | int | 4 | √ | null |
|
|
||||
| L_NAMED_COMP | varchar | 50 | √ | null |
|
|
||||
| L_COMP_3MTH | varchar | 50 | √ | null |
|
|
||||
| L_SHORT_LONG | varchar | 5 | √ | null |
|
|
||||
| L_TRIAL | int | 4 | √ | null |
|
|
||||
| L_FRAME | int | 4 | √ | null |
|
|
||||
| R_TREAT_TO | varchar | 2 | √ | null |
|
|
||||
| DEFINITIVE_TREATMENT | int | 4 | √ | null |
|
|
||||
| CWT_PROFORMA | int | 4 | √ | null |
|
|
||||
| L_COMMENTS | text | 2147483647 | √ | null |
|
|
||||
| BRAIN_RADIOSURGERY_INDICATOR | varchar | 2 | √ | null |
|
|
||||
| PRE_TREAT_PSA | real | 4 | √ | null |
|
|