The Report Detail screen shows payroll transaction details that support the percentages on the effort report.
When viewing an effort report in ERS, click on the View Payroll Details button to access the Report Detail screen which shows the payroll transaction detail that supports the percentages on the effort report.
The transaction detail comes from the KFS Labor Ledger.
Report Detail Table
|Column||What It Means|
|Pay Period End Date||This is the period for which the employee was paid. It tells when the effort was expended.|
|Pay Cycle Code||This is a payroll code indicating the payroll compute which produced the transaction. Pay cycle codes include:
|FAU||This is the Full Accounting Unit that was used for the payroll transaction. The FAU is used to group transactions on the effort report and to link to the Sponsored Project, which determines whether the project is federal.|
|DOS Code||This is the Description of Service code from the payroll transaction. The DOS Code is one of the values used to determine whether the transaction should be included in the effort report. For example, REG pay is included in an employee's 100% effort but STP (stipend) is not.|
|Trans Code||This is the payroll transaction code that indicates whether the payment was issued automatically, entered by the department as late pay, or resulted from a transfer of payroll expense.|
|Title Code||This is the Title Code from the payroll transaction. The title code is used to determine which employees must self-certify. It is also used to determine when pay transactions must be normalized because an employee has titles with different bases.|
|Pay Rate||This is the Pay Rate from the payroll transaction. This amount will be shown as a Monthly rate, an Hourly rate, or a By Agreement amount.|
|Rate Type||This is the Rate Type from the payroll transaction. The code indicates how to interpret the value in the Pay Rate column.
Rate Types include:
|Paid %||This is the Time % value from the payroll transaction. For annual-paid employees, the Paid % equals the Time % charged to the FAU for the pay period. For hourly employees, the Paid % shows the hours charged to the FAU for the pay period.|
|Derived %||This is the derived percent value from the payroll transaction. For annual-paid employees, the Derived % is equal to the Paid %. For hourly employees, the Derived % is generally calculated as the Hours divided by the average number of working hours in a month (174).|
This value is calculated by ERS when an employee has a combination of nine-month and eleven-month appointments. Nine month appointments are typically paid over twelve months. This means for each three months worked the employee receives four checks. In the case of eleven month appointments the employee receives three checks for each three months worked. The weighted percent is necessary to normalize the paid percentages. If the system were simply to average the nine month pay with the eleven month pay, the effort calculation would be distorted with the nine month effort being overstated and the eleven month effort being understated.
The Weighted % solves this problem. When all payments are made on the same Basis (either 9/12 or 11/12), the Weighted % value is copied from the Derived % value. When there is a mix of 9/12 and 11/12 payments, the 9/12 payments must be weighted to account for the fact that each 9/12 payment represents one-third effort rather than one-fourth effort.
In these cases, the Weighted % is calculated as the Derived % multiplied by 0.75 and the result can then be combined with the 11/12 payments to arrive at a valid total. This is an unusual situation however, and in most cases employees will have a single Basis and the Weighted % value will be the same as the Derived % value as calculated by UCPath.
|Pay Category||This is the Pay Category attribute associated with the DOS Code. The Pay Category Code is one of the values used to determine whether the transaction should be included in the effort report:
|Time Code||This is the Time Code attribute associated with the DOS Code. The Time Code is one of the values used to determine whether the transaction should be included in the effort report. Time code will indicate whether the pay is for Regular time, Overtime, By Agreement amount, etc.|
|Pay Cycle End Date||This is the date on which the payroll cycle that produced this transaction was processed, that is, the date the transaction posted to the ledger.|