Results for “evaluated_date”

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

Overview

APPS.HRFV_JOB_EVALUATIONS is a read-only Oracle EBS view that presents job evaluation records for jobs within a business group. It is a reporting-facing construct built on top of the HR foundation tables that store job definitions and their associated evaluations. The view joins evaluation data from PER_JOB_EVALUATIONS to job and business group descriptive information, and applies lookup decoding through the HR_BIS package so that coded values are returned as their user-facing meanings rather than raw codes.

Because the view is defined WITH READ ONLY, it is intended exclusively for query, reporting, and integration consumption. It does not support DML operations. The view also incorporates the security profile business group filter via HR_BIS.GET_SEC_PROFILE_BG_ID, meaning rows are automatically restricted to the business group(s) to which the querying user has access. This makes it suitable for use in concurrent programs, BI Publisher data models, OBIEE/OTBI extracts, and custom PL/SQL reporting without requiring report authors to re-implement security logic.

Underlying Base Objects

The view is defined over four documented base objects (all exposed through APPS synonyms) plus the HR_BIS package:

• PER_JOB_EVALUATIONS (alias JEVAL) — supplies the evaluation facts such as score, evaluation date, measurement unit, and evaluation system.
• PER_JOBS (alias JOBS) — supplies the job identifier and business group identifier, and provides the join key to evaluations.
• PER_JOBS_TL (alias JBT) — supplies the translated job name.
• HR_ALL_ORGANIZATION_UNITS_TL (alias BGRT) — supplies the translated business group name.
• HR_BIS (package) — supplies BIS_DECODE_LOOKUP for lookup translation and GET_SEC_PROFILE_BG_ID for security filtering.

The join path links PER_JOBS to PER_JOB_EVALUATIONS on JOB_ID, PER_JOBS to PER_JOBS_TL on JOB_ID, and PER_JOBS to HR_ALL_ORGANIZATION_UNITS_TL on BUSINESS_GROUP_ID. Both translation tables are filtered to the session language using USERENV('LANG'), so names are returned in the user's current language. The business group predicate applies NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, JOBS.BUSINESS_GROUP_ID), enforcing security when a profile value exists and returning all groups otherwise.

Key Columns

• BUSINESS_GROUP_NAME — translated name of the business group owning the job.
• JOB_NAME — translated name of the job being evaluated.
• EVALUATED_SCORE — the overall evaluation score (OVERALL_SCORE) assigned to the job.
• EVALUATED_DATE — the date the evaluation was performed (DATE_EVALUATED).
• MEASURED_IN — decoded value of the MEASURED_IN column via lookup type EVAL_SYSTEM_MEAS, describing the unit or scale of measurement.
• SYSTEM — decoded value of the SYSTEM column via lookup type EVAL_SYSTEM, identifying the evaluation system or methodology used. This is the column directly relevant to the search term "eval_system".
• BUSINESS_GROUP_ID — identifier of the business group.
• JOB_ID — identifier of the job.
• '_DF:PER:PER_JOB_EVALUATIONS:JEVAL' — a constant descriptor string used by EBS flexfield/descriptive flexfield processing to identify the source entity.

Common Use Cases and Queries

Typical uses include job evaluation reporting by business group, comparison of evaluation scores across evaluation systems, and feeds into compensation or grading analysis. Because the SYSTEM column surfaces the decoded evaluation system, queries filtering on it commonly target a specific methodology such as a points-factor or classification plan.

• List all evaluations with their decoded system and measurement:

  SELECT job_name, evaluated_score, evaluated_date,
         measured_in, system, business_group_name
  FROM   apps.hrfv_job_evaluations
  ORDER  BY business_group_name, job_name;

• Filter to a specific evaluation system (the "eval_system" search context):

  SELECT job_name, evaluated_score, evaluated_date
  FROM   apps.hrfv_job_evaluations
  WHERE  system = :p_eval_system;

• Aggregate average scores per system:

  SELECT system, COUNT(*) eval_count, AVG(evaluated_score) avg_score
  FROM   apps.hrfv_job_evaluations
  GROUP  BY system;

Security behavior should be noted in every use case: results are automatically constrained by the user's security profile business group, and all displayed names respect the session language.