Human Resources

Human Resources

Human Resources

site header

QU_HR_DATA_BIOGRAPHIC

Description

Select employee biographic details including a summary of all current and historical employee job records held by the employee. This query can be joined with the results of any QU_HR_DATA query by using the Vlookup function on the Employee ID field in Excel.

Criteria

  • Include only the current (Effective Dated) employee record
  • Limited to PeopleSoft department access

Running the Query

  1. Navigation: Reporting Tools > Query > Query Viewer > Search by Name Begins with QU_HR_DATA_BIOGRAPHIC
  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