Search Results pay_us_tax_report_balances




Overview
Explore in AI Chat

Overview

PAY_US_TAX_REPORT_BALANCES is a table owned by the HR schema within the Oracle E-Business Suite Payroll (PAY) module. It is documented as a VALID object in ETRM for both release 12.1.1 and 12.2.2. Functionally, the table identifies the tax balances that are consumed by the US Payroll Tax Summary Listing report, acting as an associative mapping between a specific report and the individual tax balances that the report is expected to present.

From a Data Vault modeling perspective, the metadata's heuristic classification labels this table as satellite-leaning. This suggests that it is best understood as a descriptive, context-bearing structure attached to other entities rather than as a standalone hub of a core business concept. The table does not introduce a new independent business key of its own; instead, it carries report-specific attributes that qualify the referenced tax balances. Practically, it behaves as an intersection or cross-reference structure: it links a report identity (REPORT_CODE) to a tax balance instance (TAX_BALANCE_ID) and adds an ordinal attribute describing how that balance should appear in the report output.

Key Information Stored

The documented physical schema for ETRM 12.2.2 lists three columns. These should not be confused with the full runtime table definition, but the metadata confirms the following persistent attributes:

  • REPORT_CODE — Identifies the report context. In this table, it distinguishes which report configuration or report variant the associated tax balance belongs to. It forms one half of the composite primary key and is a business-key candidate.
  • TAX_BALANCE_ID — The foreign key referencing PAY_US_TAX_BALANCES. It points to the specific US payroll tax balance record that should be included in the report. It forms the second half of the composite primary key and is also a business-key candidate.
  • BALANCE_PRINT_SEQUENCE — Controls the ordering in which the referenced tax balance is printed or displayed on the Tax Summary Listing report. It is a presentational attribute rather than an identifying one.

The surrogate primary key is defined by the unique index PAY_US_TAX_REPORT_BALANCES_PK, which is a composite of (REPORT_CODE, TAX_BALANCE_ID). Because the documented unique index matches the natural business key rather than a system-generated sequence, there is no separate single-column surrogate identifier in the documented model. The combination of REPORT_CODE and TAX_BALANCE_ID enforces that a given tax balance can appear at most once per report code.

Common Use Cases and Queries

The primary use case is report composition. A developer or support analyst investigating why a given tax balance does or does not appear on the US Payroll Tax Summary Listing report will query this table to confirm the report-to-balance mapping.

  • Enumerating balances for a report: selecting all TAX_BALANCE_ID values for a specific REPORT_CODE and ordering by BALANCE_PRINT_SEQUENCE reproduces the report's expected balance lineup.
  • Reverse lookup: given a TAX_BALANCE_ID, determining which report codes reference it by joining directly to PAY_US_TAX_BALANCES.
  • Integrity checks: comparing row counts and sequence values against the report output to detect missing or misordered balances.
  • Diagnostic SQL pattern: SELECT b.REPORT_CODE, b.TAX_BALANCE_ID, b.BALANCE_PRINT_SEQUENCE, t.* FROM HR.PAY_US_TAX_REPORT_BALANCES b JOIN HR.PAY_US_TAX_BALANCES t ON b.TAX_BALANCE_ID = t.TAX_BALANCE_ID WHERE b.REPORT_CODE = :report_code ORDER BY b.BALANCE_PRINT_SEQUENCE;

Because the table is small and structurally simple, queries are inexpensive and well suited to ad hoc validation during payroll close or tax reporting cycles.

Related Objects

  • PAY_US_TAX_BALANCES — The immediate parent table. The foreign key PAY_US_TAX_REPORT_BALANCES.TAX_BALANCE_ID references PAY_US_TAX_BALANCES.TAX_BALANCE_ID. This is the only documented FK relationship and the most significant dependency.
  • PAY_US_TAX_REPORT_BALANCES_PK — The primary key unique index enforcing the composite business key (REPORT_CODE, TAX_BALANCE_ID).
  • US Payroll Tax Summary Listing report — The consuming report logic; REPORT_CODE and BALANCE_PRINT_SEQUENCE are read to determine report content and ordering.

Additional tables and views in the PAY and HR schemas referencing the same tax balance identifiers may participate in broader payroll tax reporting, but the documented metadata confirms PAY_US_TAX_BALANCES as the principal object joined to this table.