Search Results igs_ps_us_prenr_cfg_u2

Overview

The IGS_PS_US_PRENR_CFG table is a configuration table 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 (iGrants) schema, its core function is to store pre-enrollment configuration details for the Year of Program feature. It acts as a master definition table that establishes a controlled mapping between academic unit sets and mapping sets, governing how student academic plans are structured during the pre-enrollment process. The table's design ensures data integrity through unique constraints on its key business columns.

Key Information Stored

The table stores a concise set of columns focused on defining mapping relationships and audit trails. The primary business columns are:

• MAPPING_SET_CD (VARCHAR2(30)): The unique identifier for a grouping or set of mapping rules. This is a primary key column and is central to the table's function.
• UNIT_SET_CD (VARCHAR2(10)): The code representing an academic unit set (e.g., a major, minor, or concentration). This column has a unique constraint, meaning a unit set can be associated with only one mapping set in this configuration.
• SEQUENCE_NO (NUMBER): A number used to specify the processing or display order of records within a given MAPPING_SET_CD. It forms part of the composite primary key with MAPPING_SET_CD.

The remaining columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) are standard EBS "Who" columns for tracking row creation and modification history.

Common Use Cases and Queries

This table is primarily used in administrative setup and validation processes for student academic planning. A common operational query involves retrieving the full configuration for a specific mapping set to understand its composition.

SELECT mapping_set_cd,
       sequence_no,
       unit_set_cd
FROM igs.igs_ps_us_prenr_cfg
WHERE mapping_set_cd = '&MAPPING_SET_CODE'
ORDER BY sequence_no;

Another critical use case is validating or finding the mapping set associated with a particular unit set, which is essential for downstream enrollment logic.

SELECT mapping_set_cd
FROM igs.igs_ps_us_prenr_cfg
WHERE unit_set_cd = '&UNIT_SET_CODE';

Reporting often involves joining this configuration table with transactional data to analyze pre-enrollment setups across different academic programs.

Related Objects

The IGS_PS_US_PRENR_CFG table serves as a parent reference for other objects in the OSM module. The documented foreign key relationship indicates it is a key source of validated codes.

• Referenced By (Child Table): The table IGS_EN_UNIT_SET_MAP contains a foreign key constraint where its MAPPING_SET_CD column references IGS_PS_US_PRENR_CFG.MAPPING_SET_CD. This links the high-level configuration defined in IGS_PS_US_PRENR_CFG to more detailed unit mapping rules.
• Primary Key: The table's primary key constraint, IGS_PS_US_PRENR_CFG_PK, is defined on the columns (MAPPING_SET_CD, SEQUENCE_NO).
• Unique Indexes: Two unique indexes enforce business rules: IGS_PS_US_PRENR_CFG_U1 on (MAPPING_SET_CD, SEQUENCE_NO) and IGS_PS_US_PRENR_CFG_U2 on (UNIT_SET_CD).