Search Results igs_ps_usec_x_grp




Overview
Explore in AI Chat

Overview

IGS_PS_USEC_X_GRP is a core configuration table within the Oracle E-Business Suite Student System (IGS) product family, owned by the IGS schema. It stores the definition of Unit Section Cross-Listed Groups — logical groupings that associate two or more unit sections offered by different academic organizations so that they are treated as a single combined activity for enrollment, scheduling, and grade processing purposes. Cross-listing is commonly used when the same physical class, lecture, or laboratory session is delivered jointly by multiple departments, and each participating department must maintain its own catalog representation while the system recognizes the sections as a single teaching event.

The table therefore acts primarily as a reference or definition entity rather than a transactional one: it captures the group header, defines the calendar context in which the group is valid, and constrains how many enrollment and override groups the combination may generate. Under the heuristic Data Vault classification mined from the foreign key structure, this object is satellite-leaning, suggesting that in a dimensional or Data Vault style model it would typically be represented as a descriptive satellite attached to the cross-listed group business key, with its dependent membership rows held in a separate link or child structure.

Key Information Stored

The table is documented with twelve columns. The most significant are:

  • USEC_X_LISTED_GROUP_ID — the surrogate primary key of the table (IGS_PS_USEC_X_GRP_PK) and also the business-key candidate defined by unique index IGS_PS_USEC_X_GRP_U1. Every downstream reference to the cross-listed group, including membership rows, resolves through this identifier.
  • USEC_X_LISTED_GROUP_NAME — the user-facing name of the cross-listed group, used in inquiry screens, enrollment validation messages, and reporting.
  • CAL_TYPE — the calendar type that qualifies the group, forming the first component of the secondary unique key. It participates in the foreign key to IGS_CA_INST_ALL.
  • CI_SEQUENCE_NUMBER — the calendar instance sequence number, the second component of the composite foreign key to IGS_CA_INST_ALL, tying the group to a specific academic calendar instance.
  • LOCATION_INHERITANCE — controls whether location attributes defined on the group are inherited by its member unit sections.
  • MAX_ENR_GROUP and MAX_OVR_GROUP — capacity thresholds governing the maximum number of enrollment groups and override groups permitted for the cross-listed combination.

The secondary unique index IGS_PS_USEC_X_GRP_U2 covers USEC_X_LISTED_GROUP_NAME, CAL_TYPE, and CI_SEQUENCE_NUMBER, establishing that a group name must be unique within a given calendar type and sequence. The remaining columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — are standard Oracle EBS audit columns and carry no business meaning beyond row provenance.

Common Use Cases and Queries

Typical usage includes identifying all cross-listed groups active in a given academic period, verifying that a candidate group name is unique before creation, and reporting capacity limits imposed on combined sections. A representative query joining the group to its calendar instance is:

  • SELECT g.usec_x_listed_group_id, g.usec_x_listed_group_name, g.cal_type, g.ci_sequence_number, g.max_enr_group FROM igs.igs_ps_usec_x_grp g WHERE g.cal_type = :cal_type AND g.ci_sequence_number = :ci_seq;
  • Membership expansion: join to IGS_PS_USEC_X_GRPMEM on USEC_X_LISTED_GROUP_ID to enumerate the unit sections belonging to each group.
  • Data-quality checks: detect groups with null LOCATION_INHERITANCE or with MAX_ENR_GROUP set below the number of member sections.

Related Objects

  • IGS_CA_INST_ALL — referenced through the composite foreign key IGS_PS_USEC_X_GRP.CAL_TYPE and CI_SEQUENCE_NUMBER; provides the calendar instance context for each group.
  • IGS_PS_USEC_X_GRPMEM — the child membership table; its USEC_X_LISTED_GROUP_ID column references this table's primary key and records which unit sections participate in the group.
  • IGS_PS_USEC_X_GRP_PK / _UK1 / _U1 / _U2 — the primary, unique, and business-key indexes enforcing identifier and name uniqueness.
  • Student System enrollment and scheduling components that consume cross-listed group definitions when validating section combinations and computing combined capacity.