Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| PALL_ID | int | 4 | null |
|
|
|||||
| CARE_ID | int | 4 | null |
|
|
|||||
| TEMP_ID | varchar | 255 | √ | null |
|
|
||||
| N12_1_DECISION_DATE | smalldatetime | 16 | √ | null |
|
|
||||
| N12_2_START_DATE | smalldatetime | 16 | √ | null |
|
|
||||
| N1_3_ORG_CODE_TREATMENT | varchar | 5 | √ | null |
|
|
||||
| N_SITE_CODE_DTT | varchar | 5 | √ | null |
|
|
||||
| N_L39_PROVIDER | varchar | 2 | √ | null |
|
|
||||
| N_L40_COMMUNITY | varchar | 2 | √ | null |
|
|
||||
| N_L41_TREATMENT | varchar | 1 | √ | null |
|
|
||||
| N_L42_TREAT_DATE | smalldatetime | 16 | √ | null |
|
|
||||
| N_TREATMENT_EVENT | varchar | 2 | √ | null |
|
|
||||
| N_TREATMENT_SETTING | varchar | 2 | √ | null |
|
|
||||
| N_SPECIALIST | varchar | 2 | √ | null |
|
|
||||
| L_TRIAL | int | 4 | √ | null |
|
|
||||
| DEFINITIVE_TREATMENT | int | 4 | √ | null |
|
|
||||
| CWT_PROFORMA | int | 4 | √ | null |
|
|
||||
| L_COMMENTS | text | 2147483647 | √ | null |
|
|
||||
| N7_2_CONSULTANT | varchar | 8 | √ | null |
|
|
||||
| PRE_TREAT_PSA | real | 4 | √ | null |
|
|