Search Results hr_organization_units_v

Overview

The APPS.BEN_ELIG_ORG_UNIT_PRTE_D view is a denormalized, presentation-layer object within the Oracle Advanced Benefits (BEN) module. It exposes the eligibility organization unit participation records held in the underlying BEN_ELIG_ORG_UNIT_PRTE_F table in a form that resolves foreign keys into human-readable descriptions for reporting and integration purposes. The view is flagged as "Retrofitted," indicating that it was adapted during the transition to the current data model, and it remains VALID in both release 12.1.1 and 12.2.2.

Users frequently reach this object indirectly when searching for the hr_organization_units_v view. The relationship is direct: BEN_ELIG_ORG_UNIT_PRTE_D joins to HR_ORGANIZATION_UNITS_V to obtain the organization name, which is why the two objects commonly appear together in benefits eligibility queries.

Underlying Base Objects

The view is defined over the following documented base objects:

• BEN_ELIG_ORG_UNIT_PRTE_F (SYNONYM) — the primary eligibility organization unit participation base table, aliased as EOU, supplying the ID, effective dates, exclusion flag, order number, and audit columns.
• HR_ORGANIZATION_UNITS_V (VIEW) — aliased ORG, providing the organization name and the join keys ORGANIZATION_ID and BUSINESS_GROUP_ID.
• HR_LOOKUPS (VIEW) — aliased HL1, joined on EXCLD_FLAG with LOOKUP_TYPE 'YES_NO' to translate the exclusion flag into a meaning.
• FND_USER (SYNONYM) — aliased FUSER, resolving the LAST_UPDATED_BY user ID to a user name.
• HR_API, HR_GENERAL, and HR_SECURITY (packages) — referenced by the underlying HR views to enforce business-group security and other HR rules.

The joins on HR_LOOKUPS and FND_USER are outer joins, so participation rows are preserved even when a lookup or user record cannot be resolved. The join to HR_ORGANIZATION_UNITS_V is an inner join, meaning the organization must exist and pass security validation for the row to appear.

Key Columns

• ELIG_ORG_UNIT_PRTE_ID — primary identifier for the participation record.
• EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — date-tracked validity window of the record.
• ORGANIZATION_NAME — the organization unit name sourced from HR_ORGANIZATION_UNITS_V.
• EXCLD_FLAG_MEANING — decoded YES/NO meaning of the exclusion flag, indicating whether the unit is included or excluded from the eligibility rule.
• ORDR_NUM — the ordering sequence applied to the organization unit within the eligibility definition.
• LAST_UPDATE_DATE / LAST_UPDATED_BY — standard audit columns; LAST_UPDATED_BY is complemented by the resolved user name from FND_USER.

Common Use Cases and Queries

This view is typically used to audit which organization units participate in a given eligibility configuration and to report on that configuration without navigating the base tables.

SELECT elig_org_unit_prte_id,
       organization_name,
       excld_flag_meaning,
       ordr_num,
       effective_start_date,
       effective_end_date
FROM   apps.ben_elig_org_unit_prte_d
WHERE  TRUNC(SYSDATE) BETWEEN effective_start_date AND effective_end_date;

Because the view passes through HR security packages, results are restricted to the organizations the querying responsibility is authorized to see, making it suitable for both reporting and controlled integration extracts. When combined with organization unit criteria in an eligibility rule, it provides a convenient bridge between benefits setup and the HR organization hierarchy referenced through hr_organization_units_v.