Search Results igs_ps_usec_x_grp_u2

Overview

IGS.IGS_PS_USEC_X_GRP is a transactional table in the Oracle EBS Student Systems (IGS) schema that stores information about Unit Section Cross-Listed Groups. A cross-listed group represents a logical grouping of unit sections that share enrollment, capacity, and location behavior across multiple academic offerings — a common construct in higher-education institutions where the same instructional activity is delivered under several course or section identifiers. The table resides in the APPS_TS_TX_DATA tablespace with a PCTFREE of 10, confirming its classification as a transactional, DML-active object rather than a reference or setup-only table.

Under a heuristic Data Vault classification mined from the foreign-key structure, this table is satellite-leaning. Its grain is defined by a single business key (USEC_X_LISTED_GROUP_ID), while descriptive attributes such as name, inheritance indicators, and enrollment limits accrue to that key. The one outbound foreign key — CAL_TYPE to IGS_CA_INST_ALL — behaves as a reference to a calendar instance rather than a true many-to-many link, reinforcing the satellite interpretation rather than a hub or link classification.

Key Information Stored

The surrogate primary key is USEC_X_LISTED_GROUP_ID (NUMBER(10)), defined by the primary key constraint IGS_PS_USEC_X_GRP_PK. This column is also the first documented business-key candidate, enforced by the unique index IGS_PS_USEC_X_GRP_U1 — the index the user searched for. The second unique index, IGS_PS_USEC_X_GRP_U2, spans USEC_X_LISTED_GROUP_NAME, CAL_TYPE, and CI_SEQUENCE_NUMBER, establishing an alternate composite business key that guarantees a cross-listed group name is unique within a given calendar type and calendar instance.

• USEC_X_LISTED_GROUP_ID — Surrogate primary key and cross-listed group code.
• USEC_X_LISTED_GROUP_NAME — Descriptive name (VARCHAR2(80)); part of the U2 business key.
• LOCATION_INHERITANCE — Indicator controlling whether location attributes are inherited by member unit sections.
• CAL_TYPE — Calendar type; foreign key to IGS_CA_INST_ALL and part of the U2 business key.
• CI_SEQUENCE_NUMBER — Calendar instance sequence number; part of the U2 business key.
• MAX_ENR_GROUP — Maximum enrollment permitted across the cross-listed group.
• MAX_OVR_GROUP — Maximum override enrollment permitted across the group.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO audit columns populated by the EBS framework.

Common Use Cases and Queries

Typical usage centers on capacity management, cross-listing configuration, and enrollment reporting. Enrollment processing reads MAX_ENR_GROUP and MAX_OVR_GROUP to enforce group-level caps so that students enrolling in any member section consume a shared pool of seats. Academic administrators query the table to audit cross-listed group definitions by calendar instance, and integration scripts frequently join it to member records to publish catalog or scheduling data.

SELECT g.usec_x_listed_group_id,
       g.usec_x_listed_group_name,
       g.cal_type,
       g.ci_sequence_number,
       g.max_enr_group,
       g.max_ovr_group
FROM   igs.igs_ps_usec_x_grp g
WHERE  g.cal_type = :cal_type
AND    g.ci_sequence_number = :ci_sequence_number;

A capacity-utilization report joins the group to its members and to section enrollments to compare actual headcount against MAX_ENR_GROUP, while a data-quality query uses the U1 and U2 indexes to detect duplicate names or orphaned calendar references.

Related Objects

• IGS.IGS_PS_USEC_X_GRPMEM — The child table holding group members; joins on USEC_X_LISTED_GROUP_ID to IGS_PS_USEC_X_GRP.
• IGS.IGS_CA_INST_ALL — Calendar instance reference; joined via CAL_TYPE (and CI_SEQUENCE_NUMBER).
• IGS.IGS_PS_USEC_X_GRP_U1 / U2 — Unique indexes enforcing the primary and alternate business keys.
• APPS.IGS_PS_USEC_X_GRP — The APPS-layer synonym through which forms, concurrent programs, and PL/SQL APIs reach the base IGS table.
• IGS.IGS_PS_USEC_X_GRP_PK — Primary key constraint on USEC_X_LISTED_GROUP_ID.

All references above are drawn from the documented FK and index metadata; the table itself references no other database objects apart from the calendar lookup, and is referenced only by its member table and the APPS synonym.