Search Results hz_person_language

Overview

IGSBV_PERSON_LANGUAGE is a read-only reporting view within the Oracle E-Business Suite IGS (Student System) product family, which is documented as obsolete in release 12.1.1 and 12.2.2. The view exposes the languages that a person speaks, reads, and writes, along with decoded lookup values for the native language and primary language indicators. It serves as a stable, denormalized presentation layer over the HZ_PERSON_LANGUAGE base table, allowing institutional reporting and integration routines to retrieve person-language proficiency data without directly querying the transactional table.

The view is defined with the WITH READ ONLY clause, guaranteeing that no DML operations can be issued against it. It is classified as "Not implemented in this database" in the reference environment, meaning the object may be absent or unreachable in the current instance, and deployments should verify its presence before use. Despite its obsolete status, the object remains relevant for legacy student-system integrations that predate its retirement.

Underlying Base Objects

The sole documented base object is HZ_PERSON_LANGUAGE, aliased as HPL in the view definition. No other referenced base objects are documented. The view filters the join by selecting only a fixed column set and appending two Oracle Lookup-derived attributes using the '_LA' column-alias syntax against IGS_LOOKUP_VALUES with lookup type YES_NO. The view joins these decoded values on the NATIVE_LANGUAGE and PRIMARY_LANGUAGE_INDICATOR columns of the base table, translating raw lookup codes into their MEANING values.

Because the view simply projects and decodes columns from HZ_PERSON_LANGUAGE, its row cardinality equals that of the base table, and no aggregation or filtering conditions are applied in the view text.

Key Columns

• LANGUAGE_USE_REFERENCE_ID — Primary reference identifier for the language usage record.
• PERSON_IDENTIFIER — Identifier of the person (party) to whom the language record belongs, derived from HPL.PARTY_ID.
• LANGUAGE_NAME — Name of the spoken, read, or written language.
• _LA:NATIVE_LANGUAGE — Decoded indicator of whether the language is the person's native language, resolved from IGS_LOOKUP_VALUES (YES_NO).
• PRIMARY_LANG_INDICATOR — Decoded indicator of whether the language is the person's primary language.
• READS_LEVEL, SPEAKS_LEVEL, WRITES_LEVEL — Proficiency levels for reading, speaking, and writing respectively.
• Audit columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, CREATION_DATE, LAST_UPDATE_LOGIN provide standard WHO-column auditing.

Common Use Cases and Queries

Typical usage includes student demographic reporting, language-proficiency extracts for admissions or placement, and integration feeds into third-party learning management systems. A representative query retrieves all language records for a person:

SELECT language_name, native_language, primary_lang_indicator, reads_level, speaks_level, writes_level FROM igsbv_person_language WHERE person_identifier = :person_id;

A second common pattern filters for primary languages across a population:

SELECT l.person_identifier, l.language_name, l.speaks_level FROM igsbv_person_language l WHERE l.primary_lang_indicator = 'Y';

Consumers should note the obsolete classification and confirm object availability in the target environment before relying on these queries in production.