Search Results igsbv_ad_act_stats_subscore




Overview
Explore in AI Chat

Overview

The IGSBV_AD_ACT_STATS_SUBSCORE view is a read-only reporting object owned by the APPS schema within the Oracle E-Business Suite Student System (IGS) product family. It presents ACT statistical test components and their associated category details for records classified as sub-test scores, filtering the underlying statistics table to entries where STATISTIC_TYPE = 'TEST_SUB_SCORE'. In the context of Oracle EBS 12.1.1 and 12.2.2, the view functions as a denormalized, presentation-ready layer over the admissions test statistics data model, allowing institutions to report on ACT sub-scores alongside applicant identity, test segment grouping, and normative reference values.

The view is defined WITH READ ONLY, confirming that it is intended purely for query, reporting, and integration consumption rather than data maintenance. It is particularly relevant to users searching for the NATIONAL_NORM element, which appears as a first-class column in the view and exposes the national normative reference for each ACT sub-score record.

Underlying Base Objects

Although the ETRM metadata lists no separately documented referenced base objects, the view text identifies its two driving source tables explicitly:

The join to IGS_PE_ALT_PERS_ID applies a DECODE(SUBSTR(...)) transformation that strips a leading hyphen from the ACT identifier before matching, ensuring identifiers prefixed with '-' resolve correctly.

Key Columns

Common Use Cases and Queries

Typical applications include ACT sub-score reporting, comparison of applicant performance against national and local norms, and integration feeds into analytics platforms. A representative query retrieving national norm context follows:

  • SELECT person_identifier, act_identifier, statistic_category_code, score, national_norm, local_norm FROM igsbv_ad_act_stats_subscore WHERE reporting_year = :year AND test_type = 'N'; — returns national ACT sub-scores with their national norms.
  • SELECT segment_group, statistic_category_code, AVG(national_norm), AVG(score) FROM igsbv_ad_act_stats_subscore GROUP BY segment_group, statistic_category_code; — aggregates scores against national norms by segment.
  • Filtering on _LA:STATISTIC_CATEGORY_DESC supports user-facing descriptive reporting.

The view's read-only nature and lookup-driven translations make it suitable for both direct SQL reporting and embedded use within concurrent programs or BI Publisher data templates.