Search Results per_cagr_grades




Overview
Explore in AI Chat

Overview

The PER_CAGR_GRADES table is a core data object within the Oracle E-Business Suite Human Resources (HR) module, specifically for releases 12.1.1 and 12.2.2. It serves as a reference table that stores the defined grades within a collectively agreed grading structure. In the context of workforce management, a collective agreement is a formal contract negotiated between an employer and a labor union that governs terms of employment. This table is essential for mapping standard job grades, as defined in the enterprise's grade structures, to the specific grades outlined in such a labor agreement. Its primary role is to maintain the formal linkage between the organization's internal grading hierarchy and the legally or contractually binding grades established through collective bargaining.

Key Information Stored

The table's structure is designed to enforce data integrity and define relationships. The most critical column is CAGR_GRADE_ID, which serves as the table's unique primary key identifier for each record. Two other columns form a unique key constraint, ensuring that a specific grade definition can only appear once within a given structure. These are CAGR_GRADE_STRUCTURE_ID, a foreign key linking to the PER_CAGR_GRADE_STRUCTURES table to identify the overarching collective agreement structure, and CAGR_GRADE_DEF_ID, a foreign key linking to the PER_CAGR_GRADES_DEF table, which holds the definitional details (like name, sequence) of the individual grade itself. The table acts as a junction, connecting a structure to its constituent grade definitions.

Common Use Cases and Queries

This table is central to processes involving unionized employees or those covered under specific labor contracts. Common use cases include generating reports on the composition of collective agreements, validating employee assignments against agreed-upon grades during payroll processing, and supporting compliance audits. A typical query would join PER_CAGR_GRADES to its related definition and structure tables to list all grades within an agreement. For example, to find grades for a specific agreement structure, one might use:

  • SELECT pgd.NAME, pgd.SEQUENCE
  • FROM PER_CAGR_GRADES pcg,
  • PER_CAGR_GRADE_STRUCTURES pcgs,
  • PER_CAGR_GRADES_DEF pgd
  • WHERE pcg.CAGR_GRADE_STRUCTURE_ID = pcgs.CAGR_GRADE_STRUCTURE_ID
  • AND pcg.CAGR_GRADE_DEF_ID = pgd.CAGR_GRADE_DEF_ID
  • AND pcgs.NAME = '<Agreement Structure Name>';

Technical consultants often reference this table when debugging grade-related data issues or building custom integrations for HR and payroll systems.

Related Objects

PER_CAGR_GRADES maintains defined foreign key relationships with two primary tables, as documented in the ETRM metadata. These relationships are fundamental to its purpose and data integrity.

  • PER_CAGR_GRADE_STRUCTURES: Linked via the column PER_CAGR_GRADES.CAGR_GRADE_STRUCTURE_ID. This table defines the overall collective agreement grading structure to which these grades belong.
  • PER_CAGR_GRADES_DEF: Linked via the column PER_CAGR_GRADES.CAGR_GRADE_DEF_ID. This reference table holds the master definitional attributes for a grade, such as its name and sequence number, which are then instantiated within a specific agreement structure via the PER_CAGR_GRADES table.

These relationships create a hierarchy where a GRADE_STRUCTURE contains multiple GRADES, each of which points to a single GRADE_DEFinition.