Search Results igs_ad_ss_lookups

Overview

The IGS_AD_SS_LOOKUPS table is a data object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically in the now-obsolete IGS (Student System) product family. Its primary role is to store self-service lookup data associated with specific admission application types. This table functioned as a cross-reference or mapping entity, linking an admission application type to specific lookup codes and types, likely used to control or define the available values and behaviors within self-service application interfaces. The provided ETRM metadata explicitly notes this table was "Not implemented in this database," indicating it may have been part of a data model that was not deployed in standard installations or was superseded in later releases.

Key Information Stored

The table's structure is defined by a composite primary key, which dictates the core data it holds. The key columns are ADMISSION_APPLICATION_TYPE, SS_LOOKUP_TYPE, and SS_LOOKUP_CODE. The ADMISSION_APPLICATION_TYPE column stores the code identifying a specific category or process for admissions. The SS_LOOKUP_TYPE and SS_LOOKUP_CODE columns work in tandem; the SS_LOOKUP_TYPE defines a category of lookup values (e.g., 'COUNTRY', 'MAJOR'), while the SS_LOOKUP_CODE stores the individual valid value within that category (e.g., 'US', 'BIOLOGY'). Together, these three columns define which lookup codes are valid or available for a given application type within the self-service context.

Common Use Cases and Queries

This table's primary use case was to dynamically control the list of valid selections presented to an applicant during the online application process based on their chosen application type. For example, certain academic programs or residency status options might only be applicable for specific admission pathways. A typical query would retrieve all valid lookup codes for a given application type and lookup type to populate a list of values (LOV).

SELECT ss_lookup_code, meaning
FROM igs_ad_ss_lookups
WHERE admission_application_type = 'FRESHMAN'
  AND ss_lookup_type = 'RESIDENCY_STATUS'
ORDER BY ss_lookup_code;

Another common operational query would verify the validity of a user-submitted value against this control table.

Related Objects

Based on the documented foreign key relationship, this table has a direct dependency on the IGS_AD_SS_APPL_TYP table. The relationship is defined as follows:

• Foreign Key Reference: The ADMISSION_APPLICATION_TYPE column in IGS_AD_SS_LOOKUPS references the corresponding column in the IGS_AD_SS_APPL_TYP table.
• Purpose: This ensures referential integrity, meaning that every application type configured in the lookup table must first be defined as a valid application type in the IGS_AD_SS_APPL_TYP master table. This prevents orphaned lookup data.

As the source of the lookup codes themselves, this table was likely referenced by various student self-service application forms and underlying PL/SQL logic within the obsolete IGS module to validate and present application data.