This view contains YTD, QTD and MTD payroll tax balances by employee, calendar and fiscal year for employees who receive a W-2.
One row per employee per tax element per month for calendar month and fiscal month.
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 Tax Code
- Balance Year
- Balance Quarter
- Balance Period
- Balance Tax State Code
- Balance Tax Locality Code
- Balance Tax Tax Class