Search Results igs_ps_usec_x_grp_v

Overview

IGS_PS_USEC_X_GRP_V is a reporting view belonging to the Oracle IGS (Student System) product family. In Oracle E-Business Suite 12.1.1 and 12.2.2, the IGS module provides the general student-system foundation that underpins Higher Education and Student Management functionality. The view exposes configured "use of cross-listed group" records — that is, the definitions governing how enrollment groups are cross-listed across calendar instances — together with their associated calendar-instance attributes.

The _V suffix identifies this as a view rather than a base table, and it is intended primarily as a read-only query surface for reports, concurrent-program extracts, and integration interfaces. Its role is to join the configuration table that stores cross-listed group definitions to the calendar-instance table so that a single query returns both the group configuration and the descriptive context of the calendar instance (alternate code, start and end dates) to which the group belongs. ETRM explicitly notes that this object is part of the Obsolete IGS data model, and the implementation note states that it is "Not implemented in this database." Customers on 12.1.1 or 12.2.2 should therefore confirm existence before referencing the view, as it may be absent or superseded in their installed schema.

Underlying Base Objects

The view text is defined over two documented base tables:

• IGS_PS_USEC_X_GRP (aliased USXG) — the primary table holding cross-listed use-of-group definitions, including the group identifier, name, location inheritance, calendar type, calendar-instance sequence number, and maximum enrollment/override settings.
• IGS_CA_INST (aliased CI) — the calendar-instance table carrying the alternate code and validity dates for a given calendar type and sequence number.

The two tables are joined on USXG.CAL_TYPE = CI.CAL_TYPE AND USXG.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER. ETRM lists no separately documented referenced base objects beyond these, and the view's columns are drawn directly from the two source tables.

Key Columns

The view projects the surrogate ROW_ID, the group key USEC_X_LISTED_GROUP_ID and descriptive USEC_X_LISTED_GROUP_NAME, LOCATION_INHERITANCE, and the calendar linkage columns CAL_TYPE and CI_SEQUENCE_NUMBER. From the joined calendar instance it exposes ALTERNATE_CODE, START_DT, and END_DT. Standard audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN — are carried through from the base group table. Two workload-definition columns, MAX_ENR_GROUP and MAX_OVR_GROUP, express maximum enrollment and maximum override thresholds for the group.

Common Use Cases and Queries

Typical usage includes reporting on cross-listed group configuration by calendar instance, validating enrollment thresholds, and feeding date-effective extracts into downstream systems.

• Listing active groups for a calendar period:

SELECT usec_x_listed_group_id,
       usec_x_listed_group_name,
       alternate_code,
       start_dt,
       end_dt
FROM   igs_ps_usec_x_grp_v
WHERE  TRUNC(SYSDATE) BETWEEN start_dt AND end_dt
ORDER  BY alternate_code;

• Auditing threshold settings by calendar type:

SELECT cal_type,
       ci_sequence_number,
       usec_x_listed_group_name,
       max_enr_group,
       max_ovr_group
FROM   igs_ps_usec_x_grp_v
WHERE  max_ovr_group IS NOT NULL;

Because ETRM classifies the object as obsolete and not implemented, queries should be preceded by a check of ALL_VIEWS and, where the view is unavailable, redirected to the underlying base tables.