Search Results govt_country_cd

Overview

The IGS_PE_GOV_COUNTRYCD table is a core reference table within the Oracle E-Business Suite Student System (IGS). It serves as the master repository for the official DEET (Department of Education, Employment and Training) set of country codes. This table provides the standardized government-defined codes, such as '0011' for Albania, which are used to ensure data consistency and compliance with governmental reporting requirements across student-related modules. Its primary role is to act as a controlled lookup source for country information, enabling accurate demographic recording and statutory reporting for student entities.

Key Information Stored

The table's structure is designed to store the authoritative government country code list. The central column is GOVT_COUNTRY_CD, which serves as the table's primary key. This column holds the unique, government-issued numeric or alphanumeric identifier for a country (e.g., '0011', '0208'). While the provided metadata does not list all columns, a table of this nature typically includes complementary fields such as a description or name for the country (e.g., 'Albania', 'Zambia'), and potentially validity dates or inactive indicators to manage the code list over time. The integrity of the GOVT_COUNTRY_CD is critical as it is referenced by other key person and country tables in the system.

Common Use Cases and Queries

This table is primarily used in scenarios involving student demographic data entry, validation, and government compliance reporting. When entering or updating a person's country of citizenship or origin, the application validates the input against the valid codes in IGS_PE_GOV_COUNTRYCD. Common reporting use cases include generating demographic summaries for regulatory bodies. A typical SQL query to retrieve the active government country list would be: SELECT govt_country_cd, description FROM igs.igs_pe_gov_countrycd WHERE SYSDATE BETWEEN start_date AND NVL(end_date, SYSDATE) ORDER BY govt_country_cd;. Another frequent pattern is joining this table to person data for reports: SELECT p.person_id, g.description FROM igs.igs_pe_country_cd p, igs.igs_pe_gov_countrycd g WHERE p.govt_country_cd = g.govt_country_cd;.

Related Objects

The IGS_PE_GOV_COUNTRYCD table has a direct and documented foreign key relationship with the IGS_PE_COUNTRY_CD table, which is a more general person-country code mapping table. The relationship is defined as follows:

• The IGS_PE_COUNTRY_CD table references IGS_PE_GOV_COUNTRYCD via its GOVT_COUNTRY_CD column. This links a person's specific country code record to the official government standard stored in IGS_PE_GOV_COUNTRYCD.

This relationship ensures that any country code used within a person's context can be traced back to an authorized government code, maintaining data integrity for downstream processes and reports.