Cube: Employee Pay

Use this cube to report on pay items for your employees once they have been processed through payroll. You can also draw on the following dimensions to add detail to your report: 

Branch, Branch rollback, Cancel Code, Client, Client Cost Centre, Client Name, Employee, Employee Cost Centre, Employee Name, Facility, Funder, Pay code, Pay code overtime, Pay code holiday, Payroll Run, Service, Service Codes

Fields

• Employee Pay ID: the ID of the payroll item
• Quantity Reg Units: visit, hour, or amount according to the pay code
• Employee Pay Type Detail
• Employee Pay Type: calculated_premium, daily_premium, regular, shift_premium, or time_off
• Visit Approval Status
• Visit ID
• Visit Bill Override NULL
• Visit Pay Override NULL

Start and end dates for visits, visit premiums, calculated premiums:

• Visit Start Year
• Visit Start Month
• Visit Start Week
• Visit Start Day: for Visits, Visit Premiums, and Calculated Premiums
• Visit End Year
• Visit End Month
• Visit End Day
• Visit Start Time
• Visit End Time
• Date Year: same as Visit Start Year
• Date Month: same as Visit Start Month
• Date Day: same as Visit Start Day

Payroll period dates:

• Payroll Period Start Year
• Payroll Period Start Month
• Payroll Period Start Day
• Payroll Period End Year
• Payroll Period End Month
• Payroll Period End Day

Measures

• Employee Distinct Count
• Employee Pay Hours Reg. Sum
• Employee Pay Hours Ot. Sum
• Employee Pay Hours Holiday Sum
• Employee Quantity Reg. Sum: sum of payroll items
• Visit Distinct Count
• Visit Approved Hours Sum
• Visit Scheduled Hours Sum
• Visit Overtime Pay Rate Sum: the rate of the pay code for a overtime visit
• Visit Regular Pay Rate Sum: the rate of the pay code for a regular visit
• Visit Holiday Pay Rate Sum: the rate of the pay code for a holiday visit
• Visit Regular Pay Rate Total Sum: the total payable amount for a visit, ie, quantity multiplied by pay code.
• Visit Overtime Pay Rate Total Sum: the total payable amount for a visit, ie, quantity multiplied by pay code.
• Visit Holiday Pay Rate Total Sum: the total payable amount for a visit, ie, quantity multiplied by pay code.
• Visit Rate Sum: the rate of a calculated premium multiplied by quantity
• Override Bill Sum: the bill override quantity for a visit
• Override Pay Sum: the pay override quantity for a visit