| 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 . 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 Reportfor employees who receive a 1042.
One row per employee per tax element per month for calendar month and fiscal month.
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