Search Results per_grades




Overview
Explore in AI Chat

Overview

The PER_GRADES table is a core data object within the Oracle E-Business Suite Human Resources (PER) module. It serves as the master repository for all grade definitions within a business group. A grade is a classification level within an organization's job hierarchy, often linked to compensation ranges, career progression paths, and approval authorities. This table is fundamental for structuring the workforce, managing assignments, and administering compensation and benefits policies. Its integrity is critical as it is referenced extensively across HR, Payroll, and related modules to enforce business rules and maintain data consistency.

Key Information Stored

The table stores the defining attributes for each grade. Its primary key is the system-generated, unique GRADE_ID. A composite unique key on NAME and BUSINESS_GROUP_ID ensures grade names are unique within a business group. The BUSINESS_GROUP_ID column links the grade to its owning business group via a foreign key to HR_ALL_ORGANIZATION_UNITS. Another critical column is GRADE_DEFINITION_ID, which links to the PER_GRADE_DEFINITIONS table, allowing for the association of a specific grade with a broader grade structure or ladder. Other typical columns, inferred from standard implementations, would include effective start and end dates (EFFECTIVE_START_DATE, EFFECTIVE_END_DATE), a sequence number (SEQUENCE), and descriptive attributes like COMMENTS.

Common Use Cases and Queries

This table is central to numerous operational and reporting processes. Common use cases include validating grade assignments for employees and positions, configuring grade-based eligibility for salary elements or benefits, and generating organizational grade distribution reports. A typical query retrieves all active grades for a business group:

  • SELECT grade_id, name FROM per_grades WHERE business_group_id = &bg_id AND SYSDATE BETWEEN effective_start_date AND NVL(effective_end_date, SYSDATE) ORDER BY sequence;

Another frequent pattern is joining to assignment data to analyze the employee population by grade:

  • SELECT pg.name, COUNT(pa.person_id) FROM per_grades pg, per_all_assignments_f pa WHERE pg.grade_id = pa.grade_id AND pa.primary_flag = 'Y' AND SYSDATE BETWEEN pa.effective_start_date AND pa.effective_end_date GROUP BY pg.name;

Related Objects

As indicated by the extensive foreign key relationships, PER_GRADES is a pivotal table integrated with many HR and Payroll functions. Key related objects include: