Search Results pay_us_state_tax_info_f




Overview
Explore in AI Chat

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

Overview

PAY_US_STATE_TAX_INFO_F is a payroll reference table owned by the HR schema in Oracle E-Business Suite, holding United States state-level tax configuration information used by the Payroll (PAY) module. The table defines the statutory tax characteristics that apply to a given state for a defined effective date range, including whether State Income Tax (SIT) applies and the associated wage limits for State Unemployment Insurance (SUI), State Disability Insurance (SDI), and State Health Insurance (SHI) at both employee and employer levels. Because payroll tax rules vary by jurisdiction and change over time, this table is date-effectivity driven and forms part of the legislative/reference data foundation upon which payroll tax calculations are performed.

The ETRM metadata classifies this object as standalone under the heuristic Data Vault mining approach; no foreign-key relationships were identified pointing to or from it. In Data Vault modeling terms, this suggests treating the object as a satellite-style reference entity: it carries descriptive, dated attributes keyed by a state identifier rather than participating in hub/link relationships with other transactional entities. The classification is a modeling suggestion only, derived from the FK structure, and does not imply a physical constraint beyond what is documented.

Key Information Stored

The table contains 73 documented columns. The primary key is defined by the unique index PAY_US_STATE_TAX_INFO_F_PK, whose business-key candidate columns are STATE_TAX_INFO_ID, STATE_CODE, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE, and ZD_EDITION_NAME. Here STATE_TAX_INFO_ID serves as the surrogate identifier, while STATE_CODE combined with the effective date range constitutes the natural business key that distinguishes one configuration record from another. ZD_EDITION_NAME reflects the editioning view support introduced in EBS 12.2.

Common Use Cases and Queries

This table is primarily consumed by payroll tax calculation logic and by reporting that must reconcile state wage limits for a specific period. A typical query resolves the effective record for a state as of a payroll date:

  • Retrieve current state tax rules: SELECT STATE_CODE, SIT_EXISTS, SUI_EE_WAGE_LIMIT, SUI_ER_WAGE_LIMIT FROM PAY_US_STATE_TAX_INFO_F WHERE STATE_CODE = :p_state AND TRUNC(SYSDATE) BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;
  • Historical point-in-time lookup for a prior tax year by supplying the relevant effective date.
  • Reporting on states where State Income Tax applies, filtered by SIT_EXISTS = 'Y'.
  • Comparing employee versus employer wage limits across states for SUI, SDI, and SHI.
  • Audit queries using REQUEST_ID and LAST_UPDATE_DATE to trace configuration changes made by concurrent programs.

Because flexfield columns are populated contextually, reports referencing STA_INFORMATION segments should filter or decode against STA_INFORMATION_CATEGORY.

Related Objects

The documented metadata classifies this object as standalone with no FK-derived relationships. Consistent with its role as state tax reference data, it is typically joined by STATE_CODE and effective dates rather than by a foreign key to the following related objects:

Developers should treat STATE_CODE plus EFFECTIVE dates as the de facto join path, since the metadata documents no enforced FK relationships.