Search Results person_end_date




Overview
Explore in AI Chat

Overview

APPS.HRFV_GRADE_RATE_ASGS_BG is a Business view template (Business Group–secured) from which the Oracle E-Business Suite flexfield view for grade rate assignments is generated. It belongs to the PER — Human Resources product family and carries a VALID status in the ETRM registry for releases 12.1.1 and 12.2.2. The view consolidates assignment, people, grade, pay basis, rate, and grade rule information into a single denormalized row, one row per assignment/grade-rule/rate combination for employee-type assignments (ASG.ASSIGNMENT_TYPE = 'E') tied to grade-level rate types (GRL.RATE_TYPE = 'G').

Its primary role is reporting and integration: it supplies grade rate values, grade minimums, mid values, and maximums in the context of a specific person and assignment, along with effective-dating boundaries for the person, the assignment, and the grade rule. Because it is a "business view template," it is designed as the base from which a flexfield (DFF) view is generated — the literal column '_DF:PAY:PAY_RATES:RAT' in the view text indicates that the descriptive flexfield context for PAY_RATES (RAT) is exposed so that attribute columns can be appended during generation.

Underlying Base Objects

The view is defined over the following documented objects:

Date alignment is enforced via overlapping-range predicates between PER_ALL_PEOPLE_F and PER_ASSIGNMENTS_F, and similarly between the assignment and PAY_GRADE_RULES_F, so each returned row respects the effective-dating of all three entities.

Key Columns

Common Use Cases and Queries

Typical applications include compensation analysis, grade-rate validation during payroll or element entry, and reporting that must align a person's assignment effective dates with the applicable grade rate. A representative query filtering on assignment start date, the exact term the user searched for:

  • Rate lookup for a person as of a date: SELECT PERSON_NAME, GRADE_NAME, GRADE_RATE_VALUE, UNIT_OF_MEASURE FROM HRFV_GRADE_RATE_ASGS_BG WHERE PERSON_ID = :p_person AND TRUNC(:p_date) BETWEEN ASSIGNMENT_START_DATE AND ASSIGNMENT_END_DATE;
  • Grade range audit: SELECT GRADE_NAME, GRADE_MINIMUM, GRADE_MID_VALUE, GRADE_MAXIMUM, GRADE_RATE_VALUE FROM HRFV_GRADE_RATE_ASGS_BG WHERE GRADE_ID = :p_grade ORDER BY GRADE_RULE_START_DATE;
  • Effective-dated assignment history: SELECT ASSIGNMENT_ID, ASSIGNMENT_START_DATE, ASSIGNMENT_END_DATE, GRADE_RATE_NAME FROM HRFV_GRADE_RATE_ASGS_BG WHERE PERSON_ID = :p_person ORDER BY ASSIGNMENT_START_DATE DESC;

Because the view is business-group secured and template-driven, it is generally used for reporting and integration rather than direct DML. Confirm the generated flexfield view name and any site-specific DFF attributes against the actual database before relying on the template itself in production code.