Results for “subject_status”

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

Overview

HRFV_SUBJECTS is a business view template in the Oracle E-Business Suite 12.1.1 / 12.2.2 environment, owned by the APPS schema and delivered as part of the PER (Human Resources) product family. As indicated by its description, it serves as the source template from which the flexfield view is generated. The view presents a consolidated, denormalized picture of the qualifications, subjects taken, and establishment attendance records associated with a person, joining information across the qualification, subject, establishment, and business group domains into a single read-only reporting surface.

The object is registered as VALID and is defined WITH READ ONLY, meaning it is intended strictly for query and reporting purposes rather than for direct DML operations. Because the view resolves descriptive values through lookup decoding and applies an Oracle HRMS security profile filter, it is well suited to ad-hoc reporting, HR analytics, and integration extracts where a human-readable rendering of employee qualification and subject data is required.

Underlying Base Objects

The view is defined over several base tables, synonyms, views, and packages. The documented referenced objects are HR_ALL_ORGANIZATION_UNITS_TL, HR_BIS (package), HR_GENERAL (package), HR_PERSON_NAME (package), HR_SECURITY (package), PER_ESTABLISHMENTS, PER_ESTABLISHMENT_ATTENDANCES, PER_PEOPLE_X, PER_QUALIFICATIONS, PER_QUALIFICATIONS_TL, PER_QUALIFICATION_TYPES_TL, PER_SUBJECTS_TAKEN, and PER_SUBJECTS_TAKEN_TL.

In the view text, the driving data is PER_SUBJECTS_TAKEN (aliased SUB), which is joined to PER_QUALIFICATIONS (QUA) on QUALIFICATION_ID. The qualification in turn links to PER_QUALIFICATION_TYPES (QUT) via QUALIFICATION_TYPE_ID, to PER_ESTABLISHMENT_ATTENDANCES (ATT) via ATTENDANCE_ID, and to HR_ALL_ORGANIZATION_UNITS_TL (BGRT) via BUSINESS_GROUP_ID. Outer joins to PER_PEOPLE_X (PEO) and PER_ESTABLISHMENTS (EST) preserve records even where person or establishment details are absent. The HR_BIS package supplies the BIS_DECODE_LOOKUP function used for lookup decoding, while HR_SECURITY drives the business group security predicate through GET_SEC_PROFILE_BG_ID.

Key Columns

• BUSINESS_GROUP_NAME — Name of the business group, resolved from HR_ALL_ORGANIZATION_UNITS_TL using the user's language.
• PERSON_NAME — Full name of the person, derived from PER_PEOPLE_X.
• SUBJECT — Decoded subject value, rendered through the PER_SUBJECTS lookup.
• MAJOR — Yes/No indicator decoded via the YES_NO lookup, flagging whether the subject was a major.
• SUBJECT_STATUS — Decoded status of the subject via the PER_SUBJECT_STATUSES lookup.
• SUBJECT_GRADE_ATTAINED, SUBJECT_START_DATE, SUBJECT_END_DATE — Grade and date range for the subject taken.
• QUALIFICATION_TYPE and QUALIFICATION_TITLE — Descriptive qualification type name and qualification title.
• SCHOOL_OR_COLLEGE_NAME — Name of the establishment attended.
• QUALIFICATION_START_DATE, QUALIFICATION_END_DATE — Date range of the qualification.
• BUSINESS_GROUP_ID, PERSON_ID, QUALIFICATION_ID — Identifiers that link the view back to the underlying business group, person, and qualification records. QUALIFICATION_ID is the join key to PER_QUALIFICATIONS.

Common Use Cases and Queries

Typical scenarios include HR qualification audits, regulatory reporting, learning management extracts, and integration feeds into external systems. The mandatory business group security predicate restricts results to the business groups the querying user is authorized to see.

To retrieve all subjects for a given person:

• SELECT person_name, subject, major, subject_status, qualification_title FROM hr fv_subjects WHERE person_id = :p_person_id;

To report qualifications and subjects by business group:

• SELECT business_group_name, qualification_type, qualification_title, subject FROM hrfv_subjects WHERE business_group_id = :p_bg_id ORDER BY qualification_title, subject;

To trace subjects back to their qualification identifier (the search term "qualification_id"):

• SELECT qualification_id, qualification_title, subject, subject_grade_attained FROM hrfv_subjects WHERE qualification_id = :p_qualification_id;

Because the view is read-only and decoded through HR_BIS lookups, it should be queried directly rather than used as a DML target; write operations must target the underlying PER_QUALIFICATIONS, PER_SUBJECTS_TAKEN, and related tables.