Public Query - Reported vs Standard Hours

Overview

MTL_RPTD_TIME_VS_STDHRS_BW is a public query that was created to help timekeepers prevent under/over-reporting, and possibly over-paying, a biweekly employee's hours. This query does not work for Punch Time departments.

This query compares the hours reported for an employee against the standard number of hours in the employee's Job Data. If there is a positive variance, the hours are over-reported. If there is a negative variance, the hours are under-reported.

How Reported Hours Are Calculated:

• Hours included = Regular (REG) hours, plus the following:
  • Hours that reduce REG hours without reducing pay (e.g., sick, vacation, PTO, Jury Duty).
  • Hours that reduce REG hours and reduce pay (e.g., Excused time without pay, Unexcused
    Time).
• Hours NOT included = Any hours that add to pay or leave balances (Overtime, Overtime Added to PTO, Holiday 1.5 Rate).

How Standard Hours Are Calculated:

• Standard Hours (for one week) in Job Data times two.
• Note: The standard hours used are those effective in Job Data as of the pay period end date.

Range of Dates:

• For accurate variance results, you must run this query for a complete biweekly pay period. If you run the query for a partial pay period or for more than one pay period, the variance results will be inaccurate.
• Note: The query results will not be accurate for employees who had a mid-pay period effort change.

Examples

1. Mollie Pstrain has a job with 40 Standard Hours per week. During the pay period ending August 25, 2007, Mollie had the following number of reported hours.
   • 48 REG – Regular pay
   • 24 VAC – Vacation Pay
   The MTL_RPTD_TIME_VS_STDHRS_BW query will display:
   • 72 Reported Hours (48 REG + 24 VAC)
   • 80 Standard Hours (40 Standard Hours times 2 weeks)
   • -8 Variance, under-reported by 8 hours
   Mollie will be paid the 80 standard hours on Job Data. Therefore, she is being paid for 8 hours more than were reported.


2. Jorge Pstrain has a job with 40 Standard Hours per week. During the pay period ending August 25, 2007, Jorge had the following number of reported hours.
   • 72 REG – Regular pay
   • 16 PTU – Unscheduled Paid Time Off
   The MTL_RPTD_TIME_VS_STDHRS_BW query will display:
   • 88 Reported Hours (72 REG + 16 PTU)
   • 80 Standard Hours (40 Standard Hours times 2 weeks)
   • 8 Variance, Over-reported by 8 hours
   Jorge will be paid the 80 standard hours on Job Data. Because he is a Hospital non-exempt employee, he is being under-paid by 8 hours. If Jorge was a Service Maintenance (AFSCME bargained for) employee or Campus non-exempt employee, the 8 over-reported hours would be converted to 8 OTP, Overtime at 1.5 pay.

Navigation

NavBar > Navigator > Reporting Tools > Query > Query Manager > MTL_RPTD_TIME_VS_STDHRS_BW

This query does not work for Punch Time departments.

Letter	Field/Button	Description
A	Group ID	The ID number of the Static Group.
B	DUR Begin Date	This must be the first day of the biweekly pay period.
C	DUR End Date	This must be the last day of the biweekly pay period.
D	Sum of Hrs Rptd	The total number of regular (REG) hours plus any hours that reduce REG hours.
E	Biweekly Std Hrs	The number of weekly Standard Hours on Job Data times 2 weeks.
F	Variance from BW Std Hrs	The Biweekly Std Hrs minus the Sum of Hrs Rptd. A positive variance indicates that you have over-reported hours. A negative balance indicates you have under-reported hours.