Search Results igs_ad_test_segments_v

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

• ROW_ID — The ROWID of the base table row.
• TEST_SEGMENT_ID — Primary identifier for the test segment definition.
• ADMISSION_TEST_TYPE — The admission test to which the segment belongs.
• TEST_SEGMENT_NAME and DESCRIPTION — The segment's label and descriptive text.
• SEGMENT_TYPE — The classification of the segment, distinguishing the kind of scored component being defined. This is the column of interest to users searching on "segment_type."
• SEGMENT_GROUP — The grouping to which the segment is assigned.
• MIN_SCORE and MAX_SCORE — The valid scoring range for the segment.
• INCLUDE_IN_COMP_SCORE — Indicates whether the segment contributes to a composite score.
• SCORE_IND, PERCENTILE_IND, NATIONAL_PERCENTILE_IND, STATE_PERCENTILE_IND, PERCENTILE_YEAR_RANK_IND — Reporting flags controlling whether score and various percentile measures apply.
• SCORE_BAND_UPPER_IND and SCORE_BAND_LOWER_IND — Indicators for upper and lower score band reporting.
• IRREGULARITY_CODE_IND — Indicates whether an irregularity code applies to the segment.
• CLOSED_IND — Marks whether the segment definition is closed to new use.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard audit 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.