Results for “grade_step”

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

Overview

The APPS.HRFV_GRADE_STEP_PLACEMENTS view is a business view template within the Oracle EBS Human Resources (PER) module from which the flexfield view is generated. Its primary purpose is to expose grade step placement data in a denormalized, report-friendly structure. Grade step placements represent the assignment of an employee's spinal point (grade step and grade point) on a pay scale, along with the reason for that placement. The view consolidates information from multiple HR entities—people, assignments, grade scales, grade steps, and spinal point placements—into a single queryable object.

In Oracle EBS 12.1.1 and 12.2.2, this view serves as a foundation for reporting and integration related to compensation structures, particularly in public sector or unionized environments where grade step progression is formally tracked. Because it is a view template tied to flexfield generation, it also supports descriptive flexfield reporting scenarios where grade step placement attributes must be surfaced alongside standard HR reference data.

Underlying Base Objects

The view is defined over the following documented base objects and packages:

• PER_PEOPLE_X (VIEW) — provides person-level attributes such as full name, employee number, and person ID.
• PER_ASSIGNMENTS_X (VIEW) — provides assignment number, assignment ID, and business group ID.
• PER_SPINAL_POINT_PLACEMENTS_X (VIEW) — provides the placement record, placement reason, placement ID, and step ID linkage.
• HRFV_GRADE_STEPS (VIEW) — supplies grade step, grade point, ceiling step, and ceiling point values.
• HRFV_GRADE_SCALES (VIEW) — supplies grade name, pay scale name, grade ID, and pay scale ID.
• HR_ALL_ORGANIZATION_UNITS_TL (SYNONYM) — provides the translated business group name, filtered by USERENV('LANG').
• HR_BIS, HR_GENERAL, HR_PERSON_NAME, and HR_SECURITY (PACKAGES) — support security profile filtering (HR_BIS.GET_SEC_PROFILE_BG_ID), name formatting, and general HR utilities.

The join logic links placements to assignments, assignments to grade steps, grade steps to grade scales, and assignments to people and business groups, enforcing the effective security profile on the business group.

Key Columns

• BUSINESS_GROUP_NAME — the translated name of the business group the assignment belongs to.
• PERSON_NAME and EMPLOYEE_NUMBER — identify the person holding the placement.
• ASSIGNMENT_NUMBER and ASSIGNMENT_ID — identify the assignment carrying the grade step placement.
• GRADE_NAME, GRADE_ID, PAY_SCALE_NAME, and PAY_SCALE_ID — describe the grade scale and pay scale context.
• GRADE_STEP, GRADE_POINT, GRADE_STEP_ID — the specific step and point of the placement.
• CEILING_STEP and CEILING_POINT — the maximum step and point permitted within the grade scale.
• PLACEMENT_REASON — the reason recorded for the spinal point placement (from the SPP record).
• BUSINESS_GROUP_ID, PERSON_ID — internal identifiers used for joins and security filtering.
• GRADE_STEP_PLACEMENTS_ID — the placement identifier, aliased from SPP.PLACEMENT_ID.

Common Use Cases and Queries

Typical uses include compensation reporting, grade step progression analysis, and integration extracts for payroll or third-party systems. The following query lists grade step placements for a business group:

SELECT business_group_name,
       employee_number,
       person_name,
       assignment_number,
       grade_name,
       pay_scale_name,
       grade_step,
       grade_point,
       placement_reason
FROM   apps.hrfv_grade_step_placements
WHERE  business_group_id = :p_business_group_id;

To analyze progression relative to the ceiling, compare GRADE_STEP to CEILING_STEP and GRADE_POINT to CEILING_POINT. Joining on ASSIGNMENT_ID or PERSON_ID allows correlation with other HR reporting views. Because the view enforces security via HR_BIS.GET_SEC_PROFILE_BG_ID, results are automatically restricted to the business groups permitted by the executing user's security profile.