Skip to main content

System Status: 

DOPE Report

The DOPE report is used to confirm applied payroll expenses for a given payroll cycle.

The DOPE Report is available from the Business Analytics Hub (bah.ucsd.edu) under the Payroll Accounting and Reconciliation tab.

For more information and resources related to payroll accounting and reconciliation please review the Payroll Reconciliation Toolkit and the KBA: How to Understand Vacation Accounting Transactions in UCPath

Access

 

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.

Distribution of Payroll Expense (DOPE) Report

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

  • Employee Name
  • Employee ID
  • Employee Record
  • Pay Period End Date
  • Earnings Period Start Date
  • Earnings Period End Date
  • Pay Check Date
  • Transaction Type
  • Fiscal Year
  • Accounting Period Number
  • Department Code
  • Department
  • Position Number
  • Position
  • Job FTE
  • Job Code
  • Job Description
  • Pay Group Code
  • Pay Group
  • Earnings Code
  • Earnings Type
  • Pay Basis
  • Job Compensation Frequency
  • Employee CBR Rate Group
  • Employee UCPath CBR Rate Group
  • Employee UCPath CBR Rate Code
  • CCOA Entity Code
  • CCOA Entity
  • CCOA Fund Code
  • CCOA Fund
  • CCOA FinU Code
  • CCOA FinU
  • CCOA Account Code
  • CCOA Account
  • CCOA Funct Code
  • CCOA Funct
  • CCOA Program Code
  • CCOA Program
  • CCOA Project Code
  • CCOA Project
  • CCOA Location Code
  • CCOA Location
  • CCOA Activity Code
  • CCOA Activity
  • CCOA TASK Code
  • CCOA TASK
  • CCOA Funding Source Code
  • CCOA Funding Source
  • OTC Indicator Code
  • Project Manager Name Full
  • Task Manager Name Full
  • Salary Cap Rate
  • LL Annual Rate
  • Job Compensation Rate
  • Employee CBR Rate
  • Salary Hours
  • Salary Derived Effort Percent
  • Salary Total Pay Component Percent
  • Monetary Amount
  • Pay Run Code
  • Salary Earnings Run Code
  • Journal ID
  • Journal Line
  • GL Journal Line Number
  • Journal Template Code
  • Cost Transfer Code
  • Original Transaction Reference Number
  • Transaction Type - Account
  • Project - Task
  • Salary Grouped Total
  • Fringe Grouped Total
  • Salary and Fringe Grouped Total

Resources

FAQ

What is UCRP and why it is not applied to Federal Flow Thru salary?

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
The UCSD Salary Derived Effort Percent is a calculated value that produces an effort percent by dividing the Monetary Amount by either the Job Compensation Rate or the Salary Cap Rate, adjusted for partial FTEs, for the scenarios described above.  For all non-faculty positions and for rows with 0% effort, the Salary Derived Effort Percent value is used.  There are isolated circumstances where this calculation does not happen correctly:
  • 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.
Fund managers should use their own discretion in determining which column to use when determining effort.