Search Results ss_er




Overview
Explore in AI Chat

Overview

APPS.PAY_US_FED_LIABILITY_TYPES_V is a reporting view in the Oracle E-Business Suite Payroll (PAY) module that exposes United States federal tax liability element types. It joins payroll element definitions against U.S. tax type and tax balance configuration to present the subset of federal liability elements that the payroll engine recognizes — specifically the employer-side (ER) liabilities Medicare_ER, FUTA, and SS_ER. The view is documented in ETRM for both release 12.1.1 and 12.2.2 and is owned by the APPS schema.

The view plays a narrow but important role: it correlates an element's human-readable name in PAY_ELEMENT_TYPES_F_TL with a U.S. tax type code by stripping the _ER suffix and matching the uppercase remainder against PAY_US_TAX_TYPES.TAX_TYPE_CODE. This naming convention (SS_ER → SS) is precisely what the search term "ss_er" targets. The result is a canonical list of federal employer liability tax types with their associated balance categories, element attributes, and effective dates, suitable for payroll costing, tax reporting, and integration extracts.

Underlying Base Objects

The view is defined over four documented base objects, all accessed through APPS synonyms:

The element and tax type tables are joined on ELEMENT_TYPE_ID (element to translation) and on the derived tax type code (element to tax type), while the two U.S. tax tables are joined on TAX_TYPE_ID.

Key Columns

  • TAX_TYPE_ID — primary key of the U.S. tax type record.
  • TAX_TYPE_CODE — federal tax code (for example SS, MEDICARE, FUTA), derived from the element name.
  • TAX_DOMAIN_CODE — restricted to FEDERAL in the view predicate.
  • LIMIT_TAX_FLAG — indicates whether a wage limit applies to the tax.
  • EE_OR_ER_CODE — identifies the employee- or employer-side balance category.
  • USER_REPORTING_NAME and BALANCE_CATEGORY_CODE — reporting label and balance classification (filtered to LIABILITY).
  • ELEMENT_NAME and ELEMENT_TYPE_ID — the payroll element identity.
  • EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — element dating for point-in-time analysis.
  • BUSINESS_GROUP_ID, PROCESSING_PRIORITY, and LEGISLATION_CODE — organizational and processing attributes.

Common Use Cases and Queries

Typical uses include validating that a federal employer liability element is correctly mapped to its tax type, driving extracts that feed tax filing or third-party remittance systems, and reconciling payroll liability balances by element. A representative query lists all federal liability element types:

SELECT tax_type_code,
       element_name,
       user_reporting_name,
       processing_priority
FROM   apps.pay_us_fed_liability_types_v
ORDER  BY tax_type_code;

To isolate the Social Security employer liability that the "ss_er" search implies:

SELECT element_name, tax_type_code, ee_or_er_code
FROM   apps.pay_us_fed_liability_types_v
WHERE  element_name = 'SS_ER';

Point-in-time analysis of currently effective liabilities:

SELECT element_name, effective_start_date, effective_end_date
FROM   apps.pay_us_fed_liability_types_v
WHERE  TRUNC(SYSDATE) BETWEEN effective_start_date AND effective_end_date;