Search Results igs_pe_gov_per_rescd_pk

Overview

The table IGS_PE_GOV_PER_RESCD is a reference data entity within the Oracle E-Business Suite, specifically the now-obsolete IGS (Student System) product family. Its core function is to serve as a master list or code lookup for government-defined permanent residence statuses. This table is critical for standardizing and validating residency information for persons within the student system, ensuring data integrity and compliance with governmental reporting requirements. The metadata explicitly notes this table is "Not implemented in this database," indicating it may have been defined for product completeness but not actively populated or used in a standard deployment of the specified EBS versions (12.1.1 / 12.2.2). Its role is to act as the authoritative source for valid residency codes referenced by other transactional tables.

Key Information Stored

Based on the provided metadata, the table's structure is centered on a single primary key column. The most critical data element is the GOVT_PERM_RESIDENT_CD column, which constitutes the table's primary key (IGS_PE_GOV_PER_RESCD_PK). This column stores the unique alphanumeric codes that represent distinct government-recognized permanent residence statuses. While the ETRM excerpt does not list additional descriptive columns, typical reference tables of this nature often include supporting columns such as a description, an effective date range, and an inactive date to manage the lifecycle of the code.

Common Use Cases and Queries

The primary use case for this table is data validation and enrichment. When a user or an interface process enters or updates a person's residency code in a related transactional table, the system would validate the entered code against the valid values in IGS_PE_GOV_PER_RESCD. Common queries would involve listing all active codes for use in application drop-down lists or reporting on the distribution of codes. A typical SQL pattern would be a simple lookup or a join to retrieve the code description for a report.

-- Sample query to list all valid government residence codes
SELECT govt_perm_resident_cd
FROM igs_pe_gov_per_rescd
ORDER BY 1;

-- Sample join to get code details for persons
SELECT p.person_id,
       p.govt_perm_resident_cd,
       g.description
FROM   igs_pe_perm_res_cd p,
       igs_pe_gov_per_rescd g
WHERE  p.govt_perm_resident_cd = g.govt_perm_resident_cd;

Related Objects

The documented relationship data shows a clear foreign key dependency from the transactional table IGS_PE_PERM_RES_CD. This table stores the permanent residence code for a person and uses IGS_PE_GOV_PER_RESCD as its validation source.

• Referencing Table: IGS_PE_PERM_RES_CD
• Relationship: The column IGS_PE_PERM_RES_CD.GOVT_PERM_RESIDENT_CD is a foreign key that references IGS_PE_GOV_PER_RESCD.GOVT_PERM_RESIDENT_CD.
• Join Condition: IGS_PE_PERM_RES_CD.GOVT_PERM_RESIDENT_CD = IGS_PE_GOV_PER_RESCD.GOVT_PERM_RESIDENT_CD

This relationship enforces referential integrity, ensuring that any permanent residence code stored against a person in IGS_PE_PERM_RES_CD must exist as a valid code in the IGS_PE_GOV_PER_RESCD master table.