Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

This view contains YTD, QTD and MTD payroll deduction balances by employee, calendar and fiscal year.  Start here and then branch out if you are need finding the data you need.

Data Loads:

UCPath data is sent from UCOP to UCSD on a nightly basis.  To see when the data completed being loaded by UCSD into EAH see this report: Tableau QA > Public > AH Data Load Status Report

Fields that make up the primary key:

  • Employee ID
  • Balance Type Code
  • Balance  Year
  • Balance Quarter
  • Balance Period
  • Balance Deduction Employee Record
  • Balance Deduction Plan Type
  • Balance Deduction Benefit Plan
  • Balance Deduction Code
  • Balance Deduction Deduction Class

Key Fields to use as filters: