Search Results govt_citizenship_cd




Overview
Explore in AI Chat

Overview

The IGS_PE_GOVCITIZEN_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 Oracle Student Management (OSM) or related educational modules under the IGS schema. It serves as a master list of standardized government codes that define a student's citizenship and residency status. Its primary role is to enforce data integrity by providing a controlled set of allowable values, as mandated by governmental reporting requirements like the DETYA (Department of Education, Training and Youth Affairs) Higher Education Student Data Collection. This table is critical for accurate student demographic reporting and compliance.

Key Information Stored

The table is structured to store the code, its description, and its active status. The key columns are:

  • GOVT_CITIZENSHIP_CD (NUMBER): The primary key. A unique numeric identifier for a specific citizenship/residency status (e.g., 1 for Australian citizen, 2 for New Zealand citizen).
  • DESCRIPTION (VARCHAR2(60)): The textual description of the code, providing clear meaning for reporting and user interfaces.
  • CLOSED_IND (VARCHAR2(1)): A flag indicating whether the code is active ('N') or closed ('Y'). A closed code cannot be assigned to new or modified student records, supporting historical data preservation.
  • Standard WHO Columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN): Audit columns that track the user and timestamp for record creation and modification.

Common Use Cases and Queries

This table is primarily used in two contexts: data validation and regulatory reporting. When entering or updating a student's citizenship information, the application validates the entered code against this table. For reporting, it is joined to student demographic tables to translate numeric codes into meaningful descriptions for government submissions or internal analytics. A typical query to retrieve all active citizenship codes for a lookup list would be:

SELECT govt_citizenship_cd, description
FROM igs.igs_pe_govcitizen_cd
WHERE closed_ind = 'N'
ORDER BY govt_citizenship_cd;

To analyze student distribution by citizenship status, a report would join this table to the relevant student statistics entity, such as IGS_PE_PERSON_STATISTICS or its derivatives.

Related Objects

The IGS_PE_GOVCITIZEN_CD table is a referenced parent table in the data model. Its primary key is enforced by the index IGS_PE_GOVCITIZEN_CD_U1. The documented foreign key relationship is:

  • IGS_ST_CITIZENSHP_CD.GOVT_CITIZENSHIP_CD references IGS_PE_GOVCITIZEN_CD.GOVT_CITIZENSHIP_CD. This indicates that the institution-specific citizenship code definitions (likely in IGS_ST_CITIZENSHP_CD) are mapped to the standardized government codes stored in this table, ensuring institutional data aligns with national reporting standards.