Search Results per_qualifications




Overview
Explore in AI Chat

Overview

The PER_QUALIFICATIONS table is a core data structure within the Oracle E-Business Suite (EBS) Human Resources (HR) module, specifically under the PER product family. It serves as the central repository for storing records of formal and professional credentials associated with a person. This includes completed or in-progress educational qualifications, professional certifications, licenses, and other formally recognized achievements. Its primary role is to maintain a comprehensive historical and current profile of an individual's credentials, which is fundamental for talent management, compliance reporting, career development, and workforce planning processes within the application.

Key Information Stored

The table's structure is designed to capture the essential details of a qualification. The primary identifier is the system-generated QUALIFICATION_ID. Each record is uniquely constrained by a combination of START_DATE, QUALIFICATION_TYPE_ID, ATTENDANCE_ID, TITLE, BUSINESS_GROUP_ID, and PERSON_ID, as defined by the PER_QUALIFICATIONS_UK unique key. Critical columns include PERSON_ID, which links the qualification to an individual in the PER_ALL_PEOPLE_F table; QUALIFICATION_TYPE_ID, a foreign key to PER_QUALIFICATION_TYPES that classifies the credential (e.g., Degree, License, Certificate); and ATTENDANCE_ID, which can link to an educational institution record in PER_ESTABLISHMENT_ATTENDANCES. The BUSINESS_GROUP_ID anchors the record to the appropriate organizational security context. Additional columns typically store details such as the qualification's title, grade, awarding body, completion date, and any expiry information.

Common Use Cases and Queries

This table is pivotal for generating employee skills and qualifications profiles, verifying compliance for job roles requiring specific licenses, and reporting on organizational talent pools. Common reporting needs include listing all employees holding a specific certification or identifying individuals whose professional licenses are nearing expiration. A typical query might join PER_QUALIFICATIONS with PER_ALL_PEOPLE_F and PER_QUALIFICATION_TYPES to produce a readable report.

  • Sample Query Pattern: To find employees with an active 'Project Management Professional' certification: SELECT papf.full_name, pq.title, pq.date_obtained FROM per_qualifications pq, per_all_people_f papf, per_qualification_types pqt WHERE pq.person_id = papf.person_id AND pq.qualification_type_id = pqt.qualification_type_id AND SYSDATE BETWEEN papf.effective_start_date AND papf.effective_end_date AND pqt.name = 'Professional Certification' AND pq.title LIKE '%PMP%' AND (pq.expiry_date IS NULL OR pq.expiry_date > SYSDATE);

Related Objects

PER_QUALIFICATIONS is a central node in the HR data model with several key relationships. It is a child table of PER_QUALIFICATION_TYPES (for the type of qualification) and HR_ALL_ORGANIZATION_UNITS (for the business group). It can optionally link to PER_ESTABLISHMENT_ATTENDANCES to associate the qualification with a specific educational institution. Crucially, it acts as a parent table to PER_SUBJECTS_TAKEN, which stores detailed subject or module results for a broader qualification. This table is also heavily referenced by key HRMS APIs and is the foundation for numerous standard and custom HR reports concerning employee development and credentials.