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
>
>
>
HR Information Systems
糖心Vlog视频
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鈥攖ypically Level III access with job data visibility鈥攎ay 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鈥攖he compass icon in the upper-right corner鈥攁nd follow this navigation path:
Menu > HRMS > Reporting Tools > Query > Query Viewer
| Query | Description |
|---|---|
| 糖心Vlog视频_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. |
| 糖心Vlog视频_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. |
| 糖心Vlog视频_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. |
| 糖心Vlog视频_TIMESHEET_PENDING_APPROVAL Note: This query currently shows only the employee ID. An update has been requested. | 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. |
| 糖心Vlog视频_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. |
| 糖心Vlog视频_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. |
Request Access
Don't have the access you need? Request access below.