DOPE Report

Access the dashboard through the Business Analytics Hub 

If you do not already have access to this report, please submit an access request for the Payroll Accounting and Reconciliation report category.

1. Navigate to bah.ucsd.edu.
2. Select HR/Payroll
3. If using the List View, look for DOPE in the list or use the search bar at the top right and click the dashboard name
   • If using the Card View, click the Payroll Accounting and Reconciliation tab and click Launch on the DOPE tile
4. Use your Active Directory credentials to sign in, if prompted.

This report displays actual labor ledger payroll expenses applied for a given payroll cycle.

Report includes:

• Combined Salary & Fringe:   Lists all Salary and Fringe Labor Ledger data on a single tab.  
• Condensed Column Set: Shows only the essential columns required for Project Managers and Sponsors which keeps all columns on the screen together, no horizontal scrolling required.
• Employee Summary:   Totals Salary and Fringe monetary amounts for the Condensed Column Set.  Totals are grouped first by employee and then by pay and earnings periods.
• Optional Report Pages:
    ○ Salary Details: Lists only salary detail rows
    ○ Fringe Details: Lists only fringe detail rows
    ○ Stipend and Tuition Fees: Lists all related FinAH rows

Required Input

• Pay Calendar Dates
• Accounting FY-Periods

Fields

Resources

UCRP stands for University of California Retirement Plan and it’s a defined (pension) plan for eligible employees. There are two components of UCRP expenses: 1) principal and 2) interest. The “UCRP SI” or “RPNI” line reflected on the DOPE report is for the interest component. The interest assessment recovers the interest costs associated with the UC Retirement Plan unfunded liability. The UCRP Supplemental Interest assessment is applied to Non-Federal funding sources of covered compensation. The principal expense component is a part of the CBR assessment charge.

Salary derived effort percent is not always the same as salary total component percent. Could you please explain when this would happen?

Total pay component percent and total effort can be different for capped funds. This is due to over the cap amounts being re-directed to other fund sources, which impacts total pay component percent only. Salary derived effort is not impacted if salary is re-directed to another fund source because “effort” is based on the amount of time an employee spends working on a project. An employee’s time on a project does not change because funding was split to two different funding sources.

Why are some lines showing 0% salary derived effort? And 0% salary total pay component?

Salary derived effort & total pay component percent are only applied to salary lines. Fringe lines do not reflect them. Additionally, some earn codes are not effort bearing. Consequently, effort and associated paid percent will be set to 0%.

Why are some lines showing a monetary amount but does not show a project code number?

There could be a couple of reasons for this. Projects are assigned on the Funding Entry page in UCPath. A project will not appear on the DOPE if funding entry isn’t completed or if this field is intentionally left blank on this page.

How does UCPath know how many hours someone has put into a project? Especially if that person is salaried?

UCPath publishes a monthly working hours calendar located here - https://www.ucop.edu/ucpath-center/_files/mypath/calendar/ucpath-monthly-working-hours-2023.pdf A persons hours are calculated using this schedule, the persons FTE rate, and the percentage breakdown reflected on the Funding Entry page in UCPath.

How often is DOPES updated? If an employee changes a position or have a salary increase how soon it going to be reflected in DOPES?

The DOPE is updated after payroll is processed each month. We currently process payroll 1 x per month. The payroll schedule can be found here: https://ucsdcollab.atlassian.net/wiki/spaces/HRIS/pages/18975125/Labor+Ledger+Schedule (see the I714 Payroll column)

Employee changes will be reflected on the subsequent month’s DOPE after the change has been made and approved (if applicable) as long as it’s by the prescribed deadline in the payroll processing schedule located here: https://www.ucop.edu/ucpath-center/_files/mypath/calendar/payroll-processing-schedule-2023.pdf (see the “Employee Data Change” column)

Should I use the Salary Derived Effort Percent or the UCSD Salary Derived Effort Percent column?  What is the difference?

The Salary Derived Effort Percent is a value produced by UCPath. It is not a calculation.  It may be incorrect in certain situations:

• Faculty with 12 month appointments
• Faculty with summer salary funded on capped funds when the over-the-cap amount was not paid
• Faculty with 9-month appointments paid over 12 months

• Salary was short paid in one period, and a catch-up payment was made in a later period.  In these cases, the Salary Derived Effort Percent correctly assigns 100% effort to the first payment and 0% effort to the second payment.  The UCSD Salary Derived Effort Percent incorrectly assigns partial effort to the first payment and 0% effort to the second payment.
• A Direct Retro was performed after a change in the Job Compensation Rate.  The effort calculation for the original payroll will be correct, but the effort calculation for the Direct Retro reversal line will be based on the new Job Compensation Rate rather than the original Job Compensation Rate and will be therefore incorrect.