Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
PROVNUM | varchar | 500 | null |
|
|
|||
PROVNAME | varchar | 500 | √ | null |
|
|
||
ADDRESS | varchar | 500 | √ | null |
|
|
||
CITY | varchar | 500 | √ | null |
|
|
||
STATE | varchar | 500 | √ | null |
|
|
||
ZIP | varchar | 500 | √ | null |
|
|
||
SURVEY_DATE_OUTPUT | date | 6 | null |
|
|
|||
SURVEYTYPE | varchar | 500 | √ | null |
|
|
||
DEFPREF | varchar | 500 | √ | null |
|
|
||
TAG | varchar | 500 | null |
|
|
|||
TAG_DESC | varchar | 500 | √ | null |
|
|
||
SCOPE | varchar | 500 | √ | null |
|
|
||
DEFSTAT | varchar | 500 | √ | null |
|
|
||
STATDATE | date | 6 | √ | null |
|
|
||
CYCLE | int | 4 | null |
|
|
|||
STANDARD | varchar | 500 | √ | null |
|
|
||
COMPLAINT | varchar | 500 | √ | null |
|
|
||
FILEDATE | date | 6 | null |
|
|
|||
AVA_InsDate | datetime2 | 16,3 | (getdate()) |
|
|
|||
AVA_YYYYMMKey | int | 4 | null |
|
|
|||
AVA_FileKey | varchar | 100 | null |
|
|
|||
TAG_CATEGORY | varchar | 200 | √ | null |
|
|
||
LOCATION | varchar | 500 | √ | null |
|
|
||
Infection Control Inspection Deficiency | varchar | 500 | √ | null |
|
|
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
Medicare_HealthDeficiencies_PK | Primary key | Asc/Asc/Asc/Asc/Asc | PROVNUM + TAG + SURVEY_DATE_OUTPUT + CYCLE + FILEDATE |
IX_Medicare_HealthDeficiencies | Performance | Asc/Asc | AVA_YYYYMMKey + AVA_FileKey |
Diagram producer might be missing
No diagrams were produced please see application output for any errors