Search Results inq_test_id




Overview
Explore in AI Chat

Overview

The IGS_SS_INQ_TEST table is a core data structure within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Institutional Global Systems (IGS) product family. As documented in the ETRM, its primary role is to hold Self Service Staging Inquiry Test records. This table functions as a staging or transactional repository for standardized test score data, such as SAT or ACT scores, submitted by prospective students (inquiries) through self-service portals. The data is typically processed and validated before potential integration into the core student information system, supporting the admissions and recruitment lifecycle.

Key Information Stored

The table stores essential attributes for managing inquiry-related test scores. Key columns include:

  • INQ_TEST_ID: The unique primary key identifier for each test record.
  • INQ_PERSON_ID: A foreign key linking the test score to a specific inquiry person record in the IGS_SS_INQ_PERSON_ALL table.
  • ADMISSION_TEST_TYPE: A code classifying the test (e.g., 'SAT', 'ACT', 'TOEFL').
  • COMP_TEST_SCORE and TEST_DATE: The numerical score and the date the test was taken.
  • STATUS: Indicates the processing state of the test record.
  • TEST_SOURCE_ID: An identifier for the source system or batch from which the test data originated.
  • Standard WHO Columns (CREATED_BY, CREATION_DATE, etc.): For auditing and tracking record creation and modifications.
  • Standard Concurrent Program Columns (REQUEST_ID, PROGRAM_ID, etc.): For tracking records submitted or processed via concurrent requests.

Common Use Cases and Queries

This table is central to reporting on and processing incoming test scores from inquiries. Common operational scenarios include generating lists of recently submitted scores for counselor review, validating scores against admission criteria, and troubleshooting data integration issues from external sources like testing agencies. A fundamental query to retrieve all test data for a specific inquiry person would be: SELECT * FROM apps.IGS_SS_INQ_TEST WHERE INQ_PERSON_ID = :person_id ORDER BY TEST_DATE DESC; For reporting on test scores by type and status, a typical pattern is: SELECT ADMISSION_TEST_TYPE, STATUS, COUNT(*), AVG(COMP_TEST_SCORE) FROM apps.IGS_SS_INQ_TEST WHERE TEST_DATE > ADD_MONTHS(SYSDATE, -12) GROUP BY ADMISSION_TEST_TYPE, STATUS; The table's interface tablespace (APPS_TS_INTERFACE) designation further indicates its role in staging inbound data flows.

Related Objects

Based on the provided relationship data, IGS_SS_INQ_TEST has defined integration points within the IGS schema:

  • Parent Table (Foreign Key Reference): The INQ_PERSON_ID column is a foreign key referencing the IGS_SS_INQ_PERSON_ALL table. This enforces referential integrity, ensuring every test record is associated with a valid inquiry person.
  • Child Table (Referenced by Foreign Key): The table is referenced by the IGS_SS_INQ_TESTSEG table via its INQ_TEST_ID column. This suggests the existence of segmented or detailed test component data that links back to the primary test record stored in IGS_SS_INQ_TEST.
  • Primary Key: The table is defined with a primary key constraint named IGS_SS_INQ_TEST_PK on the INQ_TEST_ID column.
These relationships form a logical data model for managing comprehensive test information within the self-service inquiry process.