Search Results grade_dp




Overview
Explore in AI Chat

Overview

APPS.EDW_HR_GRD_GRADES_LCV is a view in the Oracle E-Business Suite HRMS (Human Resources) reporting schema, part of the Oracle HR Intelligence / Enterprise Data Warehouse (EDW) layer. The view presents grade definitions in a flattened, reporting-friendly format suitable for extract, transformation, and load operations as well as for direct querying by BI tools such as Oracle Business Intelligence Applications (OBIA). It is derived from the underlying EDW base view EDWBV_HR_GRD_GRADES_LCV and is defined with an LCV ("logical compare view" / localized code value) naming convention typical of the HRMS EDW wrappers. In the context of Oracle EBS 12.1.1 and 12.2.2, this object exposes standardized grade attributes — including the grade's display name, its effective dates, sequence, business group ownership, and surrogate identifiers — allowing downstream reporting and integration processes to consume consistent HR grade data across source systems and localization variations.

Underlying Base Objects

According to the documented ETRM metadata, the view is defined by a single SELECT statement over EDWBV_HR_GRD_GRADES_LCV, with no additional documented base objects. The header comment in the source (hrisvgd.odf 115.5 2001/11/01) indicates the view has been in place since the early HRMS release cycle and is retained in later releases, including 12.1.1 and 12.2.2. The view does not itself own or store data; it is a projection over the base EDW view. Its similarity to the core HR grade tables (PER_GRADES, PER_GRADES_TL, PER_GRADE_DEFINITIONS) means that the EDW layer has already reconciled the translated and definition components into a single denormalized structure, and the LCV wrapper simply re-exposes that structure with an explicit column list.

Key Columns

  • GRADE_PK — Surrogate primary key used within the EDW model to uniquely identify a grade row.
  • GRADE_DP — The grade display name (the "display" attribute, essential for user-facing and localized reporting).
  • NAME — The internal grade name, distinct from the display value.
  • INSTANCE — Identifies the source EBS instance from which the row was extracted.
  • ALL_FK — Foreign-key reference used in EDW/OBIA star-schema navigation.
  • GRADE_DATE_FROM / GRADE_DATE_TO — Effective date range of the grade definition.
  • GRADE_SEQUENCE — Ordering/sequence number for the grade within its legislative or grade scale context.
  • BUSINESS_GROUP / BUSINESS_GROUP_ID — The HR business group (organization) that owns the grade.
  • GRADE_ID, GRADE_DEFINITION_ID — Source identifiers linking back to the base HR grade tables.
  • LAST_UPDATE_DATE / CREATION_DATE — Audit columns supporting incremental and delta-based extraction.
  • Trailing NULL columns — Eight placeholder columns appended to the SELECT list, reserved for future or optional attributes.

Common Use Cases and Queries

The view is used for grade-level reporting and for populating OBIA HR subject areas. A common pattern is filtering by business group and effective date to retrieve the current grade set. For example:

SELECT grade_pk, name, grade_dp, business_group
FROM apps.edw_hr_grd_grades_lcv
WHERE business_group_id = :p_bg_id
AND SYSDATE BETWEEN grade_date_from AND NVL(grade_date_to, SYSDATE);

Incremental extraction scenarios typically use LAST_UPDATE_DATE:

SELECT grade_id, name, grade_dp, last_update_date
FROM apps.edw_hr_grd_grades_lcv
WHERE last_update_date > :p_high_date;

Because the view exposes GRADE_DP directly, it is frequently joined to assignment and payroll datasets to produce grade-lookup columns in enterprise reports, avoiding the need to resolve translation (TL) tables separately. The combination of INSTANCE and GRADE_PK makes it suitable for cross-instance consolidation efforts in a multi-organization deployment.