Search Results igs_ss_inq_test_pk

Overview

The table IGS_SS_INQ_TEST is a historical data object within the Oracle E-Business Suite, specifically belonging to the now-obsolete IGS (Student System) module. Its primary function was to serve as a staging table within the Self Service architecture, holding inquiry test records. These records were likely part of a process for capturing and temporarily storing standardized test score information (such as SAT, ACT, or other entrance exams) submitted by prospective students via a self-service portal before formal validation and processing into the core student information system. As explicitly noted in the ETRM documentation, this table is marked as obsolete and, in the specific database instance referenced, was not implemented. Its presence in the data dictionary is for reference regarding legacy system design.

Key Information Stored

While the full column list is not provided in the metadata, the documented primary and foreign keys reveal the core structural elements. The central column is INQ_TEST_ID, which served as the unique primary identifier for each staged test record. Another critical column is INQ_PERSON_ID, a foreign key that linked the test record to a specific prospective student's master inquiry record in the IGS_SS_INQ_PERSON_ALL table. This relationship ensured that all test scores were associated with the correct individual within the staging environment. Other columns, not detailed here, would have typically stored data points like test type, date, scores for various sections, and a status flag indicating the processing stage.

Common Use Cases and Queries

As a staging table in an obsolete module, direct operational use cases are no longer applicable. However, historically, its purpose was to support data intake and validation workflows. Common activities would have included querying for unprocessed test records for a batch operation or reconciling submitted scores with person data. A typical reporting query might have joined to the person table to list all pending scores.

SELECT it.inq_test_id, ip.inquiry_person_number, it.test_type, it.test_date
FROM igs_ss_inq_test it,
     igs_ss_inq_person_all ip
WHERE it.inq_person_id = ip.inq_person_id
AND it.process_status = 'PENDING';

Data from this table would ultimately have been migrated or used to update permanent academic records via a concurrent program, after which the staging records might have been purged or archived.

Related Objects

The ETRM documentation specifies clear foreign key relationships for this table, defining its position in the obsolete data model.

• Referenced Parent Table: The table IGS_SS_INQ_TEST references IGS_SS_INQ_PERSON_ALL via the foreign key column INQ_PERSON_ID. This establishes that every test record must belong to an existing inquiry person record.
• Referencing Child Table: The table IGS_SS_INQ_TESTSEG references IGS_SS_INQ_TEST via the foreign key column INQ_TEST_ID. This indicates a one-to-many relationship where a single test header record in IGS_SS_INQ_TEST could have multiple detailed segments (e.g., for individual sub-scores or components) stored in the IGS_SS_INQ_TESTSEG table.

The primary key constraint IGS_SS_INQ_TEST_PK on the INQ_TEST_ID column enforced uniqueness for all records in this table.