Search Results igs_st_citizenshp_cd

Overview

The table IGS_ST_CITIZENSHP_CD is a core reference entity within the Oracle E-Business Suite Student System (IGS). It functions as a user-defined lookup table, centrally storing and maintaining the valid codes that represent different citizenship statuses for individuals within the system. Its primary role is to ensure data integrity and consistency by providing a controlled list of values for the citizenship attribute across related student and person entities. As a foundational component of the Student System's data model, it supports critical processes in student administration, demographic reporting, and government compliance reporting by standardizing this key demographic identifier.

Key Information Stored

The table's structure is designed to manage code-value pairs for citizenship. The primary and most critical column is CITIZENSHIP_CD, which stores the unique user-defined code, such as 'USC' for U.S. Citizen or 'PR' for Permanent Resident. Based on standard EBS patterns and the provided foreign key relationship, the table also contains a column named GOVT_CITIZENSHIP_CD. This column likely stores a corresponding government-standardized citizenship code, creating a mapping between the institution's internal codes and official external classifications. This facilitates accurate reporting to governmental bodies. Additional descriptive columns, common to such lookup tables, would typically include fields for the code's meaning (DESCRIPTION), an active indicator (CLOSED_IND), and standard WHO columns for auditing.

Common Use Cases and Queries

This table is primarily accessed for validation, reporting, and data integration. A common operational use case is populating a list of values (LOV) in forms where a user must select a student's citizenship, such as during person or student record creation. For reporting, it is frequently joined to person statistics to analyze student demographics by citizenship status. A typical query to retrieve all active citizenship codes with their descriptions would be: SELECT citizenship_cd, description FROM igs.igs_st_citizenshp_cd WHERE closed_ind = 'N' ORDER BY 1;. For data integration, the relationship via GOVT_CITIZENSHIP_CD is used to translate internal codes into government-submission formats, ensuring compliance in statutory returns.

Related Objects

The IGS_ST_CITIZENSHP_CD table is integrated into the Student System through defined key relationships, as documented in the ETRM metadata.

• Primary Key Constraint: IGS_ST_CITIZENSHP_CD_PK on the column CITIZENSHIP_CD.
• Foreign Key (Outgoing Reference): The column GOVT_CITIZENSHIP_CD references the table IGS_PE_GOVCITIZEN_CD. This links the user-defined code to an official government citizenship code.
• Foreign Key (Incoming Reference): The column CITIZENSHIP_CD is referenced by the IGS_PE_STATISTICS table via its CITIZENSHIP_CD column. This is the primary usage link, where the citizenship code is assigned to a person's statistical record, making it a critical source for demographic data.