Results for “igs_ps_sch_x_usec_int_all_u2”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGS.IGS_PS_SCH_X_USEC_INT_ALL is a public interface table within the Oracle E-Business Suite Student System (product code IGS). It stores Unit Section Cross Listings information that is consumed by the third-party scheduling interface. The corresponding production table is IGS_PS_USEC_X_GRPMEM, meaning this interface table acts as a staging area that feeds cross-listed unit section membership data into the scheduler integration. The object is classified with a status of VALID and lifecycle of active in the ETRM 12.1.1 documentation, and it resides in the APPS_TS_INTERFACE tablespace, confirming its transient, batch-oriented role.

From a Data Vault modeling perspective, the mined relationship structure suggests a satellite-leaning classification. The table is anchored by a single-column surrogate primary key (IGS_PS_SCH_X_USEC_INT_ALL_PK on INT_USEC_X_USEC_ID), while its descriptive payload—child unit codes, titles, calendar attributes, and enrollment limits—behaves as attribute data belonging to a parent unit section. The presence of foreign keys pointing to IGS_PS_SCH_USEC_INT_ALL and IGS_PS_USEC_X_USEC reinforces this satellite interpretation.

Key Information Stored

Each row represents one cross-listing detail record for the scheduling interface. The most significant columns are:

• INT_USEC_X_USEC_ID — Surrogate primary key; unique identifier for each Unit Section Cross Listing row in the interface table.
• INT_USEC_ID — Foreign key to the parent unit section record in IGS_PS_SCH_USEC_INT_ALL.
• UNIT_SEC_CROSS_UNIT_SEC_ID — Foreign key identifying the cross-listed unit section in IGS_PS_USEC_X_USEC.
• PARENT_UOO_ID / CHILD_UOO_ID — Unique identifiers for the parent and child unit section occurrences.
• CHILD_UNIT_CD, CHILD_VERSION_NUMBER, CHILD_TITLE — Code, version, and descriptive name of the cross-listed child unit.
• CHILD_CAL_TYPE, CHILD_ALTERNATE_CODE, CHILD_CI_SEQUENCE_NUMBER — Calendar type, alternate code, and calendar instance sequence for the child offering.
• START_DT, END_DT — Effective date range for the child unit version.
• CHILD_UNIT_CLASS, CHILD_UNIT_MODE, CHILD_LOCATION_CD — Delivery class, mode, and location attributes of the child unit.
• CLASS_MAX_ENROLLMENT_NUMBER — Enrollment cap used by the scheduler.
• ORG_ID — Multi-org operating unit discriminator.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — Standard WHO audit columns.

Two unique indexes act as business-key candidates: U1 enforces uniqueness on INT_USEC_X_USEC_ID, and U2 enforces uniqueness on the INT_USEC_ID plus UNIT_SEC_CROSS_UNIT_SEC_ID combination.

Common Use Cases and Queries

Typical usage centers on pre-scheduling extraction and diagnostics. A common pattern retrieves all cross-listed children for a given parent section:

• SELECT c.CHILD_UNIT_CD, c.CHILD_TITLE, c.CHILD_CAL_TYPE, c.START_DT, c.END_DT FROM IGS_PS_SCH_X_USEC_INT_ALL c WHERE c.INT_USEC_ID = :parent_int_usec_id;
• Joining to IGS_PS_SCH_USEC_INT_ALL to validate that every child row resolves to a parent section, typically used to detect orphaned interface records before the scheduler extract runs.
• Aggregating CLASS_MAX_ENROLLMENT_NUMBER by CHILD_CAL_TYPE to verify enrollment capacity loads.
• Filtering by ORG_ID to reconcile records across operating units.

Because the table lives in APPS_TS_INTERFACE, queries are usually short-lived batch operations rather than long-running reporting, and contents are purged or regenerated with each interface cycle.

Related Objects

• IGS.IGS_PS_SCH_USEC_INT_ALL — Parent interface table; joined on INT_USEC_ID.
• IGS.IGS_PS_USEC_X_USEC — Cross-listed unit section source; joined on UNIT_SEC_CROSS_UNIT_SEC_ID.
• IGS.IGS_PS_USEC_X_GRPMEM — The corresponding production table that receives the staged cross-listing data.
• IGS.IGS_PS_SCH_X_USEC_INT_ALL_U1 / _U2 — Unique indexes described above.
• IGS.IGS_PS_SCH_X_USEC_INT_ALL_PK — Primary key constraint on INT_USEC_X_USEC_ID.