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

1. Navigation:Reporting Tools > Query > Query Viewer > Search by Name Begins with QU_HR_DATA_JOB_ALL_ROWS
2. Run the report to HTML
3. In addition to the criteria above, this query uses a prompts
   
   
   1. 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

   
   

   2. 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%)
   3. 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)
4. Download the results as CSV TextFile
5. The results should be imported into a spreadsheet allowing the user to filter on specific fields.

Return to HR Production Queries