Search Results ss_lookup_type




Overview
Explore in AI Chat

Overview

The IGS_AD_SS_LOOKUPS table is a core data repository within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the IGS (Oracle Student Management) application. It functions as a configuration and validation table for self-service lookup data, enabling the categorization and control of user-selectable values within the admissions process. Its primary role is to store and manage discrete, application-specific codes (lookups) that are grouped under defined types, with the critical capability to scope these lookups to specific admission application types. This design ensures that the valid options presented to users in self-service interfaces are contextually relevant and properly governed.

Key Information Stored

The table's structure is designed to enforce uniqueness and facilitate efficient retrieval. The primary key is a composite of three columns, establishing the fundamental rule for each lookup entry. Key columns include:

  • ADMISSION_APPLICATION_TYPE (VARCHAR2(30), Mandatory): The key scoping attribute that ties the lookup data to a specific category of admission application, as defined in a related table (IGS_AD_SS_APPL_TYP).
  • SS_LOOKUP_TYPE (VARCHAR2(30), Mandatory): The high-level category or grouping identifier for a set of lookup codes (e.g., 'ETHNICITY', 'CITIZENSHIP').
  • SS_LOOKUP_CODE (VARCHAR2(30), Mandatory): The individual, meaningful code within a given lookup type (e.g., 'USA' within the 'CITIZENSHIP' type).
  • CLOSED_FLAG (VARCHAR2(1)): An administrative control flag used to prevent the further use of a specific lookup code in self-service transactions without purging historical data.
  • Standard WHO Columns (CREATED_BY, CREATION_DATE, etc.): Audit columns tracking the user and timestamp for record creation and modification.

Common Use Cases and Queries

This table is central to populating and validating lists of values (LOVs) in the student self-service admission portal. A common operational task is querying all active lookups for a specific application type to verify configuration. For example, to retrieve all valid citizenship codes for the 'UNDERGRAD' application type, one would use:

SELECT ss_lookup_code FROM igs.igs_ad_ss_lookups WHERE admission_application_type = 'UNDERGRAD' AND ss_lookup_type = 'CITIZENSHIP' AND NVL(closed_flag, 'N') = 'N' ORDER BY ss_lookup_code;

Administrative reporting often involves identifying all lookup types and their associated codes defined within the system, which can be achieved by querying the distinct combinations of `ADMISSION_APPLICATION_TYPE` and `SS_LOOKUP_TYPE`. The `CLOSED_FLAG` is frequently used in WHERE clauses to filter out inactive options from user-facing LOVs while retaining them for historical reporting on past applications.

Related Objects

The IGS_AD_SS_LOOKUPS table has defined relationships with other EBS objects, primarily through its foreign key constraint. The documented relationships are:

  • Primary Key: IGS_AD_SS_LOOKUPS_PK on (ADMISSION_APPLICATION_TYPE, SS_LOOKUP_TYPE, SS_LOOKUP_CODE).
  • Foreign Key (References): The column `ADMISSION_APPLICATION_TYPE` references the `IGS_AD_SS_APPL_TYP` table. This enforces referential integrity, ensuring that a lookup record can only be associated with a valid, pre-defined admission application type.
  • Index: IGS_AD_SS_LOOKUPS_N1 on (SS_LOOKUP_TYPE, SS_LOOKUP_CODE). This non-unique index optimizes queries that search by lookup type and code, independent of the application type.

As per the dependency information, the table is referenced by the APPS synonym `IGS_AD_SS_LOOKUPS`, which is the standard access point for all application code and queries within the EBS environment.