Human Resources

Human Resources

Human Resources

site header

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