Search Results primary_use_code




Overview
Explore in AI Chat

Overview

IGSBV_ROOMS is a read-only view owned by the APPS schema in the Oracle E-Business Suite Student System (IGS) product family. In ETRM 12.2.2, the object is documented as VALID and is described as an entity that "contains room information associated to a building." The view presents a denormalized, reporting-oriented projection of institutional room (space) records, joining room master data to the building that contains each room. In Oracle EBS 12.1.1 and 12.2.2, the IGS schema underpins the Oracle Student System modules such as space management, scheduling, and facility planning. This view consequently serves as the primary read interface for administrators and integration developers needing room attributes—capacity, primary use, and closure status—together with the parent building code in a single queryable source.

Underlying Base Objects

According to the documented view text, IGSBV_ROOMS is defined over two base tables in the IGS_AD schema:

  • IGS_AD_ROOM_ALL (aliased RM) — the room master table, supplying room code, building reference, description, primary use, capacity, and the closed indicator.
  • IGS_AD_BUILDING_ALL (aliased BLD) — the building master table, supplying the building code and providing the equijoin target on BUILDING_ID.

The view is a simple inner join on RM.BUILDING_ID = BLD.BUILDING_ID. It is created WITH READ ONLY, meaning no DML is permitted through the view and it is intended strictly for query and reporting purposes. The non-ALL editions of the underlying tables expose the same physical data; the ALL suffix indicates the multi-organization/master-data-enabled base tables that also carry the standard WHO columns.

Key Columns

  • ROOM_NUMBER (RM.ROOM_CD) — the user-facing room code that identifies the room within its building.
  • BUILDING_ID — internal foreign key linking the room to its building; join key to the building master.
  • DESCRIPTION — descriptive text for the room.
  • PRIMARY_USE_CODE (RM.PRIMARY_USE_CD) — coded classification of the room's principal purpose (for example lecture, laboratory, or office).
  • CAPACITY — the seating or occupancy capacity of the room.
  • CLOSED_INDICATOR (RM.CLOSED_IND) — the flag indicating whether the room is currently closed to use. This column is the direct match for the user's search term "closed_indicator."
  • BUILDING_CODE (BLD.BUILDING_CD) — the human-readable code of the parent building, denormalized into the view.
  • ROOM_ID — the surrogate primary key for the room record.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — standard Oracle EBS WHO audit columns inherited from the room master.

Common Use Cases and Queries

Typical uses include room schedule and capacity reporting, integration feeds into timetabling or space-planning systems, and validation that a room is not closed before assignment. The CLOSED_INDICATOR column is frequently filtered to exclude unavailable rooms.

List all open rooms with capacity:

SELECT room_number, building_code, description, capacity, primary_use_code
FROM apps.igsbv_rooms
WHERE closed_indicator = 'N'
ORDER BY building_code, room_number;

Locate closed rooms by building:

SELECT building_code, room_number, description
FROM apps.igsbv_rooms
WHERE closed_indicator = 'Y'
ORDER BY building_code;

Aggregate capacity by building for open rooms:

SELECT building_code, COUNT(*) room_count, SUM(capacity) total_capacity
FROM apps.igsbv_rooms
WHERE closed_indicator = 'N'
GROUP BY building_code;