Search Results per_cagr_grades_def




Overview
Explore in AI Chat

Overview

PER_CAGR_GRADES_DEF is a Key Flexfield (KFF) combinations table owned by the HR schema in Oracle E-Business Suite. It stores the valid, defined combinations of the "Collective Agreement Grades" key flexfield structure, which is used within Oracle Human Resources to classify employee assignments according to a negotiated collective agreement grade. Each row represents a distinct grade combination that can be referenced by an assignment or by a collective agreement grade record. The table is classified in the ETRM metadata under the PER – Human Resources product, and its object status is recorded as VALID.

Under a heuristic Data Vault classification mined from the foreign-key structure, PER_CAGR_GRADES_DEF leans toward a hub role. This is a modeling suggestion rather than a normative statement: the table holds a unique primary key (CAGR_GRADE_DEF_ID) that is referenced by multiple dependent tables, which is characteristic of a hub entity anchoring business keys.

Key Information Stored

The table contains 32 documented columns. The most significant are summarized below.

  • CAGR_GRADE_DEF_ID — the surrogate primary key, defined by the unique index PER_CAGR_GRADES_DEF_PK. It is the business-key candidate and the column referenced by all foreign keys pointing to this table.
  • ID_FLEX_NUM — the internal identifier of the key flexfield structure that governs the grade combination.
  • SEGMENT1 through SEGMENT20 — the flexfield segment values that collectively describe a grade combination. The number of populated segments depends on the configured structure.
  • CONCATENATED_SEGMENTS — the concatenated, display-ready representation of the segment values, commonly used in reporting and user-facing listings.
  • SUMMARY_FLAG — indicates whether the combination is a summary (parent) combination rather than a detail combination.
  • ENABLED_FLAG — controls whether the grade combination is active and selectable.
  • START_DATE_ACTIVE and END_DATE_ACTIVE — the effective date range during which the combination is valid.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — the standard Oracle EBS audit columns tracking record creation and modification.

Common Use Cases and Queries

This table is typically queried when reporting on assignments tied to collective agreement grades, validating grade combinations, or building analytic extracts. A common pattern resolves an assignment to its grade definition via the foreign key PER_ALL_ASSIGNMENTS_F.CAGR_GRADE_DEF_ID.

  • Listing enabled grade combinations for a given flexfield structure with their concatenated display values.
  • Joining assignments to grade definitions to produce headcount or grade-distribution reports, filtered by the effective date range.
  • Feeding data warehouse extracts (for example the HR EDW activity tables) that carry CAGR_GRADE_DEF_ID.

A representative query pattern:

  • SELECT a.assignment_id, a.cagr_grade_def_id, g.concatenated_segments FROM per_all_assignments_f a, per_cagr_grades_def g WHERE a.cagr_grade_def_id = g.cagr_grade_def_id AND g.enabled_flag = 'Y';

Related Objects

The following objects are the most significant referencing or related tables based on the documented foreign-key relationships.

  • PER_ALL_ASSIGNMENTS_F — references CAGR_GRADE_DEF_ID, linking employee assignments to their grade definition.
  • PER_CAGR_GRADES — references CAGR_GRADE_DEF_ID, associating collective agreement grade records with the defined combination.
  • HR_EDW_WRK_ACTVTY_F — the HR data warehouse work-activity fact, referencing CAGR_GRADE_DEF_ID.
  • HR_EDW_WRK_ACTVTY_FSTG — the corresponding staging table, also carrying CAGR_GRADE_DEF_ID.
  • The key flexfield definition objects (via ID_FLEX_NUM) that govern the segment structure of the grade combination.