Results for “igs_pe_language_cd”

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

Overview

IGS.IGS_PE_LANGUAGE_CD is a reference (lookup) table within the Oracle EBS IGS — Student System product. As its ETRM description states, the entity "describes the available list of user-defined language codes" maintained by an institution. It functions as the seeded and locally extensible vocabulary of spoken, governmental, and instructional languages used throughout student records, admissions, and statistics processing. Institutions rely on it so that values entered for a person's home language, a program's language of tuition, or a term's language component are constrained to a controlled, institution-defined set rather than free text.

Following the heuristic Data Vault classification supplied in the metadata, this object is hub-leaning: its single-column primary key, LANGUAGE_CD, behaves like a durable business key around which descriptive attributes and downstream associations cluster. Teams modeling the Student System analytically may therefore treat IGS_PE_LANGUAGE_CD as a candidate hub, with the descriptive columns carried as satellite attributes.

Key Information Stored

The table carries a documented total of ten columns, of which the following are the most operationally significant:

• LANGUAGE_CD — the primary key column and the single unique business key, enforced by unique index IGS_PE_LANGUAGE_CD_U1 and the primary key constraint IGS_PE_LANGUAGE_CD_PK. This is the value other tables store when they reference a language.
• GOVT_LANGUAGE_CD — a foreign key to IGS_PE_GOV_LANG_CD, mapping the institution-defined code to the government/regulatory language classification used for statutory reporting.
• DESCRIPTION — the user-facing name of the language, typically the value displayed in LOVs and reports.
• CLOSED_IND — a status flag indicating whether the code is retired and therefore unavailable for new entry while remaining valid for historical records.
• NOTES — free-form institutional commentary.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard Oracle EBS "WHO" audit columns recording insert and update attribution and timestamps.

The primary key here is a natural business key rather than a generated surrogate; LANGUAGE_CD itself is both the PK and the unique-index candidate.

Common Use Cases and Queries

Typical scenarios include populating language LOVs in admissions and student maintenance forms, reporting on the linguistic composition of a student body, and validating that instructional language assignments reference an open code. A standard lookup query is:

• SELECT language_cd, description FROM igs_pe_language_cd WHERE closed_ind = 'N' ORDER BY description;
• Joining to statistics to profile home languages: SELECT s.home_language_cd, l.description, COUNT(*) FROM igs_pe_statistics s, igs_pe_language_cd l WHERE s.home_language_cd = l.language_cd GROUP BY s.home_language_cd, l.description;
• Resolving the government equivalent for regulatory extracts: SELECT l.language_cd, l.description, g.description FROM igs_pe_language_cd l, igs_pe_gov_lang_cd g WHERE l.govt_language_cd = g.govt_language_cd;

Because the table is small and slowly changing, it is frequently extracted in full into reporting marts and cached in application lookup views.

Related Objects

Relationship data identifies one outbound reference and three inbound references:

• IGS_PE_GOV_LANG_CD — referenced by IGS_PE_LANGUAGE_CD.GOVT_LANGUAGE_CD; supplies the governmental language definition.
• IGS_PE_STATISTICS — references this table via HOME_LANGUAGE_CD, capturing each student's home language for statistical and equity reporting.
• IGS_AD_TER_EDU — references this table twice, through LANGUAGE_COMPONENT and LANGUAGE_OF_TUITION, defining language-related attributes of a student's prior or current education.

These relationships confirm the table's role as a shared reference hub across admissions (IGS_AD) and student records (IGS_PE) functionality in Oracle EBS 12.1.1 and 12.2.2.