Results for “hr_org”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

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:

• HR_ORGANIZATION_UNITS — the organization definition itself, supplying name, effective dates, and the internal/external flag. The view filters on INTERNAL_EXTERNAL_FLAG = 'INT' so only internal organizations qualify.
• HR_ORGANIZATION_INFORMATION — the descriptive flexfield holding classification data. The view filters where ORG_INFORMATION_CONTEXT = 'CLASS', ORG_INFORMATION1 = 'HR_ORG', and ORG_INFORMATION2 = 'Y'.

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.