Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| cms_certification_number | varchar | 500 | null |
|
|
|||
| facility_name | varchar | 500 | √ | null |
|
|
||
| address_line_1 | varchar | 500 | √ | null |
|
|
||
| city | varchar | 500 | √ | null |
|
|
||
| state | varchar | 500 | √ | null |
|
|
||
| zip_code | varchar | 500 | √ | null |
|
|
||
| county_name | varchar | 500 | √ | null |
|
|
||
| phone_number | varchar | 500 | √ | null |
|
|
||
| cms_region | int | 4 | √ | null |
|
|
||
| measure_code | varchar | 500 | null |
|
|
|||
| detail_measure_code | varchar | 45 | √ | null |
|
|
||
| metric_name | varchar | 46 | √ | null |
|
|
||
| reported_on_carecompare | varchar | 1 | √ | null |
|
|
||
| score | varchar | 500 | √ | null |
|
|
||
| footnote | varchar | 500 | √ | null |
|
|
||
| start_date | date | 6 | null |
|
|
|||
| end_date | date | 6 | √ | null |
|
|
||
| qrp_start_year | int | 4 | √ | null |
|
|
||
| qrp_end_year | int | 4 | √ | null |
|
|
||
| qrp_start_quarter | int | 4 | √ | null |
|
|
||
| qrp_end_quarter | int | 4 | √ | null |
|
|
||
| location1 | varchar | 500 | √ | null |
|
|
||
| AVA_InsDate | datetime2 | 16,3 | null |
|
|
|||
| AVA_YYYYMMKey | int | 4 | null |
|
|
|||
| AVA_FileKey | varchar | 100 | null |
|
|