Search Results per_competence_outcomes

Overview

The PER_COMPETENCE_OUTCOMES table is a core data object within the Oracle E-Business Suite (EBS) Human Resources (HR) module. It functions as the master repository for defining specific, measurable outcomes associated with competencies. A competency represents a skill, behavior, or area of knowledge, while an outcome defines a particular level of proficiency or a specific achievement within that competency. This table enables organizations to create a structured framework for assessing and measuring employee performance, development, and qualifications against defined competency models. Its primary role is to store the discrete outcome definitions that can be linked to competencies and subsequently to employees via assessments, appraisals, or development plans.

Key Information Stored

While the full column list is not detailed in the provided metadata, the documented primary and foreign keys reveal the essential structure. The central column is OUTCOME_ID, which serves as the unique primary key identifier for each competence outcome record. The COMPETENCE_ID column is a critical foreign key that links each outcome to its parent competency defined in the PER_COMPETENCES table. This establishes a one-to-many relationship where a single competency can have multiple defined outcomes. Other typical columns in this table, based on Oracle HRMS data model conventions, would include fields for the outcome name, description, a sequence or rating level, effective start and end dates for temporal validity, and creation/modification audit information.

Common Use Cases and Queries

This table is central to competency-based talent management processes. Common use cases include configuring the rating scales for performance appraisals, defining proficiency requirements for job roles, and tracking employee development goals. A frequent reporting requirement is to list all available outcomes for a specific competency, which can be achieved with a simple join:

SELECT pco.outcome_id, pco.name, pc.competence_name
FROM per_competence_outcomes pco,
     per_competences pc
WHERE pco.competence_id = pc.competence_id
AND pc.competence_id = :p_comp_id
AND SYSDATE BETWEEN pco.effective_start_date AND NVL(pco.effective_end_date, SYSDATE);

Another critical use case involves analyzing assessment results by joining through the PER_COMP_ELEMENT_OUTCOMES table to see which outcomes have been assigned or achieved by employees.

Related Objects

• PER_COMPETENCES: This is the parent table. The relationship is defined by the foreign key PER_COMPETENCE_OUTCOMES.COMPETENCE_ID referencing PER_COMPETENCES. It provides the master competency definition to which the outcome belongs.
• PER_COMP_ELEMENT_OUTCOMES: This is a key child table. The relationship is defined by the foreign key PER_COMP_ELEMENT_OUTCOMES.OUTCOME_ID referencing PER_COMPETENCE_OUTCOMES.OUTCOME_ID. This table links specific outcomes to individual competency elements or assessments for employees, making it the bridge between outcome definitions and actual employee records or appraisal data.