Search Results per_cagr_grades_def




Overview
Explore in AI Chat

Overview

The PER_CAGR_GRADES_DEF table is a core data object within the Oracle E-Business Suite Human Resources (PER) module, specifically for versions 12.1.1 and 12.2.2. It serves as the key flexfield combinations table for collective agreement grades. In the context of Oracle HRMS, a collective agreement (often linked to union or labor contracts) defines specific grades and pay scales. This table stores the unique, validated combinations of key flexfield segments that define a specific grade within such an agreement. Its primary role is to provide a centralized, normalized definition for grades, which are then referenced by assignment and grade detail records to ensure data integrity and consistency across the application.

Key Information Stored

The table's structure is centered on its primary key and the flexfield combination it represents. The most critical column is CAGR_GRADE_DEF_ID, a unique system-generated identifier (sequence number) for each grade definition combination. This ID acts as the foreign key for all related records. While the specific descriptive columns (like SEGMENT1, SEGMENT2, etc.) are defined by the flexfield configuration and are not detailed in the provided metadata, the table inherently stores the concatenated code and description for the combination. Additional standard Oracle columns, such as CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, and LAST_UPDATED_BY, are also present for auditing purposes.

Common Use Cases and Queries

This table is primarily accessed indirectly through the application's grade and assignment interfaces or via reporting to analyze workforce structures tied to collective agreements. A common reporting use case is to list all defined grade combinations for a specific agreement or to find assignments associated with a particular grade. A typical SQL query would join PER_CAGR_GRADES_DEF to related tables using the CAGR_GRADE_DEF_ID.

  • Sample Query (Basic Join): To retrieve assignment details with their associated grade definition, a query would join: SELECT paa.assignment_number, pcgd.cagr_grade_def_id FROM per_all_assignments_f paa, per_cagr_grades_def pcgd WHERE paa.cagr_grade_def_id = pcgd.cagr_grade_def_id;
  • Data Validation: The table ensures that only pre-defined, valid grade combinations can be assigned to an employee's record (PER_ALL_ASSIGNMENTS_F).

Related Objects

As documented in the provided metadata, PER_CAGR_GRADES_DEF maintains strict foreign key relationships with two principal tables, using the CAGR_GRADE_DEF_ID column as the link.

  • PER_ALL_ASSIGNMENTS_F: This is the master assignments table. The column PER_ALL_ASSIGNMENTS_F.CAGR_GRADE_DEF_ID references PER_CAGR_GRADES_DEF.CAGR_GRADE_DEF_ID. This relationship ties an employee's assignment to a specific collective agreement grade definition.
  • PER_CAGR_GRADES: This table stores detailed information about each grade, such as effective start and end dates, sequence, and potentially rate values. The column PER_CAGR_GRADES.CAGR_GRADE_DEF_ID references PER_CAGR_GRADES_DEF.CAGR_GRADE_DEF_ID, allowing multiple time-effective grade records (PER_CAGR_GRADES) to share the same core definition.

These relationships establish PER_CAGR_GRADES_DEF as the central reference point for collective agreement grade structures within the HR schema.