Results for “hrfv_position_evaluations”

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

Overview

The APPS.HRFV_POSITION_EVALUATIONS view is a business view template within the Oracle E-Business Suite Human Resources (PER) product family. It is generated from a flexfield view definition and is retained as a read-only reporting object (the view text terminates with the WITH READ ONLY clause). The view consolidates position evaluation data held in PER_JOB_EVALUATIONS with position and business group descriptive information, presenting a denormalised result set suitable for operational reporting, Oracle Business Intelligence (BIS) extraction, and integration interfaces.

The view is documented as a template from which the flexfield view is generated, indicating it forms part of the descriptive flexfield (DFF) reporting infrastructure. Note the literal column "_DF" in the column list, which carries the DFF reference _DF:PER:PER_JOB_EVALUATIONS:JEVAL. This is the standard mechanism by which Oracle HRMS views expose the flexfield context so that descriptive flexfield segments can be surfaced alongside the base query. The view is marked VALID in the APPS schema and is registered against both EBS 12.1.1 and 12.2.2 documentation sets.

Underlying Base Objects

The view is defined over the following documented base objects:

• PER_JOB_EVALUATIONS (synonym) — the primary transactional source, aliased JEVAL, holding the evaluation records keyed by POSITION_ID.
• PER_ALL_POSITIONS (synonym) — aliased POS, supplying the position name, position identifier, and business group identifier used to join the evaluation to its parent position definition.
• HR_ALL_ORGANIZATION_UNITS_TL (synonym) — aliased BGRT, the translated organization units table, providing the business group name. The join is constrained to the user's session language via BGRT.LANGUAGE = USERENV('LANG').
• HR_ALL_POSITIONS_F_TL (synonym) — documented as a referenced base object, associated with the position translation layer.
• HR_BIS (package) — provides two helper calls: BIS_DECODE_LOOKUP for decoding lookup values, and GET_SEC_PROFILE_BG_ID for security profile enforcement.

Row-level security is applied through the predicate POS.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, POS.BUSINESS_GROUP_ID), which restricts results to the business group(s) the querying user is authorised to see. When no security profile business group is returned, the predicate degenerates gracefully and does not filter.

Key Columns

• BUSINESS_GROUP_NAME — the translated name of the business group owning the position.
• POSITION_NAME — the position name from PER_ALL_POSITIONS.
• EVALUATION_SCORE — mapped from JEVAL.OVERALL_SCORE; the aggregate score recorded for the position evaluation.
• EVALUATION_DATE — mapped from JEVAL.DATE_EVALUATED. This is the column surfaced when users search for evaluation_date, and it represents the date on which the position evaluation was performed.
• MEASURED_IN — decoded via BIS_DECODE_LOOKUP('EVAL_SYSTEM_MEAS', JEVAL.MEASURED_IN), describing the unit or scale in which the evaluation was measured.
• SYSTEM — decoded via BIS_DECODE_LOOKUP('EVAL_SYSTEM', JEVAL.SYSTEM), identifying the evaluation system applied.
• "_DF" — the descriptive flexfield context marker for PER_JOB_EVALUATIONS.
• BUSINESS_GROUP_ID and POSITION_ID — the identifying keys carried through for joins and downstream processing.

Common Use Cases and Queries

Typical usage includes position evaluation history reports, score trending by business group, and BIS extracts feeding workforce analytics. Because the view already decodes lookup values and enforces security, it is commonly selected directly rather than building equivalent joins from PER_JOB_EVALUATIONS. Note that "date" is not a reserved word in this context and requires no quoting.

Retrieve evaluations for a position, ordered by evaluation date:

SELECT position_name, evaluation_score, evaluation_date
FROM   apps.hrfv_position_evaluations
WHERE  position_id = :p_position_id
ORDER BY evaluation_date DESC;

Report evaluations within a date range for the current security context:

SELECT business_group_name, position_name,
       evaluation_score, evaluation_date, measured_in, system
FROM   apps.hrfv_position_evaluations
WHERE  evaluation_date BETWEEN :p_from_date AND :p_to_date;

Aggregate average scores per business group:

SELECT business_group_name,
       AVG(evaluation_score) avg_score,
       MAX(evaluation_date)   latest_eval
FROM   apps.hrfv_position_evaluations
GROUP BY business_group_name;

Because read-only enforcement prevents DML through the view, all maintenance of evaluation records must be performed against the underlying PER_JOB_EVALUATIONS entity.