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
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