Results for “ceiling_point”

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

Overview

HRFV_GRADE_SCALES is an APPS-owned, VALID database view in the Oracle E-Business Suite PER (Human Resources) product module. Per the ETRM repository, it is documented as a "business view template from which the flexfield view is generated." In practice, this indicates that HRFV_GRADE_SCALES is a Business Intelligence (BIS) style view — the "FV" prefix and the presence of the HR_BIS package reference in its definition confirm this lineage — rather than an end-user maintenance entity. Its purpose is to expose grade-scale (grade spine) and spinal-point structure in a denormalized, reporting-friendly shape, so that downstream flexfield views and analytical queries can present grade ladders, pay scales, and ceiling points without requiring callers to join the underlying normalized PER tables themselves.

The view is read-only (declared WITH READ ONLY) and applies Business Group security at query time, which makes it suitable for multi-organization or secured HR reporting and for feeding integration extracts where only the current user's authorized business group should be visible.

Underlying Base Objects

The documented base objects referenced by HRFV_GRADE_SCALES include: HR_ALL_ORGANIZATION_UNITS_TL (synonym), HR_BIS (package), PER_GRADES_TL (synonym), PER_GRADE_SPINES_X (view), PER_PARENT_SPINES (synonym), PER_SPINAL_POINTS (synonym), and PER_SPINAL_POINT_STEPS_X (view). The view text also directly references PER_SPINAL_POINTS and PER_SPINAL_POINT_STEPS_X multiple times in self-joins.

• PER_GRADES_TL / PER_GRADES — supplies the grade definition (GRADE_ID, grade name).
• PER_GRADE_SPINES_X — the grade spine (grade scale) header, joining grade to parent spine.
• PER_PARENT_SPINES — the pay scale / parent spine, joined to business group.
• PER_SPINAL_POINTS and PER_SPINAL_POINT_STEPS_X — the spinal point and step definitions used to derive the ceiling point and step counts.
• HR_ALL_ORGANIZATION_UNITS_TL — provides the translated business group name.
• HR_BIS — the security package function, invoked as HR_BIS.GET_SEC_PROFILE_BG_ID to restrict rows to the user's business group.

Key Columns

The view exposes twelve columns. Notable ones include:

• BUSINESS_GROUP_NAME — translated name of the business group organization.
• GRADE_NAME and PAY_SCALE_NAME — descriptive names for the grade and its associated pay scale (parent spine).
• CEILING_POINT — the terminal spinal point value of the grade scale.
• CEILING_STEP — a COUNT(*) aggregate indicating the number of steps at or below the ceiling point.
• BUSINESS_GROUP_ID, GRADE_ID, GRADE_SCALE_ID, PAY_SCALE_ID, CEILING_POINT_ID — surrogate keys linking back to the source entities.
• _DF — a literal marker ('_DF:PER:PER_PARENT_SPINES:PS') used for flexfield/descriptive-flexfield view generation.

Common Use Cases and Queries

Typical usages include validating grade-scale configuration, reporting grade ladders with their ceiling points, and driving flexfield-based extracts. A representative query:

SELECT business_group_name,
       grade_name,
       pay_scale_name,
       ceiling_point,
       ceiling_step
  FROM apps.hrfv_grade_scales
 WHERE grade_name = :p_grade
 ORDER BY pay_scale_name, ceiling_point;

Because row visibility is filtered by HR_BIS.GET_SEC_PROFILE_BG_ID, callers need not append their own business-group predicate; the view already restricts results to the session's secured business group. This makes HRFV_GRADE_SCALES convenient for both ad-hoc HR reporting and for integrations that must respect Oracle HR security profiles.