Search Results igs_ad_ss_test_conf_u1

Overview

The IGS_AD_SS_TEST_CONF table is a configuration entity within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the IGS (iGrants) module. Its primary function is to manage the association between different admission test types and admission application types, serving as a foundational setup for the student admissions process. The ETRM documentation explicitly marks this table as "Obsolete," indicating it is a legacy object that may have been superseded by newer data models or configurations in later releases. Despite this status, it remains a valid table in the referenced EBS versions, storing critical linkage data that governs which standardized tests are applicable to which types of admission applications.

Key Information Stored

The table's structure is relatively simple, centering on a unique configuration pair and its administrative metadata. The core business columns are ADMISSION_TEST_TYPE and ADMISSION_APPLICATION_TYPE, which together form a unique key (enforced by the IGS_AD_SS_TEST_CONF_U1 index). The ADMISSION_TEST_TYPE column identifies the category or name of the standardized test (e.g., SAT, ACT, GRE). The ADMISSION_APPLICATION_TYPE column defines the specific type of admission application to which the test is relevant. The INACTIVE column functions as a soft-delete or deactivation flag for the configuration. Standard EBS WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) track the audit trail for all records.

Common Use Cases and Queries

A primary use case is validating and reporting on which admission tests are configured for use within the system. Administrators might query this table to audit setup data, generate configuration lists for business process documentation, or identify active associations for application form logic. Given its obsolete status, direct transactional use in new customizations is discouraged, but queries may be necessary for data migration, support, or reporting on legacy data.

Sample Query: Retrieve all active test configurations for a specific application type

SELECT admission_test_type,
       admission_application_type
FROM   igs.igs_ad_ss_test_conf
WHERE  inactive IS NULL
AND    admission_application_type = 'FRESHMAN';

Sample Query: List all unique test types configured in the system

SELECT DISTINCT admission_test_type
FROM   igs.igs_ad_ss_test_conf
ORDER BY 1;

Related Objects

Based on the provided dependency information, the IGS_AD_SS_TEST_CONF table does not reference any other database objects. However, it is referenced by an object named IGS_AD_SS_TEST_CONF within the APPS schema. This reference likely points to a public synonym (APPS.IGS_AD_SS_TEST_CONF) that points to the underlying IGS-owned table, which is a standard EBS architecture pattern for providing a unified APPS interface to all objects. The absence of foreign key relationships in the provided metadata suggests this table operates as a standalone configuration or lookup entity, with its data being referenced programmatically by other application components within the IGS module.