Search Results igs_ad_test_results_pk

Overview

The IGS_AD_TEST_RESULTS table is a core data structure within the Oracle E-Business Suite Student System (IGS) module. It serves as the primary repository for storing admission test results associated with prospective students or applicants. This table is integral to the admissions process, enabling institutions to record, track, and evaluate standardized test scores and other assessment outcomes that form a critical component of application reviews. Its role is to maintain a master record of all test submissions linked to individuals within the system.

Key Information Stored

While the full column list is not provided in the metadata, the documented foreign key relationships indicate the table's essential data components. The primary key is the TEST_RESULTS_ID column, which uniquely identifies each test result record. Crucially, the table stores a link to the individual via the PERSON_ID column, which references HZ_PARTIES. It categorizes the type of test taken through the ADMISSION_TEST_TYPE column, linked to IGS_AD_TEST_TYPE. Furthermore, it holds references to classified codes for important attributes: EDU_LEVEL_ID for the educational level, GRADE_ID for the result grade, and SCORE_SOURCE_ID for the origin of the score, all referencing the IGS_AD_CODE_CLASSES table.

Common Use Cases and Queries

A primary use case is generating applicant evaluation reports by joining test results with person and application data. Admissions officers may query this table to list all test scores for a specific applicant or to find applicants who have achieved scores above a certain threshold for a particular test type. Common SQL patterns include selecting results for a specific person or for a cohort based on application term. For example, a query might join IGS_AD_TEST_RESULTS with HZ_PARTIES on PERSON_ID and with IGS_AD_TEST_TYPE on ADMISSION_TEST_TYPE to produce a readable list of applicant names, test names, and scores. The table is also a key source for data loads from external testing agencies and for integration with student portals where applicants can view their submitted credentials.

Related Objects

The table maintains defined relationships with several other EBS objects, primarily through foreign key constraints:

• Primary Key: IGS_AD_TEST_RESULTS_PK on TEST_RESULTS_ID.
• Foreign Key References (Parent Tables):
  • IGS_AD_CODE_CLASSES (linked via EDU_LEVEL_ID, GRADE_ID, and SCORE_SOURCE_ID)
  • IGS_AD_TEST_TYPE (linked via ADMISSION_TEST_TYPE)
  • HZ_PARTIES (linked via PERSON_ID)
• Child Table (Referenced by):
  • IGS_AD_TST_RSLT_DTLS (linked via TEST_RESULTS_ID). This suggests the existence of a detail table holding supplementary information for each main test result record.