Each year, hundreds of employees risk losing vacation leave hours in excess of CU’s carryover limits. To help your employees schedule time off ahead of the June 30 deadline, HCM users are encouraged to review and adjust leave balances in the spring.

Providing accurate leave balances early in the year empowers employees to know exactly how many hours they need to take. It also allows you to provide advance notice to their supervisors and teams, so departments continue to run smoothly.

Review employee leave usage and reconcile balances with these queries:

• Leave Accrual Summary (CUES_HCM_LEAVE_ACCRUAL_SUM): This query reflects the Summary tab within the CU Leave Accrual Summary page.
• Leave Accrual Detail (CUES_HCM_LEAVE_ACCRUAL_DTL): This query pulls information from the CU Leave Accrual Summary page’s Detail tab for individual employees.
• Leave Taken (CUES_HCM_LEAVE_TAKEN): This query provides leave hours that have been processed by payroll, giving you the ability to compare third-party/off-line timekeeping entries with uploads.
• My Leave Calendar View (CUES_HCM_MY_LEAVE_CALENDAR): This query returns detailed information about My Leave requests shown on the calendar view, excluding holidays, giving you the ability to compare and determine if all calendar events are reflected in the HCM Leave Accrual balance.
• Leave Sweep Forecast (CUES_HCM_LEAVE_SWEEP_FORECAST): This query is a long-range forecast that returns a best guess on future leave balances based on currently available information. This query is appropriate to run until late May, after which a short-range forecasting query will be made available.  
• Leave Sweep FY2024 (CUES_HCM_Leave_SWEEP_FY24): This query is intended to be run in May and June only and returns current leave sweep and leave adjustment calculations for each benefit record belonging to currently active employees as of the most recent Leave Accrual Process date. It will not provide actual hard-data Leave Sweep values before the June Leave Accrual Process date.
  • Please note: This query returns a large volume of information. Use the Process Scheduler if running by node or for a large department.

How to access the queries

1. Log into the employee portal.
2. Open the CU Resources Home dropdown menu and click Business Tools.
3. Select the HCM tile and choose HCM Community Users from the drop-down menu.
4. Click the HCM WorkCenter tile.
5. Choose the Resources tab.

Need a refresher on running queries? Instructions are available.

Step-by-step guides, job aids and resources are available on the HCM Community Website.