Results for “user_reporting_name”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The PAY_US_FED_ER_WAGE_TYPES_V view is a payroll reporting object owned by the APPS schema within the Oracle E-Business Suite Payroll (PAY) module. It presents a consolidated, denormalized result set describing United States federal employer-side wage and tax element types. The view joins element type definitions to their US federal tax type and tax balance definitions, filtering specifically for employer-level (ER) federal tax processing. Its role is to support reporting, integration, and validation of federal employer wage types such as Medicare, Social Security, and FUTA, which must be mapped to their corresponding payroll element types and balance categories.

Because it encapsulates multi-table joins and hard-coded filter logic, the view provides a stable access point for developers, report authors, and integration specialists who need to reconcile payroll element definitions against federal tax configuration without reconstructing the underlying joins themselves. In EBS 12.1.1 and 12.2.2 the view is documented as VALID, and it is exposed in the standard APPS schema alongside other payroll reporting views.

Underlying Base Objects

Per the documented ETRM metadata, the view is defined over four base objects, accessed through synonyms in the APPS schema:

• PAY_ELEMENT_TYPES_F — the base element type definition table, supplying the element name, element type ID, effective dates, business group, processing priority, and legislation code.
• PAY_ELEMENT_TYPES_F_TL — the translation table for element types, supplying the user-facing element name as resolved for the current session language via USERENV('LANG').
• PAY_US_TAX_TYPES — the US tax type definition table, supplying tax type ID, limit tax flag, tax domain code, and tax type code.
• PAY_US_TAX_BALANCES — the US tax balance definition table, supplying balance category code, employee/employer indicator, and user reporting name.

The joins link element type IDs between the definition and translation tables, tax type IDs between tax types and tax balances, and the element name to the tax type code through string replacement. The view effectively constrains the universe to a small, well-defined set of federal employer wage types.

Key Columns

• TAX_TYPE_ID — identifier of the associated US tax type.
• LIMIT_TAX_FLAG — indicates whether the tax is subject to a wage limit.
• TAX_DOMAIN_CODE — tax domain; constrained to FEDERAL by the view definition.
• TAX_TYPE_CODE — the tax type code, aligned to the element name.
• BALANCE_CATEGORY_CODE — restricted to TAXABLE or SUBJECT.
• EE_OR_ER_CODE — employee or employer indicator; constrained to ER.
• USER_REPORTING_NAME — reporting label for the tax balance.
• ELEMENT_NAME — element name, filtered to MEDICARE_ER, FUTA, or SS_ER.
• ELEMENT_TYPE_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE, BUSINESS_GROUP_ID, PROCESSING_PRIORITY, LEGISLATION_CODE — element definition attributes.

Common Use Cases and Queries

Typical uses include auditing federal employer wage type configuration, validating that element-to-tax mappings exist, and driving downstream integrations. A representative query lists all federal employer wage types:

• SELECT element_name, tax_type_code, balance_category_code, user_reporting_name, effective_start_date, effective_end_date FROM apps.pay_us_fed_er_wage_types_v ORDER BY element_name;
• Filter by business group to isolate a specific legislative configuration: WHERE business_group_id = :p_bg_id.
• Join the view to payroll balance results by element_type_id to reconcile taxable employer balances.

The view should be treated as read-only reporting infrastructure; its restrictive filters mean it will not surface non-federal or employee-side wage types.