ERS Report Details Screen

When viewing an effort report in ERS, click on the View Payroll Details button to access the Report Detail screen. The Report Detail screen displays the payroll transaction detail that supports the effort report. The percent effort for each sponsored project or category line displayed on the effort report is based on information from the Payroll Personnel System (PPS).

In addition to the payment information, unrecognized and excluded earnings are included on this report.

Report Detail Table
Each column represents information that should be reviewed prior to certifying the effort report. If you have questions, you may wish to check in with your departmental payroll processor.

Column What It Means

Pay Period End Date This is the period the employee was paid for.

Pay Cycle Code This is a payroll code indicating the type of payroll cycle which produced the transaction. Pay cycle codes include:

MO for monthly
B1, B2 for biweekly

FAU This is the full accounting unit that was used for the payroll transaction. The FAU is what determines how the payment is categorized for the effort report. A Sponsored Project can contain one or more FAUs.

DOS Code This is the Description of Service code from the payroll transaction. The DOS Code defines various characteristics of pay, such as whether the payment is a By Agreement amount, and is one of the values used to determine whether the transaction should be included in the effort report.

Trans Code This is the payroll transaction code that triggered the payment to the employee. For example, it 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 one of the values used to determine whether the transaction should be included in a particular effort report. For example, fiscal year or 11 month appointments (title codes) are included in a different report than academic year or 9 month appointments (title codes).

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:

A for Annual (shown as a monthly rate)
H for Hourly
B for By Agreement

Paid % This is the Earnings Percent value from the payroll Distribution %. The value indicates the percent of time that an individual was paid on a project during a pay period.

Derived % This is the derived percent value from the payroll transaction. During the payroll compute process, PPS derives an equivalent percent of time for employees paid by the hour. PPS also transfers the percent of time for each pay transaction for employees paid with a monthly rate into the Derived % field. The Derived % field contains a percent of time paid for each pay transaction and this field can be used to calculate effort for all types and combinations of payment types.
The Derived % will differ from the Paid % if the employee was paid at an hourly rate. The Derived % will be the same as the Paid % if the employee is paid at a monthly rate.

Weighted % This value is calculated by ERS when an employee has a combination of nine-month and eleven-month appointments. Nine month appointments are 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 equalize 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 PPS.

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:

N=regular
L=leave
A=additional, one-time pay
D=differential
P-perquisite
S=suspense item
Only N pay categories are included in effort reporting.

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.

Column	What It Means
Pay Period End Date	This is the period the employee was paid for.
Pay Cycle Code	This is a payroll code indicating the type of payroll cycle which produced the transaction. Pay cycle codes include: MO for monthly B1, B2 for biweekly
FAU	This is the full accounting unit that was used for the payroll transaction. The FAU is what determines how the payment is categorized for the effort report. A Sponsored Project can contain one or more FAUs.
DOS Code	This is the Description of Service code from the payroll transaction. The DOS Code defines various characteristics of pay, such as whether the payment is a By Agreement amount, and is one of the values used to determine whether the transaction should be included in the effort report.
Trans Code	This is the payroll transaction code that triggered the payment to the employee. For example, it 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 one of the values used to determine whether the transaction should be included in a particular effort report. For example, fiscal year or 11 month appointments (title codes) are included in a different report than academic year or 9 month appointments (title codes).
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: A for Annual (shown as a monthly rate) H for Hourly B for By Agreement
Paid %	This is the Earnings Percent value from the payroll Distribution %. The value indicates the percent of time that an individual was paid on a project during a pay period.
Derived %	This is the derived percent value from the payroll transaction. During the payroll compute process, PPS derives an equivalent percent of time for employees paid by the hour. PPS also transfers the percent of time for each pay transaction for employees paid with a monthly rate into the Derived % field. The Derived % field contains a percent of time paid for each pay transaction and this field can be used to calculate effort for all types and combinations of payment types. The Derived % will differ from the Paid % if the employee was paid at an hourly rate. The Derived % will be the same as the Paid % if the employee is paid at a monthly rate.
Weighted %	This value is calculated by ERS when an employee has a combination of nine-month and eleven-month appointments. Nine month appointments are 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 equalize 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 PPS.
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: N=regular L=leave A=additional, one-time pay D=differential P-perquisite S=suspense item Only N pay categories are included in effort reporting.
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.

Back to Effort Reporting Help Home

This site maintained by UC Davis Accounting & Financial Services
Questions about this site? Contact us at afsweb@ucdavis.edu.