Search Results per_valid_grades




Overview
Explore in AI Chat

Overview

The PER_VALID_GRADES table is a core data structure within the Oracle E-Business Suite (EBS) Human Resources (HR) module, specifically in releases 12.1.1 and 12.2.2. It functions as a junction or mapping table that defines and enforces the permissible relationships between grades, and jobs or positions within a business group. Its primary role is to maintain the integrity of the organization's grading structure by ensuring that only authorized, pre-defined grade assignments can be made to specific jobs and positions. This table is fundamental to the setup and maintenance of the enterprise's compensation and position management frameworks.

Key Information Stored

The table's structure centers on foreign key relationships that link the core entities. The most critical columns are the identifiers that create these associations. The VALID_GRADE_ID column serves as the table's unique primary key. The BUSINESS_GROUP_ID column scopes the validity of the relationship to a specific operating unit. The table then links a specific GRADE_ID (from PER_GRADES) to either a JOB_ID (from PER_JOBS) or a POSITION_ID (from PER_ALL_POSITIONS). A single record typically establishes that a particular grade is valid for a specific job or position within a given business group, forming the basis for assignment and compensation rules.

Common Use Cases and Queries

This table is central to configuration and validation processes. A primary use case is during the assignment of an employee to a job or position, where the system validates that the selected grade is permitted for that role. For reporting, it is used to generate matrices of available grades by job or position. Common queries include listing all valid grades for a specific job or identifying which jobs can be assigned a particular grade. A typical SQL pattern to find valid grades for a job would be:

  • SELECT g.name GRADE_NAME, j.name JOB_NAME FROM per_valid_grades vg, per_grades g, per_jobs j WHERE vg.grade_id = g.grade_id AND vg.job_id = j.job_id AND j.name = '<JOB_NAME>' AND vg.business_group_id = <BG_ID>;

Another critical use is in data migration or bulk loading scenarios, where this table must be populated correctly before employee assignments can be created.

Related Objects

As documented in the ETRM metadata, PER_VALID_GRADES has extensive foreign key relationships, highlighting its integrative role. The table references four key master tables: HR_ALL_ORGANIZATION_UNITS (via BUSINESS_GROUP_ID), PER_GRADES (via GRADE_ID), PER_JOBS (via JOB_ID), and PER_ALL_POSITIONS (via POSITION_ID). Furthermore, it is referenced by the PER_COMPETENCE_ELEMENTS table through the VALID_GRADE_ID column. This last relationship indicates that competence or proficiency requirements can be defined at the granular level of a valid grade for a specific job or position, linking competency management directly to the grading structure.