Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
PCC_FacId | int | 4 | √ | null |
|
|
||
FacilityCode | varchar | 5 | √ | null |
|
|
||
FacilityName | varchar | 375 | √ | null |
|
|
||
FacilityType | varchar | 254 | √ | null |
|
|
||
CBC_Input_ID | int | 4 | null |
|
|
|||
reporting_month | date | 6 | √ | null |
|
|
||
Year | int | 4 | √ | null |
|
|
||
Month | int | 4 | √ | null |
|
|
||
Census | int | 4 | √ | null |
|
|
||
Census_Daily | int | 4 | √ | null |
|
|
||
Census_Lastday | int | 4 | √ | null |
|
|
||
Medicaid_Residents | int | 4 | √ | null |
|
|
||
Private_Pay_Residents | int | 4 | √ | null |
|
|
||
Total number of resident falls | numeric | 20,2 | √ | null |
|
|
||
Number of pressure ulcers (>=stage II) | numeric | 20,2 | √ | null |
|
|
||
Number of residents w/ significant weight loss | numeric | 20,2 | √ | null |
|
|
||
Incidents of medication errors | numeric | 20,2 | √ | null |
|
|
||
Average call response time in minutes | numeric | 20,2 | √ | null |
|
|
||
Incidents of resident elopements | numeric | 20,2 | √ | null |
|
|
||
Incidents of falls resulting in fracture | numeric | 20,2 | √ | null |
|
|
||
Incidents of injuries of unknown origin | numeric | 20,2 | √ | null |
|
|
||
Incidents of falls with injury | numeric | 20,2 | √ | null |
|
|
||
Number of employees out of compliance w/trainings | numeric | 20,2 | √ | null |
|
|
||
Number of clinically denied admissions | numeric | 20,2 | √ | null |
|
|
||
Corporate_Goal_ALF_Total number of resident falls | numeric | 20,2 | √ | null |
|
|
||
Corporate_Goal_ALF_Number of pressure ulcers (>=stage II) | numeric | 20,2 | √ | null |
|
|
||
Corporate_Goal_ALF_Number of residents w/ significant weight loss | numeric | 20,2 | √ | null |
|
|
||
Corporate_Goal_ALF_Incidents of medication errors | numeric | 20,2 | √ | null |
|
|
||
Corporate_Goal_ALF_Average call response time in minutes | numeric | 20,2 | √ | null |
|
|
||
Corporate_Goal_ALF_Incidents of resident elopements | numeric | 20,2 | √ | null |
|
|
||
Corporate_Goal_ALF_Incidents of falls resulting in fracture | numeric | 20,2 | √ | null |
|
|
||
Corporate_Goal_ALF_Incidents of injuries of unknown origin | numeric | 20,2 | √ | null |
|
|
||
Corporate_Goal_ALF_Incidents of falls with injury | numeric | 20,2 | √ | null |
|
|
||
Corporate_Goal_ALF_Number of employees out of compliance w/trainings | numeric | 20,2 | √ | null |
|
|
||
Corporate_Goal_ALF_Number of clinically denied admissions | numeric | 20,2 | √ | null |
|
|
||
Corporate_Goal_RCF_Total number of resident falls | numeric | 20,2 | √ | null |
|
|
||
Corporate_Goal_RCF_Number of pressure ulcers (>=stage II) | numeric | 20,2 | √ | null |
|
|
||
Corporate_Goal_RCF_Number of residents w/ significant weight loss | numeric | 20,2 | √ | null |
|
|
||
Corporate_Goal_RCF_Incidents of medication errors | numeric | 20,2 | √ | null |
|
|
||
Corporate_Goal_RCF_Average call response time in minutes | numeric | 20,2 | √ | null |
|
|
||
Corporate_Goal_RCF_Incidents of resident elopements | numeric | 20,2 | √ | null |
|
|
||
Corporate_Goal_RCF_Incidents of falls resulting in fracture | numeric | 20,2 | √ | null |
|
|
||
Corporate_Goal_RCF_Incidents of injuries of unknown origin | numeric | 20,2 | √ | null |
|
|
||
Corporate_Goal_RCF_Incidents of falls with injury | numeric | 20,2 | √ | null |
|
|
||
Corporate_Goal_RCF_Number of employees out of compliance w/trainings | numeric | 20,2 | √ | null |
|
|
||
Corporate_Goal_RCF_Number of clinically denied admissions | numeric | 20,2 | √ | null |
|
|
||
Calculation_Total number of resident falls | numeric | 20,2 | √ | null |
|
|
||
Calculation_Number of pressure ulcers (>=stage II) | numeric | 20,2 | √ | null |
|
|
||
Calculation_Number of residents w/ significant weight loss | numeric | 20,2 | √ | null |
|
|
||
Calculation_Incidents of medication errors | numeric | 20,2 | √ | null |
|
|
||
Calculation_Average call response time in minutes | numeric | 20,2 | √ | null |
|
|
||
Calculation_Incidents of resident elopements | numeric | 20,2 | √ | null |
|
|
||
Calculation_Incidents of falls resulting in fracture | numeric | 20,2 | √ | null |
|
|
||
Calculation_Incidents of injuries of unknown origin | numeric | 20,2 | √ | null |
|
|
||
Calculation_Incidents of falls with injury | numeric | 20,2 | √ | null |
|
|
||
Calculation_Number of employees out of compliance w/trainings | numeric | 20,2 | √ | null |
|
|
||
Calculation_Number of clinically denied admissions | numeric | 20,2 | √ | null |
|
|
||
AVA_insdate | datetime2 | 16 | √ | null |
|
|