Tip: Use the "Favorites" link to keep a list of your most used queries.
Each of the most common run options are covered below.
This screen print shows the window opened to Excel with the results of the query.
A wild card allows you to specify a partial string for a field. Wild cards can be helpful in finding all values that match specific patterns in a string. To specify a wild card, type a partial string in the field. The wild card symbol (%) can be placed anywhere in a string. For example, if you are looking for Dept Ids that begin with ‘A48’ then you would enter A48% as a wild card. This would return all values beginning with A48. Such as A480000 or A4800200.
Query Name: UW_TL_EXCEPTION_QUERY
Who: Payroll Coordinators, Supervisors, Service Center
When: During Processing Week (Regularly) and Payroll Week
Description: The output from this query will list exceptions for all employees (problems with an employee’s timecard; for example, not complete) by campus/division.
Prompts/Inputs: Begin Date (Required), End Date (Required), Dept Id (Needs '%' at minimum), Group Id (Needs '%' at minimum), Empl Id (Needs '%' at minimum), Employee Classification (Needs '%' at minimum)
Query Name: UW_TL_DUPLICATE_TIME_QUERY
Who: Payroll Coordinators, Supervisors
When: Pay Processing Week
Description: The query identifies employees with multiple jobs where reported time overlaps for a specific time period for those jobs. PeopleSoft does not include functionality to track time on one timecard for a person with multiple jobs. Therefore, this query will assist in identifying duplicate entries for time reporters who have multiple jobs.
Note: This is a very resource intensive query, running the query with a date range greater than two weeks could cause the query to not run to success or return unreliable data. Best Practice: Limit the date range in query to be one or two weeks at the most.
Prompts/Inputs: From Date, To Date, Dept Id, Employee Classification
Query Name: UW_TL_772_TRPY
Who: Payroll Coordinators, Service Center
When: Payroll Processing Week (Tue-Thu)
Description: This query lists payable time detail that is rejected by Payroll. UW-Service Center, campuses and divisional Time and Labor Administrators will review the output details of this query to assist them in determining the employees whose payable time was rejected by payroll.
Prompts/Inputs: From Date, To Date (Required), Dept Id, Time Group (Group ID), Employee Classification (Optional-for all enter % for each field)
Query Name: UW_TL_773_PSR
Who: Service Center
When: Payroll Processing Week
Description: This query lists all payable time by payable statuses. It will provide managers with a picture of processed and unprocessed time for time reporters with payable time.
Prompts/Inputs: Payable Status, From Date (Required), To Date (Required), Dept Id, Empl Id (Optional-for all enter % for each field)
Description: This query will provide a list of positive time reporters who failed to report time for a specific pay period (Note: date range must be for a payroll period).
Prompts/Inputs: Dept Id, Start Date (required), End Date (required), Group Id, Employee Classification
Results:Query Name: UW_TL_775_RTTRC
Who: Payroll Coordinators, Supervisor
When: Payroll Processing Week
Description: This query provides a list of employee TRC's based on search criteria provided by the user.
Prompts/Inputs: Start Date (Required), End Date, (Required), Dept Id, TRC Code, TRC Category, Group Id, Employee Classification (Optional-for all enter % for each field)
Query Name: UW_TL_776_RTT
Who: STOUT, Athletic, Housing
When: Payroll Processing Week, Ad-Hoc
Description: This query lists payable time by Task ID and TRC for a given date range. The output from this query is for time reporters and employees/units who are utilizing task entities. In Time and Labor, a task represents work assigned to a time reporter, and is represented by a combination of task entities. Task entities, also called task elements, are the specific types of task data you can capture when time is reported: customer, task, product, project, activity, company, combo code, department, business unit, job code, position number, location code, and up to five user-defined categories. Additional task entities are available if you’re using Project Costing with Time and Labor. This query will be used by time reporters and employees/units who are utilizing task entities for verification purposes.
Prompts/Inputs: Dept ID, From Date (Required), To Date (Required), Task Id, Time Group (Group ID), Employee Classification (Optional-for all enter % for each field)
Query Name: UW_TL_777_NAR
Who: Payroll Coordinators, Service Center
When: Payroll Processing Week
Description: This query lists time reporters who have reported time that has not been approved for the given Business Unit/Dept ID, Time Reporter Group ID and Time Period. It looks for reported time with a payable time status of NA (“Needs Approval”). This information is needed because in order for a time reporter (employee) to be paid their time must be approved. The resulting query will assist the UWSS Service Operations and campus/division/department payroll coordinators in managing this task prior to a payroll calculation or confirm.
Prompts/Inputs: Dept ID, From Date (Required), To Date (Required), Group Id, Employee Classification (Optional-for all enter % for each field)
Query Name: UW_TL_APPROVERS_ASSIGNED
Who:Payroll Coordinators, Supervisors
When: Ad-Hoc
Description:This query identifies all employees assigned to a particular approver or backup approver.
Prompts/Inputs: Approver/Backup Empl Id, HR Status, Dept Id
Query Name: UW_TL_APPROVER_DIRECTORY
Who: Payroll Coordinators
When: Ad-Hoc
Description: This query will output names and email addresses of active approvers by department.
Prompts/Inputs: Dept Id
Description: This query will output names and email addresses of active backup approvers by department.
Prompts/Inputs: Dept Id
Results:Description: This query lists comp time balances by department. This will allow departments to monitor and limit compensatory time.
Prompts/Inputs: As of Date, DeptID, Empl Class, Emplid
Description: This query lists employees and the secruity groups they are assigned to.
Prompts/Inputs: Empl Id, Dept Id, Employee Classification & Time Group (Group Id)
Results:
Description: This query lists employees assigned to inactive approvers on the Maintain TL Security page in Time and Labor.
Prompts/Inputs: Business Units, Dept Id, Employee Classification, Time Group (Group Id), Empl Id
Query Name: UW_TL_NO_APPROVERS_ASSGN
Who: Payroll Coordinators, Supervisors
When: Ad-Hoc
Description: This query identifies employees that do not have any approvers assigned to them.
Prompts/Inputs: Dept ID, Empl ID, Employee Classification, As of Date
Query Name: UW_TL_EMPLS_ASSIGNED_TO_PYC
Who: Payroll Coordinators, Supervisors
When: Ad-Hoc
Description: This query identifies all employees (Active and/or Inactive) assigned to a particular payroll coordinator.
Prompts/Inputs: Payroll Coordinator Empl Id, Employee HR Status
Query Name: UW_TL_PYCOORD_DIRECTORY
Who: Payroll Coordinators, Supervisors
When: Ad-Hoc
Description: This query will output names and email addresses of active payroll coordinators by department
Prompts/Inputs: Dept Id
Query Name: UW_TL_SCH_HRS_EXCEED_LGHOL
Who: Payroll Coordinators, Supervisors, Service Center
When: Pay processing week in which a legal holiday occurs
Description: This query identifies employees scheduled for more than 8 hours on a legal holiday. Up to 8 hours of Legal Holiday will be loaded for eligible employees and therefore anyone with a schedule that works more than 8 hours may need to make up the time, use other leave time, or have it unpaid.
Prompts/Inputs: From Date, To Date, Dept Id, Empl Id, Time Group (Group Id), Employee Classification
Description: This query identifies employees in employee class ‘SH’ with time reported on a legal holiday.
Prompts/Inputs: From Date, To Date, Dept Id, Empl Id, Employee Classification, Time Group (Group Id)
Description: The query provides a list of employees and shows their Time Entry method as selected on the TL Security page.
Prompts/Inputs: Dept Id, Employee Classification, Begin Date, End Date, Business Unit
Results:Description: This query identifies employees that do not have any reported time for the specified biweekly pay period. It can be used independently or in conjunction with the Total 80 report.
Prompts/Inputs: Dept Id, Start Date, End Date, Time Group (Group ID), Empl Class
Results:Query Name: UW_TL_DIVISION_CHANGE
Who: Payroll Coordinators
When: Ad Hoc
Description: This query identifies employees who have had a change to their division in job data but have not had a new effective dated row with updated payroll coordinators or approvers added to their TL Security page.
Prompts/Inputs: None. This query is designed to run off of row level security settings.
Query Name: UW_TL_RPTD_TIME_AUDIT
Who: Payroll Coordinators
When: Ad Hoc
Description: This query identifies the audit stamp of who made time entries or changes to an employee's timesheet. Results are returned based on users row level security. If the operator that made the time entry is outside of the query runners row level security audit results will not be visible. Contact your Affinity Group for audit stamp information in these instances.
Prompts/Inputs: Empl ID, Empl Rcd, Start Date, End Date
Audit Action Key: A: Add, K: Change, N: New, D: Delete
Query Name: UW_TL_TIME_NOT_PROC
Who: Payroll Coordinators
When: Ad Hoc
Description: This query shows Reported Time for employees that hasn't yet been processed to Payable Time by Time Admin. The output from this query does not necessarily mean there is a problem or that Time Admin won't process the reported time. The output is only a snapshot of the Reported Time status at the moment the query was run. There is a column entitled 'Action', if the word 'Review' appears in this column, this means that this Reported Time should be monitored more closely and if the time doesn't get processed to Payable Time after the next Time Admin stream has run, contact Service Operations for assistance.
Prompts/Inputs: Campus, Dept ID, Empl Class, Empl ID, Start Date, End Date
Results:
Query Name: UW_TL_STUDENT_REP_REV
Description: This query identifies students that have entered reported time using the quantity field instead of entering IN & OUT punches. It displays the reported quantities of time per day in a given period.
Prompts/Inputs: Dept ID (optional), Empl ID, Start Date, End DateQuery Name: UW_TL_TLSEC_CUR
Description: This query shows the existing TL Security setup for active employees.
The output from this query can be used to assist with verifying a group of employees are correctly setup on their TL Security pages and identifying employees requiring adjustments to their TL Security page. In addition, the output should be included with requests for Shared Services to process mass updates to Approvers on the TL Security page for a group of employees. If Shared Services knows the existing TL Security setup for the employees that a mass update is being requested, it makes the mass update process easier and helps minimize the chance of errors.
Prompts/Inputs: Campus, Department ID (%) & Employee Classification (%)
Results:Query Name: UW_TL_PAY_TIME_APPR_REV
Description: This query shows Payable Time approval history for Employees and/or Approvers.
Prompts/Inputs: Campus, Department ID (%) , Approver, Employee ID, Start and End Date
Results:Query Name: UW_TL_DIFF_SUP_SET
Description: This query lists the Differential Supplement configuration for employees by Campus, by Department ID and Differential Supplement ID. Use this query to identify employees within a specific area that are setup to receive a Differential Supplement.
Prompts/Inputs: Campus, Department ID(%) and Dif Sup ID(%)
Results:Query Name: UW_TL_DIFF_SUP_USAGE
Description: This query lists usage of the Differential Supplement for Employees by Campus and Department for a given date range. Use this query to identify which employees are receiving Differential Supplements for a given period of time.
Prompts/Inputs: Campus, Department ID(%), Employee ID(%) and Date Range
Results: