HRMS Updates

Attention Time and Labor Payroll Approvers and Time Approvers:
Below is a list of reports that are helpful with maintaining your time reporters and identifying hours that need approval:

TL Hierarchy Report � shows a list of all Time Reporters, Time Approvers, Payroll Approvers, and Unassigned Time Reporters for a business unit, division, college, or department. The report also includes reported hours that need approval by employee.
Navigation: Manager Self Service > Time Management > Time and Labor Reports >
TL Hierarchy Report

TL Reported Time Report � shows a listing of all reported time and time statuses. It can be run by business unit, division, college, department, TL group id, and empl id. The individual date detail option provides leave dates, leave hours, and empl id of approver and date of approval for approved reported time. However, we recommend limiting running the individual detail option to an empl id or small TL group or department, as the report can be lengthy.

Navigation: Manager Self Service > Time Management > Time and Labor Reports >
TL Reported Time Report

TL Payable Time Report � shows a listing of all payable time and time statuses. It can be run by business unit, division, college, department, TL group id, or empl id. The individual date detail option provides leave dates, leave hours, and empl id of approver and date of approval for approved payable time. However, we recommend limiting running the individual detail option to an empl id or small TL group or department, as the report can be lengthy.
Navigation: Manager Self Service > Time Management > Time and Labor Reports >
TL Payable Time Report

There are also several queries that have been created for Time and Labor. All queries can be found under Reporting Tools.
   Navigation: Reporting Tools > Query > Query Viewer > <Query Name>

There are two naming conventions associated with the Time and Labor Queries, which are as follows:
   HRMS_TL_% and UPAY_TL_%

Below are four helpful queries to easily identify time to be approved:

� HRMS_TL_RPTTIME_NA_BY_DEPT � shows a list of reported time that needs approval by division, college, or department ID.

� HRMS_TL_RPTTIME_NA_BY_GRPID � shows a list of reported time that needs approval by TL group id.

� HRMS_TL_PAYTIME_NA_BY_DEPT � shows a list of payable time that needs approval by division, college, or department ID.

� HRMS_TL_PAYTIME_NA_BY_GRPID � shows a list of payable time that needs approval by TL group id.

Questions pertaining to Time and Labor should be directed to the HRMS Office at x31962.