Search Results igs_ps_sch_fac_int_pk

Overview

IGS_PS_SCH_FAC_INT is an interface (staging) table within the Oracle E-Business Suite Students System (IGS) product family. Its documented purpose is to capture scheduler interface Unit Facilities data — that is, the facility or media attributes associated with a scheduling unit as passed from an external scheduling system into Oracle EBS for subsequent validation and loading into the production scheduler tables. The table belongs to the IGS module, which is marked Obsolete in the ETRM documentation for releases 12.1.1 and 12.2.2, meaning that while the object definition survives in the data dictionary, Oracle no longer supports or ships the corresponding functionality in these releases.

From a modeling perspective, the ETRM Data Vault classification heuristic marks this object as satellite-leaning. This is a suggestion rather than a declaration: the table carries descriptive attributes (media code and description) that revolve around a parent scheduling record and a parent pattern record, with the pattern reference implemented as a foreign key, which is consistent with satellite behavior. It is important to note that the ETRM implementation data records the table as "Not implemented in this database," so the description below reflects the documented logical structure rather than a guaranteed deployed physical object in every environment.

Key Information Stored

The documented physical schema for 12.1.1 lists nine columns owned by the IGS schema. The most significant columns are:

• INT_FAC_ID — the surrogate primary key of the interface row, defined by the unique index IGS_PS_SCH_FAC_INT_PK. This is the only documented unique index and therefore the only documented business-key candidate, although ETRM explicitly labels it as a primary key rather than a natural business key.
• INT_PAT_ID — the foreign key linking this facility interface row to its parent scheduling pattern interface row in IGS_PS_SCH_PAT_INT. This column carries the relationship semantics of the interface set and is the primary structural join for the table.
• MEDIA_CODE — the coded identifier of the facility or delivery medium associated with the scheduling unit being interfaced.
• MEDIA_DESCRIPTION — the descriptive, human-readable text corresponding to MEDIA_CODE.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard Oracle EBS "Who" audit columns applied to records inserted or updated through concurrent processing, providing accountability and enabling incremental extraction in interfaces.

The deliberate separation of surrogate key from foreign key, combined with only descriptive payload columns, reinforces the satellite-leaning classification: the interface row describes a facility attribute of a parent pattern and does not itself own subordinate relationships.

Common Use Cases and Queries

Because this is an interface table, typical usage centers on pre-load validation and reconciliation rather than transactional reporting. Common scenarios include verifying that every facility interface row resolves to a valid parent pattern row before the scheduler load runs, and auditing media values for completeness.

A representative join query is:

• SELECT f.INT_FAC_ID, f.INT_PAT_ID, f.MEDIA_CODE, f.MEDIA_DESCRIPTION FROM IGS_PS_SCH_FAC_INT f JOIN IGS_PS_SCH_PAT_INT p ON f.INT_PAT_ID = p.INT_PAT_ID;
• Orphan detection: SELECT f.* FROM IGS_PS_SCH_FAC_INT f LEFT JOIN IGS_PS_SCH_PAT_INT p ON f.INT_PAT_ID = p.INT_PAT_ID WHERE p.INT_PAT_ID IS NULL;
• Media distribution reporting: SELECT MEDIA_CODE, COUNT(*) FROM IGS_PS_SCH_FAC_INT GROUP BY MEDIA_CODE;
• Incremental extraction based on LAST_UPDATE_DATE for downstream reconciliation or archival.

These patterns support interface monitoring, data quality gates, and historical comparison of what was staged versus what was ultimately accepted.

Related Objects

The documented foreign-key relationship identifies the principal related object:

• IGS_PS_SCH_PAT_INT — the parent scheduling pattern interface table, joined via IGS_PS_SCH_FAC_INT.INT_PAT_ID = IGS_PS_SCH_PAT_INT.INT_PAT_ID. This is the only documented foreign key from this table and the most significant dependency.
• IGS_PS_SCH_FAC_INT_PK — the unique index enforcing the surrogate key on INT_FAC_ID.

Beyond these, the production scheduler counterparts in the IGS_PS schema (the non-INT tables for unit facilities and scheduling patterns) serve as the natural load targets for the interface rows, and the standard concurrent programs that populate and consume the *_INT tables in the Student System constitute the principal procedural dependents. Because the IGS product is documented as Obsolete in 12.1.1 and 12.2.2, integrators should confirm actual object existence in the target instance before constructing dependent logic.