Search Results igs_ps_sch_pat_int




Overview
Explore in AI Chat

Overview

IGS_PS_SCH_PAT_INT is an interface (staging) table in the IGS schema of the Oracle E-Business Suite Student System module. Its documented purpose is to capture scheduler interface Unit Offering Pattern data — that is, the pattern-level records describing when and how a unit offering is scheduled — before that data is validated and transferred into the base Student System scheduling tables. The table resides in the IGS schema and carries a VALID status in the ETRM 12.1.1 physical schema, which documents 20 columns.

In Data Vault terms, the heuristic classification mined from the foreign-key structure is hub-leaning. This is a modeling suggestion rather than a physical implementation: INT_PAT_ID functions as the stable, unique business key of the pattern record, while descriptive and status attributes (calendar type, enrollment figures, dates, flags, and audit columns) are supplied by the surrounding interface process. A Data Vault practitioner would likely model IGS_PS_SCH_PAT_INT as a hub keyed on INT_PAT_ID, with dependent satellites capturing the descriptive columns.

Key Information Stored

The surrogate primary key is INT_PAT_ID, enforced by the unique index IGS_PS_SCH_PAT_INT_PK. Because this same column is the documented unique index, INT_PAT_ID is also the primary business-key candidate — each row represents exactly one scheduler interface unit offering pattern.

Common Use Cases and Queries

The table is typically consumed by concurrent programs and interfaces that validate inbound scheduler data, apply it to the Student System, and then purge or flag processed rows. Common scenarios include reconciling interface rows against the base unit offering pattern data, and auditing unprocessed or aborted rows.

  • Identifying all pattern rows still awaiting import: SELECT INT_PAT_ID, UNIT_CD, VERSION_NUMBER FROM IGS_PS_SCH_PAT_INT WHERE IMPORT_DONE_FLAG = 'N';
  • Linking each pattern to its parent header via TRANSACTION_ID for end-to-end interface tracing: SELECT p.INT_PAT_ID, p.UNIT_CD, h.TRANSACTION_ID FROM IGS_PS_SCH_PAT_INT p, IGS_PS_SCH_HDR_INT_ALL h WHERE p.TRANSACTION_ID = h.TRANSACTION_ID;
  • Reporting enrollment demand by unit and calendar: aggregate ENROLLMENT_EXPECTED and ENROLLMENT_MAXIMUM grouped by UNIT_CD, CALENDAR_TYPE, and START_DATE.
  • Detecting failed or aborted staging rows using ABORT_FLAG for interface error handling and audit reporting.

Related Objects

  • IGS_PS_SCH_HDR_INT_ALL — parent header interface table; joined on IGS_PS_SCH_PAT_INT.TRANSACTION_ID = IGS_PS_SCH_HDR_INT_ALL.TRANSACTION_ID.
  • IGS_PS_SCH_FAC_INT — child interface table for facility data; references this table via IGS_PS_SCH_FAC_INT.INT_PAT_ID.
  • IGS_PS_SCH_LOC_INT — child interface table for location data; references this table via IGS_PS_SCH_LOC_INT.INT_PAT_ID.
  • IGS_PS_SCH_PAT_INT_PK — the unique index enforcing the primary key on INT_PAT_ID.
  • Base IGS unit offering pattern tables — the ultimate targets into which validated, non-aborted, non-imported rows are transferred by the scheduler interface process.