Search Results age_criteria

Overview

The APPS.PAYBV_ELEMENT_LINK_DETAIL_V view is a Business Intelligence (BIS) style reporting object within the Oracle E-Business Suite Payroll (PAY) module. It exposes element link configuration data in a denormalized, human-readable form, resolving foreign keys into descriptive names and decoding lookup codes into their translated meanings. Element links determine which elements apply to which employees, assignments, organizations, payrolls, and other criteria, making this view a central reference for payroll configuration analysis. It is defined in the APPS schema with VALID status and is available on both Oracle EBS 12.1.1 and 12.2.2.

The view is purpose-built for reporting and integration rather than transactional processing. Instead of requiring the consumer to join and decode dozens of base tables, it presents each element link with its qualifying criteria, distribution set, cost allocation, and input value defaults already resolved.

Underlying Base Objects

The documented base objects referenced by PAYBV_ELEMENT_LINK_DETAIL_V span several payroll and HR entities:

• PAY_ELEMENT_LINKS_F — the primary driving table, holding each link definition and its qualifying criteria.
• PAY_ELEMENT_TYPES_F and PAY_ELEMENT_TYPES_F_TL — provide the element name and processing type.
• PAY_ELEMENT_CLASSIFICATIONS and PAY_ELEMENT_CLASSIFICATIONS_TL — supply the element classification name.
• PAY_INPUT_VALUES_F and PAY_INPUT_VALUES_F_TL — input value definitions and translated names.
• PAY_LINK_INPUT_VALUES_F — the default values assigned to inputs on a link.
• PAY_ELEMENT_SETS — the distribution set name.
• PAY_PAYROLLS_F (itself a view) and PAY_COST_ALLOCATION_KEYFLEX — payroll and costing/balancing key flexfield data.
• Packages HR_BIS, HR_GENERAL, and HR_SECURITY — used for lookup decoding and for resolving people group, organization, job, position, grade, pay basis, and location IDs into names, while enforcing row-level security.

Key Columns

• ELEMENT_NAME, CLASSIFICATION_NAME, PROCESSING_TYPE_M — the decoded identity and processing behavior of the linked element.
• STANDARD_LINK_M, LINK_TO_ALL_PAYROLLS_FLAG, LINK_TO_ALL_PAYROLLS_FLAG_M — indicator flags for standard linking and payroll scope. The PAYROLL_NAME column uses DECODE on LINK_TO_ALL_PAYROLLS_FLAG so that "N" shows the specific payroll name and other cases resolve via the lookup type YES_NO_ALL (the term the user searched for), whose "A" value typically represents "All".
• AGE_CRITERIA, SERVICE_CRITERIA — qualifying age and length-of-service thresholds.
• LINK_START_DATE, LINK_END_DATE, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE — date ranges for the link and its effective-dated rows.
• PEOPLE_GROUP_NAME, ORGANIZATION_NAME, JOB_NAME, POSITION_NAME, GRADE_NAME, PAY_BASIS_NAME, LOCATION_NAME, EMPLOYMENT_CATEGORY_M — decoded eligibility criteria.
• COSTING, BALANCING, COSTABLE_TYPE_M, COST_ALLOCATION_KEYFLEX_ID, BALANCING_KEYFLEX_ID — costing and balancing flexfield information.
• INPUT_VALUE_NAME, INPUT_VALUE_UOM_M, INPUT_VALUE_DEFAULT, DISTRIBUTION_SET_NAME — input value defaults and distribution set context.

Common Use Cases and Queries

Typical uses include auditing which elements link to all payrolls, reviewing eligibility criteria per element, validating costing setups, and extracting configuration for migration or reconciliation. A representative query:

SELECT element_name,
       classification_name,
       payroll_name,
       link_to_all_payrolls_flag_m,
       age_criteria,
       service_criteria,
       effective_start_date,
       effective_end_date
FROM   apps.paybv_element_link_detail_v
WHERE  link_to_all_payrolls_flag = 'Y'
ORDER  BY element_name;

To inspect input value defaults for a given element:

SELECT element_name, input_value_name, input_value_default, input_value_uom_m
FROM   apps.paybv_element_link_detail_v
WHERE  element_name = 'My Element';

Because the view invokes HR_SECURITY, results are filtered by the querying user's security profile, so it is safe for use in self-service style reports. Joins to PAY_ELEMENT_LINKS_F on ELEMENT_LINK_ID can supplement additional attributes not exposed directly.