Search Results igsbv_buildings

Overview

IGSBV_BUILDINGS is a read-only database view belonging to the IGS - Student System product family, historically delivered within the Oracle E-Business Suite and now classified as obsolete. The view exposes building-level information associated with a physical location, presenting a denormalized, report-friendly projection of the underlying building entity. Its purpose is to provide consumers of the Student System data model with a stable, read-only interface for retrieving building codes, location codes, descriptive text, and a closed status indicator without requiring direct access to the base table.

The view is defined with a WITH READ ONLY clause, which prohibits Data Manipulation Language operations against it and enforces its role strictly as a query and reporting artifact. The ETRM metadata explicitly records that the object is "Not implemented in this database," and no base objects are documented in the ETRM 12.2.2 record. As such, the view may not physically exist in a given environment; its presence depends on whether the IGS Student System was ever installed and whether the obsolete schema components were retained.

Underlying Base Objects

As documented, the view is defined over a single base object: IGS_AD_BUILDING_ALL. The _ALL suffix follows standard Oracle EBS conventions, indicating a multi-org or partitioned-style table that stores building records across operating units. The view performs only column aliasing and selection; it does not join to additional tables and does not apply WHERE predicates. The ETRM metadata lists no other referenced base objects, and the view text confirms this by selecting exclusively from IGS_AD_BUILDING_ALL. Because the definition is a straightforward projection, row cardinality in the view mirrors that of the base table, and any filtering must be applied by the querying application.

Key Columns

• BUILDING_CODE — Aliased from BUILDING_CD. The business-facing code that uniquely identifies a building within the Student System, typically the value referenced in location and facility validation logic.
• LOCATION_CODE — Aliased from LOCATION_CD. Identifies the location to which the building is associated, establishing the building-to-location relationship described in the view's purpose.
• DESCRIPTION — Free-text description of the building, used in reports and user interface displays.
• CLOSED_INDICATOR — Aliased from CLOSED_IND. This is the column most commonly targeted by users searching on "closed_indicator." It flags whether a building is closed, and is the primary filter used to exclude inactive facilities from reporting.
• BUILDING_ID — The internal surrogate primary key of the building record, suitable for joins to related IGS entities.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — Standard EBS audit columns recording row creation and modification history.

Common Use Cases and Queries

The view is typically used for facility reference reporting, integration extracts, and validation of building-to-location assignments. The CLOSED_INDICATOR column supports the common requirement of returning only active facilities.

Active buildings for a given location:

SELECT building_code, location_code, description
FROM igsbv_buildings
WHERE closed_indicator = 'N'
ORDER BY location_code, building_code;

Full inventory including closed records for audit purposes:

SELECT building_code, location_code, description, closed_indicator
FROM igsbv_buildings
ORDER BY closed_indicator, building_code;

Because the view carries no bind or org filters, integrations that must respect operating unit security should join back to IGS_AD_BUILDING_ALL or apply the appropriate org predicate at the source. Given the obsolete status of the IGS Student System, verified existence of the view and its base table should be confirmed before reliance in any production query path.