Human Resources

Human Resources

Human Resources

site header



Select current employee jobs that exist in PeopleSoft. This query can be joined with any QU_HR_DATA query by using the Vlookup function on the Key field in Excel.


  • Include current (Effective dated) active employee records
  • Start Date is the first date the employee was in a Job, Position, or Department 
  • Job End Date is the Expected Job End date of an active job, or the date the job was terminated
  • Limited to PeopleSoft department access

Running the Query

  1. Navigation: Reporting Tools > Query > Query Viewer > Search by Name Begins with QU_HR_DATA_JOB_CURR_ACTIVE
  2. Run the report to HTML
  3. Download the results as CSV TextFile
  4. The results should be imported into a spreadsheet allowing the user to filter on specific fields.


Return to  HR Production Queries