QU_HR_DATA_JOB_ALL_ROWS
Description
Select all 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 all current and historical (Effective dated and sequenced) employee records
- Limited to PeopleSoft department access
Running the Query
- Navigation:Reporting Tools > Query > Query Viewer > Search by Name Begins with QU_HR_DATA_JOB_ALL_ROWS
- Run the report to HTML
- In addition to the criteria above, this query uses a prompts
- From Date and To Date (mandatory) - Users with access to larger groups of employees may be required to split this query into multiple date ranges in order to retrieve all results. e.g. From Date 1901-01-01 To Date 2012-12-31 and From Date 2013-01-01 To Date 2014-12-31
- DeptID - Wildcards can be entered for this prompt
- to display all results enter %,
- to display a single department enter the 5 digit Department ID (e.g. 50010),
- to display all departments within a Faculty/VP Office enter the first 2 digits followed by the wildcard symbol (e.g. 11%)
- EmplID - Wildcards can be entered for this prompt
- to display all results enter %,
- to display a single employee enter the 8 digit Employee ID (e.g. 07425685)
- 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