Search Results igs_pe_perm_res_cd

Overview

The IGS_PE_PERM_RES_CD table is a core reference table within the Oracle E-Business Suite Student System (IGS). It functions as a master data repository for permanent residence codes, which are critical for classifying and reporting on student demographics, particularly for government compliance and institutional statistics. This table standardizes the valid codes used across the system to denote a person's permanent residency status, ensuring data consistency in related transactional and reporting modules. Its role is foundational to maintaining referential integrity for student personal data.

Key Information Stored

As a reference code table, its primary purpose is to store a controlled list of valid codes and their descriptions. The central column is PERM_RESIDENT_CD, which serves as the unique primary key for the table. This column holds the short code representing a specific permanent residence status. While the provided metadata does not list all columns, such tables typically include descriptive fields like MEANING and DESCRIPTION to provide the full text associated with the code. Additional standard columns for tracking, such as CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, and LAST_UPDATED_BY, are also commonly present.

Common Use Cases and Queries

The primary use case is the validation and lookup of permanent residence codes during data entry for a person or student record. It is essential for generating accurate demographic reports for government bodies and internal institutional research. A common query involves joining this table to student statistics to produce a descriptive report. For example:

• Reporting on Student Residency: SELECT s.person_id, prc.perm_resident_cd, prc.meaning FROM igs_pe_statistics s, igs_pe_perm_res_cd prc WHERE s.perm_resident_cd = prc.perm_resident_cd;
• Listing All Valid Codes: SELECT perm_resident_cd, meaning, description FROM igs_pe_perm_res_cd WHERE SYSDATE BETWEEN start_date_active AND NVL(end_date_active, SYSDATE) ORDER BY perm_resident_cd;

Related Objects

The table maintains defined relationships with other key entities in the Student System, as documented in the ETRM metadata. These relationships are crucial for understanding data flow and dependencies.

• Primary Key: IGS_PE_PERM_RES_CD_PK on the column PERM_RESIDENT_CD.
• Foreign Key (Outgoing Reference): The table contains a self-referential or mapping relationship where IGS_PE_PERM_RES_CD.GOVT_PERM_RESIDENT_CD references the IGS_PE_GOV_PER_RESCD table. This links internal codes to official government codes.
• Foreign Key (Incoming Reference): The IGS_PE_STATISTICS table references this table via its PERM_RESIDENT_CD column. This is the primary usage link, where student statistical records store a code validated against this reference table.