Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| CNSContactID | int | 4 | null |
|
|
|||
| PersonID | int | 4 | null |
|
|
|||
| PatientHasQuestions | bit | 1 | null |
|
|
|||
| Ethnicity | varchar | 50 | √ | null |
|
|
||
| StatedGender | varchar | 2 | √ | null |
|
|
||
| DiagnosisCode | varchar | 5 | √ | null |
|
|
||
| DiagnosisDate | smalldatetime | 16 | √ | null |
|
|
||
| PathwayStageCode | varchar | 2 | null |
|
|
|||
| PathwayStageText | varchar | 500 | √ | null |
|
|
||
| DateHNACompleted | date | 20 | √ | null |
|
|
||
| HNACompletedByOther | nvarchar | 100 | √ | null |
|
|
||
| CarePlanCompleted | bit | 1 | √ | null |
|
|
||
| CarePlanCompletedDate | datetime | 16,3 | √ | null |
|
|
||
| CarePlanCompletedBy | int | 4 | √ | null |
|
|
||
| CarePlanCompletedByOther | nvarchar | 100 | √ | null |
|
|
||
| SNOMEDCTDiagnosisID | int | 4 | √ | null |
|
|
||
| HNACompletedBy | int | 4 | √ | null |
|
|