Search Results igsfv_ad_act_stats_test




Overview
Explore in AI Chat

Overview

IGSFV_AD_ACT_STATS_TEST is a read-only Oracle EBS view belonging to the IGS (Student System) product family, which is documented as obsolete in ETRM for releases 12.1.1 and 12.2.2. The view exposes ACT (American College Testing) statistical test components together with their associated statistical category details, restricted to records whose statistic type is "Test". It is intended for institutional reporting and downstream integration where a flattened, display-ready representation of ACT test scores, norms, and category descriptions is required without directly joining the numerous base tables.

The view is explicitly declared WITH READ ONLY, so consumers must treat it purely as a query surface. The ETRM documentation further notes that the object is "Not implemented in this database," meaning its presence depends on whether the IGS Student System module has been installed and configured for ACT statistical processing. In practice it surfaces as part of legacy student-records reporting rather than as a supported integration interface.

Underlying Base Objects

The view text references the following base objects:

The IGS_AD_TEST_SEGMENTS object is the direct source of the SEGMENT_GROUP attribute that the user query targeted, linking each statistic category to a test segment based on the decoded ACT test type (DANTES, INTERNATIONAL, INSTITUTION, RESIDUAL, STATE, ARRANGED, or NATIONAL).

Key Columns

Common Use Cases and Queries

Typical usage includes extracting ACT test statistics for a reporting year, verifying segment group assignment against admission test types, and feeding data extracts for institutional research. A representative query isolating the segment group is:

  • SELECT person_identifier, segment_group, reporting_year, test_type, score FROM igsfv_ad_act_stats_test WHERE reporting_year = :year;
  • SELECT segment_group, COUNT(*) FROM igsfv_ad_act_stats_test GROUP BY segment_group;
  • SELECT act_identifier, statistic_category_code, _LA:STATISTIC_CATEGORY_DESC, national_norm FROM igsfv_ad_act_stats_test WHERE test_type = 'N';

Because the view is read-only and legacy, queries should be restricted to installations where the IGS Student System is present; otherwise the object will not resolve.