Search Results pay_us_tax_types




Overview
Explore in AI Chat

Overview

PAY_US_TAX_TYPES is a reference (lookup) table owned by the HR schema and used within the Oracle E-Business Suite PAY – Payroll product. Its documented purpose is to store US Tax Types used by US Payroll Tax Balance reporting. In practice, it defines the distinct tax classifications that US Payroll balances are grouped and reported against — for example federal income tax, Social Security, Medicare, and state or local withholding categories — providing the authoritative list of tax type codes that downstream payroll tax reporting relies upon.

Because this is a small, slowly changing reference object with a stable surrogate key and descriptive attributes, the metadata's heuristic Data Vault classification of hub‑leaning is appropriate. That classification is offered as a modeling suggestion: the table behaves primarily as a hub of distinct tax types rather than as a transactional link or a high‑churn satellite. It is a low‑volume, code‑driven object whose main role is enumeration and validation rather than transaction capture.

Key Information Stored

The table contains six documented columns. The most important of these are summarized below, distinguishing the surrogate key from the business‑key candidates identified by the unique indexes.

  • TAX_TYPE_ID — Surrogate primary key defined by the unique index PAY_US_TAX_TYPES_PK (with ZD_EDITION_NAME). This value is the identifier referenced by foreign keys in dependent balance and tax tables.
  • TAX_TYPE_CODE — The business‑facing code describing the tax type; defined as a business‑key candidate by unique index PAY_US_TAX_TYPES_UK2 (with ZD_EDITION_NAME). This is the human‑readable identifier commonly used in reporting filters.
  • ZD_EDITION_NAME — Editioning/versioning column that participates in both unique indexes, enabling edition‑aware access to the reference data.
  • TAX_DOMAIN_CODE — Classifies the tax domain to which the tax type belongs (the jurisdiction or taxing authority grouping).
  • EE_ER_CODE — Distinguishes the employee/employer designation of the tax type, indicating whose portion of the tax the type represents.
  • LIMIT_TAX_FLAG — Flag indicating whether the tax type is subject to a wage or contribution limit, a key control for accurate tax balance reporting.

Common Use Cases and Queries

The primary use case is resolving tax type codes into descriptions for US Payroll Tax Balance reporting. A typical reporting join links balances to this lookup to produce readable output:

  • Tax balance reporting: joining PAY_US_TAX_BALANCES to PAY_US_TAX_TYPES on TAX_TYPE_ID to display the tax type code and domain alongside aggregated balances.
  • Validation and reconciliation: confirming that every tax type appearing in balances has a corresponding definition, and that business keys remain unique across editions.
  • Filtering by domain or limit: using TAX_DOMAIN_CODE and LIMIT_TAX_FLAG to isolate taxes subject to wage limits for compliance monitoring.

A representative query pattern:

  • SELECT t.TAX_TYPE_CODE, t.TAX_DOMAIN_CODE, t.LIMIT_TAX_FLAG, b.BALANCE_AMOUNT FROM PAY_US_TAX_BALANCES b JOIN PAY_US_TAX_TYPES t ON b.TAX_TYPE_ID = t.TAX_TYPE_ID;

Related Objects

Several tables reference this object through the documented foreign keys, confirming its role as a central reference hub:

  • PAY_US_TAX_BALANCES.TAX_TYPE_ID — references PAY_US_TAX_TYPES; the principal consumer for tax balance reporting.
  • JAI_CMN_TAX_TYPES_ALL.TAX_TYPE_ID — references PAY_US_TAX_TYPES through the common tax types structure.
  • JAI_CMN_TAXES_ALL.TAX_TYPE_ID — references PAY_US_TAX_TYPES, linking tax calculations to the tax type definition.

The documented primary and unique indexes (PAY_US_TAX_TYPES_PK on TAX_TYPE_ID and PAY_US_TAX_TYPES_UK2 on TAX_TYPE_CODE) reinforce its function as a stable, code‑driven reference table within the US Payroll tax reporting model.