Search Results igs_da_out_tst_sgmt

Overview

The table IGS_DA_OUT_TST_SGMT is a core data object within the Oracle E-Business Suite Student System (IGS) module. It functions as a detailed repository for degree audit processing, specifically storing granular information about individual test segments. Its primary role is to capture and persist the outgoing results for each test segment identified for a student during a degree audit request execution. This table is integral to the audit engine's output, enabling the system to report on specific components of standardized tests (like SAT, ACT, or subject tests) that are evaluated as part of a student's academic progress toward a degree.

Key Information Stored

The table's structure is designed to uniquely identify a test segment within the context of a specific audit request and student. Its primary key is a composite of four columns, ensuring each record is distinct. The critical columns include BATCH_ID and PERSON_ID, which link the segment to a specific audit run and student. The TEST_SEQ_NUM identifies the specific test within the audit, and TEST_SEGMT_NAME identifies the individual segment of that test (e.g., "Mathematics," "Critical Reading"). While the provided metadata focuses on the key structure, typical columns in such a table would also store the segment score, a possible minimum or maximum score, and the date the segment was taken, forming a complete profile of the test component's contribution to the audit.

Common Use Cases and Queries

This table is central to generating detailed degree audit reports and troubleshooting audit outcomes. A common use case involves querying all test segment details for a particular student's audit to provide a comprehensive breakdown of how external test credits were applied. For system support, analysts may query this table to verify that all expected test data was processed correctly by the audit engine. A typical reporting query would join to the parent test table to retrieve high-level test information alongside segment details.

• Sample SQL: Retrieving all test segments for a specific audit batch and person.

  SELECT tst_sgmt.*
  FROM igs.igs_da_out_tst_sgmt tst_sgmt
  WHERE tst_sgmt.batch_id = :p_batch_id
  AND tst_sgmt.person_id = :p_person_id
  ORDER BY tst_sgmt.test_seq_num;

Related Objects

IGS_DA_OUT_TST_SGMT has a direct and dependent relationship with the parent test summary table, as defined by its foreign key constraints. It is a child table that provides detailed data for records in the parent.

• IGS_DA_OUT_TSTS: This is the primary related table. IGS_DA_OUT_TST_SGMT references it via a foreign key on the composite columns (BATCH_ID, PERSON_ID, TEST_SEQ_NUM). This relationship ensures that every test segment record is associated with a valid, higher-level test record from the degree audit. A query joining these tables would link segment details (from IGS_DA_OUT_TST_SGMT) to the overall test information (from IGS_DA_OUT_TSTS).