Search Results per_cagr_grade_structures




Overview
Explore in AI Chat

Overview

The PER_CAGR_GRADE_STRUCTURES table is a core data definition table within the Oracle E-Business Suite Human Resources (PER) module, specifically supporting the functionality for Collective Agreements. It serves as a configuration repository that defines which Grade Key Flexfield structures are valid and applicable for a specific collective agreement. A collective agreement, often linked to labor unions or regional regulations, governs employment terms. This table essentially maps a collective agreement to one or more specific grade structures, enabling the system to enforce and manage grade hierarchies and progressions that are contractually defined. Its role is foundational, as it establishes the permissible grade frameworks for positions and employees covered under a given agreement, ensuring data integrity and compliance in grade assignments.

Key Information Stored

The table's primary columns store the identifiers necessary to create the relationship between a collective agreement and a grade structure. The key columns include CAGR_GRADE_STRUCTURE_ID, which is the unique primary key identifier for each record. The COLLECTIVE_AGREEMENT_ID is a foreign key linking to the PER_COLLECTIVE_AGREEMENTS table, identifying the specific agreement. The ID_FLEX_NUM column stores the number identifying the specific Grade Key Flexfield structure (from FND_ID_FLEX_STRUCTURES) that is authorized for use with the linked agreement. Together, the COLLECTIVE_AGREEMENT_ID and ID_FLEX_NUM form a unique constraint (PER_CAGR_GRADE_STRUCTURES_UK1), preventing the same grade structure from being assigned multiple times to a single agreement.

Common Use Cases and Queries

This table is primarily accessed during the setup and maintenance of collective agreements and during transactional processes involving grades. A common operational use case is validating whether a particular grade is permissible for an employee covered by a specific collective agreement. For reporting, administrators may query this table to audit or list all grade structures associated with agreements. A typical query would join to related setup tables to retrieve meaningful names.

SELECT cagrs.collective_agreement_id,
       cagr.name agreement_name,
       cagrs.id_flex_num,
       fifs.id_flex_structure_name grade_structure_name
FROM   per_cagr_grade_structures cagrs,
       per_collective_agreements cagr,
       fnd_id_flex_structures fifs
WHERE  cagrs.collective_agreement_id = cagr.collective_agreement_id
AND    cagrs.id_flex_num = fifs.id_flex_num
AND    fifs.application_id = 800
AND    fifs.id_flex_code = 'GRD'
ORDER BY cagr.name;

Related Objects

The PER_CAGR_GRADE_STRUCTURES table sits at the center of a key data model for collective agreement grades. It has a direct foreign key relationship with the PER_COLLECTIVE_AGREEMENTS table, which holds the master definition of the agreements themselves. Crucially, it is referenced by the PER_CAGR_GRADES table, which stores the actual instances of grades (with steps, rates, and effective dates) defined within each permitted structure for an agreement. This relationship means that a grade cannot be created in PER_CAGR_GRADES without a valid parent record in PER_CAGR_GRADE_STRUCTURES. The ID_FLEX_NUM column implicitly relates to the underlying flexfield definition tables, primarily FND_ID_FLEX_STRUCTURES for the structure definition.