Search Results igs_ps_sch_x_usec_int_uk

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:

• INT_USEC_X_USEC_ID — surrogate primary key (index IGS_PS_SCH_X_USEC_INT_ALL_PK / _U1).
• INT_USEC_ID — foreign key to IGS_PS_SCH_USEC_INT_ALL; the parent interface usec record.
• UNIT_SEC_CROSS_UNIT_SEC_ID — foreign key to IGS_PS_USEC_X_USEC; the cross-listed unit section.
• PARENT_UOO_ID / CHILD_UOO_ID — the parent and child unit offering option identifiers in the cross-listing.
• CHILD_UNIT_CD, CHILD_VERSION_NUMBER, CHILD_TITLE — child unit identity attributes.
• CHILD_CAL_TYPE, CHILD_ALTERNATE_CODE — calendar context for the child section.
• CHILD_CI_SEQUENCE_NUMBER, CHILD_UNIT_CLASS — sequence and classification of the child.
• CHILD_UNIT_MODE, CHILD_LOCATION_CD, CHILD_LOCATION_DESCRIPTION — delivery mode and location of the child section.
• START_DT / END_DT — validity window of the cross-list relationship.
• ORG_ID — multi-org operating unit identifier.
• CROSS_LIST_GROUP_NAME, CLASS_MAX_ENROLLMENT_NUMBER — cross-list group label and enrollment cap.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard audit columns.

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.