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.”

CUES_HCM_EVERIFY_PROJ – E-Verify Needed

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.

CUES_HCM_LOCATION_CODES – Location codes

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 hcm_community@cu.edu with the subject line “Update location.”

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