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.”
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 email@example.com with the subject line “Update location.”