J.D. Wetsel Building
1225 W. Mitchell St., Suite 212
Box 19176, Arlington, TX 76019
Phone: 817-272-5554 - Fax: 817-272-7288
QUICK LINKS
Forms >
HR Information Systems
Data Queries
Data queries are requests used to retrieve specific information from the UTShare system based on defined criteria and can be used to generate reports and analyze data.
Employees with appropriate UTShare access based on their position (typically Level III access with job data visibility) may run the following HRMS queries. These queries are not available to all users; however, they can provide helpful information to assist departments with reviewing time, leave balances, and outstanding items prior to payroll deadlines.
To access the Query Viewer, select the NavBar (compass icon in the upper-right corner) and follow the navigation path:
Menu > HRMS > Reporting Tools > Query > Query Viewer
| Query | Description |
|---|---|
| UTA_TL_RPTD_TIME_UPDATED | Displays detailed reported time entries including the exact clock in and clock out punches recorded for employees and the current approval status of each entry. Use Reporter Type: Punch Time Reporter when running the query. Results can be filtered by Employee ID or Department ID. |
| UTA_TL_RPTD_TIME_UPDATED_SUM | Displays a daily summary of total hours reported from punch activity along with the approval status of the reported time. Individual punches are summarized into a daily total. Use Reporter Type: Punch Time Reporter when running the query. Results can be filtered by Employee ID or Department ID. |
| UTA_TL_MISSING_TIMESHEETS_DEPT | Identifies employees who have not reported any time for a specified workweek within the selected department. This query assists with identifying missing timesheets before payroll processing. |
|
UTA_TIMESHEET_PENDING_APPROVAL ***only shows ID, requested this to be updated |
Displays timesheets that contain reported time awaiting Manager approval. This query helps identify employees whose reported time has been submitted but has not yet been approved for payroll processing. |
| UTZ_AUDIT_TLRPTTIME | Provides an audit history of reported time activity for a specific employee over a selected time frame, including changes made to reported time entries. |
| UTA_PY_COMP_BAL_AUDIT | Displays a point-in-time audit of Compensatory Time balances, including Overtime Comp and Straight Comp, for employees. |
| UTZ_HA_VAC_SICK_LEAVE_BAL_DEPT | Displays State Service, Vacation Entitlement, Vacation Balance, and Sick Leave Balance for employees within the selected department. The query returns leave balance and accrual information for the specified Calendar Group and Department. When running the query, all required fields must be completed: Company (CO) = ARL, Calendar Group, and Department ID. This information reflects the balance as of the last time the absence process was run. |
| UTA_MONTHLY_ACCRLS | Displays the monthly leave accrual amounts for Sick and Vacation for employees within the selected department. The query returns accrual information for the specified Calendar Group and department. When running the query, all required fields must be completed: Company (CO) = ARL, Calendar Group, and Department ID. |
