Search Results test_sub_score

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:

• IGS_AD_ACT_STATISTICS (aliased ACTST) — the primary fact table holding ACT statistical records, including reporting year, test type, statistic category, score, and normative values.
• IGS_PE_ALT_PERS_ID (aliased PEA) — the alternate person identifier table, outer-joined ((+)) on API_PERSON_ID = PERSON_ID_TYPE 'ACTID', used to resolve the ACT identifier back to a person.
• IGS_LOOKUP_VALUES and IGS_AD_TEST_SEGMENTS — referenced through a scalar subquery to derive the SEGMENT_GROUP by matching lookup meanings against test segment names, conditioned on ADMISSION_TEST_TYPE per decoded test type.

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

• PERSON_IDENTIFIER — the person ID derived from the alternate person identifier join.
• SEGMENT_GROUP — the ACT test segment group, resolved via the lookup/test-segment subquery.
• REPORTING_YEAR, ACT_IDENTIFIER, TEST_TYPE — reporting period and test classification; test type is decoded across values such as ACT-NATIONAL, ACT-STATE, ACT-RESIDUAL, and others.
• TEST_DATE_TXT — textual test date.
• STATISTIC_CATEGORY_CODE, _LA:STATISTIC_CATEGORY, _LA:STATISTIC_CATEGORY_DESC — the statistic category plus translation ("_LA") columns sourced from ACT_STATISTIC_CATEGORY lookup meanings and descriptions.
• SCORE, NATIONAL_NORM, LOCAL_NORM — the sub-test score and its national and local normative references. NATIONAL_NORM is the column most directly supporting national comparative analysis.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — standard audit 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.