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