Search Results igs_ad_location_all




Overview
Explore in AI Chat

Overview

The IGS_AD_LOCATION_ALL table is a core data structure within the Oracle E-Business Suite Student System (IGS), now designated as obsolete. It functions as the master repository for defining all geographic locations where an educational institution offers or teaches its academic programs and course units. This table is fundamental for associating physical or logical venues with various academic, administrative, and financial processes. Its role is to provide a standardized reference for location data across the student lifecycle, from program offerings and admissions to fee assessment and facility management. The '_ALL' suffix indicates it is a multi-organization enabled table, designed to support data partitioning by operating unit in a multi-org architecture.

Key Information Stored

While the full column list is not provided in the excerpt, the documented primary and foreign keys reveal critical data points. The primary identifier is the LOCATION_CD column. Essential descriptive attributes would typically include the location name, address details, and active status. The table also stores classification and relational data, notably the LOCATION_TYPE, which links to the IGS_AD_LOCATION_TYPE_ALL table for categorization. It holds a reference to a coordinating person (COORD_PERSON_ID) linked to the HZ_PARTIES table in the Trading Community Architecture (TCA). For financial integration, it can be associated with a revenue account code (REV_ACCOUNT_CD) via a relationship with the IGS_FI_ACC_ALL table.

Common Use Cases and Queries

A primary use case is configuring and reporting on the available delivery locations for academic programs. Administrators use this data to define where specific program offerings or unit sections are taught. In financial modules, the location can determine applicable fee rates or revenue accounting. Common queries involve listing active locations for a given organization or joining to program offering tables. For example, to find all locations used for a specific program, one might query: SELECT DISTINCT loc.location_cd, loc.location_name FROM igs_ad_location_all loc JOIN igs_ps_ofr_opt_all ofr ON loc.location_cd = ofr.location_cd WHERE ofr.course_cd = 'PROG_CODE';. Reporting on location utilization for space planning or associating assessment items and exam supervisors with specific locations are other practical applications.

Related Objects

The table maintains extensive relationships across the Student System and into Financial Aid, as evidenced by its foreign keys. Key related objects include:

These relationships demonstrate the table's central role in connecting academic planning with operational and financial execution.