Search Results act_statistic_category




Overview
Explore in AI Chat

Overview

IGSFV_AD_ACT_STATS_TEST is a read-only Oracle EBS view in the APPS schema that exposes ACT (American College Testing) admission test statistics recorded against person records in the Oracle Student System / Recruiting and Admissions module. The view is defined with the WITH READ ONLY clause, meaning it is intended strictly for query, reporting, and integration consumption rather than for DML. Its role is to flatten the ACT test statistics stored on the base entity IGS_AD_ACT_STATISTICS into a person-centric, denormalized result set suitable for reporting on standardized admission test performance.

The view name suggests it is a "test" or development-phase variant of the production ACT statistics view (the _TEST suffix). The user search term act_statistic_category is directly relevant: the view joins the ACT_STATISTIC_CATEGORY lookup type to resolve the meaning and description of each statistic category, making the coded category values human-readable in reports.

Underlying Base Objects

The documented view text references two base tables:

  • IGS_AD_ACT_STATISTICS (alias ACTST) — the primary fact table holding ACT test statistics. The view filters this table to rows where STATISTIC_TYPE = 'TEST'.
  • IGS_PE_ALT_PERS_ID (alias PEA) — the alternate person identifier table, joined with an outer join ((+)) on person identifier type 'ACTID' to resolve the ACT identifier back to the internal PE_PERSON_ID.

Two additional tables appear inside a scalar subquery used to derive SEGMENT_GROUP: IGS_LOOKUP_VALUES (alias LKP) and IGS_AD_TEST_SEGMENTS (alias TSG). These are correlated within the SELECT list rather than joined at the top level. The ETRM metadata lists no separately documented "referenced base objects," so the base object relationships are inferred from the embedded view SQL.

Key Columns

  • PERSON_IDENTIFIER — the internal PE_PERSON_ID of the person the statistic belongs to.
  • SEGMENT_GROUP — derived via the correlated subquery, mapping the statistic category and test type to a test segment group.
  • REPORTING_YEAR, ACT_IDENTIFIER, TEST_TYPE, TEST_DATE_TXT — identifying context for each ACT test record. TEST_TYPE values decode to labels such as ACT-DANTES, ACT-INTERNATIONAL, ACT-INSTITUTION, ACT-RESIDUAL, ACT-STATE, ACT-ARRANGED, and ACT-NATIONAL.
  • STATISTIC_CATEGORY_CODE — the raw lookup code stored on the base table.
  • _LA:STATISTIC_CATEGORY / _LA:STATISTIC_CATEGORY_DESC — flexfield-style descriptive columns that resolve the category code to its MEANING and DESCRIPTION via the ACT_STATISTIC_CATEGORY lookup type, directly serving the act_statistic_category search intent.
  • SCORE, NATIONAL_NORM, DESCRIPTION — the measured ACT score, the corresponding national norm, and free-text remarks.
  • CREATED_BY / CREATION_DATE / LAST_UPDATED_BY / LAST_UPDATE_DATE — standard audit columns carried from the base table.

Common Use Cases and Queries

This view is typically used for admission reporting on ACT scores, especially when the statistic category must be presented by its descriptive meaning. A representative query retrieving test statistics for a person follows:

  • SELECT person_identifier, reporting_year, test_type, statistic_category_code, "_LA:STATISTIC_CATEGORY", score, national_norm FROM apps.igsfv_ad_act_stats_test WHERE statistic_category_code = '&category';
  • Filter on reporting_year and test_type to produce year-by-year ACT trend reports per applicant.
  • Join to PER_ALL_PEOPLE_F on person_identifier to enrich results with student name and biographical detail.
  • Because the view is read-only, use it for extraction into reporting schemas or BI Publisher data templates rather than as a DML target.

The _TEST suffix warrants verification against the corresponding production view before relying on it for live reporting in a 12.1.1 or 12.2.2 environment.