Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
TREAT_ID | int | 4 | null |
|
|
|||
CARE_ID | int | 4 | null |
|
|
|||
TreatType | varchar | 12 | null |
|
|
|||
TreatEvent | varchar | 2 | √ | null |
|
|
||
TreatIntentDesc | varchar | 50 | √ | null |
|
|
||
Adjunctive Therapy | varchar | 50 | √ | null |
|
|
||
TreatSetting | varchar | 2 | √ | null |
|
|
||
Organisation (Treatment) Site Code | varchar | 5 | √ | null |
|
|
||
Organisation (Treatment) Name | nvarchar | 500 | √ | null |
|
|
||
ConCode | varchar | 8 | √ | null |
|
|
||
DecisionDate | smalldatetime | 16 | √ | null |
|
|
||
StartDate | smalldatetime | 16 | √ | null |
|
|
||
DischargeDate | int | 4 | √ | null |
|
|
||
VALIDATED | int | 4 | √ | null |
|
|