Search Results pay_us_w2_tax_unit_v




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PAY_US_W2_TAX_UNIT_V is an Oracle EBS application view owned by the APPS schema and shipped as part of the Payroll (PAY) product family. It presents a denormalized, reporting-ready projection of United States W-2 tax unit information, drawn from payroll action records and resolved through the HR_US_W2_REP package. Its principal role is to expose the tax unit attributes required for federal W-2 wage and tax statement generation in a flat, query-friendly form, so that year-end reporting processes, W-2 extracts, and downstream integrations can retrieve employer identification and address data without directly navigating the underlying payroll action legislative parameters.

The view is registered as VALID in the ETRM metadata for release 12.2.2, and is documented as belonging to the APPS schema with the PAY - Payroll product designation. It is intended for read-only consumption by reporting logic, concurrent programs, and custom extracts rather than for transactional update.

Underlying Base Objects

The documented referenced base objects for PAY_US_W2_TAX_UNIT_V are:

  • HR_US_W2_REP (PACKAGE) — the PL/SQL package supplying the functions that resolve tax unit attributes, including business group, W-2 tax unit item values, and address lines.
  • PAY_PAYROLL_ACTIONS (SYNONYM) — the payroll action source from which the legislative parameters and payroll action identifiers are read.

The view text parses the LEGISLATIVE_PARAMETERS column of the payroll action, locating the token TRANSFER_GRE= and extracting the trailing tax unit identifier. That numeric identifier is then passed to HR_US_W2_REP functions: GET_TAX_UNIT_BG for the business group, GET_W2_TAX_UNIT_ITEM for the tax unit name and employer identification number, and GET_TAX_UNIT_ADDR_LINE for each address element. Because the view depends on a package rather than only on static tables, its results reflect the current state of the tax unit definitions at query time.

Key Columns

  • YEAR — the four-digit year derived from the payroll action effective date via TO_CHAR(EFFECTIVE_DATE,'YYYY').
  • TAX_UNIT_ID — the numeric tax unit identifier extracted from the TRANSFER_GRE token within LEGISLATIVE_PARAMETERS.
  • BUSINESS_GROUP_ID — the business group associated with the tax unit, resolved through HR_US_W2_REP.GET_TAX_UNIT_BG.
  • FEDERAL_EIN — the employer identification number for the tax unit, with a default of 'APPLIED FOR' when no value is present.
  • TAX_UNIT_NAME — the descriptive name of the tax unit.
  • ADDRESS_LINE_1, ADDRESS_LINE_2, ADDRESS_LINE_3 — the tax unit's street address lines.
  • TOWN_OR_CITY, STATE — the city and state components of the tax unit address.

Common Use Cases and Queries

Typical scenarios include year-end W-2 preparation, validation of federal employer identification data, and reconciliation of tax unit addresses across reporting years. A representative query retrieves tax unit details for a given year:

  • SELECT year, tax_unit_id, federal_ein, tax_unit_name, town_or_city, state FROM apps.pay_us_w2_tax_unit_v WHERE year = 2024;
  • SELECT tax_unit_id, tax_unit_name, federal_ein FROM apps.pay_us_w2_tax_unit_v WHERE federal_ein = 'APPLIED FOR'; — to identify tax units lacking a valid EIN.
  • SELECT business_group_id, COUNT(*) FROM apps.pay_us_w2_tax_unit_v GROUP BY business_group_id; — to profile tax units by business group.

Because the view invokes package functions per row, queries returning large result sets may incur additional overhead; filtering by year or tax unit identifier is advisable in production extracts.