Human Resources

Human Resources

Human Resources

site header

QU_HR_DATA_JOB_ALL

Description

Select all current and historical employee job records 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.

Criteria

  • Include current and historical (Effective dated) 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_ALL
  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