Search Results per_competence_elements

Overview

The PER_COMPETENCE_ELEMENTS table is a core data object within the Oracle E-Business Suite Human Resources (PER) module, specifically for versions 12.1.1 and 12.2.2. It serves as the central repository for recording and managing individual competency assessments. A competence element represents a specific instance where a competency, skill, or qualification is associated with a person, job, or position, and is evaluated with a rating. This table is fundamental to talent management processes, enabling organizations to track skill proficiencies, conduct performance appraisals, manage career development, and align workforce capabilities with organizational requirements.

Key Information Stored

The table's primary key is COMPETENCE_ELEMENT_ID, which uniquely identifies each competency record. Essential columns include COMPETENCE_ID, linking to the master list of competencies (PER_COMPETENCES), and RATING_LEVEL_ID, which stores the evaluated proficiency. The table captures the context of the assessment through columns like PERSON_ID, JOB_ID, and POSITION_ID. It also supports hierarchical competency structures via PARENT_COMPETENCE_ELEMENT_ID, which is a self-referencing foreign key. Other critical attributes include ASSESSMENT_ID and ASSESSMENT_TYPE_ID for grouping evaluations, and ORGANIZATION_ID and BUSINESS_GROUP_ID for security and data partitioning. Columns for PROFICIENCY_LEVEL_ID and HIGH_PROFICIENCY_LEVEL_ID allow for tracking current and target skill levels.

Common Use Cases and Queries

This table is central to reporting and analytics on workforce skills. Common use cases include generating skill gap analyses for a department, creating individual development plans, and identifying qualified candidates for positions based on required competencies. A typical query might join PER_COMPETENCE_ELEMENTS with PER_ALL_PEOPLE_F to list all competencies for an employee, including their ratings.

• Sample Query (Employee Competency Profile):
  SELECT ppf.full_name, pc.competence_name, prl.name rating
  FROM per_competence_elements pce,
  per_all_people_f ppf,
  per_competences pc,
  per_rating_levels prl
  WHERE pce.person_id = ppf.person_id
  AND SYSDATE BETWEEN ppf.effective_start_date AND ppf.effective_end_date
  AND pce.competence_id = pc.competence_id
  AND pce.rating_level_id = prl.rating_level_id
  AND ppf.employee_number = '12345';
• Reporting Use Case: Identifying employees in a specific job who have not yet achieved the required proficiency level in a critical competency by comparing RATING_LEVEL_ID against a target level defined in PER_JOBS or a separate requirements table.

Related Objects

The PER_COMPETENCE_ELEMENTS table has extensive foreign key relationships, integrating it deeply within the HR schema. Key documented relationships include:

• PER_COMPETENCES: (PER_COMPETENCE_ELEMENTS.COMPETENCE_ID) Links to the master definition of the competency.
• PER_ASSESSMENTS & PER_ASSESSMENT_TYPES: (ASSESSMENT_ID, ASSESSMENT_TYPE_ID) Associates the element with a formal appraisal or evaluation event.
• PER_RATING_LEVELS: Multiple FKs (RATING_LEVEL_ID, WEIGHTING_LEVEL_ID, PROFICIENCY_LEVEL_ID, HIGH_PROFICIENCY_LEVEL_ID) for scoring and weighting.
• HR_ALL_ORGANIZATION_UNITS: (ORGANIZATION_ID, BUSINESS_GROUP_ID, ENTERPRISE_ID) Provides organizational context and security.
• PER_JOBS & PER_ALL_POSITIONS: (JOB_ID, POSITION_ID) Links competencies to roles within the enterprise.
• PER_COMP_ELEMENT_OUTCOMES: (COMPETENCE_ELEMENT_ID) Child table for detailed assessment results.
• Self-Referencing: (PARENT_COMPETENCE_ELEMENT_ID) Supports competency hierarchies.