EAH-TaxBalance-View Quick Start Guide

This view contains YTD, QTD and MTD payroll tax balances by employee, calendar and fiscal year for employees who receive a W-2.

One row per employee per tax element per month for calendar month and fiscal month.

Fields that make up the primary key:

  • Employee ID
  • Balance Type Code
  • Balance Tax Code
  • Balance Year
  • Balance Quarter
  • Balance Period
  • Balance Tax State Code
  • Balance Tax Locality Code
  • Balance Tax Tax Class

Key Fields to use as filters: