Results for “per_tuition_methods”

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

Overview

APPS.HRFV_QUALIFICATIONS is a Business Intelligence (BIS) reporting view in the Oracle E-Business Suite Human Resources (HR) module. It presents a consolidated, security-aware, and multilingual-denormalized picture of qualifications and professional licenses recorded for employees across one or more business groups. Rather than exposing the raw PER_QUALIFICATIONS table with its numerous foreign keys, the view joins qualification records to their type definitions, translations, person records, establishments, and business group names, and decodes several coded columns into user-facing labels through the HR_BIS package. This makes the view suitable for ad-hoc reporting, Oracle Discoverer worksheets, XML Publisher data templates, and integration extracts where readable qualification data is required without re-implementing the standard BIS decoding and security logic.

The view is closely associated with the user search term "per_tuition_methods," which appears in the view text as the lookup type decoded into the method_of_reimbursement column (hr_bis.bis_decode_lookup('PER_TUITION_METHODS', qua.tuition_method)). The PER_TUITION_METHODS lookup governs how a qualification's tuition is reimbursed, and this view surfaces it alongside fee, fee currency, and training amounts.

Underlying Base Objects

The view is owned by APPS and defined over the following documented base objects:

• PER_QUALIFICATIONS (synonym) — the driving table holding the actual qualification/license record for a person, including status, awarded and expiry dates, fees, training amounts, attendance reference, and business group.
• PER_QUALIFICATIONS_TL (synonym) — the translated qualification rows supplying language-specific attributes such as title, grade attained, awarding body, reimbursement arrangements, units, restrictions, and group ranking.
• PER_QUALIFICATION_TYPES (synonym) — the qualification type definition linked via qualification_type_id.
• PER_PEOPLE_X (view) — the person records providing full_name and person_id.
• PER_ESTABLISHMENT_ATTENDANCES (synonym) — attendance rows linking a person to the educational establishment.
• PER_ESTABLISHMENTS (synonym) — establishment master data supplying the school or college name and establishment_id.
• HR_ALL_ORGANIZATION_UNITS_TL (synonym) — business group organization names.
• HR_BIS (package) — provides BIS decoding of lookup values and the security profile business group restriction.
• HR_SECURITY, HR_GENERAL, HR_PERSON_NAME (packages) — supporting security and formatting logic referenced by the view.

The joins are largely equi-joins on the qualification, attendance, establishment, type, and business group keys, with outer joins (+) applied to the person and establishment relationships. Language filtering uses userenv('LANG') on both translation tables. Row-level security is enforced through NVL(hr_bis.get_sec_profile_bg_id, qua.business_group_id), restricting results to the business groups the querying user is authorized to access.

Key Columns

• business_group_name, business_group_id — the business group owning the qualification.
• person_name, person_id — the employee or person the qualification belongs to.
• qualification_title, qualification_type_name, qualification_category — descriptive attributes of the qualification and its type, with category decoded from PER_CATEGORIES.
• qualification_status — decoded from the PER_SUBJECT_STATUSES lookup.
• awarded_date, qualification_start_date, qualification_end_date, projected_completion_date, license_expiry_date — key dates.
• grade_attained, group_ranking — academic results.
• fee, fee_currency, total_training_amount, training_completed_amount, training_completed_units — financial and training measures.
• method_of_reimbursement — decoded from the PER_TUITION_METHODS lookup; central to the tuition reimbursement search.
• reimbursement_arrangements — type-level reimbursement policy.
• license_number, license_restrictions — license-specific attributes.
• school_or_college_name, school_or_college_id — establishment, using nvl(est.name, att.establishment).
• comments — free-text remarks.

Common Use Cases and Queries

Typical reporting scenarios include qualification and license inventories per employee, expiry monitoring, tuition and training cost analysis, and reimbursement method breakdowns.

Listing qualifications with reimbursement methods for a business group:

SELECT person_name,
       qualification_title,
       qualification_status,
       method_of_reimbursement,
       fee,
       fee_currency
FROM   apps.hrfv_qualifications
WHERE  business_group_id = :p_business_group_id
ORDER  BY person_name;

Monitoring expiring licenses:

SELECT person_name,
       qualification_title,
       license_number,
       license_expiry_date
FROM   apps.hrfv_qualifications
WHERE  license_expiry_date BETWEEN SYSDATE AND SYSDATE + 90
ORDER  BY license_expiry_date;

Summarizing training costs by reimbursement method:

SELECT method_of_reimbursement,
       COUNT(*)                qualification_count,
       SUM(total_training_amount) total_amount
FROM   apps.hrfv_qualifications
GROUP  BY method_of_reimbursement;

Because the view applies HR security profile filtering automatically, queries return only the business groups accessible to the logged-in user, eliminating the need for custom security predicates in reporting tools.