Human Resource Respository Query Definitions
This page contains links to Excel files that describe the HR queries.
| Query Name | Description |
|---|---|
| HR-Dept Emps Current Job Data | An extract of job data for all current employees within a department. |
| HR-Employee Department Labels | Listing of current employees and their department. This is to be used for business purposes only. Can be exported into Excel for mail merge. This query will only extract employees in your department whose primary department is one you have access to. |
| HR-Employee Job History | List of job transactions by employee (historical, current, and future). |
| HR-Emps Home Address Labels | Mailing address labels. List of various salutations for employees and their mailing address. This is to be used for business purposes only. Can be exported into Excel for mail merge. This query will only extract employees in your department whose primary department is one you have access to. |
| HR-Expiring Appointments | Query should be run monthly to identify expiring Staff and Management appointments. When prompted for the "Expected End Date" limit, enter begin and end dates of next month's pay period. Department follow-up procedures are necessary to continue or terminate pay. |
| HR-Positions by Department | List of all positions within a department. |