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