Search Results override_enrollment_maximum

Overview

IGS.IGS_PS_SCH_PAT_INT is a public interface (staging) table in the Oracle E-Business Suite Student Systems (IGS) product family. It stores Unit Offering Pattern detail rows that are exported to a third-party scheduling interface, and it is explicitly documented as inactive when records exist at the section level; the corresponding production table is IGS_PS_UNIT_OFR_PAT_ALL. The table resides in the APPS_TS_TX_DATA tablespace with a PCT Free of 10, and its lifecycle status is active, with an FND Design Data entry of IGS.IGS_PS_SCH_PAT_INT.

The object’s display name, “Export Scheduling Unit Offering pattern Detail,” and its category classification (BUSINESS_ENTITY IGS_UNIT) confirm its role as a business-facing staging entity for unit offering patterns rather than a transactional master. Because the data vault classification is hub-leaning, the table is best modeled as a hub candidate keyed by its surrogate identifier, with descriptive attributes suggesting satellite treatment where the model is extended. In Oracle EBS 12.1.1 and 12.2.2, this table is populated by concurrent processes that extract scheduling data for external systems.

Key Information Stored

The table contains 20 documented columns. The most significant include:

• INT_PAT_ID — the surrogate primary key, enforced by unique index IGS_PS_SCH_PAT_INT_PK; the unique identifier for each unit offering pattern in the scheduler interface.
• TRANSACTION_ID — identifier linking the pattern row to a scheduling transaction header; this is a foreign key to IGS_PS_SCH_HDR_INT_ALL, making the column the primary business-key candidate for grouping detail rows under a header.
• CALENDAR_TYPE, SEQUENCE_NUMBER, TEACHING_CAL_ALTERNATE_CODE, START_DATE, END_DATE — the composite business-key candidates covered by nonunique index IGS_PS_SCH_PAT_INT_N1 (UNIT_CD, VERSION_NUMBER, CALENDAR_TYPE, SEQUENCE_NUMBER), describing the teaching calendar instance and its date range.
• UNIT_CD and VERSION_NUMBER — the unit code and unit version to which the pattern applies.
• ENROLLMENT_EXPECTED, ENROLLMENT_MAXIMUM, OVERRIDE_ENROLLMENT_MAXIMUM — enrollment thresholds for the unit version, including the override value.
• UNIT_STATUS — status of the unit version at export time.
• ABORT_FLAG and IMPORT_DONE_FLAG — control flags indicating whether the pattern is aborted and whether the export/import has completed.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns.

Common Use Cases and Queries

Typical usage centers on staging validation, export reconciliation, and integration troubleshooting. A frequent pattern is retrieving all pattern rows for a given scheduling transaction:

• SELECT INT_PAT_ID, UNIT_CD, VERSION_NUMBER, CALENDAR_TYPE, START_DATE, END_DATE FROM IGS.IGS_PS_SCH_PAT_INT WHERE TRANSACTION_ID = :p_transaction_id;
• SELECT * FROM IGS.IGS_PS_SCH_PAT_INT WHERE IMPORT_DONE_FLAG = 'N' AND ABORT_FLAG = 'N'; — pending exports.
• Joining the composite index columns (UNIT_CD, VERSION_NUMBER, CALENDAR_TYPE, SEQUENCE_NUMBER) to identify duplicate or overlapping calendar instances.
• Comparing staging rows against the production table IGS_PS_UNIT_OFR_PAT_ALL to confirm that section-level records take precedence, since the interface is not used when section-level records exist.

Related Objects

The dependency structure identifies this table as a hub with incoming links from two interface children and one outgoing reference to a transaction header:

• IGS_PS_SCH_HDR_INT_ALL — referenced by TRANSACTION_ID; the parent scheduling interface header.
• IGS_PS_SCH_FAC_INT — references this table via INT_PAT_ID; holds scheduling facility detail.
• IGS_PS_SCH_LOC_INT — references this table via INT_PAT_ID; holds scheduling location detail.
• IGS_PS_UNIT_OFR_PAT_ALL — the corresponding production table for unit offering patterns.
• FND Design Data entry IGS.IGS_PS_SCH_PAT_INT, used for concurrent/interface registration.