Results for “mapping_set_cd”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGS_PS_US_PRENR_CFG is a configuration table within the Oracle E-Business Suite (EBS) Student System (IGS) product family, classified as obsolete in the current data model. The object persists pre-enrollment configuration details for the Year of Program construct, providing the mapping framework that associates unit sets with the sequence-driven mapping definitions required by the student pre-enrollment process. Its physical schema belongs to the IGS owner and contains eight documented columns. In ETRM 12.1.1 and 12.2.2, the object is documented but recorded as not implemented in the reference database, indicating that it exists primarily as a legacy or source-controlled definition rather than an actively populated table in standard installations.

From a heuristic modeling perspective, the mined foreign-key structure suggests a hub-leaning classification within a Data Vault pattern. The combination of MAPPING_SET_CD and SEQUENCE_NO forms the primary key (IGS_PS_US_PRENR_CFG_PK) and the business key candidate, giving the entity a stable, singular identity suitable for hub treatment, though the presence of descriptive configuration attributes may also support satellite-style extension depending on the target design.

Key Information Stored

The documented columns concentrate on configuration identity and audit metadata rather than transaction payload:

• MAPPING_SET_CD — Component of the composite primary key and the principal business-key candidate; identifies the mapping set to which the pre-enrollment configuration belongs.
• SEQUENCE_NO — The second component of the composite primary key; orders or disambiguates entries within a mapping set.
• UNIT_SET_CD — The unit set identifier serving as the alternate unique key candidate (IGS_PS_US_PRENR_CFG_U2); links configuration to a defined unit set.
• CREATED_BY, CREATION_DATE — Standard EBS audit columns recording the creating user and creation timestamp.
• LAST_UPDATED_BY, LAST_UPDATE_DATE — Audit columns capturing the most recent modification user and timestamp.
• LAST_UPDATE_LOGIN — Records the login session under which the last update occurred, supporting audit traceability.

The surrogate primary key is the composite (MAPPING_SET_CD, SEQUENCE_NO), reinforced by unique index IGS_PS_US_PRENR_CFG_U1. The business-key candidate IGS_PS_US_PRENR_CFG_U2 on UNIT_SET_CD provides an alternate access path and enforces uniqueness of the unit set assignment.

Common Use Cases and Queries

Because the table stores pre-enrollment configuration for Year of Program, typical usage centers on configuration validation and lineage reporting. Analysts may verify which unit sets are mapped to a given configuration set, or trace configuration changes for audit purposes. A representative query joining the configuration to its child mapping table follows:

SELECT c.MAPPING_SET_CD, c.SEQUENCE_NO, c.UNIT_SET_CD, m.*
FROM   IGS_PS_US_PRENR_CFG c,
       IGS_EN_UNIT_SET_MAP m
WHERE  c.MAPPING_SET_CD = m.MAPPING_SET_CD
AND    c.SEQUENCE_NO    = m.SEQUENCE_NO;

Additional reporting patterns include extraction of all configured unit sets for migration analysis, audit queries filtering on LAST_UPDATE_DATE to detect recent configuration changes, and referential-integrity checks confirming that every configuration row has a corresponding unit-set mapping child record. Where the table is not populated, queries typically return no rows, which itself is a useful signal during upgrade or fit-gap assessment.

Related Objects

The following objects are most significant in relation to IGS_PS_US_PRENR_CFG, based on documented foreign-key relationships:

• IGS_EN_UNIT_SET_MAP — The child mapping table; its MAPPING_SET_CD and SEQUENCE_NO columns reference the IGS_PS_US_PRENR_CFG primary key, forming the principal dependency.
• IGS_PS_US_PRENR_CFG_PK — The composite primary key constraint on (MAPPING_SET_CD, SEQUENCE_NO).
• IGS_PS_US_PRENR_CFG_U1 — Unique index on (MAPPING_SET_CD, SEQUENCE_NO), reinforcing the primary key.
• IGS_PS_US_PRENR_CFG_U2 — Unique index on UNIT_SET_CD, the alternate business-key candidate.
• IGS_EN_UNIT_SET_MAP.MAPPING_SET_CD / SEQUENCE_NO — The referencing columns that establish the parent-child relationship.

As an obsolete IGS object, it should be treated as reference documentation for upgrade and impact analysis rather than a target for new development in Release 12.2.2.