Results for “hrfv_grade_steps”

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

Overview

HRFV_GRADE_STEPS is an Oracle E-Business Suite business view owned by the APPS schema and delivered as part of the PER (Human Resources) product family. The view is designated a business view template from which a flexfield view is generated, meaning it exposes grade step data in a denormalized, user-facing form suitable for flexfield-driven reporting and inquiry rather than for transactional processing. Its status is VALID in both Oracle EBS 12.1.1 and 12.2.2, and it remains internally consistent across the two releases because grade step configuration is a core HR construct rather than a release-specific feature. The view is defined WITH READ ONLY, so it cannot be used as an update target; it is intended purely for query access. It is secured by business group through the HR_BIS.GET_SEC_PROFILE_BG_ID call in its predicate, which restricts rows to the security profile business group of the querying session when one exists, falling back to the row's own business group otherwise.

Underlying Base Objects

The view is constructed over a mixture of synonyms, views, and one package:

• HR_ALL_ORGANIZATION_UNITS_TL — supplies the translated business group name joined on ORGANIZATION_ID = BUSINESS_GROUP_ID and LANGUAGE = USERENV('LANG').
• PER_SPINAL_POINTS — provides spinal point definitions, including SPINAL_POINT and SEQUENCE, used both as PSP and PSP2 to establish the ordinal relationship between points.
• PER_PARENT_SPINES — supplies pay scale (parent spine) identity, exposing PARENT_SPINE_ID and NAME as PAY_SCALE_NAME.
• PER_GRADES_TL / PER_GRADES — supply the grade name and GRADE_ID.
• PER_GRADE_SPINES_X — the grade spine intersection, providing GRADE_SPINE_ID, CEILING_STEP_ID, and the link between grade and parent spine; referenced twice (GRS and GRS2).
• PER_SPINAL_POINT_STEPS_X — step definitions within a spine, referenced twice (S1 and S2) to align grade steps against spinal points.
• HR_BIS — a package supplying BIS_DECODE_LOOKUP for the Y/N ceiling flag and GET_SEC_PROFILE_BG_ID for business group security.

Key Columns

• BUSINESS_GROUP_NAME — translated enterprise business group identifier.
• PAY_SCALE_NAME — the pay scale (parent spine) to which the grade belongs.
• GRADE_NAME — the grade description.
• GRADE_POINT — the spinal point value associated with the grade step.
• CEILING_POINT_FLAG — 'Y' when the step is the grade's ceiling step, otherwise 'N', decoded via BIS_DECODE_LOOKUP.
• GRADE_STEP — a COUNT(*) aggregate representing the number of steps accumulated up to and including the current point.
• BUSINESS_GROUP_ID, GRADE_ID, GRADE_SCALE_ID, GRADE_STEP_ID, PAY_SCALE_ID — surrogate keys enabling joins to base HR entities.

Common Use Cases and Queries

Typical usage centers on grade progression and step reporting: confirming the ceiling step of a grade, listing all steps per pay scale, and feeding downstream compensation or headcount extracts. A representative query is:

• SELECT business_group_name, pay_scale_name, grade_name, grade_point, grade_step, ceiling_point_flag FROM hrfv_grade_steps WHERE grade_name = :grade ORDER BY pay_scale_name, grade_point;
• SELECT grade_name, MAX(grade_step) total_steps FROM hrfv_grade_steps GROUP BY grade_name;
• SELECT grade_name, grade_point FROM hrfv_grade_steps WHERE ceiling_point_flag = 'Y';

Because the view is READ ONLY and secured by business group, it is well suited to ad hoc inquiry and BI extracts, but grade step maintenance must be performed against the underlying PER tables rather than through this view.