Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| censusid | int | 4 | null |
|
|
|||
| censusdate | datetime | 16,3 | null |
|
|
|||
| reporting_month | date | 6 | √ | null |
|
|
||
| residentnumber | varchar | 35 | √ | null |
|
|
||
| facility_code | varchar | 10 | null |
|
|
|||
| display_name | varchar | 300 | null |
|
|
|||
| division | varchar | 50 | null |
|
|
|||
| facilityname | varchar | 75 | null |
|
|
|||
| facilitystate | varchar | 3 | √ | null |
|
|
||
| facilityhealthcaretype | varchar | 10 | √ | null |
|
|
||
| facilitytype | varchar | 254 | null |
|
|
|||
| pcc_insurance | varchar | 80 | √ | null |
|
|
||
| std_ins_name | varchar | 1000 | √ | null |
|
|
||
| pcc_payername | varchar | 50 | √ | null |
|
|
||
| pcc_payer_type | varchar | 20 | √ | null |
|
|
||
| wade_payer_type | varchar | 50 | √ | null |
|
|
||
| pcc_daily_reimbursement | money | 21,4 | √ | null |
|
|
||
| monthly_reimb_flag | char | 1 | null |
|
|
|||
| est_method | varchar | 20 | √ | null |
|
|
||
| lbound_reimb | money | 21,4 | √ | null |
|
|
||
| avg_reimb | money | 21,4 | √ | null |
|
|
||
| median_reimb | money | 21,4 | √ | null |
|
|
||
| ubound_reimb | money | 21,4 | √ | null |
|
|
||
| carelevelcode | varchar | 5 | √ | null |
|
|
||
| unk_flag | varchar | 1 | null |
|
|
|||
| unk_or_null_flag | varchar | 1 | null |
|
|
|||
| asof_datetime | datetime2 | 16,3 | null |
|
|