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
- Navigation: Reporting Tools > Query > Query Viewer > Search by Name Begins with QU_HR_DATA_JOB_ALL
- Run the report to HTML
- Download the results as CSV TextFile
- The results should be imported into a spreadsheet allowing the user to filter on specific fields
Return to HR Production Queries