Results for “per_competence_elements”

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

Overview

PER_COMPETENCE_ELEMENTS is a Human Resources (PER) table in the Oracle E-Business Suite, owned by the HR schema. It records an individual competence along with an associated evaluation rating, functioning as the central repository for competency assessment data at the person, job, position, or organization level. A competency in this context can represent a skill, behavior, qualification, or certification, and each competence element captures both the definition of the required or demonstrated competence and the rating assigned during evaluation.

The table carries 91 documented columns in ETRM 12.2.2, making it a wide, richly attributed object. Based on the foreign key structure mined from the metadata, the heuristic Data Vault classification is satellite-leaning. This suggests a modeling approach in which the competence element functions primarily as a descriptive record attached to a parent business key, surrounded by numerous reference relationships rather than acting as an independent hub or a pure transactional link. Its self-referencing PARENT_COMPETENCE_ELEMENT_ID also introduces a hierarchical dimension.

Key Information Stored

The surrogate primary key is COMPETENCE_ELEMENT_ID (index PER_COMPETENCE_ELEMENTS_PK), which uniquely identifies each competence element row. The most significant columns include:

• COMPETENCE_ID — foreign key to PER_COMPETENCES, defining which competence is being recorded.
• PERSON_ID — the individual to whom the competence applies.
• RATING_LEVEL_ID, PROFICIENCY_LEVEL_ID, and HIGH_PROFICIENCY_LEVEL_ID — foreign keys to PER_RATING_LEVELS capturing the assigned rating and proficiency thresholds.
• WEIGHTING_LEVEL_ID — also referencing PER_RATING_LEVELS, used when competencies are weighted in an assessment.
• ASSESSMENT_ID and ASSESSMENT_TYPE_ID — link the element to a specific assessment event and its classification.
• VALID_GRADE_ID — references PER_VALID_GRADES, tying competency to grade validity.
• QUALIFICATION_TYPE_ID — references PER_QUALIFICATION_TYPES for qualification-based competencies.
• JOB_ID and POSITION_ID — constrain the competence to a job or position context.
• ORGANIZATION_ID, BUSINESS_GROUP_ID, and ENTERPRISE_ID — organizational scoping columns.
• PARENT_COMPETENCE_ELEMENT_ID — self-referencing hierarchy for nested competence structures.
• MANDATORY, STATUS, COMPETENCE_TYPE, and SEQUENCE_NUMBER — control flags and ordering.
• EFFECTIVE_DATE_FROM and EFFECTIVE_DATE_TO — date-effective validity window.
• CERTIFICATION_DATE, CERTIFICATION_METHOD, and NEXT_CERTIFICATION_DATE — certification tracking.
• LINE_SCORE and APPR_LINE_SCORE — numeric scoring values.

Twenty ATTRIBUTE columns and twenty INFORMATION columns provide descriptive flexfield and information field extensibility.

Common Use Cases and Queries

Typical scenarios include competency gap analysis, certification tracking, and assessment reporting. A common query retrieves all competences for a person with their ratings:

SELECT ce.competence_element_id, c.competence_name, rl.rating_name
FROM per_competence_elements ce
JOIN per_competences c ON ce.competence_id = c.competence_id
JOIN per_rating_levels rl ON ce.rating_level_id = rl.rating_level_id
WHERE ce.person_id = :person_id;

Managers frequently query competences filtered by JOB_ID or POSITION_ID to determine required versus demonstrated proficiency. Certification reporting uses CERTIFICATION_DATE and NEXT_CERTIFICATION_DATE to identify expiring credentials. Hierarchical reporting traverses PARENT_COMPETENCE_ELEMENT_ID to rebuild competence structures. Date-effectiveness is applied through EFFECTIVE_DATE_FROM and EFFECTIVE_DATE_TO predicates.

Related Objects

• PER_COMPETENCES — joined via COMPETENCE_ID; defines the competence.
• PER_RATING_LEVELS — joined via RATING_LEVEL_ID, PROFICIENCY_LEVEL_ID, HIGH_PROFICIENCY_LEVEL_ID, and WEIGHTING_LEVEL_ID.
• PER_ASSESSMENTS and PER_ASSESSMENT_TYPES — joined via ASSESSMENT_ID and ASSESSMENT_TYPE_ID.
• HR_ALL_ORGANIZATION_UNITS — joined via ORGANIZATION_ID, BUSINESS_GROUP_ID, and ENTERPRISE_ID.
• PER_VALID_GRADES — joined via VALID_GRADE_ID.
• PER_QUALIFICATION_TYPES — joined via QUALIFICATION_TYPE_ID.
• PER_JOBS and PER_ALL_POSITIONS — joined via JOB_ID and POSITION_ID.
• PER_COMP_ELEMENT_OUTCOMES — references this table via COMPETENCE_ELEMENT_ID.
• PA_COMPETENCE_PROFILES — references this table via COMPETENCE_ELEMENT_ID.
• OTA_ACTIVITY_VERSIONS — joined via ACTIVITY_VERSION_ID for learning linkage.