Search Results igr_is_test_pk

Overview

The IGR_IS_TEST table is a data object within the Oracle E-Business Suite (EBS) release 12.1.1 and 12.2.2. It belongs to the IGS (Student System) product family, which is documented as obsolete. The table's core function is to serve as a staging repository for "Inquiry Test" records within a self-service architecture. Specifically, it holds data related to standardized tests (such as SAT, ACT, or other entrance exams) submitted by prospective students or applicants via a self-service portal before the data is formally processed and integrated into the primary student information system. Its role is to temporarily store and manage this inbound test information during the inquiry or application lifecycle.

Key Information Stored

Based on the provided metadata, the table's structure centers on a unique identifier for each test record and a link to the individual who submitted it. The primary key column, INQ_TEST_ID, uniquely identifies each staged test record. A critical foreign key column, INQ_PERSON_ID, references the IGR_IS_PER_ALL table, thereby linking the test data to a specific person or inquiry record within the staging environment. While the full column list is not provided, typical data in such a table would include test type, scores, test date, reporting agency, and the date the record was staged.

Common Use Cases and Queries

The primary use case involves managing prospective student data captured online. Administrators would query this table to review, validate, and process incoming test scores before formal admission evaluation. A common reporting need would be to list all pending test records for a specific person or within a date range. Sample SQL patterns include joining to the person staging table for demographic details:

• SELECT t.INQ_TEST_ID, p.LAST_NAME, t.TEST_TYPE, t.SCORE FROM IGR_IS_TEST t, IGR_IS_PER_ALL p WHERE t.INQ_PERSON_ID = p.INQ_PERSON_ID AND t.CREATION_DATE > SYSDATE - 30;
• Data validation queries to find test records not yet associated with a formal application.
• Cleanup operations to purge very old staged records that were never processed.

Related Objects

The IGR_IS_TEST table exists within a defined relationship hierarchy in the staging schema, as per the documented foreign keys.

• Referenced Parent Table: IGR_IS_TEST.INQ_PERSON_ID → IGR_IS_PER_ALL. This relationship ties each test record to a staged person/inquiry record.
• Referencing Child Table: IGR_IS_TESTSEG.INQ_TEST_ID → IGR_IS_TEST.INQ_TEST_ID. The IGR_IS_TESTSEG table holds segmented or additional detail data for a given test record, forming a parent-child link where IGR_IS_TEST is the parent.

The primary key constraint IGR_IS_TEST_PK on INQ_TEST_ID enforces uniqueness for these relationships. The metadata explicitly states this table is "Not implemented in this database," indicating it may be a reference definition not deployed in all instances.