Search Results segment_group




Overview
Explore in AI Chat

Overview

IGS_AD_TEST_SEGMENTS_V is a reporting view within the Oracle E-Business Suite Student System (IGS) product family. The IGS module is classified as obsolete in ETRM 12.2.2, and the metadata explicitly records that this view is "Not implemented in this database," meaning it may not exist in all environments and is retained primarily for historical and documentation continuity. The view exposes the segment-level definition of admission tests used by higher-education institutions, presenting data that describes how a test (for example, SAT or ACT) is subdivided into scored components and how those components contribute to composite scoring, percentile reporting, and score banding. Because it is a view rather than a table, it is intended for read-only reporting and integration; it carries the standard Oracle who-columns and is not a maintenance interface.

For the searching user, "segment_type" corresponds directly to the SEGMENT_TYPE column documented in the view's SELECT text, indicating their interest is most likely in the classification of test segments.

Underlying Base Objects

The metadata documents no formal base objects, but the view text shows a single underlying source: the base table IGS_AD_TEST_SEGMENTS, aliased TS. The view is a straight projection over that table with no joins, aggregates, or filters. The only derived element is ROW_ID, populated from TS.ROWID, which provides a stable physical row identifier for the underlying record. All remaining columns map one-to-one in name and order to the base table's columns, so the view is effectively a column-consistent presentation layer over IGS_AD_TEST_SEGMENTS rather than a normalized abstraction.

Key Columns

Common Use Cases and Queries

The principal use cases are validation and configuration reporting: enumerating segments for a test type, identifying which segments feed composite scoring, and reporting closing status. Because the view is a direct projection, filters on SEGMENT_TYPE are functionally equivalent to filtering the base table.

Segment inventory by admission test:

SELECT TEST_SEGMENT_ID,
       TEST_SEGMENT_NAME,
       SEGMENT_TYPE,
       SEGMENT_GROUP,
       MIN_SCORE,
       MAX_SCORE
  FROM IGS_AD_TEST_SEGMENTS_V
 WHERE ADMISSION_TEST_TYPE = :p_test_type
   AND NVL(CLOSED_IND, 'N') = 'N'
 ORDER BY SEGMENT_GROUP, TEST_SEGMENT_NAME;

Isolating segments by type — the query matching the user's "segment_type" interest — and reporting composite-score participation:

SELECT TEST_SEGMENT_NAME,
       ADMISSION_TEST_TYPE,
       INCLUDE_IN_COMP_SCORE,
       SCORE_IND,
       PERCENTILE_IND
  FROM IGS_AD_TEST_SEGMENTS_V
 WHERE SEGMENT_TYPE = :p_segment_type
 ORDER BY ADMISSION_TEST_TYPE, TEST_SEGMENT_NAME;

Audit or refresh monitoring can use LAST_UPDATE_DATE against a cutoff to identify recently maintained definitions.