Search Results pay_element_links_f




Overview
Explore in AI Chat

Overview

The PAY_ELEMENT_LINKS_F table is a core data structure within the Oracle E-Business Suite Payroll module (PAY). It serves as the master repository for defining eligibility rules for element types. An element link establishes the specific conditions under which a payroll element, such as an earnings or deduction, becomes available for assignment to an employee. This table is date-effective, as indicated by the '_F' suffix and the EFFECTIVE_START_DATE and EFFECTIVE_END_DATE columns, allowing eligibility rules to be maintained and tracked over time. Its primary role is to control the population of the PAY_ELEMENT_ENTRIES_F table, ensuring that only eligible elements can be entered for an employee.

Key Information Stored

The table stores the criteria that determine element eligibility. Its primary key is a composite of ELEMENT_LINK_ID, EFFECTIVE_START_DATE, and EFFECTIVE_END_DATE. The ELEMENT_LINK_ID uniquely identifies a specific link instance. Crucially, the table contains numerous foreign key columns that define the link's scope. These include BUSINESS_GROUP_ID, ORGANIZATION_ID, JOB_ID, POSITION_ID, GRADE_ID, LOCATION_ID, PEOPLE_GROUP_ID, and PAY_BASIS_ID. By populating these columns, a link can be restricted to specific organizational units, jobs, grades, or other assignment attributes. The ELEMENT_SET_ID allows for linking to a predefined group of elements. The COST_ALLOCATION_KEYFLEX_ID and BALANCING_KEYFLEX_ID columns store default accounting flexfield structures for costing and balancing purposes associated with the element link.

Common Use Cases and Queries

A primary use case is auditing and reporting on element eligibility. System administrators often query this table to understand why an element is or is not available for a given employee. A common diagnostic query involves joining to PER_ALL_ASSIGNMENTS_F to check an employee's assignment attributes against the criteria of a specific element link. For implementation support, a frequent task is to identify all links for a particular element type to review or modify their eligibility rules. Sample SQL to retrieve active links for a specific element type would be:

  • SELECT pel.element_link_id, pel.effective_start_date, pel.effective_end_date, pel.organization_id, pel.job_id
  • FROM pay_element_links_f pel
  • WHERE pel.element_type_id = &element_type_id
  • AND SYSDATE BETWEEN pel.effective_start_date AND pel.effective_end_date;

Another critical use case is during payroll processing, where the engine references this table to validate element entries and apply the correct default costing rules.

Related Objects

PAY_ELEMENT_LINKS_F has extensive relationships with other key HR and Payroll tables. It is centrally linked to PAY_ELEMENT_TYPES_F via the ELEMENT_TYPE_ID. The table references numerous dimension tables to define its eligibility criteria, including PER_JOBS, PER_ALL_POSITIONS, PER_GRADES, HR_ALL_ORGANIZATION_UNITS, HR_LOCATIONS_ALL, and PAY_PEOPLE_GROUPS. It also links to PAY_ELEMENT_SETS and PER_PAY_BASES. For costing, it references PAY_COST_ALLOCATION_KEYFLEX. The most direct dependent object is PAY_ELEMENT_ENTRIES_F, as entries are created based on valid links. Key APIs, such as those in the PAY_ELEMENT_LINK_API package, provide the programmatic interface for creating and maintaining records in this table.