Search Results per_job_evaluations




Overview
Explore in AI Chat

Overview

The PER_JOB_EVALUATIONS table is a core data object within the Oracle E-Business Suite (EBS) Human Resources (HR) module, specifically under the PER product family. Its primary function is to store detailed job evaluation information that can be linked to specific jobs (from PER_JOBS) or positions (from PER_ALL_POSITIONS). This table enables organizations to formally assess and record the relative worth, grade, or classification of roles within their structure. It serves as a central repository for evaluation data, supporting compensation management, career pathing, and organizational design by providing a structured way to associate evaluation criteria and results with defined roles.

Key Information Stored

The table's structure is designed to link evaluation data to the organizational and role hierarchy. The primary key is JOB_EVALUATION_ID, a unique system-generated identifier for each evaluation record. Critical foreign key columns establish the necessary relationships: BUSINESS_GROUP_ID links to HR_ALL_ORGANIZATION_UNITS to define the organizational context; JOB_ID links to PER_JOBS for job-based evaluations; and POSITION_ID links to PER_ALL_POSITIONS for position-based evaluations. While the provided metadata does not list all columns, typical data stored would include evaluation dates, evaluation methods or systems used (e.g., point-factor scores, grade levels), the status of the evaluation, and potentially the evaluator or committee responsible. The presence of both JOB_ID and POSITION_ID indicates the table supports evaluations for both generic job definitions and specific, filled positions.

Common Use Cases and Queries

A primary use case is generating reports for compensation analysis, such as listing all jobs within a business group alongside their most recent evaluation grade. This supports equity reviews and pay band placement. Another scenario involves auditing the evaluation history for a specific position to track how its assessed value has changed over time. Common SQL queries often join this table to PER_JOBS or PER_ALL_POSITIONS and HR_ALL_ORGANIZATION_UNITS. For example, to find all evaluated jobs in a specific business group, one might use:

  • SELECT pje.JOB_EVALUATION_ID, pj.JOB_ID, pj.NAME, pje.EVALUATION_DATE FROM PER_JOB_EVALUATIONS pje JOIN PER_JOBS pj ON pje.JOB_ID = pj.JOB_ID WHERE pje.BUSINESS_GROUP_ID = &bg_id ORDER BY pj.NAME;

Data from this table may also be critical for integrations with third-party compensation benchmarking tools or for populating internal grade-level matrices.

Related Objects

As indicated by the foreign key constraints, PER_JOB_EVALUATIONS has direct, foundational relationships with several key HR tables. It is a child table of HR_ALL_ORGANIZATION_UNITS via BUSINESS_GROUP_ID, of PER_JOBS via JOB_ID, and of PER_ALL_POSITIONS via POSITION_ID. This table is likely referenced by various HRMS APIs, particularly those related to job and position management (e.g., HR_JOB_API, HR_POSITION_API) for creating or updating evaluation details. While not listed in the metadata, it may also be the base for key HRMS views that present evaluation information in a more report-friendly format, and it could feed data into compensation-related tables like PER_GRADE_RULES or PER_PAY_PROPOSALS, depending on the implementation.