Results for “igs_ps_uso_facility_u2”

6 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGS.IGS_PS_USO_FACILITY is a transactional table within the Oracle E-Business Suite student systems (IGS) schema that stores information about Unit Section Occurrence Facilities. In Oracle EBS 12.1.1 and 12.2.2, this object resides in the APPS_TS_TX_DATA tablespace with a PCT Free of 10 and is registered under the FND Design Data designation IGS.IGS_PS_USO_FACILITY. Its status is VALID. The table participates in the delivery of academic programs by associating physical or media-based facilities with specific unit section occurrences — the scheduled instances of teaching activity within a unit offering.

From a Data Vault modeling perspective, the schema metadata and foreign key topology suggest this object functions as a link. The heuristic classification is derived from the fact that the table resolves a many-to-many association between a unit section occurrence and a facility (media/equipment), with no descriptive attributes beyond standard WHO audit columns. The unique indexes enforce business keys on the relationship rather than serving as a hub of descriptive history.

Key Information Stored

The table comprises eight documented columns. The most operationally significant are:

The combination of UNIT_SECTION_OCCURRENCE_ID and FACILITY_CODE in unique index U2 is the natural (business) key, guaranteeing that a given facility is recorded only once per unit section occurrence. The surrogate USO_FACILITY_ID exists separately to provide a compact, stable identifier for downstream references.

Common Use Cases and Queries

Typical applications include facility utilization reporting, timetable and room scheduling reconciliation, and validation of resource assignments against unit section occurrences. A common query lists all facilities assigned to a given occurrence:

  • SELECT USO_FACILITY_ID, UNIT_SECTION_OCCURRENCE_ID, FACILITY_CODE FROM IGS.IGS_PS_USO_FACILITY WHERE UNIT_SECTION_OCCURRENCE_ID = :occurrence_id;

To detect duplicate or missing facility assignments, the U2 business key can be exercised directly:

  • SELECT UNIT_SECTION_OCCURRENCE_ID, FACILITY_CODE, COUNT(*) FROM IGS.IGS_PS_USO_FACILITY GROUP BY UNIT_SECTION_OCCURRENCE_ID, FACILITY_CODE HAVING COUNT(*) > 1;

Because the table is a link object, joins to IGS_PS_USEC_OCCURS_ALL and IGS_PS_MEDIA_EQUIP_ALL are the principal reporting pattern. Extraction into a warehouse typically maps UNIT_SECTION_OCCURRENCE_ID and FACILITY_CODE as the link's driving keys and USO_FACILITY_ID as its hash or sequence surrogate.

Related Objects

The table's dependencies are defined primarily through its foreign keys:

  • IGS.IGS_PS_USEC_OCCURS_ALL — joined on UNIT_SECTION_OCCURRENCE_ID; the parent occurrence record.
  • IGS.IGS_PS_MEDIA_EQUIP_ALL — joined on FACILITY_CODE; supplies facility/equipment descriptive detail.
  • APPS.IGS_PS_USO_FACILITY — the APPS synonym that references this table and is the object exposed to application and report SQL.

Together these relationships position IGS_PS_USO_FACILITY as the associative bridge between scheduled teaching occurrences and the facilities required to deliver them.