Search Results igs_ps_sch_usec_int_all_u2

Overview

IGS.IGS_PS_SCH_USEC_INT_ALL is an interface (staging) table in the Oracle E-Business Suite Student System (product code IGS) that holds high-level scheduling unit section details during the export and import of scheduling data. Its display name is "Export and Import Scheduling Unit Section Detail," and it is classified under the business entity IGS_UNIT. The table resides in the APPS_TS_INTERFACE tablespace, indicating it is a transient interface object rather than a permanent transactional store.

The corresponding production table is IGS_PS_UNIT_OFR_OPT_ALL, to which validated rows are ultimately loaded. The occurrences of a unit section can be obtained by cross-referencing the IGS_PS_SCH_INT_ALL table, which stores the individual occurrence-level records.

From a modeling perspective, the mined foreign-key structure suggests a hub-leaning classification within a Data Vault heuristic. The primary key, IGS_PS_SCH_USEC_INT_ALL_PK, is defined on INT_USEC_ID, and the interface-specific TRANSACTION_ID links to the scheduling header interface (IGS_PS_SCH_HDR_INT_ALL), reinforcing the table's role as a staging hub that batches unit section records for a single import transaction.

Key Information Stored

The table contains 33 documented columns. The most significant are summarized below:

• INT_USEC_ID — Surrogate primary key; unique identifier for each unit section in the scheduler interface. Enforced by unique index IGS_PS_SCH_USEC_INT_ALL_U1.
• UOO_ID and TRANSACTION_ID — Business-key candidates forming the unique index IGS_PS_SCH_USEC_INT_ALL_U2. UOO_ID identifies the unit offering option; TRANSACTION_ID ties the row to its import batch.
• UNIT_CD, VERSION_NUMBER, and UNIT_TITLE — Identify the unit being scheduled and its version.
• UNIT_SECTION_START_DATE and UNIT_SECTION_END_DATE — The validity window of the unit section occurrence.
• UNIT_SECTION_STATUS — Status of the occurrence, for example "planned" or "inactive."
• CALENDAR_TYPE and SEQUENCE_NUMBER — Calendar type used for scheduling and ordering of the section.
• ENROLLMENT_MAXIMUM, ENROLLMENT_ACTUAL, and ENROLLMENT_EXPECTED — Enrollment capacity and demand metrics.
• LOCATION_CD, OWNER_ORG_UNIT_CD, and ORG_UNIT_DESCRIPTION — Physical and organizational placement of the section.
• IMPORT_DONE_FLAG, ABORT_FLAG, and INT_PAT_ID — Interface control columns governing processing state and parent batch linkage.

Standard EBS audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) and ORG_ID for multi-org context are also present.

Common Use Cases and Queries

Typical uses center on monitoring and troubleshooting scheduling imports, validating staged data before it is loaded into IGS_PS_UNIT_OFR_OPT_ALL, and reconciling unit section capacity against enrollment figures.

A common query retrieves all unit sections for a given import batch:

• SELECT INT_USEC_ID, UNIT_CD, VERSION_NUMBER, UNIT_SECTION_START_DATE, UNIT_SECTION_END_DATE, UNIT_SECTION_STATUS FROM IGS_PS_SCH_USEC_INT_ALL WHERE TRANSACTION_ID = :p_transaction_id;

To identify failed or pending imports, filter on the control flags:

• SELECT INT_USEC_ID, UOO_ID, IMPORT_DONE_FLAG, ABORT_FLAG FROM IGS_PS_SCH_USEC_INT_ALL WHERE NVL(IMPORT_DONE_FLAG,'N') = 'N' OR ABORT_FLAG = 'Y';

Enrollment reporting compares ENROLLMENT_ACTUAL to ENROLLMENT_MAXIMUM to detect over-subscribed sections, while joining to IGS_PS_SCH_INT_ALL retrieves the underlying occurrence-level detail for each section.

Related Objects

The table participates in a well-defined dependency graph:

• IGS_PS_SCH_HDR_INT_ALL — Parent scheduling import header; IGS_PS_SCH_USEC_INT_ALL.TRANSACTION_ID references it.
• IGS_PS_SCH_INT_ALL — Occurrence-level scheduling interface; references INT_USEC_ID.
• IGS_PS_SCH_MWC_ALL — References INT_USEC_ID (multiple-week calendar data).
• IGS_PS_SCH_X_USEC_INT_ALL — References INT_USEC_ID (extended unit section interface).
• IGS_PS_UNIT_OFR_OPT_ALL — The production target table receiving validated rows.

Together these objects form the scheduling import pipeline, with IGS_PS_SCH_USEC_INT_ALL acting as the section-level staging hub that feeds both downstream interface tables and the production unit offering option table.