Search Results numeric_grade




Overview
Explore in AI Chat

Overview

APPS.IGSFV_AD_ACT_STATS_HIGHSCH is a read-only Oracle EBS view that exposes high school admissions test statistics maintained in the Admissions module of Oracle Student System (the IGS product family). The view is a filtered presentation of the IGS_AD_ACT_STATISTICS table, restricted to rows where STATISTIC_TYPE equals 'HIGH_SCHOOL'. It consolidates admissions test data — reporting year, ACT/test identifier, test type, test date, statistic category, and both numeric and earned grades — into a single reporting surface suitable for admissions evaluation, prospect tracking, and integration extracts.

The "V" in the view name (IGSFV) and the WITH READ ONLY clause confirm that this object is intended strictly for query and reporting. It is not a maintenance surface; data must be inserted or updated through the underlying admissions tables or their APIs. Because the view joins person-identity data, it supports linkage of test statistics to a person record, making it useful for student/prospect reporting and downstream integration.

Underlying Base Objects

Although the ETRM metadata lists no documented base objects, the view text reveals its two source tables:

  • IGS_AD_ACT_STATISTICS (alias ACTST) — the primary admissions statistics table, filtered on ACTST.STATISTIC_TYPE = 'HIGH_SCHOOL'.
  • IGS_PE_ALT_PERS_ID (alias PEA) — the alternate person identifier table, joined via an outer join (PEA.API_PERSON_ID(+) = ...) restricted to PEA.PERSON_ID_TYPE(+) = 'ACTID'.

The join matches the test identifier (ACT_IDENTIFIER) against the alternate person identifier, after stripping a leading hyphen via DECODE(SUBSTR(...),'-',SUBSTR(...,2),...). Because it is an outer join, statistics rows without a matching ACTID identifier are retained with a NULL PERSON_IDENTIFIER. No other base objects are documented; derived columns such as _LA: attributes are lookup references resolved by the application layer rather than additional tables.

Key Columns

Common Use Cases and Queries

Typical uses include admissions score review, prospect population analysis by reporting year, and extracts that must reconcile numeric grades against earned grades. A representative query retrieving numeric grades for a given person:

SELECT person_identifier,
       reporting_year,
       act_identifier,
       statistic_category_code,
       numeric_grade,
       grade_earned
FROM   apps.igsfv_ad_act_stats_highsch
WHERE  numeric_grade IS NOT NULL
ORDER  BY reporting_year, act_identifier;

Analysts frequently aggregate statistics by reporting year or filter by the resolved lookup meaning via the _LA columns. Because the object is read-only, all such queries are safe for concurrent reporting and integration consumption.