Search Results igs_pe_govcitizen_cd

Overview

The IGS_PE_GOVCITIZEN_CD table is a core reference table within the Oracle E-Business Suite Student System (IGS) module, specifically for versions 12.1.1 and 12.2.2. It serves as a master list of standardized citizenship codes as defined by the Australian Department of Education, Employment and Workplace Relations (DEET). This table functions as a lookup entity, ensuring data integrity and consistency by providing a controlled set of valid values. Its primary role is to supply the allowable citizenship codes that can be recorded against a student's demographic information, typically within person statistics entities, for official reporting and compliance purposes.

Key Information Stored

The table's structure is designed to store a concise code set. The central and most critical column is GOVT_CITIZENSHIP_CD, which serves as the table's primary key. This column holds the unique alphanumeric code representing a specific citizenship status, such as '1' for Australian Citizen or '2' for New Zealand Citizen. While the provided ETRM metadata does not list additional columns explicitly, typical reference tables in this context often include descriptive columns like a meaning or description field (e.g., DESCRIPTION) to provide the full text associated with the code, and standard WHO columns for tracking creation and modification history. The integrity of the GOVT_CITIZENSHIP_CD values is enforced by the primary key constraint IGS_PE_GOVCITIZEN_CD_PK.

Common Use Cases and Queries

The primary use case for this table is to validate and describe citizenship information during student data entry, processing, and reporting. It is essential for generating government-compliant statistical reports on student demographics. Common SQL operations involve joining this reference table to transactional student data. A typical query would retrieve a student's citizenship description by linking through the relevant statistics table. For example, to list students with their formal citizenship status, a query would join from a student demographics table to IGS_ST_CITIZENSHP_CD and then to IGS_PE_GOVCITIZEN_CD to resolve the code into its descriptive meaning. Administrators may also run simple SELECT statements against IGS_PE_GOVCITIZEN_CD itself to maintain the list of valid codes for system setup or data validation tasks.

Related Objects

The IGS_PE_GOVCITIZEN_CD table has a direct and documented foreign key relationship with the IGS_ST_CITIZENSHP_CD table. This relationship is defined as follows:

• Referencing Table: IGS_ST_CITIZENSHP_CD
• Foreign Key Column: IGS_ST_CITIZENSHP_CD.GOVT_CITIZENSHIP_CD
• References: IGS_PE_GOVCITIZEN_CD.GOVT_CITIZENSHIP_CD (Primary Key)

This relationship indicates that the IGS_ST_CITIZENSHP_CD table, which likely stores specific citizenship instances for persons, must use values that exist in the IGS_PE_GOVCITIZEN_CD master table. This enforces referential integrity, ensuring all recorded citizenship codes are valid and predefined. No other foreign key relationships are documented in the provided metadata.