Results for “target_grade_id”

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

Overview

PER_MM_VALID_GRADES is a Human Resources (PER) module table in Oracle E-Business Suite, owned by the HR schema. Its documented purpose is to hold the valid grades that will be moved with a position during a mass move operation. Mass moves in Oracle HRMS allow an administrator to relocate a group of positions, and this table records, for each position affected, the target grade set that must accompany the position as part of that move. The table therefore functions as a staging and association construct that binds three separate business entities together: a mass move definition, an affected position, and a valid grade targeted by that move.

Under the heuristic Data Vault classification derived from its foreign key structure, PER_MM_VALID_GRADES is modeled as a link table. This is appropriate because the table's identity is defined entirely by the intersection of three foreign keys — MASS_MOVE_ID, POSITION_ID, and TARGET_GRADE_ID — rather than by descriptive attributes of its own. In Data Vault terms it resolves a many-to-many relationship between mass moves, positions, and grades. This classification is offered as a modeling suggestion; in native EBS it is a standard intersection/association table with descriptive audit columns.

Key Information Stored

The table contains 29 documented columns. The most significant are the three key columns that constitute both the referenced foreign keys and the primary key:

• MASS_MOVE_ID — identifies the mass move to which this row belongs; foreign key to PER_MASS_MOVES.
• POSITION_ID — identifies the position being moved; foreign key to PER_ALL_POSITIONS.
• TARGET_GRADE_ID — identifies the valid grade to be carried with the position; foreign key to PER_GRADES.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE20 — the standard Oracle descriptive flexfield (DFF) columns, providing 21 extension segments for client-specific data.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — the standard "Who" audit columns used for change tracking and concurrency control.

The unique index PER_MM_VALID_GRADES_PK (MASS_MOVE_ID, POSITION_ID, TARGET_GRADE_ID) is documented as the primary key and simultaneously serves as the business-key candidate. There is no separate surrogate key; the composite of the three foreign keys is the sole determinant of row uniqueness, which confirms the link classification. Every row is therefore a distinct (mass move, position, target grade) tuple.

Common Use Cases and Queries

Consumers typically use this table to preview or audit which valid grades accompany positions within a mass move. Typical reporting scenarios include identifying all grades impacted by a move, confirming the completeness of a move before execution, and reconciling moved grades after processing.

A representative query joining to the referenced tables:

• SELECT mv.mass_move_id, p.name position_name, g.name target_grade FROM per_mm_valid_grades v JOIN per_mass_moves mv ON mv.mass_move_id = v.mass_move_id JOIN per_all_positions p ON p.position_id = v.position_id JOIN per_grades g ON g.grade_id = v.target_grade_id;
• Count of affected grades per move: SELECT mass_move_id, COUNT(*) FROM per_mm_valid_grades GROUP BY mass_move_id;
• Identifying all moves touching a specific position: SELECT mass_move_id FROM per_mm_valid_grades WHERE position_id = :position_id;
• Flexfield-specific extraction using ATTRIBUTE_CATEGORY and a chosen ATTRIBUTE segment for client customizations.

Because the table is transactionally tied to the mass move process, direct DML is generally discouraged; inserts and deletes occur through the mass move concurrent or form logic.

Related Objects

The following objects reference or are referenced by PER_MM_VALID_GRADES through its documented foreign keys:

• PER_MASS_MOVES — parent of the move; joined via MASS_MOVE_ID.
• PER_ALL_POSITIONS — the position being moved; joined via POSITION_ID.
• PER_GRADES — the valid grade carried with the position; joined via TARGET_GRADE_ID.
• PER_GRADE_STEPS / PER_GRADE_RATES — downstream grade configuration commonly queried alongside grades when validating move results.
• PER_ALL_ASSIGNMENTS_F / PER_POSITION_DEFINITIONS — position and assignment context useful for post-move reporting.

These relationships establish PER_MM_VALID_GRADES as a pivotal intersection in the position mass-move data model, linking move orchestration, position structure, and grade configuration within the Oracle HR schema.