Results for “grade_step_placements_id”

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

Overview

APPS.HRFV_GRADE_STEP_PLACEMENTS is a read-only reporting view in the Oracle E-Business Suite HRMS (Human Resources) module, exposed under the APPS schema. It presents the intersection of employee assignments, grade scales, grade steps, and spinal point placements — that is, the point at which an employee has been placed on a specific step or point within a grade scale. In Oracle EBS 12.1.1 and 12.2.2, the view serves as a denormalized, security-filtered projection that joins person, assignment, grade, and placement data into a single queryable surface, avoiding the need for report developers to reconstruct these joins manually.

Because the view is defined WITH READ ONLY, it cannot be used for DML. It is intended for reporting, extracts, FastFormula lookups, and integration queries. Its most distinctive feature is the aliasing of SPP.PLACEMENT_ID as GRADE_STEP_PLACEMENTS_ID, which is the exact identifier users search for when tracing a placement record back to PER_SPINAL_POINT_PLACEMENTS_X. This naming convention gives the view its "grade step placements" identity.

Underlying Base Objects

The view is defined over six directly referenced objects plus supporting packages and views. The FROM clause joins PER_PEOPLE_X (person), HR_ALL_ORGANIZATION_UNITS_TL (business group, restricted by userenv('LANG') for the session language), HRFV_GRADE_STEPS, HRFV_GRADE_SCALES (both HR Foundation views), PER_ASSIGNMENTS_X, and PER_SPINAL_POINT_PLACEMENTS_X. The join chain is: assignment to placement, placement step to grade step, grade step scale to grade scale, and assignment person to person.

Documented metadata also lists HR_BIS (used via get_sec_profile_bg_id for business group security), HR_GENERAL, HR_PERSON_NAME, and HR_SECURITY packages. These support the row-level security predicate ass.business_group_id = NVL(hr_bis.get_sec_profile_bg_id, ass.business_group_id), which restricts returned rows to the business group defined in the user's HR security profile. Consequently, query results are always filtered to the running user's authorized business group unless no security profile business group is set.

Key Columns

• grade_step_placements_id — alias of SPP.PLACEMENT_ID; the primary placement identifier linking to the spinal point placement record.
• person_id, person_name, employee_number — employee identity from PER_PEOPLE_X; safe use of HR_PERSON_NAME formatting.
• assignment_id, assignment_number — the assignment to which the placement applies.
• business_group_id, business_group_name — the legal employer / business group and its translated name.
• grade_id, grade_name, pay_scale_id, pay_scale_name — the grade scale definition.
• grade_step_id, grade_step, grade_point — the specific step/point on the scale.
• ceiling_step, ceiling_point — the maximum step and point permitted for the scale.
• placement_reason — alias of SPP.REASON; the justification recorded for the placement.

Common Use Cases and Queries

Typical uses include headcount-by-step reporting, grade progression analysis, placement audit extracts, and FastFormula or OAF lookups resolving an assignment's current step. A minimal query retrieves all placements for a business group:

SELECT business_group_name, person_name, employee_number, grade_name, grade_step, grade_point, placement_reason
FROM apps.hrfv_grade_step_placements
ORDER BY grade_name, grade_step;

To trace a single placement by its identifier:

SELECT * FROM apps.hrfv_grade_step_placements WHERE grade_step_placements_id = :p_placement_id;

To analyze step distribution against ceilings:

SELECT grade_name, grade_step, COUNT(*) placements, MAX(ceiling_step) ceiling
FROM apps.hrfv_grade_step_placements
GROUP BY grade_name, grade_step ORDER BY grade_name, grade_step;

Because of the security predicate, callers should not add an unrestrictive business group filter when cross-business-group visibility is required; instead, the security profile must authorize the target business group.