Search Results inquiry_type_id




Overview
Explore in AI Chat

Overview

The IGS.IGR_I_E_TESTTYPS table is a configuration and mapping table within the Oracle E-Business Suite (EBS) 12.1.1 / 12.2.2, specifically in the IGS (Oracle Student Management) product family. Its primary role is to store and manage the association between different types of standardized admission tests and specific inquiry entry statuses. This table acts as a reference point, enabling the system to define which admission test types are relevant or required for prospective students based on their current inquiry or application status. The presence of a unique index on INQUIRY_TYPE_ID underscores its functional link to the broader inquiry classification framework.

Key Information Stored

The table's structure is designed to capture both the core mapping data and standard audit information. The most critical columns include:

Common Use Cases and Queries

This table is central to processes involving the tracking and reporting of admission test requirements. A common operational use case is generating a list of all active test types configured for a specific inquiry type, which is essential for setting up application checklists or compliance rules. For reporting, analysts may join this table with inquiry master data to analyze test submission patterns. A foundational query to retrieve all mappings, filtered by a specific INQUIRY_TYPE_ID, is:

SELECT admission_test_type, closed_ind FROM igs.igr_i_e_testtyps WHERE inquiry_type_id = :p_inquiry_type_id ORDER BY admission_test_type;

Another typical pattern is to validate or audit configurations by checking for duplicate or inactive entries across inquiry types, using the unique indexes on ENT_TEST_TYPE_ID and INQUIRY_TYPE_ID as a basis for integrity checks.

Related Objects

Based on the provided metadata, the table's primary relationships are defined through its indexes and the INQUIRY_TYPE_ID column. The table itself does not reference other objects, but it is referenced by an object named IGR_I_E_TESTTYPS under the APPS schema. This is almost certainly a public synonym (APPS.IGR_I_E_TESTTYPS) that points to the IGS.IGR_I_E_TESTTYPS base table, providing a standard access point for EBS applications and custom code. Functionally, the INQUIRY_TYPE_ID column implies a foreign key relationship to a master table defining inquiry types, though that specific constraint is not detailed in the excerpt. This table is a key component in the data model supporting the inquiry and admissions testing workflow.