Results for “max_level”

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

Overview

PER_COMPETENCES_V is a PL/SQL-backed view owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2, delivered as part of the PER (Human Resources) product family. The view is documented in ETRM as being provided to support the Competences user interface, and it acts as a denormalized, presentation-ready projection of competence records. Rather than exposing raw transactional columns, it joins the base competence tables to their translation and definition tables and applies lookup decoding through server-side packages so that forms, OAF pages and concurrent programs receive human-readable values without additional processing.

Although the object is catalogued as a view, it is effectively a view over synonyms and package functions. The view text references CMP (PER_COMPETENCES), CPL (PER_COMPETENCES_TL), CMD (PER_COMPETENCE_DEFINITIONS), RSC/RSL (PER_RATING_SCALES and PER_RATING_SCALES_TL), and invokes functions from HR_GENERAL and PER_CPN_BUS. This makes it a read-only integration surface: it is not intended for direct DML, and the presence of ROWID in the select list allows the calling form to identify rows for update through the underlying entity rather than the view itself.

Underlying Base Objects

The ETRM 12.2.2 metadata lists the following referenced base objects: HR_GENERAL (package), PER_COMPETENCES (synonym), PER_COMPETENCES_TL (synonym), PER_COMPETENCE_DEFINITIONS (synonym), PER_CPN_BUS (package), PER_RATING_SCALES (synonym), and PER_RATING_SCALES_TL (synonym).

• PER_COMPETENCES is the primary transactional table, supplying COMPETENCE_ID, dates, business group, descriptive flexfield attributes, certification and renewal information, and the RATING_SCALE_ID foreign key.
• PER_COMPETENCES_TL is the translation table, supplying the language-dependent NAME, COMPETENCE_ALIAS and DESCRIPTION columns (CPL).
• PER_COMPETENCE_DEFINITIONS supplies the ID flexfield context via CMD.ID_FLEX_NUM and the thirty SEGMENT1 through SEGMENT30 columns used by the key flexfield structure.
• PER_RATING_SCALES and PER_RATING_SCALES_TL supply the scale name and the MIN_SCALE_STEP and MAX_SCALE_STEP bounds.
• HR_GENERAL provides DECODE_LOOKUP, used to translate coded evaluation-method and frequency values into display text.
• PER_CPN_BUS provides CHK_SET_RADIO_BUTTON, which resolves how the rating scale selection should be presented.

Because several references resolve through public synonyms, the view is dependent on the APPS synonym layer being valid and on EXECUTE privileges for the two packages. Invalidated package bodies will render the view inoperative.

Key Columns

• ROWID — pseudo-column used by the form for row identification.
• COMPETENCE_ID — primary key of the competence record.
• COMPETENCE_DEFINITION_ID, ID_FLEX_NUM, SEGMENT1–SEGMENT30 — key flexfield context and segments describing the competence definition.
• NAME, COMPETENCE_ALIAS, DESCRIPTION — translated text from PER_COMPETENCES_TL.
• BUSINESS_GROUP_ID — owning business group; a DECODE expression returns 'Y' when null, flagging global (seeded) competences.
• DATE_FROM, DATE_TO — effective dating.
• RATING_SCALE_ID, MIN/MAX level columns — the DECODE logic returns MIN_LEVEL/MAX_LEVEL when no scale is assigned, otherwise the scale's MIN_SCALE_STEP/MAX_SCALE_STEP.
• PER_CPN_BUS.CHK_SET_RADIO_BUTTON(...) — derived flag controlling radio-button presentation of scale selection.
• CERTIFICATION_REQUIRED, EVALUATION_METHOD, renewal frequency and units — with DECODE_LOOKUP columns supplying their display values.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE20 — descriptive flexfield values.
• Audit columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE.

Common Use Cases and Queries

The view is most commonly used for competence reporting, HR extracts and eligibility checks. To restrict to a specific business group, join or filter on BUSINESS_GROUP_ID:

• SELECT competence_id, name, date_from, date_to FROM per_competences_v WHERE business_group_id = :p_bg_id AND SYSDATE BETWEEN NVL(date_from, SYSDATE) AND NVL(date_to, SYSDATE+1);
• SELECT competence_id, name, certification_required, evaluation_method FROM per_competences_v WHERE business_group_id IS NULL; — retrieves global competences.
• SELECT competence_id, name, rating_scale_id FROM per_competences_v WHERE rating_scale_id IS NOT NULL;

Because several columns are function-derived, queries that filter on decoded values (for example the lookup description of EVALUATION_METHOD) cannot use an index and may require a function-based index or a materialized copy in a reporting schema. Note that the identifier qa_organization is not a column of this view and is not referenced anywhere in its definition; searches combining the two terms most likely originate from a combined HR quality-assurance data model rather than from PER_COMPETENCES_V itself. Queries must therefore target BUSINESS_GROUP_ID or the organization-related base tables separately.