Use HCM resources to find FY21 expired funding rows that will send payroll to suspense.

The Funding Suspense Max Row query (CUES_HCM_FUNDING_SUSPENSE_MAX) will return active employees who have a Project End Date, Funding End Date or Budget End Date on their max funding row from the past or up to 45 days in the future. Additionally, results include future effective dated funding rows.

The Funding Suspense Current Row query (CUES_HCM_FUNDING_SUSPENSE) will return active employees who have a Project End Date, Funding End Date or a Budget End Date listed on their current funding row. Likewise, this query provides results from the past or up to 45 days in the future.

Both queries will return:

• Correct Project End Date as shown in Finance.
• Effective Date of the funding row being returned.
• Distribution Amount, calculated by multiplying Comp Rate by Distribution Percent.
• Ability to search fields, or “prompts,” for the following:
  • Campus
  • Dept ID
  • Empl ID
  • Position Nbr 
  • Project ID
  • Combo Code

Access these queries

To access the new and updated queries, follow these steps:

1. Select Main Menu.
2. Choose CU HCM User WorkCenter, then Resources and Query Manager.
3. Scroll to the bottom of the list and select click here for all.

Need a refresher on accessing and running queries? Review this step-by-step guide and webinar recording.