New tools make reports more robust and easier to run.

HCM WorkCenters organize frequently used reports and queries under the "HCM User Resources" tab or in the main menu under "Reporting Tools." You can also "save" common queries and reports in favorites lists, similar to bookmarks on an Internet browser.  You'll have better tools at your disposal, too:

  • Cognos pulls data from HCM, the Central Information Warehouse and Finance to provide snapshots of data trends over time.
  • PS Query allows you to find existing queries or build your own, pulling real-time data from HCM.
  • PeopleSoft Reports uses complex logic to generate dozens of built-in and configured reports.

If you find the existing reports and queries not helpful, please give your feedback through one of the available web forms below to help us better meet your needs.


CU Careers Reports

Step-by-step: Working with Reports in CU Careers 

Training video: CU Careers Reporting 


HCM Reports

Step-by-step: Comprehensive Learning Report

Step-by-step: Creating and Modifying Queries

Step-by-step: Running Queries

Step-by-step: Uploading Course Completion Data

Training video: Reporting 


Common Queries and Reports

 Job List Query: CUES_HCM_JOB_LIST

 Payroll Register Account Detail: CUES_HCM_PAYROLL_REGISTER_DTL

Payroll Register Summary: CUES_HCM_PAYROLL_REGISTER_SUM

 Payroll Register: CUES_HCM_PAYROLL_REGISTER

Leave Accruals: CUES_HCM_LEAVE_ACCRUALS

Leave Balances: CUES_HCM_LEAVE_BALANCES

 Annual Leave Certification: CUES_HCM_ANNUAL_LV_CERT

Leave Sweep: CUES_HCM_LEAVE_SWEEP

Not finding what you are looking for?

We are always looking for new ways to improve our reports and queries. If you have any feedback, please fill out one of our available web forms:

*Custom reports and queries can take significant time and/or resources. Before requesting a custom report or query, please review the existing queries already available on the CU HCM User WorkCenter. Often, an existing query will meet your needs.

Which tool should I use?

Each tool has a few advantages and disadvantages. 

  Cognos PeopleSoft Reports PS Query
Advantages
  • Pulls in data from CU-SIS, FIN and HCM
  • 15 years of data available
  • Scheduling and distribution is available
  • Uses real-time data
  • Complex logic
  • Many reports will be available on Day 1
  • Scheduling and distribution is available
  • Uses real-time data
  • Ability to drill-down
  • Can be created by all users
  • Scheduling and distribution is available
Disadvantages
  • Data is one day old
  • Less flexible than PS Query
  • Reports are written by Employee Services staff,
    meaning they are not customized to your specifications.
  • Run through Report Manager
  • Changes to reports require a technical resource
  • Requires an understanding
    of PeopleSoft table structures if creating your own query.

Most queries are available with your basic HCM access. Visit our   HCM Access and Training page for information on how to obtain any additional roles needed for the more secure queries.

CU Careers also features a simpler, user-friendly tool called Oracle Business Intelligence. Use this to access:

  • Internal Candidates
  • Hired Candidates
  • Candidate timeframe in step/status
  • Time posted
  • Posting source
  • Number of candidates per requisition
  • Requisition aging