Results for “igs_en_unit_set_map”

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

Overview

The IGS_EN_UNIT_SET_MAP table is a component of the Oracle E-Business Suite IGS (Student System) product, which is classified as obsolete in Oracle EBS 12.1.1 and 12.2.2. The table's documented description is "Unit Set Mapping," indicating that it defines relationships between pre-enrollment configuration mapping sets and unit set definitions used within the student system's enrollment and progression logic. It captures which stream unit set versions correspond to a given mapping set and sequence position, effectively acting as a cross-reference bridge between configuration and curricular structures.

The ETRM metadata records that this table is "Not implemented in this database," meaning it does not exist as a physical object in the reference environment from which the documentation was mined. Consequently, this summary reflects documented structure rather than verified runtime behavior. Where the metadata is silent, general EBS conventions are noted explicitly.

The heuristic Data Vault classification derived from the foreign key structure is link. In modeling terms, this suggests the table functions primarily as an associative entity resolving a many-to-many style relationship between mapping configuration records and unit set definitions, rather than as a standalone hub of business entities or a descriptive satellite. This classification should be treated as a suggestion, not a definitive architectural statement.

Key Information Stored

The documented physical schema for this table contains nine columns, with four participating in the primary key and business key structure. The primary key, IGS_EN_UNIT_SET_MAP_PK, is composite and comprises the following columns, which together serve as the surrogate and business-key backbone of the table:

• MAPPING_SET_CD — Identifier for the mapping set, forming the first component of the primary key and the leading column of the foreign key to IGS_PS_US_PRENR_CFG.
• SEQUENCE_NO — Ordinal position within the mapping set, providing ordering semantics and serving as the second primary key component.
• STREAM_UNIT_SET_CD — Identifier for the stream unit set, the third primary key component and the leading column of the foreign key to IGS_EN_UNIT_SET_ALL.
• US_VERSION_NUMBER — Version number of the unit set, completing the primary key and pairing with STREAM_UNIT_SET_CD in the foreign key to IGS_EN_UNIT_SET_ALL.

The remaining documented columns are the standard EBS audit and control attributes: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN. These are maintained automatically by the EBS who-column framework and are rarely used in application logic. No separate unique index is documented beyond the composite primary key, so the four key columns above collectively represent the business-key candidate. Because the table is documented as not implemented, column data types, nullability, and check constraints are not available from the metadata and would need to be confirmed against an actual installation if one exists.

Common Use Cases and Queries

The principal use case for this object is resolving which stream unit set versions are associated with a pre-enrollment configuration mapping set, in sequence order. Practical scenarios include auditing pre-enrollment configuration, reporting the ordered composition of unit set mappings, and validating referential integrity between mapping configuration and unit set definitions.

A representative query joining the mapping table to its parent configuration and unit set tables would follow this pattern:

• Select the mapping set, sequence number, stream unit set, and version from IGS_EN_UNIT_SET_MAP, joining MAPPING_SET_CD to IGS_PS_US_PRENR_CFG and joining STREAM_UNIT_SET_CD with US_VERSION_NUMBER to IGS_EN_UNIT_SET_ALL.
• Filter by MAPPING_SET_CD to reconstruct the ordered unit set composition for a specific configuration, ordering by SEQUENCE_NO.
• Left-join to child tables to detect orphaned mapping rows where the referenced configuration or unit set version no longer exists.

Because the object is obsolete and reportedly unimplemented, these queries are best regarded as documentation-driven reconstruction patterns. Any production use should first verify existence via ALL_TABLES and inspect actual column definitions through ALL_TAB_COLUMNS before relying on the structure described here.

Related Objects

The documented foreign key relationships define the most significant related objects for this table:

• IGS_PS_US_PRENR_CFG — Referenced via MAPPING_SET_CD. This pre-enrollment configuration table supplies the mapping set definition that the mapping rows belong to.
• IGS_EN_UNIT_SET_ALL — Referenced via the composite of STREAM_UNIT_SET_CD and US_VERSION_NUMBER. This unit set table provides the curricular definition and version that each mapping row points to.
• IGS_EN_UNIT_SET_MAP_PK — The composite primary key constraint spanning MAPPING_SET_CD, SEQUENCE_NO, STREAM_UNIT_SET_CD, and US_VERSION_NUMBER, enforcing uniqueness of mapping entries.

Beyond these documented relationships, the IGS Student System typically includes related enrollment, unit set, and pre-enrollment configuration objects, but no additional dependencies for this specific table are confirmed in the provided metadata.