Search Results igs_ad_ps_apl_tst_rs

Overview

The table IGS_AD_PS_APL_TST_RS is a core data object within the Oracle E-Business Suite (EBS) Student System (IGS). Its primary function is to store standardized test results associated with student admission applications. This table is integral to the admissions process, enabling institutions to record, track, and evaluate applicant qualifications based on external examinations such as the SAT, ACT, GRE, or other institution-defined admission tests. It serves as a central repository linking an applicant's identity, their specific application, and the scores they have achieved, thereby supporting critical decision-making workflows for admissions committees.

Key Information Stored

The table's structure is defined by a composite primary key that uniquely identifies each test result record. The key columns are PERSON_ID, ADMISSION_APPL_NUMBER, NOMINATED_COURSE_CD, ADMISSION_TEST_TYPE, and ACHIEVED_DT. This design allows an applicant to have multiple test results for the same test type on different achievement dates within a single application. The ADMISSION_TEST_TYPE column is a critical foreign key that references the IGS_AD_TEST_TYPE table, ensuring data integrity for the types of tests recognized by the system. While the provided metadata does not list all columns, the core data stored includes the applicant's identifier, the application details, the specific test taken, and the date the result was achieved.

Common Use Cases and Queries

A primary use case is generating reports for admissions review, such as listing all applicants for a specific program along with their relevant test scores. This data is also used to validate if applicants meet minimum test score requirements for a nominated course. Common SQL queries involve joining this table with related applicant and personal information tables. For example, a query to retrieve an applicant's most recent SAT score for a given application might filter on ADMISSION_TEST_TYPE = 'SAT', order by ACHIEVED_DT descending, and join to IGS_PE_PERSON on PERSON_ID. Another typical pattern is aggregating data to report average test scores by department or program for incoming applicant pools.

Related Objects

The table IGS_AD_PS_APL_TST_RS maintains a strict relationship with other entities in the Student System through its defined keys. Its primary key ensures uniqueness within the context of an application. The documented foreign key relationship is:

• IGS_AD_TEST_TYPE: The column ADMISSION_TEST_TYPE in IGS_AD_PS_APL_TST_RS references the IGS_AD_TEST_TYPE table. This relationship validates that every test result recorded is for a test type that is pre-defined and maintained within the system, enforcing referential integrity.

While not explicitly listed in the provided excerpt, this table is logically and functionally dependent on core application tables such as IGS_AD_APPL (which stores the main application header identified by PERSON_ID and ADMISSION_APPL_NUMBER) and IGS_PE_PERSON (which stores the person's master record). Any integration or reporting involving admission test results will typically involve joins to these foundational tables.