Results for “hrfv_qualifications”

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

Overview

HRFV_QUALIFICATIONS is an APPS-owned business view template in the Oracle E-Business Suite Human Resources (PER) module. It is not a conventional reporting view in isolation; rather, it is the flexfield view template from which a descriptive flexfield (DFF) view is generated. This distinction is significant because the view is designed to carry the "_DF:PER:PER_QUALIFICATIONS:QUA" flexfield context reference, meaning it serves as the semantic layer that exposes both standard qualification attributes and the descriptive flexfield columns for the PER_QUALIFICATIONS entity.

In Oracle EBS 12.1.1 and 12.2.2, HRFV_QUALIFICATIONS presents a flattened, denormalized projection of qualification records. Each row represents a single qualification attained by a person, enriched with the business group name, the person's full name, the qualification type and category, the awarding body, and licensing details. This makes it a practical foundation for reporting, extracts, and integration interfaces that need human-readable qualification data without navigating the full normalized PER schema.

Underlying Base Objects

The view is defined over a join of several PER and HR objects. The documented base objects include PER_QUALIFICATIONS (the primary qualification record), PER_QUALIFICATION_TYPES (the qualification type definition), PER_ESTABLISHMENT_ATTENDANCES (linking the person to an establishment), PER_ESTABLISHMENTS (the school or college attended), PER_PEOPLE_X (the person record), and HR_ALL_ORGANIZATION_UNITS_TL (the business group translation table). Supporting packages referenced include HR_BIS (for BIS_DECODE_LOOKUP translations of lookup values), HR_GENERAL, HR_PERSON_NAME, and HR_SECURITY.

The join logic is anchored on QUA.QUALIFICATION_TYPE_ID = QUT.QUALIFICATION_TYPE_ID and QUA.ATTENDANCE_ID = ATT.ATTENDANCE_ID, with outer joins from attendance to person and establishment. The business group is resolved through BGRT.ORGANIZATION_ID matching QUA.BUSINESS_GROUP_ID, filtered by the session language. The combination of HR_SECURITY and HR_PERSON_NAME packages indicates the view respects Oracle HR security profiles and applies person name formatting rules, which is important when the view is consumed by restricted users.

Key Columns

The view exposes both business attributes and technical keys. Notable columns relevant to the "license_number" search include LICENSE_NUMBER (the actual license identifier stored on the qualification), LICENSE_EXPIRY_DATE (mapped from QUA.EXPIRY_DATE), and LICENSE_RESTRICTIONS (any restrictions on the license). These three columns make the view particularly valuable for professional licensing and certification tracking.

• QUALIFICATION_TITLE — the title of the qualification awarded.
• QUALIFICATION_STATUS — decoded via HR_BIS.BIS_DECODE_LOOKUP from the PER_SUBJECT_STATUSES lookup.
• QUALIFICATION_CATEGORY — decoded from the PER_CATEGORIES lookup.
• QUALIFICATION_TYPE_NAME — the type of qualification (from PER_QUALIFICATION_TYPES).
• AWARDED_DATE / PROJECTED_COMPLETION_DATE — actual and expected attainment dates.
• GRADE_ATTAINED — the grade or result achieved.
• FEE, FEE_CURRENCY, TOTAL_TRAINING_AMOUNT, TRAINING_COMPLETED_AMOUNT — financial and training measures.
• METHOD_OF_REIMBURSEMENT — decoded from the PER_TUITION_METHODS lookup.
• SCHOOL_OR_COLLEGE_NAME — using NVL(EST.NAME, ATT.ESTABLISHMENT).
• Awarding body, group ranking, comments — additional descriptive fields.
• BUSINESS_GROUP_ID, PERSON_ID, QUALIFICATION_ID, SCHOOL_OR_COLLEGE_ID — technical key columns.

Common Use Cases and Queries

The view supports qualification compliance reporting, license expiration monitoring, tuition reimbursement analysis, and HR integration extracts. A typical query retrieves qualifications for a person, including license details, filtering by business group. For example:

SELECT person_name, qualification_title, license_number, license_expiry_date, awarding_body FROM apps.hrfv_qualifications WHERE business_group_id = :p_bg_id AND person_id = :p_person_id ORDER BY awarded_date DESC;

For license renewal tracking, a query can identify qualifications with licenses expiring within a window:

SELECT person_name, qualification_title, license_number, license_expiry_date FROM apps.hrfv_qualifications WHERE license_number IS NOT NULL AND license_expiry_date BETWEEN SYSDATE AND ADD_MONTHS(SYSDATE, 6) ORDER BY license_expiry_date;

Because the view is a flexfield template, users should be aware that the generated DFF view (based on the "_DF:PER:PER_QUALIFICATIONS:QUA" context) may be used alongside it to retrieve descriptive flexfield segments. Direct querying of HRFV_QUALIFICATIONS is appropriate for read-only reporting; data maintenance should be performed through the corresponding PER_QUALIFICATIONS base table or the Oracle HRMS forms. Security profiles applied via HR_SECURITY in the view ensure that results are constrained to the user's authorized business groups and person records.