Search Results igs_ad_test_type_pk

Overview

The IGS_AD_TEST_TYPE table is a core reference table within the Oracle E-Business Suite Student System (IGS) module. It functions as the master repository for defining and managing the types of standardized admission tests that an institution recognizes during its student recruitment and application processes. This table is critical for maintaining data integrity across the admissions lifecycle, as it provides the valid list of test types, such as SAT, ACT, GRE, or GMAT, against which all related applicant test scores and configurations are validated. Its role is foundational, ensuring consistency in how test information is captured, reported, and utilized for admission decision-making in both Oracle EBS 12.1.1 and 12.2.2.

Key Information Stored

While the provided metadata does not list specific columns beyond the primary key, the table's description and relationships indicate its core structure. The central column is ADMISSION_TEST_TYPE, which serves as the unique identifier (primary key) for each test type. This column typically stores a short code representing the examination. Based on standard practice for such reference tables, it is highly probable the table also contains descriptive columns, such as a full name or description (e.g., TEST_DESCRIPTION), and control columns for enabling/disabling records (e.g., CLOSED_IND). The integrity of the ADMISSION_TEST_TYPE code is enforced by a primary key constraint (IGS_AD_TEST_TYPE_PK), making it the anchor point for all related transactional data.

Common Use Cases and Queries

This table is primarily used in two contexts: system setup and operational reporting. Administrators use it to configure the suite of tests accepted by the institution. For reporting and data validation, common SQL patterns involve joining this table to transactional tables to retrieve meaningful descriptions for test codes. A fundamental query to list all active test types would be: SELECT admission_test_type, description FROM igs_ad_test_type WHERE closed_ind = 'N' ORDER BY 1;. A more complex, typical reporting use case involves retrieving applicant test results with their descriptions: SELECT a.person_id, a.admission_test_type, t.description, a.test_score FROM igs_ad_test_results a, igs_ad_test_type t WHERE a.admission_test_type = t.admission_test_type;. This table is also essential for validating data entry in any interface or API that processes admission test information.

Related Objects

The IGS_AD_TEST_TYPE table is referenced by numerous transactional and configuration tables through foreign key relationships, as documented in the metadata. These relationships demonstrate its central role in the admissions schema:

• IGS_AD_SS_TEST_CONF: Links via ADMISSION_TEST_TYPE to configure test-specific setup for self-service applications.
• IGS_AD_PS_APL_TST_RS: Links via ADMISSION_TEST_TYPE to store test results associated with a person's application.
• IGS_AD_TEST_RESULTS: Links via ADMISSION_TEST_TYPE to store detailed test result records for applicants.
• IGS_AD_ENT_TEST_TYPS: Links via ADMISSION_TEST_TYPE to define which test types are valid for specific admission entry periods (terms).
• IGR_I_E_TESTTYPS: Links via ADMISSION_TEST_TYPE within the IGR (Institutional Research) module for test type reporting.
• IGS_RC_I_E_TESTTYPS: Links via ADMISSION_TEST_TYPE within the IGS Recruitment module for test type reporting.

All foreign keys reference the primary key column ADMISSION_TEST_TYPE, ensuring referential integrity across the student system.