Search Results igs_ad_test_scores_v




Overview
Explore in AI Chat

Overview

The view IGS_AD_TEST_SCORES_V belongs to the IGS — Student System product family within Oracle E-Business Suite, a module that is now flagged as obsolete in Oracle's ETRM documentation. It is a reporting and integration construct designed to expose detailed admissions test score information for students and applicants held in the Student System. The view consolidates identity, test-scheduling, scoring, and lookup-derived descriptive attributes into a single denormalized result set that is convenient for downstream reporting, interfaces, and inquiry screens.

The view's purpose is to present, for each test result and each associated test segment, the score achieved together with the descriptive meaning of the various coded values. Rather than requiring the consumer to join fact tables against code classes, test segments, and lookup values manually, the view performs those resolutions internally through scalar subqueries and outer joins. This makes the object well suited to ad hoc queries, concurrent-program extracts, and integration feeds that need readable test score data rather than raw identifiers.

The user's search term "score_source" directly maps to the SCORE_SOURCE column exposed by this view, one of its most semantically important attributes.

Underlying Base Objects

The view is defined over four base objects: IGS_AD_TEST_RESULTS (aliased ATT), IGS_AD_TST_RSLT_DTLS (aliased ATR), IGS_AD_TEST_SEGMENTS (aliased ATS), and IGS_LOOKUP_VALUES (aliased L1). The primary driving table is IGS_AD_TEST_RESULTS, which supplies the applicant header-level test information, including the person, test type, test date, combined score, active indicator, and standard WHO columns.

ETRM records no documented base objects and notes the view as "Not implemented in this database," consistent with the obsolescence of the IGS module.

Key Columns

Common Use Cases and Queries

Typical uses include applicant scoring reports, admissions dashboards, and extracts filtered by score source or score type.

SELECT person_id, test_type, test_date,
       score_source, score_type_meaning,
       test_segment, segment_score, combined_score
  FROM igs_ad_test_scores_v
 WHERE score_source = '&score_source'
   AND active_ind = 'Y';

Segment-level analysis can aggregate scores per segment group, while combined scores support ranking and cut-off evaluation.

SELECT person_id, test_type, MAX(combined_score) combined_score
  FROM igs_ad_test_scores_v
 GROUP BY person_id, test_type;

Because the object is obsolete and not implemented in current databases, these queries are primarily relevant for legacy 12.1.1 / 12.2.2 environments retaining historical IGS data.