Results for “per_competences”

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

Overview

PER_COMPETENCES is a core Human Resources (PER) table in Oracle E-Business Suite 12.1.1 and 12.2.2, owned by the HR schema. It stores the definition of a competence — a discrete unit of knowledge, skill, ability, or personal characteristic that a person may possess. Competences serve as the master reference list against which employee assessments, competency profiles, position requirements, and eligibility rules are all evaluated. Because the table holds the canonical name, alias, rating scale linkage, and behavioral definition of each competence, it functions as the anchor point for the wider competency management model spanning performance, learning, recruiting, benefits, and manufacturing skills.

Under the heuristic Data Vault classification derived from the foreign-key structure, PER_COMPETENCES is hub-leaning. In a dimensional or Data Vault model, the table would be treated as a hub: it carries a stable surrogate key (COMPETENCE_ID) and the descriptive, largely immutable attributes of the competence itself, while the many dependent tables act as links and satellites. Note that this classification is a modeling suggestion inferred from the FK footprint, not a documented Oracle construct.

Key Information Stored

The table defines 74 columns in the documented 12.2.2 physical schema. The most significant are:

• COMPETENCE_ID — the surrogate primary key (PER_COMPETENCES_PK) and the value propagated to every dependent table.
• BUSINESS_GROUP_ID — the business group (HR_ALL_ORGANIZATION_UNITS) that owns the competence; a unique key (PER_COMPETENCES_UK2) together with NAME.
• NAME — the competence name, the primary business identifier visible to users.
• COMPETENCE_ALIAS — a short code or alternate reference, itself documented as a unique key (PER_COMPETENCES_UK3).
• COMPETENCE_DEFINITION_ID — foreign key to PER_COMPETENCE_DEFINITIONS, carrying the descriptive definition text.
• RATING_SCALE_ID — foreign key to PER_RATING_SCALES, dictating how the competence is scored.
• MIN_LEVEL / MAX_LEVEL — the numeric proficiency boundaries for the competence.
• BEHAVIOURAL_INDICATOR — flags whether the competence is behavioural rather than technical.
• CERTIFICATION_REQUIRED, EVALUATION_METHOD — assessment-related configuration flags.
• RENEWAL_PERIOD_FREQUENCY / RENEWAL_PERIOD_UNITS — validity and renewal timing for certified competences.
• DATE_FROM / DATE_TO — effective-dating window for the competence.
• COMPETENCE_CLUSTER, LEVEL_TYPE, LEVEL_NUMBER — grouping and level classification attributes.
• OBJECT_VERSION_NUMBER, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY — concurrency control and audit columns.
• Numbered ATTRIBUTE1–20 and INFORMATION1–20 flexfield segments for extensible customer data.

The distinction to note is that COMPETENCE_ID is a system-generated surrogate, whereas NAME (with BUSINESS_GROUP_ID) and COMPETENCE_ALIAS are the documented business-key candidates.

Common Use Cases and Queries

Typical scenarios include building a competence catalogue per business group, resolving a competence name to its rating scale for assessment screens, and driving competency-profile reporting for performance and succession planning. Common SQL patterns join the hub to its lookup satellites:

• Listing competences by business group: SELECT competence_id, name, competence_alias FROM per_competences WHERE business_group_id = :p_bg_id.
• Resolving the rating scale: join PER_RATING_SCALES on RATING_SCALE_ID.
• Reporting which competences belong to a profile: join PA_COMPETENCE_PROFILES on COMPETENCE_ID.
• Identifying certified competences with renewal rules using CERTIFICATION_REQUIRED and RENEWAL_PERIOD_UNITS.

Related Objects

• HR_ALL_ORGANIZATION_UNITS — parent business group via PER_COMPETENCES.BUSINESS_GROUP_ID.
• PER_RATING_SCALES — rating scale via RATING_SCALE_ID.
• PER_COMPETENCE_DEFINITIONS — definition text via COMPETENCE_DEFINITION_ID.
• PER_COMPETENCE_ELEMENTS, PER_COMPETENCE_OUTCOMES, PER_RATING_LEVELS — child tables keyed on COMPETENCE_ID.
• PA_COMPETENCE_PROFILES and PA_COMPETENCE_CRITERIA_TEMP — project competency profiles referencing COMPETENCE_ID.
• BOM_RESOURCES / BOM_OPERATION_SKILLS — manufacturing skill requirements.
• AHL_RESOURCE_SKILLS — product-development resource skills.
• BEN_COMPTNCY_RT_F / BEN_ELIG_COMPTNCY_PRTE_F — benefits eligibility by competence.
• OTA_COMPETENCE_LANGUAGES — learning-management translations.
• IEX_STRATEGY_WORK_SKILLS / IEX_STRY_TEMP_WORK_ITEMS_B — interaction-center strategy work skills.