Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

This view contains YTD, QTD and MTD payroll 1042 reportable witholding tax 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 Tax1042 Code
  • Balance Year
  • Balance Quarter
  • Balance Period
  • Balance Tax1042 State Code
  • Balance Tax1042 Country Code
  • Balance Tax1042 Income Source Code
  • Balance Tax1042 Tax Rate

Key Fields to use as filters:


  • No labels