Search Results pay_us_fed_liability_types_v




Overview
Explore in AI Chat

Overview

PAY_US_FED_LIABILITY_TYPES_V is an APPS-owned database view in the Oracle E-Business Suite Payroll (PAY) product family. It exposes US federal tax liability element types alongside their associated tax type and balance attributes, giving payroll developers, report authors, and integration specialists a single denormalized source for federal withholding liability configuration. The view carries a VALID status and is shipped in both the 12.1.1 and 12.2.2 releases.

Rather than storing data, the view joins payroll element type definitions to US federal tax types and tax balance rows, filtered to the federal domain and the liability balance category. Its practical purpose is to answer configuration questions such as which payroll elements represent employer-side federal liabilities, what balance category each maps to, and what reporting name and processing priority apply. Because it returns the element type identifier and effective dating, it is also suitable for date-effective lookups during payroll processing analysis and for reconciliation of tax liability balances against general ledger postings.

Underlying Base Objects

The view is defined over four synonym-referenced base objects in the APPS schema:

The joins are driven by ELEMENT_TYPE_ID between the element type and its translation, and by TAX_TYPE_ID between the tax type and tax balance. Two binding filters restrict the result set: TAX_DOMAIN_CODE = 'FEDERAL' and BALANCE_CATEGORY_CODE = 'LIABILITY'.

Key Columns

  • TAX_TYPE_ID — primary identifier of the federal tax type.
  • TAX_TYPE_CODE — code of the tax type; matched to the uppercase element name after stripping the '_ER' suffix.
  • TAX_DOMAIN_CODE — constrained to 'FEDERAL' in this view.
  • LIMIT_TAX_FLAG — indicates whether the tax is subject to a wage limit.
  • BALANCE_CATEGORY_CODE — constrained to 'LIABILITY'.
  • EE_OR_ER_CODE — distinguishes employee versus employer liability.
  • USER_REPORTING_NAME — the reporting label for the liability.
  • ELEMENT_NAME — the payroll element name; the view matches only 'MEDICARE_ER', 'FUTA', and 'SS_ER'.
  • ELEMENT_TYPE_ID — identifier of the element type; the principal join key.
  • EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — date-effective boundaries of the element type.
  • BUSINESS_GROUP_ID — the business group owning the element type.
  • PROCESSING_PRIORITY — relative processing order for the element.
  • LEGISLATION_CODE — the legislative context of the element type.

Common Use Cases and Queries

The view is typically used to audit employer federal liability element configuration, to source reporting names for balance reconciliation, and to validate effective dating of federal liability elements prior to a payroll run or upgrade.

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

SELECT element_type_id,
       element_name,
       business_group_id,
       legislation_code
  FROM apps.pay_us_fed_liability_types_v
 WHERE SYSDATE BETWEEN effective_start_date AND NVL(effective_end_date, SYSDATE);

SELECT t.element_name, t.user_reporting_name
  FROM apps.pay_us_fed_liability_types_v t
 WHERE t.ee_or_er_code = 'ER';

Oracle proprietorship applies to all referenced objects; the view should be queried read-only and its filters treated as fixed constraints when building downstream reports.