Issue
The Percent of Effort displayed in the Distribution of Payroll Expense (DPE) Report does not accurately reflect the percent of effort for some earnings distribution lines resulting from salary cost transfers onto capped funding sources. Earnings Amounts and Percent of Pay are accurately reflected in the DPE.
Root Cause
The incorrect calculations are being generated in UCPath and are due to an upstream defect in the General Ledger data. This issue is under investigation by the UCPath Center.
Mitigation Plan
To manually calculate the correct effort percent for each capped funding source, sum the N-OTC Percent of Pay and the Y-OTC Percent of Pay on the earnings distribution lines for the funding source. For example, adding the Percent of Pay from the N-OTC001 up to the cap distribution line to the Percent of Pay from the corresponding Y-OTC001 over the cap distribution line will equal the Percent of Effort for the capped funding source indicated on the N-OTC001 distribution line.
If you need further assistance, contact the Controller’s Office Solution Center.
Issue Status
Update: April 2023
The UCPath Center implemented a fix to correctly calculate the derived effort percent on earnings distrbution lines for future salary cost transfers onto capped funding sources. The effort percent for historical distribution lines on the DPE can be manually calculated using the mitigation instructions above.
Update: February 2023
The UCPath Center is working to correct the derived effort percent calculations that we receive on the Labor Ledger and which appear on the Distribution of Payroll Expense (DPE). The target release date is March 2023.