Search Results org_change_flag




Overview
Explore in AI Chat

Overview

APPS.EDW_HR_ASCH_ASG_CHNG_LCV is a reporting view within the Oracle E-Business Suite HR Analytics (Enterprise Data Warehouse, EDW) layer. It exposes assignment change records sourced from the HR assignment-change entity and is intended primarily for extract, reporting, and integration consumption rather than transactional processing. Because it resides in the APPS schema and is prefixed with the EDW naming convention, it functions as a governed, read-friendly projection of the underlying change-tracking data used by Oracle HRMS Analytics and downstream warehouse loads.

The object is a lightweight view. Its definition selects a defined set of columns from the view EDWBV_HR_ASCH_ASG_CHNG_LCV, which is the documented base object. This layered pattern is characteristic of EDW HR objects: a business view (EDW_...) selects from a base warehouse view (EDWBV_...), presenting a stable column contract to reporting tools and ETL routines while insulating them from changes in the underlying physical tables.

The view is relevant to change-detection and delta-processing scenarios, particularly around the assignment changes that occur when an employee's organization, job, position, grade, or geography is modified. The column name grd_change_flag, which prompted the search that leads to this object, is one of the several change-indicator columns exposed by the view.

Underlying Base Objects

The documented metadata states that the view is defined over a single documented base object: EDWBV_HR_ASCH_ASG_CHNG_LCV. No physical base tables are enumerated in the ETRM metadata; the base object is itself a view, so the lineage continues beyond it into the HR Analytics warehouse objects that hold the persisted assignment-change data. Accordingly, all columns exposed by APPS.EDW_HR_ASCH_ASG_CHNG_LCV are inherited directly from EDWBV_HR_ASCH_ASG_CHNG_LCV without transformation.

The metadata records the relationship as a straightforward pass-through: the SELECT list in the outer view maps column-for-column to the base view, and the FROM clause references only that base view. Practitioners tracing the full lineage should treat EDWBV_HR_ASCH_ASG_CHNG_LCV as the immediate parent and continue investigation below it to reach the underlying HRMS transaction and change-tracking tables.

Key Columns

  • asg_change_pk — Primary key of the assignment-change record; the identifier for each change event.
  • all_fk — Surrogate foreign key linking the change record to the broader HR warehouse dimension structure.
  • creation_date / last_update_date — Standard audit columns recording when the row was created and last modified.
  • instance — Instance or source-system identifier, supporting multi-instance warehouse consolidation.
  • name — Descriptive name associated with the assignment-change record.
  • asg_change_dp — Assignment change date (date part), indicating when the change took effect.
  • org_change_flag — Indicates an organization change on the assignment.
  • job_change_flag — Indicates a job change on the assignment.
  • pos_change_flag — Indicates a position change on the assignment.
  • grd_change_flag — Indicates a grade change on the assignment; the column referenced in the search.
  • geog_change_flag — Indicates a geography or location change.
  • other_change_flag — Captures any change not covered by the specific category flags.
  • change_status — Status of the change record.
  • asg_change_code — Code classifying the type of assignment change.

The five NULL placeholders in the SELECT list indicate reserved positions retained for compatibility with the expected EDW column contract.

Common Use Cases and Queries

Typical usage filters on one or more change flags to isolate the assignment changes of interest, frequently constrained by date for periodic delta extracts. To retrieve grade-change records in a given period:

  • SELECT asg_change_pk, all_fk, name, asg_change_dp, grd_change_flag, change_status FROM apps.edw_hr_asch_asg_chng_lcv WHERE grd_change_flag = 'Y' AND asg_change_dp BETWEEN :start_date AND :end_date;
  • Reporting on all change categories for a single event: SELECT asg_change_kp, org_change_flag, job_change_flag, pos_change_flag, grd_change_flag, geog_change_flag, other_change_flag FROM apps.edw_hr_asch_asg_chng_lcv WHERE asg_change_pk = :pk;
  • Aggregating change counts by type for trend analysis, grouping on asg_change_code with COUNT(*).

Because the view is read-only and built on warehouse objects, it is suited to incremental loads and analytics rather than OLTP writes.