Search Results igs_ps_sch_x_usec_int_all




Overview
Explore in AI Chat

Overview

IGS_PS_SCH_X_USEC_INT_ALL is a Student System (IGS) interface staging table within Oracle E-Business Suite 12.1.1 and 12.2.2. It resides in the IGS schema and holds scheduler interface unit section cross-listing data. Its stated purpose is to capture cross-listing relationships between unit sections as they are prepared for, or received from, the scheduling interface process.

In Data Vault modeling terms, the structure is heuristic satellite-leaning. The single-column primary key (INT_USEC_X_USEC_ID) functions as a row-level surrogate identifier, while the foreign keys (INT_USEC_ID and UNIT_SEC_CROSS_UNIT_SEC_ID) point outward to interface and usec reference tables. This pattern is characteristic of a satellite table describing descriptive attributes attached to a parent interface unit or section record, rather than a pure hub of business keys.

Key Information Stored

The table comprises 25 documented columns. The most significant are:

The business-key candidate is expressed by unique index IGS_PS_SCH_X_USEC_INT_ALL_U2 over (INT_USEC_ID, UNIT_SEC_CROSS_UNIT_SEC_ID), indicating a section cannot appear twice under the same interface usec.

Common Use Cases and Queries

Typical uses include validating scheduler interface loads, reconciling cross-listed sections prior to posting, and reporting enrollment capacity across cross-list groups.

  • Listing all cross-list rows for a staging batch:
    SELECT a.int_usec_id, a.cross_list_group_name, a.class_max_enrollment_number FROM igs_ps_sch_x_usec_int_all a WHERE a.int_usec_id = :int_usec_id;
  • Joining to the parent interface table to confirm orphaned rows:
    SELECT x.* FROM igs_ps_sch_x_usec_int_all x WHERE NOT EXISTS (SELECT 1 FROM igs_ps_sch_usec_int_all u WHERE u.int_usec_id = x.int_usec_id);
  • Reporting approved cross-listings within a date range:
    SELECT child_unit_cd, child_title, start_dt, end_dt FROM igs_ps_sch_x_usec_int_all WHERE start_dt >= :from_dt AND end_dt <= :to_dt;

Related Objects

  • IGS_PS_SCH_USEC_INT_ALL — parent interface unit section table; join on INT_USEC_ID.
  • IGS_PS_USEC_X_USEC — cross-listed unit section reference; join on UNIT_SEC_CROSS_UNIT_SEC_ID.
  • IGS_PS_SCH_X_USEC_INT_ALL_PK — primary key constraint (INT_USEC_X_USEC_ID).
  • IGS_PS_SCH_X_USEC_INT_UK / _U2 — alternate unique key (INT_USEC_ID, UNIT_SEC_CROSS_UNIT_SEC_ID).
  • IGS_PS_SCH_X_USEC_INT_ALL_U1 — unique index on the surrogate key.

The table is a staging, interface-oriented artifact in the IGS scheduling flow, and is consumed by the scheduler integration processes that read cross-listing data from these interface tables.