Results for “local_norm”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The IGSFV_AD_ACT_STATS_SUBSCORE view is a read-only reporting object in the Oracle E-Business Suite Student System (IGS) product family, owned by the APPS schema. It exposes ACT statistical test components that are classified as sub-test scores, together with the descriptive category details that give those scores their business meaning. The view sits at the intersection of the admissions testing data model and the IGS flexible value (lookup) infrastructure, bridging the raw statistical score records held against a person with the lookup-driven category definitions used for display and analysis.

Its principal role is to provide a presentation-ready projection of ACT sub-test statistics. Rather than exposing the raw STATISTIC_CATEGORY code, the view resolves the meaning and description of the category through seeded lookup values, and it resolves an associated test segment group from the test segmentation configuration. This makes it suitable for institutional reporting, applicant score review, and any downstream integration that must present ACT sub-test results in human-readable form. Because the view carries translation attributes prefixed with _LA:, it also supports multilingual (language-agnostic) rendering of the category meaning and description.

Underlying Base Objects

The metadata documents the view definition over two base tables: IGS_AD_ACT_STATISTICS (aliased ACTST), which stores the ACT statistical records, and IGS_PE_ALT_PERS_ID (aliased PEA), which holds alternate person identifiers. The join between them is an outer join on the alternate person identifier: the ACT identifier stored on the statistics row, stripped of a leading hyphen where present, is matched to PEA.API_PERSON_ID with PEA.PERSON_ID_TYPE(+) = 'ACTID'. The outer join preserves statistical rows that have no corresponding ACTID person identifier record.

The view definition additionally references IGS_LOOKUP_VALUES and IGS_AD_TEST_SEGMENTS within a scalar subquery that derives SEGMENT_GROUP. This subquery constrains the lookup type to ACT_STATISTIC_CATEGORY, matches the lookup code to the record's statistic category, matches the lookup meaning to the test segment name, and correlates the decoded test type to the admission test type. No other referenced base objects are documented in the ETRM metadata.

Key Columns

• PERSON_IDENTIFIER — the person identifier derived from the alternate person identifier join; identifies the individual to whom the ACT statistic belongs.
• SEGMENT_GROUP — the resolved test segment group, obtained by correlating the statistic category against the ACT_STATISTIC_CATEGORY lookup and the test segments configuration.
• ACT_IDENTIFIER — the ACT identifier associated with the statistical record.
• REPORTING_YEAR, TEST_TYPE, TEST_DATE_TXT — reporting year, decoded test type such as ACT-DANTES or ACT-NATIONAL, and the test date as text.
• STATISTIC_CATEGORY_CODE — the raw statistic category code stored in IGS_AD_ACT_STATISTICS.
• _LA:STATISTIC_CATEGORY, _LA:STATISTIC_CATEGORY_DESC — translation-enabled meaning and description of the category, resolved through IGS_LOOKUP_VALUES.
• SCORE, NATIONAL_NORM, LOCAL_NORM — the reported score and its national and local norm values.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE.

The view restricts output to rows where STATISTIC_TYPE = 'TEST_SUB_SCORE', so only sub-test components appear.

Common Use Cases and Queries

The primary use case is retrieving ACT sub-test scores for a given person or reporting year, with the category meaning presented ready for a report. A typical query filters on the person and year:

• Applicant score review: SELECT person_identifier, reporting_year, act_identifier, statistic_category_code, score FROM igsfv_ad_act_stats_subscore WHERE reporting_year = :p_year;
• Category-level analysis: SELECT statistic_category_code, avg(score), count(*) FROM igsfv_ad_act_stats_subscore GROUP BY statistic_category_code;
• Segment group reporting: SELECT segment_group, count(*) FROM igsfv_ad_act_stats_subscore WHERE segment_group IS NOT NULL GROUP BY segment_group;

Because the view is declared WITH READ ONLY, it is intended strictly for query and reporting, not for DML. Consumers should be aware of the outer join on the alternate person identifier, which can yield null person identifiers for statistics rows lacking an ACTID record.