Surveys_CBC_Data

3147 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
Facility_ID int 4 null
CBC_Input_ID int 4 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 √ (getdate())

Indexes

Constraint Name Type Sort Column(s)
PK_Surveys_CBC_Data Primary key Asc/Asc Facility_ID + CBC_Input_ID

Diagram producer might be missing

No diagrams were produced please see application output for any errors