Search Results building_desc




Overview
Explore in AI Chat

Overview

IGSFV_ROOMS is a read-only Oracle EBS view belonging to the IGS (Student System) product family, a module now classified as obsolete. As its description states, the entity "contains rooms information associated with a building." It presents a denormalized, joined picture of room records and their parent building, exposing room attributes alongside building codes and descriptions in a single relational source. In EBS 12.1.1 and 12.2.2, such views were typically used for reporting, inquiry forms, and downstream integration extracts, providing a convenient join layer so that consumers did not need to reconstruct the ROOM-to-BUILDING relationship themselves.

The view is defined with the WITH READ ONLY clause, confirming that it is not an updateable entity and is intended strictly for query access. The ETRM metadata indicates the view is "Not implemented in this database," meaning it exists in the repository definition but is not deployed in every instance. Its inclusion in the documentation remains relevant for environments running the legacy Student System or for migrations that reference it.

Underlying Base Objects

Although the documented "Referenced base objects" field is empty, the view text itself exposes the two source tables:

The join condition is RM.BUILDING_ID = BLD.BUILDING_ID, an inner join that returns only rooms with a valid matching building record. Note that IGS_AD_ROOM_ALL carries the _ALL suffix, indicating a multi-organization or partitioned table pattern common in IGS, though the view does not filter by organization explicitly.

Key Columns

Common Use Cases and Queries

The view is suited to facility and scheduling reports that need room and building context together. A typical query retrieves active rooms in a given building:

SELECT ROOM_NUMBER, BUILDING_CODE, BUILDING_DESC, CAPACITY
FROM IGSFV_ROOMS
WHERE CLOSED_INDICATOR = 'N'
ORDER BY BUILDING_CODE, ROOM_NUMBER;

A second common pattern groups capacity by building for utilization analysis:

SELECT BUILDING_CODE, BUILDING_DESC, COUNT(*) ROOM_COUNT, SUM(CAPACITY) TOTAL_CAPACITY
FROM IGSFV_ROOMS
GROUP BY BUILDING_CODE, BUILDING_DESC;

Because the view is read-only and, per the metadata, frequently not implemented in a given database, callers should verify its existence before relying on it in production SQL or integration code.