Search Results per_qualification_types

Overview

The PER_QUALIFICATION_TYPES table is a foundational reference table within the Oracle E-Business Suite Human Resources (PER) module. Its primary role is to maintain the master list of qualification categories that can be assigned to individuals within the organization. This table acts as a central lookup, standardizing the types of qualifications—such as academic degrees, professional certifications, licenses, or language proficiencies—that the enterprise tracks for its workforce. By defining these types centrally, it ensures data consistency across all employee qualification records and supports related functionalities in recruitment, competency management, and resource planning.

Key Information Stored

The table's structure is designed to uniquely identify and describe each qualification type. The primary key is QUALIFICATION_TYPE_ID, a system-generated unique identifier. A critical column is NAME, which holds the descriptive title of the qualification type (e.g., "Bachelor's Degree," "Project Management Professional," "First Aid Certification") and is itself protected by a unique key constraint (PER_QUALIFICATION_TYPES_UK) to prevent duplicates. While the provided ETRM excerpt focuses on keys, typical implementations of this table may also include columns for enabling or disabling a qualification type, controlling its usage, and storing user-defined descriptive flexfield segments to capture additional organization-specific attributes.

Common Use Cases and Queries

This table is primarily queried in conjunction with transactional tables to report on or validate employee qualifications. A common use case is generating a list of all employees holding a specific type of qualification, such as a security clearance. This supports compliance reporting and talent searches. Another key scenario is within the iRecruitment (IRC) module, where the table defines the allowable qualification levels for candidate search criteria. A typical reporting query would join PER_QUALIFICATION_TYPES to PER_QUALIFICATIONS. For example:

• SELECT pq.QUALIFICATION_TYPE_ID, pqt.NAME, COUNT(pq.PERSON_ID) AS HOLDER_COUNT FROM PER_QUALIFICATIONS pq, PER_QUALIFICATION_TYPES pqt WHERE pq.QUALIFICATION_TYPE_ID = pqt.QUALIFICATION_TYPE_ID GROUP BY pq.QUALIFICATION_TYPE_ID, pqt.NAME;

This query summarizes the number of employees associated with each qualification type. Administrators also frequently query this table to maintain the list of available types via standard EBS forms or custom data loads.

Related Objects

As documented in the ETRM, PER_QUALIFICATION_TYPES is referenced by several key transactional tables via foreign key relationships, underscoring its central role. The primary relationship is with the PER_QUALIFICATIONS table, which stores the actual qualification instances assigned to persons, linked via QUALIFICATION_TYPE_ID. It is also referenced by PER_COMPETENCE_ELEMENTS, linking qualification types to the competency framework. Within the Advanced Service Logistics (AHL) module, the AHL_RESOURCE_SKILLS table references it to classify resource skills. Furthermore, the iRecruitment module's IRC_SEARCH_CRITERIA table references it twice: for both the minimum (MIN_QUAL_LEVEL) and maximum (MAX_QUAL_LEVEL) qualification level criteria used in candidate searches.