Search Results int_fac_id

Overview

IGS.IGS_PS_SCH_FAC_INT is a public interface table in the Oracle E-Business Suite IGS (Student Systems / Higher Education) product. Its display name, "Export Scheduling Unit Offering Pattern Facilities Detail," accurately describes its function: it holds facility (media) information configured at the unit offering pattern level so that the scheduling engine can subsequently generate unit section and unit section occurrence level data. As an interface (staging) object, it acts as a transient bridge between configuration data and the production table IGS_PS_UNIT_FACILITY. The table is owned by the IGS schema, resides in the APPS_TS_TX_DATA tablespace, and carries a status of VALID with an active lifecycle.

From a Data Vault modeling perspective, the heuristic classification for this object is satellite-leaning. The design rationale is that its primary key, INT_FAC_ID, is a surrogate unique identifier rather than a natural business key, and the table carries descriptive attributes (MEDIA_CODE, MEDIA_DESCRIPTION) plus standard Who columns. This suggests it behaves as a descriptive satellite attached to a parent pattern interface object, rather than as a standalone hub or a pure association link.

Key Information Stored

The table is documented with nine columns, of which the most significant are:

• INT_FAC_ID (NUMBER) — the surrogate unique identifier for each unit offering pattern facility record in the scheduler interface. This column is the single-column primary key enforced by the unique index IGS_PS_SCH_FAC_INT_PK.
• INT_PAT_ID (NUMBER) — the identifier of the parent unit offering pattern in the scheduling interface. This is the documented foreign key, forming the principal business relationship of the table and the primary grouping key for facility rows.
• MEDIA_CODE (VARCHAR2(10)) — the media code corresponding to the unit version of the unit offering pattern. This is the descriptive business attribute that determines the facility type to be created in production.
• MEDIA_DESCRIPTION (VARCHAR2(60)) — a human-readable description of the media, useful for reporting without a lookup join.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard Oracle Who columns recording audit and concurrency information for each interface row.

No alternate unique index is documented beyond the primary key, so INT_FAC_ID is the sole documented business-key candidate and the only guaranteed unique attribute on the record.

Common Use Cases and Queries

The most common scenario for this table is verifying that pattern-level facility configuration has been staged correctly before the scheduling process promotes rows into IGS_PS_UNIT_FACILITY. A typical diagnostic query retrieves all facilities belonging to a specific pattern:

• SELECT INT_FAC_ID, INT_PAT_ID, MEDIA_CODE, MEDIA_DESCRIPTION FROM IGS.IGS_PS_SCH_FAC_INT WHERE INT_PAT_ID = :pattern_id;
• Reporting by media type: SELECT MEDIA_CODE, COUNT(*) FROM IGS.IGS_PS_SCH_FAC_INT GROUP BY MEDIA_CODE; to analyze the distribution of facility requirements across offering patterns.
• Audit and troubleshooting: select rows where LAST_UPDATE_DATE is recent to determine what the interface load has most recently touched, or join CREATED_BY to FND_USER for accountability.
• Referential integrity checks: identifying orphan facility rows whose INT_PAT_ID does not exist in IGS_PS_SCH_PAT_INT, which would indicate an incomplete or out-of-sequence load.

Related Objects

The dependency metadata identifies a focused set of relationships:

• IGS.IGS_PS_SCH_PAT_INT — the parent interface table. The foreign key IGS_PS_SCH_FAC_INT.INT_PAT_ID references it, making this the primary join partner for pattern-and-facility analysis.
• IGS.IGS_PS_UNIT_FACILITY — the documented production destination table into which staged facility detail is ultimately created.
• APPS.IGS_PS_SCH_FAC_INT — the APPS-synonym view or wrapper, referenced by the table according to the dependency listing, providing the application-facing access path.
• IGS_PS_SCH_FAC_INT_PK — the unique index on INT_FAC_ID in APPS_TS_TX_IDX, the access path for both direct key lookups and the INT_PAT_ID grouping queries.

The table references no other database objects beyond its parent pattern interface, and its column set is intentionally narrow, reflecting its short-lived role as a staging surface rather than a persistent transaction store.