Search Results language_cd

Overview

The IGS_PE_LANGUAGE_CD table is a core reference data table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Institutional Global Systems (IGS) module. It serves as a master repository for institution-defined language codes used primarily for student demographic and statistical reporting. Its critical role is to maintain a controlled mapping between an institution's internal language codes and standardized government-defined language codes, ensuring data collected for entities like students can be accurately reported to external regulatory bodies, such as the Department of Education, Training and Youth Affairs (DETYA) in the context of higher education data collections.

Key Information Stored

The table stores the definition and administrative state of each language code. Key columns include:

• LANGUAGE_CD (VARCHAR2(10), Primary Key): The unique, institution-defined identifier for a language.
• GOVT_LANGUAGE_CD (NUMBER): The foreign key linking to the government-standardized language code, enabling regulatory reporting compliance.
• DESCRIPTION (VARCHAR2(60)): A descriptive name for the institution-defined language code.
• CLOSED_IND (VARCHAR2(1)): A flag indicating whether the code is active ('N') or closed ('Y'), preventing its future use in new person statistics records.
• NOTES (VARCHAR2(2000)): A free-text field for supplementary information.
• Standard WHO Columns (CREATED_BY, CREATION_DATE, etc.): Audit columns tracking the record's creation and last update details.

Common Use Cases and Queries

This table is central to maintaining and validating language data for student profiles and compliance reporting. Common operational and reporting queries involve joining to related transactional tables or validating active codes. A fundamental query to retrieve all active, mapped language codes is:

SELECT ilc.language_cd, ilc.description, ilc.govt_language_cd, glc.govt_description
FROM igs.igs_pe_language_cd ilc,
igs.igs_pe_gov_lang_cd glc
WHERE ilc.govt_language_cd = glc.govt_language_cd
AND NVL(ilc.closed_ind, 'N') = 'N'
ORDER BY ilc.language_cd;

Another critical use case is data validation during student data entry or batch loading, ensuring that a provided HOME_LANGUAGE_CD exists and is active in IGS_PE_LANGUAGE_CD. Reporting use cases typically involve aggregating student statistics by language for internal dashboards or preparing submissions for government bodies by utilizing the mapped GOVT_LANGUAGE_CD.

Related Objects

The IGS_PE_LANGUAGE_CD table maintains defined relationships with several other key tables in the IGS schema, primarily through foreign key constraints:

• Referenced By (Parent): IGS.IGS_PE_GOV_LANG_CD via the GOVT_LANGUAGE_CD column. This enforces that every institution code must map to a valid government standard code.
• Referenced From (Child):
  • IGS_PE_STATISTICS.HOME_LANGUAGE_CD → Links language codes to individual student statistical records.
  • IGS_AD_TER_EDU.LANGUAGE_COMPONENT → Associates language codes with tertiary education admission terms.
  • IGS_AD_TER_EDU.LANGUAGE_OF_TUITION → Associates language codes with the language of instruction for admission terms.

These relationships underscore the table's role as a central reference point for language data across student demographics, statistics, and admissions processes within the EBS system.