Versions Compared

Key

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


Note
Add yourself as a Watcher to this page to be automatically emailed with any changes to this page.

Table of Contents

Warning

This page assumes you have read EAH Quick Start Guide


Overview


This view contains YTD, QTD and MTD payroll 1042 reportable witholding tax balances by employee, calendar and fiscal year for employees who receive a 1042.

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


Steps to Take


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: