Results for “per_grades”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PER_GRADES is the foundational grade definition table within the Oracle E-Business Suite Human Resources (PER) module. It stores the master list of grades defined for a business group, serving as the authoritative reference for grade structures used throughout HR, Payroll, Compensation, Budgeting, and Recruiting processes. Each row represents a single grade, such as "Associate Analyst" or "Senior Manager," belonging to exactly one business group, which allows a single EBS instance to host distinct grade hierarchies for different legal entities or operating units.

From a data modeling perspective, PER_GRADES is best classified as a hub — a central reference entity that other tables point to via foreign keys rather than being a transactional event or a dependent attribute record. This hub role is confirmed by the FK structure: PER_GRADES sits at the center of a broad web of dependent tables, including PER_ALL_ASSIGNMENTS_F, HR_ALL_POSITIONS_F, PER_ALL_VACANCIES, and numerous budget and payroll tables, all of which reference GRADE_ID.

Key Information Stored

The table carries 61 documented columns, but a smaller subset drives most business logic:

• GRADE_ID — the surrogate primary key (PER_GRADES_PK) uniquely identifying each grade row.
• NAME and BUSINESS_GROUP_ID — together forming the composite unique key PER_GRADES_UK2, ensuring grade names are unique within a business group.
• SHORT_NAME — an abbreviated grade label used in compact reports and lookups.
• GRADE_DEFINITION_ID — a foreign key to PER_GRADE_DEFINITIONS, linking the grade to its structural definition (grade set, ladder, or step configuration).
• DATE_FROM and DATE_TO — the effective dating window controlling when the grade is active and selectable.
• SEQUENCE — an ordering value used to sort grades hierarchically within a definition or set.
• INFORMATION_CATEGORY and INFORMATION1–INFORMATION20 — a configurable flexfield segment set for storing client-specific grade attributes.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE20 — the standard descriptive flexfield columns used for extensibility.
• COMMENTS — free-text notes attached to the grade.
• OBJECT_VERSION_NUMBER, LAST_UPDATE_DATE, CREATED_BY — audit and concurrency-control columns managed by the EBS framework.

Common Use Cases and Queries

PER_GRADES is queried in virtually every HR reporting scenario that involves grade-based grouping, pay equity analysis, headcount by grade, or position budgeting. A typical pattern joins grades to assignments to count active employees per grade:

SELECT g.name, COUNT(a.assignment_id)
FROM per_grades g, per_all_assignments_f a
WHERE g.grade_id = a.grade_id
AND TRUNC(SYSDATE) BETWEEN a.effective_start_date AND a.effective_end_date
GROUP BY g.name;

Another common use is filtering grades by validity date to populate LOVs, or joining to PER_GRADE_SPINES_F to reconstruct grade ladders for succession planning. Recruiting users frequently join PER_GRADES to PER_ALL_VACANCIES for open-position reporting by grade, and budget analysts join to PQH_BUDGET_DETAILS or PER_BUDGET_ELEMENTS to reconcile planned versus actual headcount at the grade level. Because NAME and BUSINESS_GROUP_ID form a unique constraint, lookups should always filter on business group to avoid cross-entity ambiguity.

Related Objects

The FK metadata identifies a large dependent fan-out. The most significant related objects include:

• PER_ALL_ASSIGNMENTS_F (via GRADE_ID) — the primary consumer, capturing each employee's assigned grade.
• HR_ALL_POSITIONS_F (via ENTRY_GRADE_ID) — defines the entry grade for each position.
• PER_ALL_VACANCIES (via GRADE_ID) — links requisitions and vacancies to grades.
• PER_GRADE_DEFINITIONS (via GRADE_DEFINITION_ID) — the parent definition referenced by PER_GRADES.
• HR_ALL_ORGANIZATION_UNITS (via BUSINESS_GROUP_ID) — the owning business group.
• PER_GRADE_SPINES_F (via GRADE_ID) — grade progression paths.
• PER_VALID_GRADES and PER_MM_VALID_GRADES (via GRADE_ID / TARGET_GRADE_ID) — control permitted grade transitions and mass-move rules.
• PAY_ELEMENT_LINKS_F (via GRADE_ID) — payroll eligibility rules tied to grades.
• PQH_BUDGET_DETAILS and PQH_POSITION_TRANSACTIONS (via GRADE_ID / ENTRY_GRADE_ID) — public-sector budgeting and position control.

Together these relationships confirm PER_GRADES as a stable, widely referenced hub whose integrity is essential to downstream HR, payroll, and budgetary processes.