Search Results edw_hr_age_band_pkg




Overview
Explore in AI Chat

Overview

EDW_HR_AGE_BAND_PKG is a small utility package in the APPS schema that supports the Oracle E-Business Suite HR analytics and Enterprise Data Warehouse (EDW) reporting layer. Its name indicates it belongs to the family of derived HR reporting helpers prefixed with EDW_HR, which translate raw employee demographic attributes into the standardized dimensions used by Oracle HRMS intelligence dashboards and workforce analytics. The specific responsibility of this package is age-band derivation: converting an employee's numeric age value into the coded band value used by age-band reporting structures in the HR warehouse.

The package is classified as OTHER in the ETRM repository rather than as a public or private API, which reflects its role as an internal computational helper rather than a transactional business API. It does not create, update, or validate HR records; it performs a pure lookup transformation. The stored package header ($Header: hriekagb.pkh 120.0 2005/05/29) shows that the interface has been stable since the early 11i-era HR intelligence builds and was carried forward unchanged into Release 12.1.1 and 12.2.2.

Key Procedures and Functions

The package spec exposes exactly one documented program unit:

  • AGE_BAND_FK — a function returning VARCHAR2 that accepts an age value and returns the corresponding age-band foreign key. It maps a numeric age onto the age-band code used elsewhere in the HR/EDW model, allowing reports and collection programs to group or join employee populations by predefined age ranges without repeating the banding logic. This is a scalar, deterministic transformation: one age in, one band code out.

No other procedures or functions are documented for this package. The package is therefore a single-purpose interface and is not designed to be extended by callers.

Tables Accessed

The ETRM record documents no tables referenced through APPS synonyms. This is consistent with the nature of the package: age-band definitions in Oracle HRMS are typically held in the age-band lookup structures that the HR intelligence layer resolves indirectly, and the function returns a foreign key value rather than querying a business entity table directly. Callers that require the actual band boundaries or labels resolve them separately against the underlying age-band definition. Because no tables are listed, direct SQL dependencies for EDW_HR_AGE_BAND_PKG should be confirmed against the deployed database in any implementation, as the ETRM metadata for utility packages of this age is occasionally incomplete.

Usage Notes

EDW_HR_AGE_BAND_PKG is referenced by eight other packages according to the documented metadata, indicating that it is consumed as a shared low-level utility rather than invoked directly by end users. Typical invocation paths include:

  • HR intelligence and EDW collection packages — the eight dependent packages call AGE_BAND_FK while populating or reconciling age-band facts, so that every collector applies an identical banding rule.
  • Concurrent programs — workforce analytics and HRMS reporting concurrent requests that load summary tables invoke it indirectly through those dependent packages.
  • Custom code — reporting extensions can call APPS.EDW_HR_AGE_BAND_PKG.AGE_BAND_FK directly, but should do so only where the standard EDW banding convention is required, and should not assume behavior beyond the documented age-to-band mapping.

Because the signature has remained unchanged since 2005, the package is safe to reference across both 12.1.1 and 12.2.2. Its narrow interface means there is little risk of side effects, but also means it carries no validation or error-handling contract beyond returning a band code.