Results for “primary_use_cd”

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

Overview

IGS_AD_ROOM_ALL is a table in the IGS (Student System) product schema of Oracle E-Business Suite, and it stores the master records for physical rooms used in academic scheduling and facilities management. In EBS 12.1.1 and 12.2.2, this table is validated and holds 13 documented columns. Its role is to define each room's identity, the building in which it resides, its primary use, its seating capacity, and whether it is currently closed for use. Downstream scheduling and space-utilization components reference room rows to assign classes, panels, and unit locations to specific physical spaces.

Using the heuristic Data Vault classification supplied in the metadata, IGS_AD_ROOM_ALL is hub-leaning. It functions conceptually as a hub: a stable, uniquely keyed business entity (the room) referenced by many dependent and transactional tables. The designation is a modeling suggestion, not a physical Data Vault implementation.

Key Information Stored

The table is keyed by the surrogate primary key ROOM_ID, enforced through IGS_AD_ROOM_PK. A second unique index, IGS_AD_ROOM_U2, spans BUILDING_ID and ROOM_CD, establishing the business-key candidate: a room code is unique within its building. This distinction matters because integrations frequently resolve rooms by building-plus-code, while internal foreign keys almost always use the surrogate ROOM_ID.

The columns of primary analytical interest include:

• ROOM_ID — surrogate primary key and the value referenced by dependent tables.
• BUILDING_ID — foreign key to IGS_AD_BUILDING_ALL; part of the unique business key.
• ROOM_CD — the room code or number; the other half of the unique business key.
• DESCRIPTION — human-readable room name or description.
• PRIMARY_USE_CD — code for the room's principal use (for example, lecture, laboratory, or office).
• CAPACITY — the seating or occupancy capacity of the room.
• CLOSED_IND — indicates whether the room is closed and therefore unavailable for scheduling.
• ORG_ID — operating unit identifier, supporting multi-org security and partitioning.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard WHO audit columns.

Common Use Cases and Queries

Typical reporting scenarios include producing room inventories by building, identifying rooms available for scheduling by capacity, and auditing closed rooms. A simple lookup by business key is:

• SELECT r.ROOM_ID, r.ROOM_CD, r.DESCRIPTION, r.CAPACITY FROM IGS_AD_ROOM_ALL r WHERE r.BUILDING_ID = :building_id AND r.ROOM_CD = :room_cd;

A capacity-driven query for scheduling candidates is:

• SELECT r.ROOM_ID, r.ROOM_CD, r.CAPACITY FROM IGS_AD_ROOM_ALL r WHERE r.CAPACITY >= :required_seats AND NVL(r.CLOSED_IND,'N') = 'N' ORDER BY r.CAPACITY;

A join to the building table and a utilization join follow the documented foreign keys:

• SELECT r.ROOM_CD, b.* FROM IGS_AD_ROOM_ALL r, IGS_AD_BUILDING_ALL b WHERE r.BUILDING_ID = b.BUILDING_ID;
• SELECT u.*, r.ROOM_CD FROM IGS_PS_UNIT_LOCATION u, IGS_AD_ROOM_ALL r WHERE u.ROOM_ID = r.ROOM_ID;

Because the table is org-striped, multi-org reports should constrain ORG_ID.

Related Objects

The following objects are most significant to IGS_AD_ROOM_ALL, based on the documented foreign-key relationships:

• IGS_AD_BUILDING_ALL — referenced via IGS_AD_ROOM_ALL.BUILDING_ID; the parent building of each room.
• IGS_PS_UNIT_LOCATION — references the room through ROOM_ID, tying rooms to teaching unit locations.
• IGS_PS_USEC_OCCURS_ALL — references the room by ROOM_ID-derived columns, including DEDICATED_ROOM_CODE, PREFERRED_ROOM_CODE, and ROOM_CODE, for scheduled occurrences.
• IGS_PS_UNSCHED_CL — references the room through ROOM_ID for unscheduled-class handling.
• IGS_PS_SCH_INT_ALL — references the room through ROOM_ID for scheduling intelligence records.
• IGS_AD_PANEL_DTLS — references the room through ROOM_ID in panel definitions.
• IGS_AD_PNMEMBR_DTLS — references the room through ROOM_ID in panel-member details.

Together these links confirm that IGS_AD_ROOM_ALL is a central reference entity for room-based scheduling, occupancy, and examination logistics in the IGS Student System.