Peopletools update go live November 7, 2020
In last week's communication we sent out a request to run a query to check if any staff have assigned schedules that are anything other than a zero schedule. The request is to update assigned schedules to a zero schedule if any non-zero schedule is assigned and the “apply schedule” function on the timesheet page is not being used. Doing this will prevent any issues as we continue our work on rules using schedules for punch and web clock users. If you find that no schedule is listed then no action is required. This is the same as having a zero schedule assigned.
As a reminder, run the MTL_SCHEDHRS_BY_GROUP query to see Assigned Schedules for staff in a static group.
Here are the actions to take:
- Assigned Schedules are currently used by the department and accurate -or- Assigned Schedules are not used by the department and zero or no schedule is already assigned: There is nothing further for you to do.
A non-zero schedule is assigned but not being used by the department: You will need to update the Assigned Schedule to a Zero Hours, or D00000 Assigned Schedule. If you’re not sure how to do this, see instructions in last week's communication.
Auditing for OTP Created by the Overtime Rules
It is very important that all departments run the queries below to ensure that the Overtime Rules are not creating overtime for anyone that was not reported in the timesheet. If any staff show up on the query it is required that corrections be made on the timesheet to reflect accurate reported time.
Updated contact resources
The following contact lists have been updated to reflect additional resources available with the MMHR Solutions Center. Please make yourself familiar with these resources and share with supervisors and staff.
Who to Contact for Timekeepers & Supervisors
Identify overtime (OTP) created by rule for a particular pay period, by employee, static group, or department ID.
MTL_PAYABLE_RULEOT_EMP
MTL_PAYABLE_RULEOT_GRP
MTL_PAYABLE_RULEOT_DEPT
You can find the entire list of queries that should be run before payroll runs here.
Running all of these queries and reacting to them before payroll runs will greatly reduce the chances that your staff will be paid incorrectly. It also ensures compliance with the Payroll Controls Standard Practice Guide.
Auditing COVID Banks
It is important that departments continue to monitor and audit the use of COVID time off banks. Some data has now been archived and will require the use of “ODS” queries to gather all the data to audit for COVID PTO bank use. The ODS_MTL_PYBL_TIME_GRP_ARC_DUR query can be used as a substitute. You will need to filter out codes that you do not need to include.
“Banks” that departments must audit, as there are no actual banks in the system to keep track:
- COVID-19 80 hour (prorated by FTE) bank (RPN, RSP)
- Emergency Paid Sick Leave 80 hour (prorated by FTE) bank (PEL, PSP)
- Expanded FMLA up to 10 weeks (prorated by FTE) (PFL)
- Patient Care 120 hour (prorated by FTE) bank (PCP)
There are over 300 employees who have overused one or more of the COVID banks currently. A message will be sent with an attached list to each Time Report Recipient by Department ID in the next couple of days. Please watch for it so you can respond and correct it right away. All of these have to be corrected by the end of the year, otherwise we will risk being out of compliance with Federal regulations. Thank you for your attention to this matter.