Search Results igs_ad_location_type_all




Overview
Explore in AI Chat

Overview

The IGS_AD_LOCATION_TYPE_ALL table is a core reference table within the now-obsolete Oracle Student System (IGS) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It serves as a master repository for classifying different categories or types of physical or logical locations used by an educational institution. Its primary role is to enforce data integrity by providing a controlled list of valid location types, which are then referenced by transactional and master data tables across the student administration system. This table is designed to support multi-organization access control through its "_ALL" suffix and corresponding partitioning strategy, allowing data to be segmented by operating unit. As noted in the provided ETRM documentation, the table's status is marked as "Obsolete," indicating it is part of a legacy codebase that may be superseded in future releases or updates.

Key Information Stored

Based on the documented primary key and typical design patterns for such reference tables in EBS, the table's central column is LOCATION_TYPE. This column acts as a unique identifier or code for each location classification (e.g., 'CAMPUS', 'BUILDING', 'ROOM', 'SPORTS_FACILITY', 'LIBRARY'). While the specific full column list is not detailed in the provided excerpt, tables of this nature commonly include descriptive columns such as DESCRIPTION, an ENABLED_FLAG to control active status, and standard EBS WHO columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN). The primary key constraint IGS_AD_LOCATION_TYPE_PK ensures the uniqueness of the LOCATION_TYPE values.

Common Use Cases and Queries

The primary use case is to maintain and query the valid set of location types for validation and reporting. It is commonly referenced in user interfaces (LOVs) when assigning a type to a new location and in reports that categorize institutional assets or spaces. A typical administrative query would list all active location types. Given the foreign key relationship, a common join query would retrieve all locations of a specific type.

  • Sample Query to list all location types: SELECT location_type, description FROM igs_ad_location_type_all WHERE enabled_flag = 'Y' ORDER BY 1;
  • Sample Query joining to the location table: SELECT loc.location_code, loc.description, loc_type.description as type_name FROM igs_ad_location_all loc, igs_ad_location_type_all loc_type WHERE loc.location_type = loc_type.location_type AND loc_type.location_type = 'CAMPUS';

Related Objects

The documented relationship data shows a clear foreign key dependency from the IGS_AD_LOCATION_ALL table, which stores the detailed instances of locations. This is the primary and, based on the provided metadata, only documented direct relationship.

  • IGS_AD_LOCATION_ALL: This table references IGS_AD_LOCATION_TYPE_ALL via its LOCATION_TYPE column (foreign key). The relationship ensures that every location record in IGS_AD_LOCATION_ALL is assigned a valid type defined in the IGS_AD_LOCATION_TYPE_ALL master table.