Results for “hrfv_current_salaries”

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

Overview

HRFV_CURRENT_SALARIES is a business view template owned by the APPS schema in Oracle E-Business Suite, delivered under the PER (Human Resources) product family. As documented in the ETRM metadata for 12.1.1 and 12.2.2, the object is classified as a VIEW with VALID status, and its formal description states that it is a "business view template from which the flexfield view is generated." This places the view within Oracle's Flexfield View Generator (FND Flexview) framework, where template views encode the join logic, security predicates, and column derivations required to expose flexfield-driven data for downstream flexfield views.

Functionally, HRFV_CURRENT_SALARIES presents a consolidated, person-centric picture of current salary information. For each employee assignment of type 'E', the view surfaces the screen entry value of a salary-related input value, multiplied by the pay basis annualization factor, to produce an ANNUAL_SALARY figure. Because the annualization factor is applied, the view normalizes salaries recorded across differing pay bases (for example, hourly, weekly, or monthly) to a common annual basis. This normalization is the primary reason the view is frequently targeted when users search for annual_salary, since no single base table exposes that normalized value directly. The view also enriches the salary figure with descriptive context: business group, person name, employee number, organization, job, position, grade, location, change date, years of service, and currency code.

Underlying Base Objects

The documented referenced objects confirm that HRFV_CURRENT_SALARIES is defined over a mix of synonyms, views, and packages. Core HR objects include PER_PEOPLE_X, PER_ASSIGNMENTS_X, PER_PERIODS_OF_SERVICE, PER_PAY_BASES, PER_GRADES_TL, PER_JOBS_TL, HR_ALL_ORGANIZATION_UNITS, HR_ALL_ORGANIZATION_UNITS_TL, HR_ALL_POSITIONS_F_TL, HR_LOCATIONS_ALL_TL, and PER_ASSIGNMENT_STATUS_TYPES. Payroll objects include PAY_ELEMENT_ENTRIES_X, PAY_ELEMENT_ENTRY_VALUES_X, PAY_ELEMENT_LINKS_X, PAY_ELEMENT_TYPES_X, and PAY_INPUT_VALUES_X. Supporting packages include FND_NUMBER, HR_BIS, HR_GENERAL, HR_PERSON_NAME, and HR_SECURITY, the last of which is significant because it enforces row-level security so that a query returns only the assignments the requesting user is authorized to see.

The view text reveals the join path: the assignment (ASG) is restricted to ASSIGNMENT_TYPE = 'E', linked to element entries (PEE) and their entry values (PEV), with input value identifiers resolving through PAY_INPUT_VALUES_X to PER_PAY_BASES (PPB) to obtain PAY_ANNUALIZATION_FACTOR. Descriptive attributes are joined via the corresponding _TL translation tables using USERENV('LANG'), and the business group is resolved through HR_ALL_ORGANIZATION_UNITS.

Key Columns

• ANNUAL_SALARY — PAY_ANNUALIZATION_FACTOR multiplied by the numeric screen entry value; the normalized figure users seek.
• PERSON_NAME, EMPLOYEE_NUMBER — identity of the employee.
• BUSINESS_GROUP_NAME — the business group owning the assignment.
• ORGANIZATION_NAME, JOB_NAME, POSITION_NAME, GRADE_NAME, LOCATION_NAME — descriptive assignment context.
• CHANGE_DATE — effective start date of the element entry value.
• YEARS_SERVICE — rounded months between the period of service start and the assignment effective date, divided by twelve.
• CURRENCY_CODE — input currency for the element type.
• Identifiers — ASSIGNMENT_ID, PERSON_ID, BUSINESS_GROUP_ID, GRADE_ID, JOB_ID, ORGANIZATION_ID, POSITION_ID, LOCATION_ID.

Common Use Cases and Queries

Typical uses include salary reporting for HR and compensation analysts, feeds into downstream flexfield views, and ad hoc extracts requiring annualized pay by person, organization, or grade.

• Listing annual salary by employee within a business group.
• Aggregating total annualized payroll cost by organization, grade, or location.
• Comparing salary against years of service for compensation analysis.

SELECT PERSON_NAME, EMPLOYEE_NUMBER, ANNUAL_SALARY,
       JOB_NAME, GRADE_NAME, CURRENCY_CODE
FROM   APPS.HRFV_CURRENT_SALARIES
WHERE  BUSINESS_GROUP_NAME = :business_group
ORDER  BY ANNUAL_SALARY DESC;

SELECT ORGANIZATION_NAME, GRADE_NAME,
       SUM(ANNUAL_SALARY) TOTAL_SALARY
FROM   APPS.HRFV_CURRENT_SALARIES
GROUP  BY ORGANIZATION_NAME, GRADE_NAME;

Because HR_SECURITY is referenced, results are automatically filtered to the caller's authorized assignments, and queries should be run against the APPS-owned view to preserve that predicate.