Search Results igs_ps_us_prenr_cfg

Overview

The IGS_PS_US_PRENR_CFG table is a data object within the Oracle E-Business Suite (EBS) Student System (IGS) module. Its primary function is to store configuration details related to pre-enrollment for a student's Year of Program. This table acts as a master reference for defining specific pre-enrollment rules or mappings, which are subsequently utilized in the unit set mapping process. It is critical to note that the provided ETRM metadata explicitly labels the IGS - Student System as "Obsolete" and states this table is "Not implemented in this database," indicating it may be a legacy or placeholder object in the documented releases (12.1.1 / 12.2.2). Its role is foundational to the configuration of academic program structures prior to student enrollment.

Key Information Stored

The table's structure is defined by a composite primary key, which dictates the core data it holds. The key columns are MAPPING_SET_CD and SEQUENCE_NO. The MAPPING_SET_CD represents a unique code identifying a specific mapping set or configuration rule. The SEQUENCE_NO determines the order or precedence of entries within a given mapping set, allowing for sequenced logic in the pre-enrollment configuration. Additionally, the metadata indicates a unique key constraint on the UNIT_SET_CD column, which would store the code for a Unit Set (a collection of academic units), linking the configuration to a specific academic program component.

Common Use Cases and Queries

In a functional environment, this table would be queried to retrieve or validate the pre-enrollment rules applicable to a student's year of study within a program. A typical use case involves an academic advisor determining which unit sets a student is eligible to pre-enroll in based on their program year. A common SQL pattern would join this configuration table to the unit set mapping table to retrieve the full mapping details. For example, a query to list all configurations might be: SELECT mapping_set_cd, sequence_no, unit_set_cd FROM igs_ps_us_prenr_cfg ORDER BY mapping_set_cd, sequence_no;. Reporting use cases would center on auditing the established pre-enrollment pathways and their sequence for various programs.

Related Objects

The primary documented relationship for IGS_PS_US_PRENR_CFG is with the IGS_EN_UNIT_SET_MAP table. This is established via a foreign key relationship where the columns IGS_EN_UNIT_SET_MAP.MAPPING_SET_CD and IGS_EN_UNIT_SET_MAP.SEQUENCE_NO reference the primary key (MAPPING_SET_CD, SEQUENCE_NO) of IGS_PS_US_PRENR_CFG. This relationship signifies that the pre-enrollment configuration defined in IGS_PS_US_PRENR_CFG is concretely applied or detailed within individual unit set mapping records. The IGS_EN_UNIT_SET_MAP table likely contains the specific unit-to-unit-set mappings governed by the configuration sets defined in this master table.