TL Rptd Time Audit Report

Overview

When an employee submits time, the reported time travels through a series of actions performed by the timekeeper/approver and the M-Pathways system. The TL Rptd Time Audit Report provides line item details of each action.

There are two common scenarios when the TL Rptd Time Audit Report is useful:

1. If an employee's reported times are modified by the approver, the TL Rptd Time Audit Report provides the audit history of each change.
2. If a unit has more than one approver or timekeeper editing an employee's reported time, the TL Rptd Time Audit Report tracks every action performed by each user.

Report Parameters

The report requires the following:

1. An EmplID or a Static Group
2. A specific date or range of dates

The report will list only one EmplID and day per page. For the detailed steps to run reports, refer to:

• Run a Report to the Report Manager in M-Pathways – Step-by-Step Procedure
• Run a Report to a Window in M-Pathways – Step-by-Step Procedure

 

TL Rptd Time Audit Report

The report is organized into two main sections (A and B):

• The complete audit detail is in the top section (A). It lists each action on a different line.
• The bottom section (B) identifies the specific change(s) that occurred with the line items in the top section.

The recommended approach to reviewing the report is to first review the top section for the chronological history of the actions that occurred to the reported time for the date. If the change that occurred is unclear, refer to the bottom section for the breakdown of the old and new values.

TL Rptd Time Audit Report - Top Section

Letter	Report Field	Description
C	EmplID, Empl RCD#	EmplID is the employee's identification number, also called UMID. The Empl RCD# is the employment record number of the specific job appointment.
D	Audit OprID	Displays the timekeeper's or approver's uniqname.
E	Audit Stamp	The time when the individual action was uploaded into the system. The system uploads information from time clocks every 15 minutes.
F	Audit Action	Identifies whether a row of reported time was added or changed in M-Pathways. The action is Add when an employee submits time, or when the timekeeper or approver adds a row of reported time on the timesheet. The action is Chg To (change to) when M-Pathways, a timekeeper, or an approver performs an action that changes a row of reported time. For example, the employee may submit an incorrect TRC code of REG. The Audit Action would read Chg To when the approver changes it to ETW.
G	DUR	"Date Under Report" (DUR) – The date on which the employee reported time.
H	Seq Nbr	Displays a system-assigned sequence number that identifies a row of reported time. The sequence number is repeated each time an action is performed on it.
I	Punch Type	Displays Elp which stands for Elapsed. (Note to Reviewer: Any more detail needed?)
J	TRC	Displays the Time Reporting Code (TRC) that was entered on the timesheet.
K	TL Quantity	Displays the number of hours for the row of reported time, if any at the time of the action.
L	Reprtd Status	This field will be blank.
M	RT Source	This field will be blank.
N	Punch DTTM	The default date is always 01-JAN-1900. This field can be ignored.

 

TL Rptd Time Audit Report - Tope Section (Continued)

Letter	Report Field	Description
K	TCD ID	This field will be blank.
L	OprID	If the action that created the row of reported time was done by a timekeeper or approver on the timesheet page, it displays his/her operator ID (uniqname).
M	OprID Last Upd	If applicable, it displays the operator ID (uniqname) of the timekeeper or approver who last updated the reported time on the timesheet page.
N	DTTM Modified	The default date is always 01-JAN-1900. This field can be ignored.

 

TL Rptd Time Aduit Report - Bottom Section

Letter	Report Field	Description
S	Seq Nbr	Displays the system-assigned sequence number that uniquely identifies a row of reported time. The example above displays sequence numbers 1, 2 and 3, which reflect that the REG time was changed from 8.0 to 0.0 (1). The TRC was changed from ESA to ETW (2), and another TRC was changed from ESB to ESF (3).
T	Audit Time	Displays the Audit Stamp time that can be used with the sequence number to match a row from the bottom section to a row in the top section.
U	Field	Identifies the specific field that was changed in the row of reported time.
V	Old Value	Lists the original value prior to the change.
W	New Value	Lists the new value after the change.