Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| S | char | 1 | null |
|
|
|||
| SPECVERSION | varchar | 5 | null |
|
|
|||
| SUBMITCODE | varchar | 5 | √ | null |
|
|
||
| DEMOGID | int | 4 | √ | null |
|
|
||
| IMPORTLINKID | int | 4 | √ | null |
|
|
||
| PRETREATMENTSALTASSESSMENTDATE | varchar | 10 | √ | null |
|
|
||
| SALTPRIMARYSITE | varchar | 6 | √ | null |
|
|
||
| SALTPROVIDERORGANISATION | varchar | 5 | √ | null |
|
|
||
| WASPATIENTASSESSEDPOSTTREATMENT | int | 4 | √ | null |
|
|
||
| NORMALCYOFDIETPRETREATMENT | int | 4 | √ | null |
|
|
||
| NORMALCYOFDIETTHREEMONTHS | int | 4 | √ | null |
|
|
||
| NORMALCYOFDIETTWELVEMONTHS | int | 4 | √ | null |
|
|
||
| LARYNGECTOMYPROPOSEDPOSTOPCOMMUNICATION | int | 4 | √ | null |
|
|
||
| LARYNGECTOMYCOMMUNICATIONMETHODATTHREEMONTHS | int | 4 | √ | null |
|
|
||
| LARYNGECTOMYCOMMUNICATIONMETHODATTWELVEMONTHS | int | 4 | √ | null |
|
|
||
| NUTRITIONPRIMARYSITE | varchar | 6 | √ | null |
|
|
||
| NUTRITIONPROVIDERORGANISATION | varchar | 5 | √ | null |
|
|
||
| CONTACTDATE | varchar | 10 | √ | null |
|
|
||
| WASTHEPATIENTNUTRITIONALLYASSESSEDWITHINONEMONTH | int | 4 | √ | null |
|
|
||
| TUBETYPE | int | 4 | √ | null |
|
|
||
| NUTRITIONALSUPPORTMETHOD | int | 4 | √ | null |
|
|
||
| WASPATIENTSEENWITHINSIXWEEKSOFCOMPLETIONOFTREATMEN | int | 4 | √ | null |
|
|
||
| NURSINGPRIMARYSITE | varchar | 6 | √ | null |
|
|
||
| NURSINGPROVIDERORGANISATION | varchar | 5 | √ | null |
|
|
||
| FIRSTCNSCONTACTDATE | varchar | 10 | √ | null |
|
|
||
| CLINNSPRESENT | int | 4 | √ | null |
|
|
||
| HASPATIENTCONCERNSINVENTORY | int | 4 | √ | null |
|
|
||
| PALLIATIVEPRIMARYSITE | varchar | 6 | √ | null |
|
|
||
| PALLIATIVEPROVIDERORGANISATION | varchar | 5 | √ | null |
|
|
||
| PALLIATIVECARESTARTDATE | varchar | 10 | √ | null |
|
|
||
| Username | varchar | 50 | √ | null |
|
|
Diagram producer might be missing
No diagrams were produced please see application output for any errors