Results for “per_valid_grades”

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

Overview

PER_VALID_GRADES is a Human Resources (PER) module table owned by the HR schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the set of grades that are validly associated with a given job and/or position, effectively acting as the cross-reference between the grade structure, the job structure, and the position structure within an enterprise's workforce model. The table is central to grade validation logic during hire, transfer, promotion, and assignment workflows, where the application must confirm that a chosen grade is permissible for the job or position in question.

From a Data Vault modeling perspective, the mined relationship data classifies PER_VALID_GRADES as satellite-leaning. This suggests the table behaves primarily as a dependent, descriptive record anchored to parent business entities (job, position, grade, business group) rather than as an independent hub or a pure link. The 39 documented columns include the surrogate primary key, four foreign keys, dated effectiveness columns, standard EBS WHO columns, and 20 developer-defined attribute columns.

Key Information Stored

The primary key is VALID_GRADE_ID, enforced through the unique index PER_VALID_GRADES_PK. This surrogate identifier is the sole documented business-key candidate; no composite natural key is defined as a unique index, meaning the combination of job, position, grade, and business group is not formally constrained at the database layer.

• VALID_GRADE_ID — Surrogate primary key uniquely identifying each valid-grade record.
• BUSINESS_GROUP_ID — Foreign key to HR_ALL_ORGANIZATION_UNITS, scoping the record to a specific business group.
• GRADE_ID — Foreign key to PER_GRADES, identifying the grade that is valid for the associated job or position.
• JOB_ID — Foreign key to PER_JOBS, the job for which the grade is permitted.
• POSITION_ID — Foreign key to PER_ALL_POSITIONS, the position for which the grade is permitted.
• DATE_FROM / DATE_TO — Date-effective range defining when the valid-grade relationship is active.
• LAST_UPDATE_DATE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard EBS WHO audit columns tracking record provenance.
• OBJECT_VERSION_NUMBER — Optimistic locking column used by the application to detect concurrent updates.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — Concurrent program and request tracking columns populated when the row is created or updated by a batch process.
• ATTRIBUTE1 through ATTRIBUTE20, ATTRIBUTE_CATEGORY — Descriptive flexfield (DFF) segments available for client-specific extensions.
• COMMENTS — Free-text remarks associated with the valid-grade entry.

Common Use Cases and Queries

Typical uses include validating whether a selected grade is permitted for a job or position during an assignment, building grade-ladder reports for career progression, and auditing configuration where grades have been added or removed over time. Because the table is date-effective, queries should filter on DATE_FROM and DATE_TO using the effective date of interest.

A frequent access pattern joins PER_VALID_GRADES to PER_GRADES and PER_JOBS to list the grades valid for a job as of today:

• SELECT vg.grade_id, g.name grade_name, vg.job_id, vg.date_from, vg.date_to FROM per_valid_grades vg, per_grades g WHERE vg.grade_id = g.grade_id AND vg.job_id = :job_id AND TRUNC(SYSDATE) BETWEEN vg.date_from AND NVL(vg.date_to, TRUNC(SYSDATE));
• Join to PER_ALL_POSITIONS to enumerate valid grades for a specific position.
• Join to HR_ALL_ORGANIZATION_UNITS on BUSINESS_GROUP_ID to restrict results to a business group.
• Reporting on grade usage by position or job for compensation and workforce planning analysis.

Related Objects

The table participates in the following documented foreign key relationships:

• HR_ALL_ORGANIZATION_UNITS — referenced via PER_VALID_GRADES.BUSINESS_GROUP_ID.
• PER_GRADES — referenced via PER_VALID_GRADES.GRADE_ID.
• PER_JOBS — referenced via PER_VALID_GRADES.JOB_ID.
• PER_ALL_POSITIONS — referenced via PER_VALID_GRADES.POSITION_ID.
• PER_COMPETENCE_ELEMENTS — references PER_VALID_GRADES through PER_COMPETENCE_ELEMENTS.VALID_GRADE_ID, linking grade validity to competence definitions.