Search Results minimum_pay




Overview
Explore in AI Chat

Overview

HRFV_SALARY_SURVEY_MAPPINGS is an APPS-owned database view within the PER – Human Resources product family in Oracle E-Business Suite 12.1.1 and 12.2.2. Per the ETRM metadata, it is a business view template from which the flexfield view is generated, meaning it serves as the semantic foundation for the Descriptive Flexfield (DFF) enabled reporting view exposed to Oracle HRMS and Oracle Business Intelligence (BIS) reporting layers. The view consolidates salary survey mapping data — the relationships established between an enterprise's internal workforce structures (business groups, organizations, jobs, positions, grades, locations) and the external salary survey lines supplied by compensation data vendors.

Its purpose is to present salary survey line information in a denormalized, business-friendly form suitable for compensation analytics, benchmarking dashboards, and integration with the HR BIS (Business Intelligence System) package. Because the view resolves internal IDs into names and decodes lookup codes via HR_BIS.BIS_DECODE_LOOKUP, it removes the burden of secondary joins from downstream reporting consumers.

Underlying Base Objects

The view is defined over the following documented base objects:

The DECODE constructs on SSM.PARENT_TABLE_NAME determine whether JOB_NAME or POSITION_NAME is populated, since a mapping may point to either parent entity. The HR_BIS.BIS_DECODE_LOOKUP calls abstract lookup decoding for attributes such as company age, survey company, pay basis, survey job name, survey region, seniority, company size, industry, and survey age.

Key Columns

Common Use Cases and Queries

The view is typically consumed for compensation benchmarking, salary structure validation, and trend reporting. A representative query returning the percentage change for a specific job across surveys:

SELECT business_group_name, organization_name, job_name, grade_name,
       survey_name, survey_company, line_start_date,
       minimum_pay, mean_pay, maximum_pay, percentage_change
FROM   apps.hrfv_salary_survey_mappings
WHERE   percentage_change IS NOT NULL
  AND  line_start_date >= :start_date
ORDER BY percentage_change DESC;

A second common pattern aggregates average percentage change by grade to support annual merit and market movement reviews:

SELECT grade_name, AVG(percentage_change) avg_change
FROM   apps.hrfv_salary_survey_mappings
WHERE   survey_name = :survey
GROUP BY grade_name;

Because the view resolves lookup codes and names at query time, it is well suited to ad-hoc BIS reporting, Oracle Discoverer worksheets, and OBIEE repositories requiring denormalized salary survey data.