EAH-Payroll-View Quick Start Guide

Owned by Former user (Deleted)
Last updated: Apr 23, 2021 by Russia Madden

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.

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