Search Results hr_ath_empgroup_v




Overview
Explore in AI Chat

Overview

HR_ATH_EMPGROUP_V is a VALID database view owned by the APPS schema in Oracle E-Business Suite, classified under the PER (Human Resources) product family. As stated in the ETRM documentation, the view exists specifically "to support Authoria Integration," providing a streamlined, integration-ready projection of employee group data. Authoria (now part of the broader talent management and benefits communication ecosystem) required a stable, denormalized interface to Oracle HR organization data, and this view supplies exactly that: a read-only snapshot of internal Human Resources organizations that function as employee groups.

Rather than exposing the full complexity of the HR organization model — which spans multiple tables and descriptive flexfield segments — the view flattens the essential attributes: a group identifier, a group name, and validity dates. In Oracle EBS 12.1.1 and 12.2.2, this view remains available for backwards compatibility with legacy Authoria integrations and for any custom reporting that was built against it.

Underlying Base Objects

The view text joins two core HR objects: HR_ORGANIZATION_UNITS (exposed as a synonym/view in the APPS schema) aliased as O, and HR_ORGANIZATION_INFORMATION aliased as O3. The join is on ORGANIZATION_ID. The WHERE clause applies three critical filters: the ORG_INFORMATION_CONTEXT must equal 'CLASS', ORG_INFORMATION1 must equal 'HR_ORG', and ORG_INFORMATION2 must equal 'Y'. These conditions isolate only those organizations explicitly classified as HR organizations. An additional filter, INTERNAL_EXTERNAL_FLAG = 'INT', ensures only internal organizations are returned.

The documented base objects further include the HR_GENERAL and HR_SECURITY packages, which the view depends upon for organization classification and security context resolution. HR_GENERAL supplies the business group and organization classification logic, while HR_SECURITY governs data access based on the user's security profile, although the view definition itself uses a direct join rather than calling these packages explicitly in its SELECT text.

Key Columns

  • EMPLOYEE_GROUPID — The ORGANIZATION_ID converted to character format via TO_CHAR. This is the unique identifier Authoria used to map Oracle organizations to its own group construct.
  • NAME — The organization name (O.NAME), representing the human-readable label of the employee group.
  • START_DATE — The organization's DATE_FROM, indicating when the grouping became effective.
  • END_DATE — The organization's DATE_TO, with NVL logic substituting 12/31/4712 (the Oracle EBS "end of time" date) when no end date is defined, ensuring every row has a usable termination date.

Common Use Cases and Queries

Typical scenarios include extracting employee groups for third-party integration feeds, validating organization classifications, and building custom concurrent programs. A representative query follows:

  • SELECT employee_groupid, name, start_date, end_date FROM apps.hr_ath_empgroup_v WHERE SYSDATE BETWEEN start_date AND end_date ORDER BY name; — retrieves currently active employee groups.
  • SELECT employee_groupid, name FROM apps.hr_ath_empgroup_v WHERE name LIKE 'US%'; — filters groups by naming convention.
  • Joining the view to HR_ORGANIZATION_UNITS or PER_ALL_PEOPLE_F via organization_id supports assignment-based reporting, allowing analysts to attribute employees to their corresponding Authoria employee group.

Because the view relies on HR_SECURITY indirectly through its base objects, query results may be restricted by the caller's security profile. Organizations should review this view if Authoria integrations are retired, though it remains a lightweight reference for HR organization classification.