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:
- USO_FACILITY_ID (NUMBER(10)) — the surrogate primary key, enforced by unique index IGS_PS_USO_FACILITY_U1 and the primary key constraint IGS_PS_USO_FACILITY_PK. This is the internal identifier referenced throughout the application layer.
- UNIT_SECTION_OCCURRENCE_ID (NUMBER(10)) — identifies the unit section occurrence to which the facility is attached. This column is part of the business-key candidate IGS_PS_USO_FACILITY_U2 and carries a foreign key to IGS_PS_USEC_OCCURS_ALL.
- FACILITY_CODE (VARCHAR2(10)) — the code of the facility, equipment, or media resource assigned. It forms the second component of the U2 business-key candidate and references IGS_PS_MEDIA_EQUIP_ALL.
- CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard WHO audit columns recording insert and update provenance.
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.
-
This table contains information about Unit Section Occurrence Facilities.
-
12.1.1 DBA Data 12.1.1
-
12.1.1 DBA Data 12.1.1
-
eTRM - IGS Tables and Views 12.1.1
Holds applicant whose records are wrongly available . It is recommended that such applicant records are deleted from the system . It synchronizes with UCAS view 'ivStarW'.