Results for “igs_ad_building”

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

Overview

IGS_AD_BUILDING is an APPS-owned, VALID database view within the Oracle E-Business Suite Student System (IGS) product family. It presents building (physical facility) master data used by the institution's academic and administrative location hierarchy. The view exposes a secured, operating-unit-filtered projection of the underlying building entity, allowing forms, concurrent programs, and reports to query building records scoped to the current operating unit context without directly accessing the multi-org base table.

Its principal role in EBS reporting and integration is to provide a reporting-safe interface over the building entity while enforcing Multi-Org access security through the ORG_ID predicate. Rather than exposing all rows to every session, the view resolves the active organization identifier from the user's client context and returns only records that belong to that operating unit (or records with a null ORG_ID, which are treated as globally visible). This design is consistent with the standard IGS pattern of pairing an "_ALL" base table with a secured view of the same logical name.

Underlying Base Objects

The view is defined over a single base table: IGS_AD_BUILDING_ALL. This is the multi-organization ("_ALL") table that stores building records across all operating units, keyed by ORG_ID. The view text is a simple projection and filter:

• Select list — ROWID is aliased as ROW_ID, and all significant business and audit columns are carried forward unchanged.
• Security predicate — The WHERE clause compares NVL(TAB.ORG_ID, ...) against NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL,SUBSTRB(USERENV('CLIENT_INFO'),1,10))), -99). This parses the operating unit identifier from the first ten characters of the CLIENT_INFO session value and matches it to the row's ORG_ID.
• Null handling — Rows with a null ORG_ID are coalesced to the sentinel value -99, matching the default when no client org context is set, so shared/global rows remain visible.

The ETRM 12.2.2 record documents no further referenced base objects beyond IGS_AD_BUILDING_ALL, confirming the view is a single-table secured projection rather than a join.

Key Columns

• ROW_ID — The physical ROWID of the base row, used by Oracle Forms for row identification and locking.
• BUILDING_ID — Surrogate primary key of the building record.
• BUILDING_CD — The user-visible building code, typically the business key referenced by locations and scheduling.
• DESCRIPTION — Free-text name or description of the building.
• LOCATION_CD — The location code with which the building is associated, linking it into the institution's location hierarchy.
• CLOSED_IND — Flag indicating whether the building is closed and therefore unavailable for assignment.
• ORG_ID — Operating unit identifier governing multi-org access; drives the view's security filter.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN provide standard who-column auditability.

Common Use Cases and Queries

Typical uses include LOV and validation queries for building selection, reporting on facility inventories per operating unit, and integration extracts that must respect operating-unit security. Because the view applies the ORG_ID predicate automatically, it is preferred over the base table in custom reports.

List active buildings for the current operating unit:

• SELECT building_id, building_cd, description, location_cd FROM igs_ad_building WHERE NVL(closed_ind,'N') = 'N' ORDER BY building_cd;

Look up a building by code:

• SELECT building_id, description, location_cd, closed_ind FROM igs_ad_building WHERE building_cd = :p_building_cd;

Audit recently changed buildings:

• SELECT building_cd, last_updated_by, last_update_date FROM igs_ad_building WHERE last_update_date >= TRUNC(SYSDATE) - 30;

All queries are automatically constrained to the caller's operating unit context; sessions without a client org setting see only rows whose ORG_ID is null.