Results for “pay_element_types_f_vl”

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

Overview

PAY_ELEMENT_TYPES_F_VL is a vital view that provides a consolidated, current view of all Payroll element types within an Oracle E-Business Suite environment. As a 'View' object owned by the APPS schema and categorized under the PAY (Payroll) product module, it acts as a central repository for retrieving comprehensive definitions of payroll elements—the fundamental building blocks used to calculate earnings, deductions, and other payments for employees.

Its primary role is to serve as a secure, denormalized read-only interface for reporting, data extraction, and integration. By exposing a unified set of columns from underlying base tables, it allows developers, report writers, and integration specialists to access complex element type configurations without directly querying multiple underlying transactional tables. This view is essential for understanding the pay structure, as it contains critical information such as element names, classifications, processing rules, and associated formulas.

Underlying Base Objects

The view PAY_ELEMENT_TYPES_F_VL is defined over two key synonym-referenced base tables:

• PAY_ELEMENT_TYPES_F: This table stores the core, language-independent data for all element types. It includes all the key identifiers, flags, and business rules that define how a particular element behaves within payroll processing.
• PAY_ELEMENT_TYPES_F_TL: This table contains the language-dependent, translatable information for the element types. It holds the user-facing names, descriptions, and reporting names that are displayed in the application, which can be translated into different languages.

The view joins these two tables to present a single, comprehensive record for each element type, combining the functional configuration from the base table with the user-friendly text from the translation table, ensuring that all descriptive information is presented in the user's preferred language.

Key Columns

The view exposes a wide array of columns that define the characteristics of a payroll element type. Some of the most important include:

• ELEMENT_TYPE_ID: The unique system-generated primary key that identifies each element type.
• ELEMENT_NAME and REPORTING_NAME: The user-identifiable name of the element and the name that appears in reports (from the _TL table).
• CLASSIFICATION_ID: Links the element to its primary classification (e.g., Earnings, Deduction, Information), which determines its processing behavior.
• FORMULA_ID: The identifier for the formula that calculates the element's value during a payroll run.
• PROCESSING_TYPE and PROCESSING_PRIORITY: Define whether the element is processed during a payroll run and its sequence relative to other elements.
• BUSINESS_GROUP_ID: Defines the specific business group to which the element belongs, enabling multi-tenant configurations.
• EFFECTIVE_START_DATE and EFFECTIVE_END_DATE: Determine the date range during which the element type definition is active.
• Various Flags (e.g., MULTIPLE_ENTRIES_ALLOWED_FLAG, INDIRECT_ONLY_FLAG, ADJUSTMENT_ONLY_FLAG): Control specific behavioral rules, such as whether an element can have multiple entries or is reserved for indirect results.

Common Use Cases and Queries

This view is commonly used for creating custom reports and for data migration or integration with external systems. Typical scenarios involve generating a list of all active earnings elements, identifying elements that use a specific formula, or exporting element definitions for a data warehouse.

Sample Query: List all active element types for a specific business group

• SELECT element_name, reporting_name, classification_id, processing_type FROM pay_element_types_f_vl WHERE business_group_id = :p_business_group_id AND TRUNC(SYSDATE) BETWEEN effective_start_date AND effective_end_date ORDER BY element_name;

Sample Query: Find an element's formula and processing rules

• SELECT element_name, formula_id, processing_priority, multiple_entries_allowed_flag FROM pay_element_types_f_vl WHERE element_name = 'Regular Salary';

The view provides an efficient and standardized way to access this critical payroll configuration data, making it a fundamental object for any technical work involving Oracle Payroll element definitions.