Results for “hrifv_pereit”

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

Overview

HRIFV_PEREIT is a read-only Oracle E-Business Suite view owned by the APPS schema in the Human Resources Intelligence (HRI) product family. It exposes person-level Extra Information Types (EIT) — the configurable, flexfield-style attribute groups that Oracle HRMS administrators attach to person records — and denormalizes each EIT instance into a single report-ready row. The view therefore bridges the transactional HRMS tables used to store extra person information and the flat, descriptive structures required by Oracle HRMS Intelligence reports, Discoverer workbooks, and downstream integration extracts.

Because HRI is the reporting and analytics layer for Human Resources, HRIFV_PEREIT is not a transaction-entry object. It is queried, not maintained. The view is defined WITH READ ONLY, and all DML against it is prohibited by the database. Query access is additionally constrained by HR Security through row-level business group filtering.

Underlying Base Objects

The view is defined over three core HRMS objects, with supporting lookups and security routines supplied by packages and synonyms:

• PER_PEOPLE_EXTRA_INFO (SYNONYM) — the transactional table holding one row per person/EIT instance, including the PERSON_EXTRA_INFO_ID primary key.
• PER_PEOPLE_INFO_TYPES (SYNONYM) — the EIT definition table supplying the information type, description, active/inactive and multiple-occurrence flags, and legislation code.
• PER_PEOPLE_F (VIEW) — the effective-dated person view providing FULL_NAME, PERSON_ID, BUSINESS_GROUP_ID, and the person effective start/end dates.
• HR_BIS (PACKAGE) — supplies BIS_DECODE_LOOKUP, which converts YES/NO lookup codes into user-readable values.
• HR_GENERAL (PACKAGE) — supplies GET_BUSINESS_GROUP_ID, which drives the business group restriction in the WHERE clause.
• HR_PERSON_NAME and HR_SECURITY (PACKAGE) — referenced by the name and security logic underlying the person name and business group filters.

Joins are performed on INFORMATION_TYPE between the EIT instance and its definition, and on PERSON_ID between the instance and the person record.

Key Columns

• PERSON_NAME — the person's full name from PER_PEOPLE_F, the attribute most commonly searched by users.
• INFORMATION_TYPE — the EIT identifier shared between the instance and definition tables; the join key.
• ACTIVE_INACTIVE / MULTIPLE_OCCURENCES — decoded YES/NO display values derived from the EIT definition flags.
• ACTIVE_INACTIVE_FLAG / MULTIPLE_OCCURENCES_FLAG — the underlying undecoded flag values.
• EXTRA_INFO_TYPE_DESCRIPTION — the descriptive label of the information type.
• LEGISLATION_CODE — the legislation to which the EIT definition applies.
• PERSON_EFFECTIVE_START_DATE / PERSON_EFFECTIVE_END_DATE — the effective-dating range of the person record.
• PERSON_EXTRA_INFO_ID, PERSON_ID, BUSINESS_GROUP_ID — surrogate and foreign keys that support joins and security filtering.
• "_DF:EIT_DF1" and "_DF:EIT_DF2" — internal descriptive flexfield reference columns used by the HRI reporting engine.

Common Use Cases and Queries

Typical uses include person EIT reports, data-quality audits for missing or inactive EITs, HR extracts, and Discoverer worksheets. The canonical query filters by person name or information type and enforces the current business group:

SELECT person_name, information_type, extra_info_type_description, active_inactive, legislation_code FROM apps.hrifv_pereit WHERE person_name LIKE :name ORDER BY person_name, information_type;

Auditing inactive EIT definitions currently assigned to people:

SELECT person_name, information_type, active_inactive FROM apps.hrifv_pereit WHERE active_inactive_flag = 'N';

Listing all EITs for a specific person:

SELECT information_type, extra_info_type_description FROM apps.hrifv_pereit WHERE person_id = :person_id;

Because the view is read-only and business group filtered, no DML is possible and results are automatically restricted to the querying session's authorized business group.