Search Results hr_org




Overview
Explore in AI Chat

Overview

APPS.HR_ATH_EMPGROUP_V is a reporting view in Oracle E-Business Suite (validated against 12.1.1 and 12.2.2) that exposes Human Resources organizations flagged as employee groups. It presents a simplified, denormalized list of internal organizations whose classification designates them as an "HR_ORG" employee group, along with a start and end date bracketing their effective period.

The view exists to support downstream reporting, integration, and configuration of employee group assignments, particularly where Oracle Time and Labor, benefits, or payroll processes require a stable list of valid employee groups. By returning only the organization identifier, name, and effective dates, it hides the underlying flexfield classification structure and offers a clean key-and-label interface. The EMPLOYEE_GROUPID column is returned as a character string, matching the datatype expected by downstream employee group references.

Underlying Base Objects

The view is defined over two primary sources joined on ORGANIZATION_ID:

ETRM metadata additionally documents references to the packages HR_GENERAL and HR_SECURITY. HR_SECURITY supplies the organization security predicates that govern which organizations a given session may see, ensuring the view remains consistent with EBS security profiles. HR_GENERAL provides the shared HR utility logic used across these organization objects.

Key Columns

  • EMPLOYEE_GROUPID — TO_CHAR(O.ORGANIZATION_ID); the character-form organization identifier serving as the employee group key.
  • NAME — the organization name (O.NAME), used as the descriptive group label.
  • START_DATE — O.DATE_FROM; the effective start of the group definition.
  • END_DATE — NVL(O.DATE_TO, TO_DATE('12/31/4712','MM/DD/YYYY')); the effective end, defaulted to the standard high date when open-ended.

Common Use Cases and Queries

Typical uses include populating employee group list-of-values, validating employee group references in integrations, and reconciling Time and Labor or benefits configuration.

  • Retrieve all currently active employee groups: 
    SELECT employee_groupid, name, start_date, end_date
FROM   apps.hr_ath_empgroup_v
WHERE  SYSDATE BETWEEN start_date AND end_date;
  • Resolve a group name from an identifier: 
    SELECT name
FROM   apps.hr_ath_empgroup_v
WHERE  employee_groupid = :p_group_id;
  • Feed an integration extract with a stable key/label pair: 
    SELECT employee_groupid, name
FROM   apps.hr_ath_empgroup_v
ORDER  BY name;

Because HR_SECURITY participates, results are automatically restricted to organizations visible to the querying responsibility, making the view safe to expose directly to reporting consumers.