Search Results govt_language_cd

Overview

The IGS.IGS_PE_GOV_LANG_CD table is a reference data table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Oracle Student Management (OSM) or Campus Solutions modules under the IGS (iGrants) schema. Its primary role is to maintain the standardized set of government-defined language codes, as mandated by the Australian Department of Education, Training and Youth Affairs (DETYA), now the Department of Education. The table serves as the authoritative source for valid codes that describe the use of a language other than English at a student's permanent home residence, corresponding to DETYA data element number 348. It functions as a critical validation entity for institutional language code setups, ensuring reporting compliance with governmental standards.

Key Information Stored

The table stores the code, its description, and its active status. The key columns are:

• GOVT_LANGUAGE_CD (NUMBER): The primary key and the unique numerical identifier for the government language code (e.g., 02 for Afghani, 21 for Fijian).
• DESCRIPTION (VARCHAR2(60)): The textual explanation of the code.
• CLOSED_IND (VARCHAR2(1)): A flag indicating whether the code is open for use ('N') or closed ('Y'). A closed status prevents the code from being assigned to new or modified institution-defined language records.
• Standard WHO Columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN): Audit columns tracking the creation and modification history of each row.

Common Use Cases and Queries

This table is primarily used during student data setup and governmental reporting. A common operational use case is when an administrator defines an institution-specific language code (in IGS_PE_LANGUAGE_CD) and must map it to a valid government standard code from this table for compliance. For reporting, the codes are used to aggregate and submit data on student language backgrounds to the relevant government authority. A typical query to retrieve all active government language codes for a lookup list would be:

SELECT GOVT_LANGUAGE_CD, DESCRIPTION
FROM IGS.IGS_PE_GOV_LANG_CD
WHERE CLOSED_IND = 'N'
ORDER BY GOVT_LANGUAGE_CD;

To analyze the mapping between institutional and government codes, a join with the related table is essential:
SELECT INST.LANGUAGE_CD, INST.DESCRIPTION, GOV.GOVT_LANGUAGE_CD, GOV.DESCRIPTION AS GOV_DESCRIPTION
FROM IGS.IGS_PE_LANGUAGE_CD INST, IGS.IGS_PE_GOV_LANG_CD GOV
WHERE INST.GOVT_LANGUAGE_CD = GOV.GOVT_LANGUAGE_CD(+);

Related Objects

The IGS_PE_GOV_LANG_CD table has a central relationship with the institution-specific language code definition table. The documented foreign key relationship is:

• Referencing Table: IGS.IGS_PE_LANGUAGE_CD
• Join Column: The GOVT_LANGUAGE_CD column in IGS_PE_LANGUAGE_CD references the GOVT_LANGUAGE_CD primary key in IGS_PE_GOV_LANG_CD.
• Relationship: This is a one-to-many relationship where a single government language code in IGS_PE_GOV_LANG_CD can be linked to multiple institution-defined language codes in IGS_PE_LANGUAGE_CD, enforcing referential integrity for data validation.