Search Results igs_ad_tst_rslt_dtls




Overview
Explore in AI Chat

Overview

The IGS_AD_TST_RSLT_DTLS table is a core data structure within the Oracle E-Business Suite (EBS) Student System (IGS), specifically designed for managing admissions-related data. As its name and description indicate, its primary role is to store granular test result details. This table functions as a child entity, holding specific component scores or segment results that roll up into a broader test result record. It is critical for institutions that require detailed breakdowns of standardized test performances, such as individual section scores from multi-part examinations. It is important to note that the provided ETRM metadata explicitly labels the IGS Student System as "Obsolete," indicating this table belongs to a legacy module. Furthermore, the documentation states it was "Not implemented in this database," suggesting it may not be present in all EBS 12.1.1 or 12.2.2 deployments, or that its implementation was contingent on specific configuration choices.

Key Information Stored

The table's primary key is TST_RSLT_DTLS_ID, a unique identifier for each test result detail record. The central data points stored revolve around linking a detail record to its parent test result and a specific test segment, and capturing the associated score or grade. Based on standard patterns and the foreign key relationships documented, the table likely contains columns such as TEST_RESULTS_ID (linking to IGS_AD_TEST_RESULTS), TEST_SEGMENT_ID (linking to IGS_AD_TEST_SEGMENTS), and a field for the actual result value (e.g., SCORE, GRADE, PERCENTILE). A critical column is IRREGULARITY_CODE_ID, which links to the IGS_AD_CODE_CLASSES table. This allows the system to flag a specific test detail with a coded reason for an anomalous or irregular result, such as a testing irregularity or an accommodated exam.

Common Use Cases and Queries

The primary use case is detailed reporting and analysis of applicant test performances. Admissions officers might query this table to analyze performance trends on specific test segments (e.g., verbal vs. quantitative scores) across applicant pools or to identify applicants with exceptional scores in a particular area. Another key operational use is managing irregular results; queries can be built to list all result details flagged with a specific irregularity code for review. A typical reporting query would join the detail table to its parent and segment tables to produce a comprehensive score breakdown.

SELECT  iatrd.score,
        iats.segment_name,
        iatr.test_type,
        iatr.person_id
FROM    igs_ad_tst_rslt_dtls iatrd,
        igs_ad_test_results iatr,
        igs_ad_test_segments iats
WHERE   iatrd.test_results_id = iatr.test_results_id
AND     iatrd.test_segment_id = iats.test_segment_id
AND     iatr.person_id = :p_person_id;

Related Objects

The IGS_AD_TST_RSLT_DTLS table is centrally connected to several other entities in the Admissions module, as defined by its foreign key constraints:

  • Parent Table: IGS_AD_TEST_RESULTS via TEST_RESULTS_ID. Every detail record must belong to a master test result.
  • Reference Table: IGS_AD_TEST_SEGMENTS via TEST_SEGMENT_ID. This defines which portion of a test the detail record pertains to.
  • Code Reference: IGS_AD_CODE_CLASSES via IRREGULARITY_CODE_ID. This provides a standardized list of codes to classify irregularities.
  • Child Tables (Referencing IGS_AD_TST_RSLT_DTLS):
    • IGS_AV_STND_UNIT_LVL_ALL uses TST_RSLT_DTLS_ID as a foreign key, linking test details to standardized unit levels.
    • IGS_AV_STND_UNIT_ALL also uses TST_RSLT_DTLS_ID, linking details to standardized units for advanced standing or credit transfer evaluations.