While the majority of Employee Services staff will work remotely to do our part to reduce community spread of the COVID-19 virus, our services will continue without interruption. We're dedicated to providing excellent service to every CU employee and every HCM user. You can still reach us by phone or email. If you have questions or need assistance, reach out at firstname.lastname@example.org or 303-860-4200, option 2.
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.
HCM Data Dictionary
This dictionary provides a list of trusted HCM records that can be used to build PS Query reports.
(Click to expand to full size.)
Step-by-step: Reviewing a Training Summary
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
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
CU Careers Reports
Step-by-step: Working with Reports in CU Careers
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:
- Report an Issue with an Existing Report or Query
- Request a Modification to an Existing Report or Query
- Request Development of a New Report or Query *
*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|
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