Search Results test_segment

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.

• IGS_AD_TST_RSLT_DTLS is joined with an outer join ((+)) on TEST_RESULTS_ID, supplying segment-level scores by TEST_SEGMENT_ID.
• IGS_AD_TEST_SEGMENTS is outer-joined on TEST_SEGMENT_ID, providing SEGMENT_TYPE and SEGMENT_GROUP.
• IGS_LOOKUP_VALUES is outer-joined on SCORE_TYPE against LOOKUP_CODE where LOOKUP_TYPE = 'TEST_SCORE_TYPE', yielding SCORE_TYPE_MEANING.
• SCORE_SOURCE is resolved via an inline scalar subquery against IGS_AD_CODE_CLASSES for CLASS = 'SYS_SCORE_SOURCE', and TEST_SEGMENT via a subquery on IGS_AD_TEST_SEGMENTS.

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

• ROW_ID — row identifier from the test results table.
• TEST_RESULTS_ID — primary identifier of the test result record.
• PERSON_ID — the student or applicant to whom the score belongs.
• TEST_TYPE — the admission test type.
• TEST_DATE — date the test was taken.
• SCORE_SOURCE — descriptive name of the score source, decoded from SCORE_SOURCE_ID.
• SCORE_TYPE / SCORE_TYPE_MEANING — coded score type and its lookup meaning.
• TEST_SEGMENT, SEGMENT_TYPE, SEGMENT_GROUP — test segment description and classification.
• SEGMENT_SCORE — segment-level test score.
• COMBINED_SCORE — composite score at the test result level.
• ACTIVE_IND and the WHO audit columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN).

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.