Search Results lookup




Overview
Explore in AI Chat

Overview

The view EDWBV_HR_ASCH_ASG_CHNG_LCV is an Oracle E-Business Suite database object owned by the APPS schema and classified under the HRI (Human Resources Intelligence) product family. Within the Oracle EBS 12.1.1 and 12.2.2 architectures, HRI objects support the Oracle HRMS Intelligence / Daily Business Intelligence (DBI) reporting layer, and this particular view functions as a dimension-level lookup value source for the assignment change ("ASCH") analytic subject area. The "LCV" suffix conventionally denotes a "List of Values / Lookup Code Value" construct, and the object plays the role of a discrete dimension that records which categories of assignment change occurred — organisational unit, job, position, grade, geography, or other changes — together with the status of the change record.

Because the view is a reporting-layer dimension rather than a transactional entity, it is typically referenced by the ETL and business intelligence processes that populate and query HRI star schemas, exposing a materialised, de-normalised projection of the HR lookup codes that drive assignment-change analysis.

Underlying Base Objects

The documented view text reveals that EDWBV_HR_ASCH_ASG_CHNG_LCV is defined over a seven-way cartesian join of HR_LOOKUPS, filtered on LOOKUP_TYPE = 'YES_NO'. Each of the seven subquery aliases (T1 through T7) selects the same set of columns — a decoded lookup value produced by HR_GENERAL.DECODE_LOOKUP('YES_NO', LOOKUP_CODE), the raw LOOKUP_CODE, and the CREATION_DATE and LAST_UPDATE_DATE audit columns — from the HR_LOOKUPS table in the APPS schema.

The join produces the cross-product of all YES/NO lookup code values across the seven change dimensions, which is why each alias maps to a distinct semantic role (organisation, job, position, grade, geography, other, and status). No documented base objects beyond HR_LOOKUPS are recorded in the ETRM metadata; the view therefore depends solely on the HR lookup infrastructure and the HR_GENERAL utility package.

Key Columns

Common Use Cases and Queries

This view is most frequently used to resolve assignment-change flags into descriptive values for HRI reports, or to validate that the change dimension has been correctly populated. A representative query follows:

SELECT asg_change_pk, name, org_change_flag, job_change_flag, pos_change_flag, grd_change_flag, geog_change_flag, other_change_flag, change_status FROM apps.edwbv_hr_asch_asg_chng_lcv WHERE org_change_flag IS NOT NULL;

Because each flag is rendered through HR_GENERAL.DECODE_LOOKUP, analysts may also join this view back to HRI fact tables on ASG_CHANGE_PK to enrich assignment-change analytics with human-readable lookup descriptions.