Results for “per_qualification_types”

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

Overview

PER_QUALIFICATION_TYPES is a core Human Resources (PER) reference table in Oracle E-Business Suite 12.1.1 and 12.2.2, owned by the HR schema. It maintains the list of qualification types that can be attained by employees, applicants, and resources, and functions as a definition table that categorizes qualifications within the enterprise's competency and qualification framework. Each row represents a qualification type — such as a degree, certification, license, or coursework — against which individual qualifications are recorded in the PER_QUALIFICATIONS table.

From a Data Vault modeling perspective, the heuristic classification for this object is hub-leaning. Its single-column surrogate primary key, generated from a stable business identifier, and its role as the referenced parent of several downstream foreign keys support treating QUALIFICATION_TYPE_ID as a hub key. The descriptive columns (NAME, CATEGORY, RANK, and the framework attributes) would naturally be modeled as a satellite on that hub, with the various referencing tables represented as links or dependent satellites.

Key Information Stored

The table contains 73 documented columns. The most significant are:

• QUALIFICATION_TYPE_ID — the surrogate primary key (PER_QUALIFICATION_TYPES_PK) that uniquely identifies each qualification type and is propagated to all referencing tables.
• NAME — the business-key candidate, uniquely enforced by the PER_QUALIFICATION_TYPES_UK unique index; this is the user-visible qualification type name.
• CATEGORY and RANK — classification and ordering attributes used to group and sequence qualification types.
• QUALIFICATION_TYPE and QUAL_FRAMEWORK_ID — identify the type classification and the qualification framework to which the type belongs.
• LEVEL_TYPE and LEVEL_NUMBER — define the level scale associated with the type, used in minimum/maximum level comparisons.
• CREDIT_TYPE and CREDITS — describe credit-bearing attributes for the qualification type.
• FIELD, SUB_FIELD, and PROVIDER — capture the subject area and issuing body.
• QA_ORGANIZATION — the quality assurance or accrediting organization.
• OBJECT_VERSION_NUMBER, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard WHO columns for concurrency control and audit.
• ATTRIBUTE_CATEGORY, ATTRIBUTE1–ATTRIBUTE20, INFORMATION_CATEGORY, INFORMATION1–INFORMATION30, and ZD_EDITION_NAME — descriptive flexfield and extensibility columns, with ZD_EDITION_NAME forming part of the unique index for editioning support.

Common Use Cases and Queries

Typical uses include reporting on available qualification types, validating lookups during qualification entry, and joining to downstream tables for competency and resource-skill analysis. A basic lookup query retrieves active qualification types by name:

• SELECT qualification_type_id, name, category, rank FROM per_qualification_types ORDER BY name;

To list qualifications recorded against each type, join to PER_QUALIFICATIONS:

• SELECT q.qualification_type_id, t.name, COUNT(*) FROM per_qualifications q JOIN per_qualification_types t ON q.qualification_type_id = t.qualification_type_id GROUP BY q.qualification_type_id, t.name;

Reporting scenarios frequently involve the IRC_SEARCH_CRITERIA min/max level ranges, which reference this table on MIN_QUAL_LEVEL and MAX_QUAL_LEVEL, and the AHL_RESOURCE_SKILLS linkage used in resource qualification tracking.

Related Objects

Five foreign keys reference this table, defining its place in the qualification and competency model:

• PER_QUALIFICATIONS.QUALIFICATION_TYPE_ID — the principal child table storing individual qualifications attained.
• PER_COMPETENCE_ELEMENTS.QUALIFICATION_TYPE_ID — links competence elements to qualification types.
• AHL_RESOURCE_SKILLS.QUALIFICATION_TYPE_ID — associates resource skills with qualification types.
• IRC_SEARCH_CRITERIA.MIN_QUAL_LEVEL — recruitment search minimum level bound.
• IRC_SEARCH_CRITERIA.MAX_QUAL_LEVEL — recruitment search maximum level bound.

These relationships make PER_QUALIFICATION_TYPES a central reference point for HR qualification, competency, and iRecruitment search functionality across the PER and AHL modules.