Search Results cagr_grade_def_id




Overview
Explore in AI Chat

Overview

The HR.PER_CAGR_GRADES table is a core data structure within the Oracle E-Business Suite Human Resources (HRMS) module, specifically supporting the Collective Agreements (CAGR) functionality. This table is critical for managing graded pay structures that are defined through collective bargaining agreements. It serves as a junction table that associates specific grade definitions with a grade structure, thereby establishing the valid grades available for assignments within a governed collective agreement. Its role is to provide a reference set of collectively agreed grades that can be applied to employee assignments, ensuring compensation and position management align with negotiated terms.

Key Information Stored

The table stores the relationship and ordering of grades within a collective agreement structure. The primary columns include CAGR_GRADE_ID, the system-generated unique identifier. The CAGR_GRADE_STRUCTURE_ID is a foreign key linking to the overarching grade structure (PER_CAGR_GRADE_STRUCTURES), while CAGR_GRADE_DEF_ID is a foreign key linking to the specific definition of the grade itself (PER_CAGR_GRADES_DEF). The SEQUENCE column dictates the ordinal position of the grade within its parent structure, which is essential for defining hierarchies and progression paths. Standard Oracle EBS audit columns (OBJECT_VERSION_NUMBER, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN) track row history and changes.

Common Use Cases and Queries

This table is central to reporting and validating grade assignments. A common use case involves generating a list of all available grades within a specific collective agreement structure for validation or selection in user interfaces. Another key scenario is auditing the grade hierarchy for compliance. A typical query to retrieve the grade hierarchy for a structure would be:

  • SELECT pgd.NAME, pcg.SEQUENCE FROM HR.PER_CAGR_GRADES pcg JOIN HR.PER_CAGR_GRADES_DEF pgd ON pcg.CAGR_GRADE_DEF_ID = pgd.CAGR_GRADE_DEF_ID WHERE pcg.CAGR_GRADE_STRUCTURE_ID = <structure_id> ORDER BY pcg.SEQUENCE;

For troubleshooting assignment data, one might join to assignment tables to verify which employees are assigned to which collectively agreed grades. The unique constraint on CAGR_GRADE_STRUCTURE_ID and CAGR_GRADE_DEF_ID ensures a grade definition cannot be added more than once to the same structure.

Related Objects

The table maintains defined foreign key relationships with two primary parent tables, forming the core of the collective agreement grade model. The relationship to PER_CAGR_GRADES_DEF via the CAGR_GRADE_DEF_ID column provides access to the grade's name and descriptive attributes. The relationship to PER_CAGR_GRADE_STRUCTURES via the CAGR_GRADE_STRUCTURE_ID column ties the grade to its specific structural context. The PER_CAGR_GRADES_FK2 index on CAGR_GRADE_DEF_ID facilitates efficient lookups from the grade definition to its usage in structures. This table is a likely parent for assignment-related tables that store which collective agreement grade is applied to an employee's assignment.