This view contains employee paycheck summary information and related federal and state tax withholding attributes.
One row per employee paycheck.
For more information about the details of each paycheck use EAH-PayrollDeductionDetail-View, EAH-PayrollEarningsDetail-View or EAH-PayrollTaxDetail-View.
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 Pay Check Number
Key Fields to use as filters:
- Pay Run Code
- Deduction Class has values - After-tax, Before-tax, Nontaxable benefit
- Deduction Plan Type has values - Dental, Life, Medical, vision, UC Retirement Plan, etc.
- Deduction has values - HealthCare FSA, Basic Life, Delta Dental PPO, Voluntary Long-Term Disability, etc.
- Pay Group - Has value UCSD Academic Exempt Monthly
- Employee Status - 6 Values of Active Paid Leave of Absence, Retired, etc.
- Job Code = CONV are converted records that can be filtered out if not needed
- HR Status has values Active, inactive
- Job Action has values - Termination, Hire, Rehire etc.
Fields of interest:
- Pay Check Number
- Pay Check Total Deductions
- Pay Check Total Gross
- Pay check Total Taxes