Search Results ee_er_code

Overview

PAYBV_US_TAX_TYPES_V is a read-only Oracle EBS view owned by the APPS schema and registered under the Payroll (PAY) product family. It presents a denormalized, business-friendly projection of the United States tax type definitions stored in the PAY_US_TAX_TYPES table. The view is one of the seeded "PAYBV" (Payroll Business View) objects delivered with Oracle E-Business Suite and is valid in both 12.1.1 and 12.2.2.

The primary purpose of the view is to expose US payroll tax type attributes together with a decoded, human-readable tax domain description, so that reporting tools, extracts, and integrations can consume tax type reference data without joining to the underlying lookup infrastructure. Because the view is defined with the WITH READ ONLY clause, it cannot be used for DML; it is strictly a query surface over the base synonym.

Analysts frequently encounter this object when tracing the meaning of the EE_ER_CODE column, which distinguishes employee-level tax types from employer-level tax types. That flag and its companion columns are covered below.

Underlying Base Objects

The view is defined over two documented dependencies:

• PAY_US_TAX_TYPES (SYNONYM) — the core base object holding the US tax type rows. In the view text it is referenced with the alias PUTT. All persistent columns (EE_ER_CODE, LIMIT_TAX_FLAG, TAX_TYPE_CODE, TAX_DOMAIN_CODE, TAX_TYPE_ID) originate from this source.
• HR_BIS (PACKAGE) — the HR business intelligence utility package. The view calls HR_BIS.BIS_DECODE_LOOKUP('US_TAX_DOMAIN', PUTT.TAX_DOMAIN_CODE) to translate the stored tax domain code into its descriptive lookup meaning.

Because the definition includes a lookup function call, query performance depends on the standard lookup caching behavior of HR_BIS rather than on a direct table join. The view is a pure projection: it adds no filtering predicate and exposes every row present in PAY_US_TAX_TYPES.

Key Columns

• EE_ER_CODE — The employee/employer indicator. This is the column most often searched for. It identifies whether the tax type applies to the employee side (withholding from the employee) or the employer side (employer-paid liability). It is the governing attribute for split tax reporting.
• LIMIT_TAX_FLAG — Indicates whether the tax type is subject to a wage or contribution limit (for example, a statutory ceiling on taxable wages).
• TAX_TYPE_CODE — The code identifying the specific US tax type, annotated in the view text as /* CODES */.
• TAX_DOMAIN_CODE — The stored code for the tax domain that the tax type belongs to (for example, federal, state, or local categories).
• TAX_DOMAIN — The decoded description produced by BIS_DECODE_LOOKUP against the US_TAX_DOMAIN lookup, providing a display-ready label for the domain.
• TAX_TYPE_ID — The internal surrogate primary key for the tax type; used as the join key to payroll balance, costing, and run-result tables.

Common Use Cases and Queries

Typical uses include building payroll tax reference extracts, validating tax setups during implementations, and joining tax types to balance or run-result data. A common filter is by employee/employer code:

• List all employee-side tax types: SELECT tax_type_code, tax_domain FROM paybv_us_tax_types_v WHERE ee_er_code = 'EE';
• List all employer-side tax types: SELECT tax_type_code, tax_domain FROM paybv_us_tax_types_v WHERE ee_er_code = 'ER';
• Identify limited tax types by domain: SELECT tax_type_code, tax_domain FROM paybv_us_tax_types_v WHERE limit_tax_flag = 'Y' ORDER BY tax_domain;
• Resolve a tax type ID to its code and domain: SELECT tax_type_code, tax_domain FROM paybv_us_tax_types_v WHERE tax_type_id = :p_tax_type_id;

Accurate use of EE_ER_CODE is essential when reconciling employee versus employer tax balances, since mixing the two sides produces misleading totals.