Search Results sui_er




Overview
Explore in AI Chat

Overview

APPS.PAY_US_STATE_LIABILITY_TYPES_V is a reporting view in the Oracle EBS Payroll (PAY) module that exposes United States state-level employer tax liability definitions. Its principal purpose is to correlate seeded payroll element types for state disability insurance and state unemployment insurance employer contributions with their corresponding tax type and tax balance configuration. The view is particularly relevant to queries involving the SUI employer element, since it explicitly filters for the SUI_ER element alongside SDI_ER.

Because the view joins tax type metadata, balance category configuration, and translated element names, it provides a consolidated, language-aware description of employer state liability tax types. It is commonly referenced in payroll reporting, statutory compliance analysis, and integration logic that must resolve a state tax type from its associated employer element.

Underlying Base Objects

The view is owned by APPS and is defined over four documented objects, all accessed through synonyms:

  • PAY_ELEMENT_TYPES_F — the base element type definition, supplying element type identifier, effective dates, business group, processing priority, and legislation code.
  • PAY_ELEMENT_TYPES_F_TL — the translated element name, restricted to the session language via USERENV('LANG').
  • PAY_US_TAX_TYPES — the US tax type definition, supplying tax type identifier, domain code, and limit tax flag.
  • PAY_US_TAX_BALANCES — the tax balance configuration, supplying balance category, employer/employee indicator, and the user-facing reporting name.

The joins are driven by element type identifier, tax type identifier, and a derived match between the element name and the tax type code (the trailing _ER suffix is stripped). Only rows with a STATE tax domain, a LIABILITY balance category, and element names of SUI_ER or SDI_ER are returned.

Key Columns

Common Use Cases and Queries

Typical scenarios include retrieving the tax type and reporting name associated with the state unemployment employer element, auditing effective-dated element configuration, and supporting integration routines that must translate an element into its tax type. The following query isolates the SUI employer liability type:

  • SELECT tax_type_code, user_reporting_name, element_name, effective_start_date, effective_end_date, legislation_code FROM apps.pay_us_state_liability_types_v WHERE element_name = 'SUI_ER';
  • To list all state employer liability types subject to a wage limit:
  • SELECT tax_type_code, user_reporting_name, limit_tax_flag FROM apps.pay_us_state_liability_types_v WHERE limit_tax_flag = 'Y';

Because the view is language-aware and effective-dated, results reflect the session language and the current element definition rows, making it suitable for localized compliance reporting.