Search Results govt_perm_resident_cd




Overview
Explore in AI Chat

Overview

The IGS_PE_GOV_PER_RESCD table is a core reference data object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Oracle Student Management (OSM) product, owned by the IGS schema. It functions as a standardized code lookup table that defines government-mandated permanent residency statuses for students. Its primary role is to provide a controlled, validated list of codes, as specified by the Australian Department of Education, Training and Youth Affairs (DETYA) Higher Education Student Data Collection standards (specifically Element No. 390 from the 1997 collection). This table ensures data integrity and compliance for institutional reporting by serving as the authoritative source for these government codes, which are then mapped to institution-specific codes within the application.

Key Information Stored

The table stores the code, its description, and its active status. The GOVT_PERM_RESIDENT_CD column (NUMBER, Primary Key) is the unique identifier for the government-defined residency status. The DESCRIPTION (VARCHAR2(60)) provides the human-readable meaning of the code. A critical operational column is CLOSED_IND (VARCHAR2(1)), which acts as an inactivation flag; when set, it prevents the code from being used in new or modified institutional records. Standard EBS "Who" columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) track the audit history for each row.

Common Use Cases and Queries

The primary use case is the maintenance and validation of student permanent residency data for compliance and reporting. Administrators use this table as a reference when setting up institutional codes and when generating government compliance reports. A typical query retrieves all active codes for use in a validation list of values (LOV) within a form or interface.

-- Retrieve all active government permanent residence codes
SELECT govt_perm_resident_cd,
       description
FROM igs.igs_pe_gov_per_rescd
WHERE closed_ind = 'N'
ORDER BY 1;

Another common pattern is to join this table to institutional mappings to verify or report on code usage across the student population, ensuring alignment with government specifications.

Related Objects

The IGS_PE_GOV_PER_RESCD table has a direct and essential relationship with the institutional mapping table. It is referenced via a foreign key constraint by the IGS_PE_PERM_RES_CD table. This relationship links the government standard code (IGS_PE_GOV_PER_RESCD.GOVT_PERM_RESIDENT_CD) to an institution's internal definition of a permanent residence code (IGS_PE_PERM_RES_CD.GOVT_PERM_RESIDENT_CD). This design allows an institution to maintain its own codes and descriptions while maintaining a mandatory mapping to the official government standard for reporting purposes. The primary key constraint on this table is named IGS_PE_GOV_PER_RESCD_PK.