Search Results igs_ps_usec_x_grpmem_v




Overview
Explore in AI Chat

Overview

IGS_PS_USEC_X_GRPMEM_V is a seeded, read-only view owned by the APPS schema in the Oracle E-Business Suite Student System (IGS) product. It presents a denormalized, report-ready projection of unit section cross-listed group membership records, combining enrollment group membership details with presentation attributes of the underlying unit offering option. The view is intended for enrollment reporting and integration scenarios where a human-readable section identifier and enrollment capacity figures are required alongside group membership data. Because the view synthesizes a UNIT_SECTION descriptor from multiple coded columns, it removes the need for consumers to perform their own concatenation logic and joins against the unit offering option, unit version, unit class, and calendar instance tables.

In Oracle EBS 12.1.1 and 12.2.2 the object remains defined in the APPS schema with VALID status. Its presence in the ETRM repository confirms it is a supported, documented object for reporting rather than an internal implementation artifact.

Underlying Base Objects

The view definition references the following IGS tables:

Note that the documented ETRM metadata lists no explicitly registered base objects for this view; the relationships above are derived from the shipped view text.

Key Columns

  • ROW_ID — ROWID of the underlying IGS_PS_USEC_X_GRPMEM row, useful for DML targeting against the base table.
  • UNIT_SECTION — a 2000-character concatenation of unit code, version number, location, unit class, unit mode, and alternate code; the primary human-readable label.
  • USEC_X_LISTED_GROUP_MEM_ID / USEC_X_LISTED_GROUP_ID — membership and group identifiers.
  • UOO_ID — the unit offering option identifier, the principal link back to enrollment transactions.
  • PARENT — the parent indicator for hierarchical group membership.
  • ENROLLMENT_MAXIMUM — returns NULL when MAX_ENR_GROUP is set on the group header (delegating control to the group), otherwise the maximum from the waitlist limit row, falling back to the unit version, then zero.
  • OVERRIDE_MAXIMUM — analogous logic applied to the override enrollment maximum.
  • ENROLLMENT_ACTUAL — NVL(UOOV.ENROLLMENT_ACTUAL, 0), the actual enrolled count for the offering option.
  • Audit columns CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN preserve the base row's who-columns.

Common Use Cases and Queries

The view is typically used to report enrollment against capacity at the cross-listed group level, and to reconcile actual enrollment counts with configured maximums.

  • Enrollment versus capacity by section: SELECT unit_section, enrollment_actual, enrollment_maximum FROM igs_ps_usec_x_grpmem_v WHERE enrollment_maximum > 0 AND enrollment_actual >= enrollment_maximum;
  • Locating the group membership for a specific offering option: SELECT * FROM igs_ps_usec_x_grpmem_v WHERE uoo_id = :p_uoo_id;
  • Audit of recently modified memberships: SELECT usec_x_listed_group_mem_id, unit_section, last_updated_by, last_update_date FROM igs_ps_usec_x_grpmem_v ORDER BY last_update_date DESC;

Because ENROLLMENT_ACTUAL is sourced from IGS_PS_UNIT_OFR_OPT and defaulted to zero, the value reflects the offering option snapshot at query time and is not a live registration count; consumers requiring transactional precision should aggregate from the enrollment base tables instead.