Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
---|---|---|---|---|---|---|---|---|---|---|
reporting_month | date | 6 | √ | null |
|
|
||||
asof_date | date | 6 | null |
|
|
|||||
parent_facility_code | varchar | 10 | null |
|
|
|||||
facility_code | varchar | 10 | null |
|
|
|||||
facility_id | int | 4 | null |
|
|
|||||
facility_name | varchar | 300 | null |
|
|
|||||
lbound_reimb_total | money | 21,4 | √ | null |
|
|
||||
median_reimb_total | money | 21,4 | √ | null |
|
|
||||
avg_reimb_total | money | 21,4 | √ | null |
|
|
||||
ubound_reimb_total | money | 21,4 | √ | null |
|
|
||||
total_census_days | int | 4 | √ | null |
|
|
||||
unknown_census_days | int | 4 | √ | null |
|
|
||||
curr_month_flag | varchar | 1 | null |
|
|
|||||
prior_month_flag | varchar | 1 | null |
|
|
|||||
curr_open_month | date | 6 | √ | null |
|
|
||||
prior_closed_month | date | 6 | √ | null |
|
|