Results for “max_enr_group”

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

Overview

IGS_PS_UNIT_X_GRP is the IGS (Student System) master table that stores information about Unit Cross-Listed Groups. In Oracle EBS 12.1.1 and 12.2.2, the table resides in the IGS schema and holds the definitional header records for groups that associate multiple academic units under a single cross-listed offering. A cross-listed group allows several unit versions to be treated as one logical enrollment entity, which is essential for timetabling, enrollment counting, and student record consolidation where the same teaching activity is delivered across more than one unit code or career.

The object is classified as VALID and carries ten documented columns in the ETRM 12.1.1 physical schema. Its parent role is confirmed by the foreign key relationship in which IGS_PS_UNIT_X_GRPMEM references IGS_PS_UNIT_X_GRP through UNIT_X_LISTED_GROUP_ID; the group header therefore governs the membership rows beneath it. From a heuristic Data Vault modeling perspective, this table is hub-leaning: its single-column surrogate primary key and stable business key make it a natural candidate for a hub entity, with the descriptive attributes suitable for a satellite and the member relationships modeled as a link.

Key Information Stored

The table is keyed by UNIT_X_LISTED_GROUP_ID, which is enforced by the primary key constraint IGS_PS_UNIT_X_GRP_PK. This identifier is the surrogate key used by all dependent records, including the membership table. Two unique indexes are documented, both acting as business-key candidates: IGS_PS_UNIT_X_GRP_U1 on UNIT_X_LISTED_GROUP_ID and IGS_PS_UNIT_X_GRP_U2 on UNIT_X_LISTED_GROUP_NAME. The presence of a unique constraint on the name confirms that GROUP_NAME is a meaningful, user-facing business identifier rather than a free-form label, and it should be treated as the principal alternate key when integrating with external systems.

• UNIT_X_LISTED_GROUP_ID — surrogate primary key and the join column referenced by all child records.
• UNIT_X_LISTED_GROUP_NAME — unique business name of the cross-listed group.
• LOCATION_INHERITANCE — controls whether location attributes are inherited across the units within the group, governing how delivery location defaults resolve.
• MAX_ENR_GROUP — maximum enrollment threshold for the group as a whole, used for capacity control.
• MAX_OVR_GROUP — maximum over-enrollment permitted for the group.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS WHO columns providing audit and concurrency information.

Common Use Cases and Queries

Typical usage centers on resolving which units belong to a cross-listed group and on enforcing group-level enrollment limits. A common join retrieves the header together with its members:

• SELECT g.unit_x_listed_group_id, g.unit_x_listed_group_name, m.* FROM igs_ps_unit_x_grp g, igs_ps_unit_x_grpmem m WHERE g.unit_x_listed_group_id = m.unit_x_listed_group_id;
• Lookup by business name: SELECT * FROM igs_ps_unit_x_grp WHERE unit_x_listed_group_name = :name;
• Capacity reporting by comparing MAX_ENR_GROUP and MAX_OVR_GROUP against aggregated enrollment counts for the group.
• Audit and change-tracking extracts driven by LAST_UPDATE_DATE for incremental loads into a warehouse.

These patterns support student enrollment validation, timetabling consolidation, and institutional reporting on cross-listed teaching activity.

Related Objects

The following objects are most significant in relation to this table:

• IGS_PS_UNIT_X_GRPMEM — the membership (child) table; joined on IGS_PS_UNIT_X_GRPMEM.UNIT_X_LISTED_GROUP_ID = IGS_PS_UNIT_X_GRP.UNIT_X_LISTED_GROUP_ID.
• IGS_PS_UNIT_X_GRP_PK / IGS_PS_UNIT_X_GRP_U1 / IGS_PS_UNIT_X_GRP_U2 — the constraints and unique indexes that enforce identity and business-key uniqueness.
• IGS_PS_UNIT / IGS_PS_UNIT_VERSIONS-family tables — unit definition tables whose records are grouped by the cross-listing header.
• Enrollment and timetable objects in the IGS Student System — consume group definitions for capacity and scheduling logic.

In practice, any dependency analysis for this object begins with the IGS_PS_UNIT_X_GRPMEM foreign key, since it is the only documented inbound reference and defines the table's role as a parent hub.