Overview Top Package Entity

Dimensional Warehouse Model Data Model

---

Entity Labor Productivity Analysis

Description

Labor Productivity metrics are primary comprised of a number of hours worked or expense combined with a volume of activity such as procedures performed. These can be used to assess how efficiently labor resources are being used.

Attributes

Account Dk

Actual Mix Percent Rt

Actual Volume Num

Agency Percent Rt

Annualized Impact Num

Contract Agency Percent Rt

Contract Dollar Variance Amt

Contract Hours Variance Amt

Contract Staffing Hours Qty

Contract Staffing Hours Rt

Currency Cd

Currency Code Sk

Education Actual Calculation For Graph Num

Education and Orientation Dollar Variance Num

Education and Orientation Hours Variance Num

FTE Mix Variance Amt

Hourly Rate Average Rt

Hours Agency Qty

Hours Clerical Qty

Hours Clinical Non Licensed Qty

Hours Education Qty

Hours Executive Qty

Hours Holiday Qty

Hours Management Qty

Hours Nursing LPN Qty

Hours Nursing RN Qty

Hours Orientation Qty

Hours Other Nursing Qty

Hours Paid Other Qty

Hours Professional Non Nursing Qty

Hours PTO Qty

Hours Regular Qty

Hours Sick Qty

Hours Support Qty

Hours Technical Qty

Hours Total Paid Qty

Hours Vacation Qty

Job Dk

Labor Expense Index Rt

Labor Expense Per Unit Actual Rt

Labor Expense Per Unit for Key Volume Rt

Labor Expense Per Unit Rt

Labor Expense Per Unit Target Rt

Labor Expense Variance Amt

Labor Expense Variance versus Target Num

Measure Definition Dk

Mix FTE Actual Num

Mix FTE Target Num

Overtime Dollars Variance Rt

Overtime FTE Variance Rt

Overtime Hours Qty

Overtime Hours Variance Qty

Overtime Percent Rt

Paid Hours per Unit Actual Rt

Paid Hours per Unit Target Rt

Period Labor Expense Index Rt

Practitioner Dk

Productivity Index Rt

Productivity Rt

PTO Percent Rt

Skill Mix Actual Percent Rt

Skill Mix Difference Num

Skill Mix Dollar Variance Rt

Variance Budget Rt

Variance FTE Rt

Variance Total Dollar Rt

Volume Num

Worked FTE Actual Rt

Worked FTE Budget Rt

Worked FTE Rt

Worked FTE Target Fixed Rt

Worked FTE Target Rt

Worked FTE Target Variable Rt

Worked FTE Variance versus Target Rt

Worked Hours Other Qty

Worked Hours Per Day Actual Rt

Worked Hours Per Day Target Fixed Rt

Worked Hours Per Day Target Rt

Worked Hours Per Day Target Variable Rt

Worked Hours Per Unit Actual Rt

Worked Hours per Unit Rt

Worked Hours per Unit Target Rt

Worked Hours Qty

Worked Hours Total Qty

Relationship

Labor Productivity Analysis_Measure Dimension_FK

Labor Productivity Analysis_Account Dimension_FK

Labor Productivity Analysis_Practitioner Dimension_FK

Labor Productivity Analysis_Job Dimension_FK

Primary Key

Labor Productivity Analysis PK

Dependencies

Reverse Dependencies

Attribute Details

 Account Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	true
Is Required	true
Is Derived	false
Is Surrogate Key	false

---

 Actual Mix Percent Rt

Label	Actual Mix Percentage
Description	Total Paid Hours for all job codes in the Job Category / Total Actual Paid Hours in department
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Actual Volume Num

Label	Actual Volume
Description	Sum of Actual Volume (from raw data)
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal Small [DECIMAL(5,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Agency Percent Rt

Label	Agency Percent
Description	Sum Agency Dollars / Sum of Agency Hours
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Annualized Impact Num

Label	Annualized Impact
Description	For Department Job Code Category, use one of the following calculations: If actual expense and hours exist for the skill, then: (Actual Mix FTE – Target Mix FTE) x Average Hourly Rate by Job Code category x 2080. If expense or hours do not exist for the Job Code category and the target percentage is defined for the Job Code category, then: (Actual Mix FTE – Target Mix FTE)x Average Hourly Rate for Department x 2080
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal Small [DECIMAL(5,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Contract Agency Percent Rt

Label	Contract Agency Percentage
Description	Sum of Agency Hours / Sum of Action Paid Hours
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Contract Dollar Variance Amt

Label	Contract Dollar Variance
Description	Contract Hours Variance x Average Hourly Rate for Department
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Contract Hours Variance Amt

Label	Contract Hours Variance
Description	Actual Agency Hours – Target Agency Hours
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Contract Staffing Hours Qty

Label	Contract Staffing
Description	Sum of Agency Hours / Sum of Action Paid Hours. Actual Paid Hours = Regular Hours + Overtime Hours + Education Hours + Orientation Hours + Agency Hours + Other Worked Hours + Sick Hours + Vacation Hours + Holiday Hours + Other Benefit Hours
Data Type	Standards - Data Domains.ddm/Data Domains/Quantity Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Contract Staffing Hours Rt

Label	Contract Staffing Hours
Description	Sum of Agency Hours / Sum of Action Paid
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Currency Cd

Description	The code indicates the code for the currency used for the Expense Amount.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Currency Code Sk

Description	The surrogate key indicates the code for the currency used for the Expense Amount.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Education Actual Calculation For Graph Num

Label	Education Actual calculation for the Graph
Description	Total Education and Orientation Hours for Department x Average Rate. Education Target calculation for the graph Target % from Department Definition x Total Paid Hours x Average Rate Regarding the effective data issue: If the period is 7/1 – 7/14 and there is an Educ/Orient target effective date of 7/5, then the calculation would be: (Target1 x (5 days) + Target2 x (9 days) / 14 x Total Paid Hours x Average Rate.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal Small [DECIMAL(5,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Education and Orientation Dollar Variance Num

Label	Education and Orientation Dollar Variance
Description	Education and Orientation Hours Variance x Average Hourly Rate for Department
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal Small [DECIMAL(5,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Education and Orientation Hours Variance Num

Label	Education and Orientation Hours Variance
Description	Actual Education Hours + Actual Orientation Hours Ð Target Education and Orientation Hours
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal Small [DECIMAL(5,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 FTE Mix Variance Amt

Label	FTE Mix Variance
Description	Actual Mix FTE – Target Mix FTE
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Hourly Rate Average Rt

Label	Average Hourly Rate
Description	Sum of Labor Expense / Sum of Paid Hours Notes: Include/exclude Bonus Exp as setup in System Options. This calculation may be by skill mix category; in this case sum Labor Expense and Paid Hours for the job codes that belong to a specified Skill Mix Category.
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Hours Agency Qty

Label	Agency Hours
Description	Sum of Agency Hours (from raw data)
Data Type	Standards - Data Domains.ddm/Data Domains/Quantity Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Hours Clerical Qty

Label	Clerical
Description	Clerical Skill Mix Actual Percent x Actual Paid FTE for the department. Skill Mix Actual Percent= Paid Hours for Skill/ Paid Hours for Department. Actual Paid FTE = Actual Paid Hours/ (Hours per FTE x Days in Period). Actual Paid Hours = Regular Hours + Overtime Hours + Education Hours + Orientation Hours + Agency Hours + Other Worked Hours + Sick Hours + Vacation Hours + Holiday Hours + Other Benefit Hours.
Data Type	Standards - Data Domains.ddm/Data Domains/Quantity Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Hours Clinical Non Licensed Qty

Label	Clinical Non Licensed
Description	Clinical Non-licensed Skill Mix Actual Percent x Actual Paid FTE for the department. Skill Mix Actual Percent= Paid Hours for Skill/ Paid Hours for Department Actual Paid FTE = Actual Paid Hours/ (Hours per FTE x Days in Period). Actual Paid Hours = Regular Hours + Overtime Hours + Education Hours + Orientation Hours + Agency Hours + Other Worked Hours + Sick Hours + Vacation Hours + Holiday Hours + Other Benefit Hours.
Data Type	Standards - Data Domains.ddm/Data Domains/Quantity Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Hours Education Qty

Label	Education Hours
Description	Sum of Education Hours (from raw data)
Data Type	Standards - Data Domains.ddm/Data Domains/Quantity Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Hours Executive Qty

Description	Skill Mix Actual Percent x Actual Paid FTE for the department. Skill Mix Actual Percent= Paid Hours for Skill/ Paid Hours for Department. Actual Paid FTE = Actual Paid Hours/ (Hours per FTE x Days in Period). Actual Paid Hours = Regular Hours + Overtime Hours + Education Hours + Orientation Hours + Agency Hours + Other Worked Hours + Sick Hours + Vacation Hours + Holiday Hours + Other Benefit Hours.
Data Type	Standards - Data Domains.ddm/Data Domains/Quantity Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Hours Holiday Qty

Label	Holiday Hours
Description	Sum of Holiday Hours (from raw data)
Data Type	Standards - Data Domains.ddm/Data Domains/Quantity Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Hours Management Qty

Label	Management
Description	Skill Mix Actual Percent x Actual Paid FTE for the department. Skill Mix Actual Percent= Paid Hours for Skill/ Paid Hours for Department. Actual Paid FTE = Actual Paid Hours/ (Hours per FTE x Days in Period). Actual Paid Hours = Regular Hours + Overtime Hours + Education.
Data Type	Standards - Data Domains.ddm/Data Domains/Quantity Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Hours Nursing LPN Qty

Label	Nursing LPN
Description	Nursing-LPN Skill Mix Actual Percent x Actual Paid FTE for the department. Skill Mix Actual Percent= Paid Hours for Skill/ Paid Hours for Department. Actual Paid FTE = Actual Paid Hours/ (Hours per FTE x Days in Period). Actual Paid Hours = Regular Hours + Overtime Hours + Education Hours + Orientation Hours + Agency Hours + Other Worked Hours + Sick Hours + Vacation Hours + Holiday Hours + Other Benefit Hours.
Data Type	Standards - Data Domains.ddm/Data Domains/Quantity Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Hours Nursing RN Qty

Label	Nursing RN
Description	Nursing–RN Skill Mix Actual Percent x Actual Paid FTE for the department. Skill Mix Actual Percent= Paid Hours for Skill/ Paid Hours for Department Actual Paid FTE = Actual Paid Hours/ (Hours per FTE x Days in Period). Actual Paid Hours = Regular Hours + Overtime Hours + Education Hours + Orientation Hours + Agency Hours + Other Worked Hours + Sick Hours + Vacation Hours + Holiday Hours + Other Benefit Hours.
Data Type	Standards - Data Domains.ddm/Data Domains/Quantity Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Hours Orientation Qty

Label	Orientation Hours
Description	Sum of Orientation Hours (from raw data)
Data Type	Standards - Data Domains.ddm/Data Domains/Quantity Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Hours Other Nursing Qty

Label	Other Nursing
Description	Other Nursing Skill Mix Actual Percent x Actual Paid FTE for the department. Skill Mix Actual Percent= Paid Hours for Skill/ Paid Hours for Department. Actual Paid FTE = Actual Paid Hours/ (Hours per FTE x Days in Period). Actual Paid Hours = Regular Hours + Overtime Hours + Education Hours + Orientation Hours + Agency Hours + Other Worked Hours + Sick Hours + Vacation Hours + Holiday Hours + Other Benefit Hours.
Data Type	Standards - Data Domains.ddm/Data Domains/Quantity Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Hours Paid Other Qty

Label	Paid Other Hours
Description	Sum of Paid Other Hours (from raw data)
Data Type	Standards - Data Domains.ddm/Data Domains/Quantity Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Hours Professional Non Nursing Qty

Label	Professional Non Nursing
Description	Professional Non-nursing Skill Mix Actual Percent x Actual Paid FTE for the department. Skill Mix Actual Percent= Paid Hours for Skill/ Paid Hours for Department. Actl Paid FTE = Actual Paid Hours/ (Hours per FTE x Days in Period). Actual Paid Hours = Regular Hours + Overtime Hours + Education Hours + Orientation Hours + Agency Hours + Other Worked Hours + Sick Hours + Vacation Hours + Holiday Hours + Other Benefit Hours.
Data Type	Standards - Data Domains.ddm/Data Domains/Quantity Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Hours PTO Qty

Label	PTO Hours
Description	Total Paid Hours – Total Worked Hours
Data Type	Standards - Data Domains.ddm/Data Domains/Quantity Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Hours Regular Qty

Label	Regular Hours
Description	Sum of Regular Hours (from raw data)
Data Type	Standards - Data Domains.ddm/Data Domains/Quantity Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Hours Sick Qty

Label	Sick Hours
Description	Sum of Sick Hours (from raw data)
Data Type	Standards - Data Domains.ddm/Data Domains/Quantity Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Hours Support Qty

Label	Support
Description	Support Skill Mix Actual Percent x Actual Paid FTE for the department. Skill Mix Actual Percent= Paid Hours for Skill/ Paid Hours for Department. Actual Paid FTE = Actual Paid Hours/(Hours per FTE x Days in Period). Actual Paid Hours = Regular Hours + Overtime Hours + Education Hours + Orientation Hours + Agency Hours + Other Worked Hours + Sick Hours + Vacation Hours + Holiday Hours + Other Benefit Hours. 10). Support = Support Skill Mix Actual Percent x Actual Paid FTE for the department. Skill Mix Actual Percent= Paid Hours for Skill/ Paid Hours for Department. Actual Paid FTE = Actual Paid Hours/ (Hours per FTE x Days in Period). Actual Paid Hours = Regular Hours + Overtime Hours + Education Hours + Orientation Hours + Agency Hours + Other Worked Hours + Sick Hours + Vacation Hours + Holiday Hours + Other Benefit Hours.
Data Type	Standards - Data Domains.ddm/Data Domains/Quantity Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Hours Technical Qty

Label	Technical
Description	Technical Skill Mix Actual Percent x Actual Paid FTE for the department. Skill Mix Actual Percent= Paid Hours for Skill/ Paid Hours for Department. Actual Paid FTE = Actual Paid Hours/ (Hours per FTE x Days in Period). Actual Paid Hours = Regular Hours + Overtime Hours + Education Hours + Orientation Hours + Agency Hours + Other Worked Hours + Sick Hours + Vacation Hours + Holiday Hours + Other Benefit Hours.
Data Type	Standards - Data Domains.ddm/Data Domains/Quantity Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Hours Total Paid Qty

Label	Total Paid Hours
Description	Regular Hours + Overtime Hours + Education Hours + Orientation Hours + Agency Hours + Other Worked Hours + Sick Hours + Vacation Hours + Holiday Hours + Other Benefit Hours
Data Type	Standards - Data Domains.ddm/Data Domains/Quantity Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Hours Vacation Qty

Label	Vacation Hours
Description	Sum of Vacation Hours (from raw data)
Data Type	Standards - Data Domains.ddm/Data Domains/Quantity Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Job Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	true
Is Required	true
Is Derived	false
Is Surrogate Key	false

---

 Labor Expense Index Rt

Label	Labor Expense Index
Description	Target Labor Expense / Actual Paid Labor Expense. For multiple departments, sum target expense for all departments and divide by the sum of actual expense for all departments; exclude departments that are "Exclude from Rollup" in department definitions
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Labor Expense Per Unit Actual Rt

Label	Labor Expense per Unit: Actual
Description	Actual Paid Labor Expense / Actual Volume for Key Volume. Actual Paid Labor Expense = Regular Exp + OT Exp + Education Exp + Orientation Exp + Agency Exp + Other Worked + Sick Exp + Hol Exp + Vac Exp + Other Benefit Exp (+ Bonus Exp if set to include in System options).
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Labor Expense Per Unit for Key Volume Rt

Label	Labor Expense Per Unit for Key Volume
Description	Actual Paid Labor Expense / Actual Volume
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Labor Expense Per Unit Rt

Label	Labor Expense per Unit
Description	Target Labor Expense / Actual Paid Labor. Expense Target Labor Expense = Target LEpU x Key Volume Actual Paid Labor Expense = Regular Exp + OT Exp + Education Exp + Orientation Exp + Agency Exp + Other Worked + Sick Exp + Hol Exp + Vac Exp + Other Benefit Exp (+ Bonus Exp if set to include in System options)
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Labor Expense Per Unit Target Rt

Label	Labor Expense per Unit: Target
Description	Target Labor Expense / Actual Key Volume. Target Labor Expense = Target LEpU x Key Volume.
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Labor Expense Variance Amt

Label	Labor Expense Variance
Description	Actual Labor Expense – Target Labor Expense
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Labor Expense Variance versus Target Num

Label	Labor Expense Variance versus Target
Description	Actual Labor Expense – Target Labor Expense
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal Small [DECIMAL(5,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Measure Definition Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	true
Is Required	true
Is Derived	false
Is Surrogate Key	false

---

 Mix FTE Actual Num

Label	Actual Mix FTE
Description	Skill Mix Actual Percent x Actual Paid FTE for the department
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal Small [DECIMAL(5,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Mix FTE Target Num

Label	Target Mix FTE
Description	Skill Mix Target Percent x Actual Paid FTE for the department
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal Small [DECIMAL(5,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Overtime Dollars Variance Rt

Label	Overtime Dollars Variance
Description	If neither overtime hours nor overtime expense is 0, then the application uses the following calculation: = (Overtime Hours – Overtime Target Hours) x Overtime Average Rate. If either overtime hours or overtime expense is 0, the application uses the following calculation: =(Overtime Hours – Overtime Target Hours) x Average Job Code Rate x 1.5. Target Overtime Hours = Target Overtime% x Actual Paid Hours. Actual Paid Hours = Regular Hours + Overtime Hours + Education Hours + Orientation Hours + Agency Hours + Other Worked Hours + Sick Hours + Vacation Hours + Holiday Hours + Other Benefit Hours. Average Job Code Rate = Paid Expense for the job code/ Paid Hours for the Job Code. Actual Paid Labor Expense = Regular Exp + OT Exp + Education Exp + Orientation Exp + Agency Exp + Other Worked + Sick Exp + Hol Exp + Vac Exp + Other Benefit Exp (+ Bonus Exp if set to include in System options.
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Overtime FTE Variance Rt

Label	Overtime FTE Variance
Description	Actual Overtime Hours – Target Overtime Hours) / (Hours per FTE/ 365 x Days in Period). Target Overtime Hours = Target Overtime% x Actual Paid Hours. Actual Paid Hours = Regular Hours + Overtime Hours + Education Hours + Orientation Hours + Agency Hours + Other Worked Hours + Sick Hours + Vacation Hours + Holiday Hours + Other Benefit Hours. Hours per FTE is a system option set by the facility.
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Overtime Hours Qty

Label	Overtime Hours
Description	Sum of Overtime Hours (from raw data)
Data Type	Standards - Data Domains.ddm/Data Domains/Quantity Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Overtime Hours Variance Qty

Label	Overtime Hours Variance
Description	Actual Overtime Hours – Target Overtime Hours
Data Type	Standards - Data Domains.ddm/Data Domains/Quantity Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Overtime Percent Rt

Label	Overtime Percent
Description	Sum of Overtime Hours/ Sum of Actual Paid Hours. Overtime Hours = Sum of OT Hours (from raw data) Actual Paid Hours = Regular Hours + Overtime Hours + Education Hours + Orientation Hours + Agency Hours + Other Worked Hours + Sick Hours + Vacation Hours + Holiday Hours + Other Benefit Hours.
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Paid Hours per Unit Actual Rt

Label	Paid Hours per Unit: Actual
Description	Actual Paid Hours / Actual Key Volume Actual Paid Hours = Regular Hours + Overtime Hours + Education Hours + Orientation Hours + Agency Hours + Other Worked Hours + Sick Hours + Vacation Hours + Holiday Hours + Other Benefit Hours
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Paid Hours per Unit Target Rt

Label	Paid Hours per Unit: Target
Description	Average (Target Paid Hours) / Average (Key Volume). Target Paid Hours = PHpU x Key Volume.
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Period Labor Expense Index Rt

Label	Period Labor Expense Index
Description	Target Labor Expense / Actual Paid Labor
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Practitioner Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	true
Is Required	true
Is Derived	false
Is Surrogate Key	false

---

 Productivity Index Rt

Label	Productivity Index
Description	Sum(Target Worked Hours)/ (Actual Worked Hours)
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Productivity Rt

Label	Productivity
Description	Sum(Target Worked Hours)/ (Actual Worked Hours). Target Worked Hours = WHpU x Key Volume. Actual Worked Hours = Regular Hours + Overtime Hours + Education Hours + Orientation Hours + Agency Hours + Other Worked Hours
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 PTO Percent Rt

Label	PTO Percent
Description	Total Paid Hours – Total Worked Hours / Total Paid Hours
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Skill Mix Actual Percent Rt

Label	Skill Mix Actual Percent
Description	For Department Job Code Category = Paid Hours for Skill/ Paid Hours for Department.
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Skill Mix Difference Num

Label	Difference
Description	Actual Mix Percentage – Target Mix Percentage
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal Small [DECIMAL(5,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Skill Mix Dollar Variance Rt

Label	Skill Mix Dollar Variance
Description	For Department Job Code Category, one of the following calculations: If actual expense and hours exist for the skill then: (Paid Hours by Job Code category / Paid Hours for the department – Target Percent for the Job Code category) x Paid Expense by Job Code Category / Paid Hours by Job Code Category x Paid Hours for the department. If expense or hours do not exist for the Job Code category and Target percent is defined for the job code category then: (Paid Hours by Job Code category / Paid Hours by Department – Target Percent for the Job Code category) x Paid Expense for the Department. For Department Level Aggregation: 1) Use one of the above calculations. 2) Repeat the above calculation for all the Job Code categories. 3) Sum for all the Job Code categories in the department. Paid Hours for the department = Regular Hours + Overtime Hours + Education Hours + Orientation Hours + Agency Hours + Other Worked Hours + Sick Hours + Vacation Hours + Holiday Hours + Other Benefit Hours. Paid Labor Expense for the department = Regular Exp + OT Exp + Education Exp + Orientation Exp + Agency Exp + Other Worked + Sick Exp + Hol Exp + Vac Exp + Other Benefit Exp (+ Bonus Exp if set to include in System options)
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Variance Budget Rt

Label	Budget Variance
Description	Budget Worked FTE – Actual Worked FTE. Budget Worked FTE = Budget Worked Hours / (Hours per FTE / 365 x Days in Period). Actual FTE = Actual Worked Hours / (Hours per FTE / 365 x Days in Period). Actual Worked Hours = Regular Hours + Overtime Hours + Education Hours + Orientation Hours + Agency Hours + Other Worked Hours.
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Variance FTE Rt

Description	(Actual FTE – (Greater ( Minimum Staffing FTE, Target Worked FTE)/FTE Ratio). Actual FTE = Actual Worked Hours / (Hours per FTE / 365 x Days in Period). Target Worked FTE = Target Worked Hours / (Hours per FTE / 365 x Days in Period) FTE Ratio = Facility Hours per FTEx Number of Days / 365.
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Variance Total Dollar Rt

Label	Total Dollar Variance
Description	Actual Labor Expense – Target Labor Expense. Actual Paid Labor Expense = Regular Exp + OT Exp + Education Exp + Orientation Exp + Agency Exp + Other Worked + Sick Exp + Hol Exp + Vac Exp + Other Benefit Exp (+ Bonus Exp if set to include in System options). Target Labor Expense = Target LEpU x Key Volume
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Volume Num

Label	Volume
Description	Volume for the pay period (from raw data)
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal Small [DECIMAL(5,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Worked FTE Actual Rt

Label	Actual Worked FTE
Description	Actual Worked Hours / (Hours per FTE/ 365 x Days in Period). Actual Worked Hours = Regular Hours + Overtime Hours + Education Hours + Orientation Hours + Agency Hours + Other Worked Hours. Hours per FTE is a system option set by the facility.
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Worked FTE Budget Rt

Label	Budget Worked FTE
Description	Budget Worked Hours (from import file) / (Hours per FTE/ 365 x Days in Period). Hours per FTE is a system option set by the facility.
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Worked FTE Rt

Label	Worked FTE
Description	Actual Worked Hours / (Hours per FTE/ 365 x Days in Period)
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Worked FTE Target Fixed Rt

Label	Target Worked FTE: Fixed
Description	Target Fixed Worked Hours/ (Hours per FTE/ 365 x Days in Period)
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Worked FTE Target Rt

Label	Target Worked FTE
Description	Greater (Minimum Staffing Hours, Target Worked Hours)/ FTE Ratio. Minimum Staffing Hours = Department Minimum Staffing Hours x FTE Ratio. Target Worked Hours = WHpU x Key Volume FTE Ratio= Facility Hours per FTE x Number of Days/365
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Worked FTE Target Variable Rt

Label	Target Worked FTE: Variable
Description	Target Variable Worked Hours/ (Hours per FTE/ 365 x Days in Period)
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Worked FTE Variance versus Target Rt

Label	Worked FTE Variance versus Target
Description	(Actual FTE – (Greater ( Minimum Staffing FTE, Target Worked FTE)/FTE Ratio)
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Worked Hours Other Qty

Label	Other Worked Hours
Description	Sum of Other Worked Hours (from raw data)
Data Type	Standards - Data Domains.ddm/Data Domains/Quantity Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Worked Hours Per Day Actual Rt

Label	Actual Worked Hours per Day
Description	Actual Worked Hours / Days in Period
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Worked Hours Per Day Target Fixed Rt

Label	Target Fixed Worked Hours per Day
Description	Target Fixed Worked Hours / Days in Period
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Worked Hours Per Day Target Rt

Label	Target Worked Hours per Day
Description	Target Worked Hours / Days in Period
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Worked Hours Per Day Target Variable Rt

Label	Target Variable Worked Hours per Day
Description	Target Variable Worked Hours / Days in Period
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Worked Hours Per Unit Actual Rt

Label	Actual Worked Hours per Unit
Description	Actual Worked Hours / Actual Key Volume
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Worked Hours per Unit Rt

Label	Worked Hours per Unit
Description	Actual Worked Hours / Actual Key Volume
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Worked Hours per Unit Target Rt

Label	Target Worked Hours per Unit
Description	Actual Paid Hours / Actual Key Volume. Actual Paid Hours = Regular Hours + Overtime Hours + Education Hours + Orientation Hours + Agency Hours + Other Worked Hours + Sick Hours + Vacation Hours + Holiday Hours + Other Benefit Hours.
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Worked Hours Qty

Label	Worked Hours
Description	Regular Hours + Overtime Hours + Education Hours + Orientation Hours + Agency Hours + Other Worked Hours
Data Type	Standards - Data Domains.ddm/Data Domains/Quantity Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

---

 Worked Hours Total Qty

Label	Total Worked Hours
Description	Regular Hours + Overtime Hours + Education Hours + Orientation Hours + Agency Hours + Other Worked Hours
Data Type	Standards - Data Domains.ddm/Data Domains/Quantity Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	true
Is Surrogate Key	false

Relationship Details

 Labor Productivity Analysis_Measure Dimension_FK

Is Identifying Relationship	true
Child Table	Labor Productivity Analysis
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Measure Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

---

 Labor Productivity Analysis_Account Dimension_FK

Is Identifying Relationship	true
Child Table	Labor Productivity Analysis
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Account Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

---

 Labor Productivity Analysis_Practitioner Dimension_FK

Is Identifying Relationship	true
Child Table	Labor Productivity Analysis
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Practitioner Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

---

 Labor Productivity Analysis_Job Dimension_FK

Is Identifying Relationship	true
Child Table	Labor Productivity Analysis
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Job Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Primary Key Details

 Labor Productivity Analysis PK

Key Attribute	Account Dk
Key Attribute	Practitioner Dk
Key Attribute	Measure Definition Dk
Key Attribute	Job Dk

---

Overview Top Package Entity

Dimensional Warehouse Model Data Model