Search Results igsfv_ad_act_stats_highsch




Overview
Explore in AI Chat

Overview

IGSFV_AD_ACT_STATS_HIGHSCH is a read-only Oracle EBS view owned by the APPS schema within the IGS (Student System) product. It exposes ACT statistical test component and category details for records whose statistic type is classified as High School. The view is designed for institutions that load ACT assessment data into Oracle Student System and need to report on high school-level statistical components, grade outcomes, and course status alongside the person identifier returned by ACT.

As a reporting and integration object, the view flattens the ACT statistics data into a set of columns that are directly usable in concurrent programs, BI Publisher reports, OBIEE/OTBI style extracts, and custom PL/SQL. It also carries the standard Oracle Forms multi-language "_LA:" pseudocolumns so that statistics category codes can be automatically translated to their meaningful lookup descriptions.

Underlying Base Objects

The view is defined over two objects in the APPS schema:

  • IGS_AD_ACT_STATISTICS ACTST — the primary table holding ACT statistical test components, reporting year, test type and date, statistic category, numeric grade, course status, grade earned, and audit columns.
  • IGS_PE_ALT_PERS_ID PEA — an outer-joined alternate person identifier table used to resolve the ACT identifier to a person.

The join is an outer join (the (+) operator on PEA), and the join condition uses a DECODE to strip a leading hyphen from ACT_IDENTIFIER before matching it against PEA.API_PERSON_ID. Only rows where STATISTIC_TYPE equals 'HIGH_SCHOOL' are returned, and the view is created WITH READ ONLY, so it cannot be used for DML.

Key Columns

Common Use Cases and Queries

Typical scenarios include validating ACT high school grade loads, feeding downstream analytics, and pre-admission review. A representative query follows:

  • Retrieve grade earned by identifier: SELECT person_identifier, reporting_year, act_identifier, grade_earned, numeric_grade FROM igsfv_ad_act_stats_highsch WHERE act_identifier = :id;
  • Report all grades for a reporting year: SELECT reporting_year, statistic_category_code, grade_earned FROM igsfv_ad_act_stats_highsch WHERE reporting_year = :yr;
  • Exclude blanks: SELECT * FROM igsfv_ad_act_stats_highsch WHERE grade_earned IS NOT NULL;

Because the view returns only high school type statistics, queries should target this view rather than the base statistics table when high school filtering is required.