Search Results igs_ps_usec_x_grpmem




Overview
Explore in AI Chat

Overview

IGS_PS_USEC_X_GRPMEM is a Student System (IGS) table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores membership information for Unit Section Cross-Listed Groups. A cross-listed group allows two or more unit sections that are delivered together — but reported or administered separately — to be associated as a single logical teaching entity. This table records which individual unit offering option (that is, a specific unit section) belongs to which cross-listed group, and its position within that group's membership hierarchy.

The table resides in the IGS schema and is documented with VALID status in the ETRM. In Data Vault modeling terms, the foreign-key topology of this table — two independent references plus administrative metadata — suggests a link classification. IGS_PS_USEC_X_GRPMEM operates as the associative or intersection object that resolves the many-to-many relationship between unit offering options and cross-listed groups, rather than functioning as a descriptive hub of either entity on its own.

Key Information Stored

The documented physical schema for 12.1.1 comprises nine columns. The most significant are:

The primary key is the surrogate membership identifier; the meaningful business relationship is expressed by the combination of USEC_X_LISTED_GROUP_ID and UOO_ID, though the metadata documents only the surrogate key and UOO_ID as unique-index candidates.

Common Use Cases and Queries

Typical reporting scenarios include identifying which sections constitute a cross-listed group, and confirming the group to which a given unit offering option belongs. A representative query joins members to their group and section details:

  • SELECT m.USEC_X_LISTED_GROUP_MEM_ID, m.USEC_X_LISTED_GROUP_ID, m.UOO_ID, m.PARENT FROM IGS.IGS_PS_USEC_X_GRPMEM m WHERE m.USEC_X_LISTED_GROUP_ID = :group_id; — enumerates members of a group.
  • SELECT grp.* FROM IGS.IGS_PS_USEC_X_GRP grp, IGS.IGS_PS_USEC_X_GRPMEM m WHERE grp.USEC_X_LISTED_GROUP_ID = m.USEC_X_LISTED_GROUP_ID AND m.UOO_ID = :uoo_id; — resolves the group for a given section.
  • Joining to IGS_PS_UNIT_OFR_OPT_ALL to report section codes, teaching periods, and locations alongside group membership.

These queries support enrolment validation, timetable consolidation, fee and reporting reconciliation across cross-listed sections, and reconciliation extracts for downstream student records systems.

Related Objects

  • IGS_PS_USEC_X_GRP — parent cross-listed group definition; joined on USEC_X_LISTED_GROUP_ID.
  • IGS_PS_UNIT_OFR_OPT_ALL — unit offering options (sections); joined on UOO_ID.
  • IGS_PS_USEC_X_GRPMEM_PK / IGS_PS_USEC_X_GRPMEM_U1 — primary key and unique index enforcing row identity.
  • IGS_PS_UNIT_OFR_OPT — base unit offering option entity underlying the _ALL view, relevant when resolving USEC records.
  • IGS_PS_USEC — unit section entity that contextualises the offering options linked through membership rows.
  • IGS_PS_ENR_UNIT_OFF_OPT / enrolment objects — consume cross-listed groupings when processing student enrolments.

Because this is a link-style table, the integrity of the foreign keys to IGS_PS_USEC_X_GRP and IGS_PS_UNIT_OFR_OPT_ALL should be treated as the primary referential concern in any integration or migration activity.