Search Results class_max_enrollment_number

Overview

IGS_PS_SCH_X_USEC_INT is an APPS-owned, VALID database view in the Oracle E-Business Suite 12.1.1 / 12.2.2 environment. It is registered with an FND Design Data name of IGS.IGS_PS_SCH_X_USEC_INT and is documented as an "Interface View to capture the Scheduler Interface Unit Section Cross Listings Data." Its role is therefore to expose, in a single queryable structure, the cross-listing relationships that exist between a parent unit offering option (UOO) and one or more child unit offering options as they are processed through the Student Scheduling (Scheduler) interface.

The view is also identified as a multi-org view. As documented, such a view "will retrieve data for your current operating unit and ignore data in other operating units." This behavior is governed by the presence of the ORG_ID column, which is populated by the Multi-Org mechanism using the value of the current operating unit. In reporting and integration contexts, this view provides a controlled read interface onto cross-listing data used by admission and enrollment processes, allowing external interfaces, concurrent programs, and analytics to consume the data without accessing the underlying base tables directly. The user search term "cross_list_group_name" corresponds to the CROSS_LIST_GROUP_NAME column exposed by this view, indicating the object is frequently queried when cross-listing group details must be reported or reconciled.

Underlying Base Objects

The documented dependency for this view is APPS.IGS_PS_SCH_X_USEC_INT_ALL. As an interface view, IGS_PS_SCH_X_USEC_INT is defined over the underlying scheduler interface cross-listing entity, presenting the same conceptual data with multi-org filtering applied. The view itself is documented as valid and is referenced by the APPS schema. No other base objects are documented in the ETRM metadata for this object.

Because the view is described as a multi-org view over a base object whose name ends in _ALL, the relationship is the typical Oracle EBS pattern: the _ALL table stores data for all operating units, and the view applies an ORG_ID predicate so that only records belonging to the session's current operating unit are visible. Integration code inserting or updating through the interface should be aware that the view filters by operating unit and that the underlying _ALL object holds the unfiltered superset of rows.

Key Columns

The view exposes the following columns, each with the documented datatype and length:

• ROW_ID (ROWID): unique row identifier for the underlying record.
• INT_USEC_X_USEC_ID (NUMBER): primary identifier for the interface cross-listing record.
• INT_USEC_ID (NUMBER): identifier of the interface unit section record to which the cross-listing belongs.
• UNIT_SEC_CROSS_UNIT_SEC_ID (NUMBER): identifier of the unit section cross unit section relationship.
• PARENT_UOO_ID (NUMBER): unit offering option identifier of the parent.
• CHILD_UOO_ID (NUMBER): unit offering option identifier of the child.
• CHILD_UNIT_CD (VARCHAR2, 10), CHILD_VERSION_NUMBER (NUMBER), CHILD_TITLE (VARCHAR2, 90), CHILD_CAL_TYPE (VARCHAR2, 10), CHILD_ALTERNATE_CODE (VARCHAR2, 10): descriptive attributes of the child unit.
• START_DT (DATE), END_DT (DATE): effective date range for the cross-listing.
• CHILD_CI_SEQUENCE_NUMBER (NUMBER), CHILD_UNIT_CLASS (VARCHAR2, 10), CHILD_UNIT_MODE (VARCHAR2, 10): child unit classification, mode, and teaching sequence attributes.
• CHILD_LOCATION_CD (VARCHAR2, 10) and CHILD_LOCATION_DESCRIPTION (VARCHAR2, 60): child unit location code and description.
• ORG_ID (NUMBER, 15): operating unit identifier used by the multi-org filter.
• CROSS_LIST_GROUP_NAME (VARCHAR2, 150): the descriptive name of the cross-list group, the column matched by the user's search term.
• CLASS_MAX_ENROLLMENT_NUMBER (NUMBER): maximum enrollment number for the class.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN: standard Who columns.

Common Use Cases and Queries

The view is typically queried to reconcile scheduler interface cross-listings for the current operating unit, to report cross-listing group names and child unit details, and to drive integrations that load or validate enrollment data. A representative query filtering on the search term is shown below.

SELECT INT_USEC_X_USEC_ID, INT_USEC_ID, PARENT_UOO_ID, CHILD_UOO_ID, CHILD_UNIT_CD, CHILD_TITLE, CROSS_LIST_GROUP_NAME, START_DT, END_DT, ORG_ID FROM APPS.IGS_PS_SCH_X_USEC_INT WHERE CROSS_LIST_GROUP_NAME = :p_group_name;

To list all cross-listing groups for the current operating unit with their child unit details:

SELECT CROSS_LIST_GROUP_NAME, CHILD_UNIT_CD, CHILD_VERSION_NUMBER, CHILD_TITLE, CLASS_MAX_ENROLLMENT_NUMBER FROM APPS.IGS_PS_SCH_X_USEC_INT ORDER BY CROSS_LIST_GROUP_NAME, CHILD_UNIT_CD;

Because ORG_ID is filtered automatically by the multi-org view, callers must ensure the correct operating unit is set in their session context; otherwise rows for other operating units will not be returned. Queries against this interface view are best limited to the scheduler interface lifecycle, after which data is validated and transferred to the corresponding base entities.