Search Results per_cagr_grades




Overview
Explore in AI Chat

Overview

PER_CAGR_GRADES is a reference table in the HR schema of Oracle E-Business Suite, belonging to the PER (Human Resources) product family. It stores the collectively agreed grades associated with a Collective Agreement. In EBS 12.1.1 and 12.2.2, the table functions as the intersection entity that links a specific collective agreement grade definition to the grade structure within which that grade is applied.

From a Data Vault modeling perspective, the FK topology suggests this object behaves as a link. It resolves a many-to-many relationship between PER_CAGR_GRADE_STRUCTURES and PER_CAGR_GRADES_DEF, carrying its own surrogate key and descriptive attributes. This classification is a modeling suggestion derived from the foreign key structure rather than a documented Data Vault design.

Key Information Stored

The table contains ten documented columns. The most significant are:

A second unique index, PER_CAGR_GRADES_UK1, spans CAGR_GRADE_STRUCTURE_ID and CAGR_GRADE_DEF_ID. This is the business-key candidate: it enforces that a given grade definition appears at most once within any single grade structure, preventing duplicate assignments at the application level.

Common Use Cases and Queries

Typical usage involves resolving the grades available within a collective agreement structure, or determining which structures reference a given grade definition. A basic join retrieves the populated grade list for a structure:

  • Query all grades for a structure: SELECT g.CAGR_GRADE_ID, g.CAGR_GRADE_DEF_ID, g.SEQUENCE FROM HR.PER_CAGR_GRADES g WHERE g.CAGR_GRADE_STRUCTURE_ID = :structure_id ORDER BY g.SEQUENCE;
  • Resolve definition detail: join PER_CAGR_GRADES to PER_CAGR_GRADES_DEF on CAGR_GRADE_DEF_ID to obtain grade names and attributes.
  • Reverse lookup: join PER_CAGR_GRADE_STRUCTURES on CAGR_GRADE_STRUCTURE_ID to find all structures using a grade definition.
  • Change tracking: filter on LAST_UPDATE_DATE for incremental extracts and audit reconciliation.

Reporting scenarios include collective agreement grade listings, structure composition reports, and gap analysis comparing grade definitions against the structures that consume them. Because the table is a pure intersection with minimal attributes, reporting joins are the primary integration pattern rather than direct transactional access.

Related Objects

  • PER_CAGR_GRADE_STRUCTURES — Parent table joined via PER_CAGR_GRADES.CAGR_GRADE_STRUCTURE_ID = PER_CAGR_GRADE_STRUCTURES.CAGR_GRADE_STRUCTURE_ID. Defines the structure context.
  • PER_CAGR_GRADES_DEF — Parent table joined via PER_CAGR_GRADES.CAGR_GRADE_DEF_ID = PER_CAGR_GRADES_DEF.CAGR_GRADE_DEF_ID. Supplies the grade definition.
  • PER_CAGR_GRADES_PK — Primary key constraint on CAGR_GRADE_ID.
  • PER_CAGR_GRADES_UK1 — Unique constraint on the structure/definition pair.
  • Collective agreement structures and definitions generally participate in the broader PER collective agreement framework, so dependent views and the standard EBS WHO audit consumers also reference this table.

Understanding this object is essential when extracting or reconciling collective agreement grade assignments in EBS 12.1.1 and 12.2.2 environments.