Results for “training_completed_amount”

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

Overview

PER_QUALIFICATIONS is a Human Resources (PER) module table in the HR schema that stores a record of educational qualifications, certificates, licenses, and similar credentials that a person holds or is actively acquiring. Within Oracle EBS 12.1.1 and 12.2.2, it functions as the central repository for applicant and employee qualification data, supporting recruiting, professional development, succession planning, and compliance-driven licensing requirements. Each row represents a single qualification instance tied to a specific person, and the table carries descriptive, financial, and licensure attributes alongside twenty descriptive flexfield (DFF) columns and twenty corresponding "QUA_INFORMATION" attribute columns for customer-specific extensions.

The ETRM metadata classifies this object as satellite-leaning under a heuristic Data Vault model. In practical modeling terms, this suggests PER_QUALIFICATIONS behaves as a descriptive satellite attached to person and qualification-type hubs, with its own durable business key. It is not a pure hub, since it holds substantial descriptive and financial attributes rather than serving solely as a key registry.

Key Information Stored

The surrogate primary key is QUALIFICATION_ID, enforced by the PER_QUALIFICATIONS_PK constraint. The secondary unique index, PER_QUALIFICATIONS_UK, is documented as a composite business-key candidate over START_DATE, QUALIFICATION_TYPE_ID, ATTENDANCE_ID, TITLE, BUSINESS_GROUP_ID, and PERSON_ID. This combination reflects the business rule that a given person's same qualification type, title, and start date within a business group should not duplicate.

The most significant columns include:

• QUALIFICATION_ID – surrogate primary key uniquely identifying each qualification record.
• PERSON_ID – the person (employee or applicant) who holds or is acquiring the qualification.
• QUALIFICATION_TYPE_ID – foreign key classifying the credential (degree, certificate, license, membership).
• ATTENDANCE_ID – foreign key to the establishment attendance tying the qualification to an academic institution or establishment.
• BUSINESS_GROUP_ID – foreign key to HR_ALL_ORGANIZATION_UNITS identifying the business group that owns the record.
• TITLE – free-text title or name of the qualification.
• START_DATE and END_DATE – the acquisition or study period.
• AWARDED_DATE – date the qualification was conferred.
• STATUS and GRADE_ATTAINED – current state and grade or result.
• LICENSE_NUMBER, EXPIRY_DATE, and LICENSE_RESTRICTIONS – license-specific details.
• AWARDING_BODY, PROFESSIONAL_BODY_NAME, MEMBERSHIP_NUMBER, and MEMBERSHIP_CATEGORY – issuing and membership information.
• FEE, FEE_CURRENCY, TOTAL_TRAINING_AMOUNT, and REIMBURSEMENT_ARRANGEMENTS – financial tracking of the credential.
• OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, and LAST_UPDATE_DATE – standard audit and optimistic-locking columns.

The twenty ATTRIBUTE1–20 DFF columns and twenty QUA_INFORMATION1–20 columns provide extensibility for localized or industry-specific qualification data.

Common Use Cases and Queries

Typical scenarios include reporting current employee credentials, tracking license expiry for compliance, and analyzing training investment. A basic query retrieves all qualifications for a person:

• SELECT qualification_id, title, qualification_type_id, awarded_date, status FROM per_qualifications WHERE person_id = :p_person_id

For expiring-license compliance, filter on EXPIRY_DATE within a rolling window, joining PEOPLE or PER_ALL_PEOPLE_F for names. To retrieve subjects taken against a qualification, join PER_SUBJECTS_TAKEN on QUALIFICATION_ID. Descriptive flexfield reporting selects ATTRIBUTE_CATEGORY with the relevant ATTRIBUTE columns, while QUA_INFORMATION columns support seeded localization segments exposed through Oracle HRMS qualification forms.

Related Objects

The following objects are most significant to this table, based on the documented foreign key relationships:

• PER_QUALIFICATION_TYPES – joined via QUALIFICATION_TYPE_ID to classify the credential.
• PER_ESTABLISHMENT_ATTENDANCES – joined via ATTENDANCE_ID to identify the awarding establishment and attendance record.
• HR_ALL_ORGANIZATION_UNITS – joined via BUSINESS_GROUP_ID to resolve the owning business group.
• PER_SUBJECTS_TAKEN – child table joined on QUALIFICATION_ID, listing subjects within a qualification.
• PER_ALL_PEOPLE_F – joined via PERSON_ID to obtain person names and current records.

These relationships confirm PER_QUALIFICATIONS as a dependent satellite integrating person, qualification-type, and establishment dimensions while parenting subject-level detail through PER_SUBJECTS_TAKEN.