Categorized in: 

Are your departments’ leave balances correct? Review, then make adjustments

HCM users are encouraged to reconcile and adjust leave balances before fiscal year end for accuracy.

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, for 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, for the ability to compare and determine if all calendar events are reflected in the HCM Leave Accrual balance.
  • Leave Sweep 2021 (CUES_HCM_LEAVE_SWEEP): This query returns the leave that will be swept as of the most recent payroll.

 Here’s 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.

Add new comment