Categorized in: 

New queries dedicated to E-Verify, earnings codes, location codes

Employee Services recently released three new queries to help with a variety of tasks, including identifying employees who need E-Verification, getting details on earnings codes and looking up campus department location codes.

You can find these queries here: Main Menu > CU HCM User WorkCenter > Resources > Query Manager. Scroll to the bottom of the list and select “Click here for all.”


This query returns a list of active employees who have not been E-Verified but are receiving pay from a project speedtype that requires this verification.

CUES_HCM_EARN_CODES – Earnings codes

This query returns a list of active earnings codes with descriptions and details.


This query returns a list of active location codes with address information. If you notice an incorrect address for your department or others, please email with the subject line “Update location.”

For a refresher on accessing and running queries, check out this step-by-step guide and webinar recording.



Add new comment