Search Results igs_pe_gov_lang_cd

Overview

The table IGS_PE_GOV_LANG_CD is a reference data entity within the Oracle E-Business Suite (EBS) 12.1.1 / 12.2.2, specifically in the now-obsolete Student System (IGS) module. Its primary function is to store a standardized list of language codes as defined by the Australian Department of Education, Employment and Training (DEET). This table provides a controlled vocabulary for government-reported language classifications, enabling consistent data capture and reporting for educational institutions. Examples include code '02' for Afghani and '21' for Fijian. It is critical to note the ETRM metadata explicitly states this table is "Not implemented in this database," indicating it may exist as a shell or placeholder in standard installations, with actual implementation dependent on specific institutional customization.

Key Information Stored

The table's structure is centered around the government language code. The primary and most significant column is GOVT_LANGUAGE_CD, which stores the unique DEET language identifier (e.g., '02', '21'). While the provided metadata does not list additional columns, typical reference tables in this context would also include descriptive fields such as a language name, an inactive date flag, and creation/modification audit columns. The primary key constraint IGS_PE_GOV_LANG_CD_PK is enforced on the GOVT_LANGUAGE_CD column, ensuring data integrity and uniqueness within the reference set.

Common Use Cases and Queries

The primary use case is to validate and translate between institutional language codes and the government-mandated DEET codes for official reporting. In operational scenarios, it serves as a lookup for forms or processes where a student's language must be reported in the government-standardized format. A common query would involve joining this table to student demographic data to produce a report with the official language description.

• Basic lookup for all active government language codes: SELECT govt_language_cd FROM igs_pe_gov_lang_cd WHERE SYSDATE BETWEEN start_date AND NVL(end_date, SYSDATE);
• Joining to a student language table to get DEET descriptions: SELECT s.student_id, l.govt_language_cd, g.description FROM igs_pe_language_cd l JOIN igs_pe_gov_lang_cd g ON l.govt_language_cd = g.govt_language_cd JOIN igs_pe_student_base s ON l.person_id = s.person_id;

Related Objects

The table has a defined foreign key relationship, making it a parent reference table for student language data. The documented relationship is:

• Foreign Key Table: IGS_PE_LANGUAGE_CD
• Relationship: The column IGS_PE_LANGUAGE_CD.GOVT_LANGUAGE_CD references IGS_PE_GOV_LANG_CD.GOVT_LANGUAGE_CD.
• Purpose: This relationship ensures that a student's recorded government language code in the IGS_PE_LANGUAGE_CD table is valid and exists in the official list of DEET codes.

No other foreign key relationships are documented in the provided metadata. As a core reference table, it may also be linked to various student demographic interfaces, batch reporting programs, and descriptive flexfield value sets within the IGS module.