Search Results govt_country_cd

Overview

The IGS_PE_COUNTRY_CD table is a core reference table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Oracle Student Management (formerly Oracle Campus Solutions) product family under the IGS (iGrants) schema. Its primary role is to maintain an institution-defined list of country codes, enabling educational institutions to map their internal country classifications to standardized government codes. This table is essential for ensuring data consistency in student demographic records, international applications, and regulatory reporting where country information is a mandatory data element.

Key Information Stored

The table stores both user-defined and official government country identifiers, along with descriptive and administrative data. The key columns are:

• COUNTRY_CD (VARCHAR2(10)): The primary key and mandatory institution-specific code for a country.
• GOVT_COUNTRY_CD (VARCHAR2(2)): The corresponding official two-character government country code as defined by the Australian Department of Education, Training and Youth Affairs (DETYA), facilitating standardized external reporting.
• DESCRIPTION (VARCHAR2(60)): A textual description of the institution-defined country code.
• CLOSED_IND (VARCHAR2(1)): A flag indicating whether the country code record is active ('N') or inactive/closed ('Y'), supporting data integrity in user interfaces.
• NOTES (VARCHAR2(2000)): A free-text field for administrative notes related to the country code entry.
• Standard WHO Columns (CREATED_BY, CREATION_DATE, etc.): Audit columns tracking the user and timestamp for record creation and modification.

Common Use Cases and Queries

This table is primarily queried for validation, data translation, and reporting. A common use case is validating a student's country of citizenship or residence against the institution's approved list during data entry. Another critical use is generating reports for government bodies, where internal codes must be translated to the official GOVT_COUNTRY_CD. The table is often joined to person (PE) and address tables.

Sample queries include retrieving all active country codes:

SELECT country_cd, description, govt_country_cd
FROM igs.igs_pe_country_cd
WHERE closed_ind = 'N'
ORDER BY description;

Or, finding the government code for a specific internal code:

SELECT govt_country_cd
FROM igs.igs_pe_country_cd
WHERE country_cd = :p_internal_country_code;

Related Objects

As a reference table, IGS_PE_COUNTRY_CD is a parent table to numerous other objects within the IGS schema that store country-related data, particularly in student and person modules. While the provided dependency list shows it is referenced by the APPS synonym IGS_PE_COUNTRY_CD, in practice, it is foundational to tables storing person addresses, citizenship details, and birth country information. Any form, report, or interface in Oracle Student Management that captures or displays a country likely uses this table as the primary validation source. The unique index (IGS_PE_COUNTRY_CD_U1) on COUNTRY_CD enforces data integrity for these foreign key relationships.