Human Resources

Human Resources

Human Resources

site header

QU_TL_VACATION_RPTD

Description

View reported vacation time for an employee within specified dates. Fields include the date and quantity vacation was reported.

Criteria

  • Include only active employees that have reported vacation time
  • Limited to PeopleSoft department access

Running the Query

  1. Navigation: Reporting Tools > Query > Query Viewer > Search by Name Begins with QU_TL_VACATION_RPTD
  2. In addition to the criteria above, this query uses optional prompts for EmplID, EmplRcd, and Last Name as well as required prompts for Date Range.  
  3. Run the report to HTML or Excel.

Sample Output

Name EmplID EmplRcd DeptID DeptName Rpt Dt  Quantity
Smith, John 01234567 0 12345 Sample Unit 2015-04-01 3.500000
Smith, John 01234567 0 12345 Sample Unit 2015-04-02 7.000000

 Required Security

  • Departmental Timekeeper and Query Viewer

 

Return to  Reports and Queries