Search Results test_sub_score

Overview

APPS.IGSBV_AD_ACT_STATS_SUBSCORE is a Business Intelligence System (BIS) view in the Oracle E-Business Suite Applications (APPS) schema. It belongs to the Oracle Student System / Academic Advising product family, identified by the IGS module prefix, and is registered under FND Design Data as IGS.IGSBV_AD_ACT_STATS_SUBSCORE. The view is documented with a status of VALID and is classified explicitly as a Business Intelligence System view.

The view exposes ACT statistical test components together with their category details, filtered to the test type recorded as a sub test. In practical terms, it presents the decomposed, per-category scores that make up an ACT assessment record for a given person, reporting year, and test segment. Because it surfaces both a national norm and a local norm alongside the raw score, the view is intended for comparative and analytical reporting rather than for transactional data entry. It enables institutions to compare individual performance against reference populations and internal cohorts without navigating the normalized base tables directly.

The search term "national_norm" corresponds directly to the NATIONAL_NORM column exposed by this view, which is the primary attribute of interest when benchmarking assessment outcomes against a national reference distribution.

Underlying Base Objects

The view is defined over four documented base objects in the APPS schema: IGS_AD_ACT_STATISTICS, IGS_AD_TEST_SEGMENTS, IGS_LOOKUP_VALUES, and IGS_PE_ALT_PERS_ID.

• IGS_AD_ACT_STATISTICS — the principal source of the statistical test component rows, including scores and norm values for the ACT assessment.
• IGS_AD_TEST_SEGMENTS — provides the segment grouping that partitions the statistical record into reporting segments.
• IGS_LOOKUP_VALUES — supplies the decoded statistical category description, surfaced through the _LA:STATISTIC_CATEGORY_DESC column, which resolves the STATISTIC_CATEGORY_CODE into a meaningful label.
• IGS_PE_ALT_PERS_ID — resolves the alternate person identifier, populating PERSON_IDENTIFIER so that records can be tied to the correct individual.

Documentation confirms that APPS.IGSBV_AD_ACT_STATS_SUBSCORE is not referenced by any other database object, indicating that it is a leaf-level, read-only reporting construct with no downstream dependents.

Key Columns

• PERSON_IDENTIFIER — the alternate identifier for the person to whom the assessment results belong.
• SEGMENT_GROUP — numeric grouping that partitions results into reporting segments.
• REPORTING_YEAR — the academic or testing year associated with the record.
• ACT_IDENTIFIER — the identifier of the ACT assessment record.
• TEST_TYPE — the type of test; this view is scoped to the sub test type.
• TEST_DATE_TXT — the test date rendered as text.
• STATISTIC_CATEGORY_CODE — the coded category of the statistic, decoded through lookup values.
• _LA:STATISTIC_CATEGORY and _LA:STATISTIC_CATEGORY_DESC — lookup-driven category label attributes derived from IGS_LOOKUP_VALUES.
• SCORE — the reported score for the component represented by the row.
• NATIONAL_NORM — the national norm value used to benchmark the score against the national reference distribution.
• LOCAL_NORM — the local norm value used for institution-specific comparison.
• Standard Who columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, and LAST_UPDATE_DATE provide audit information.

Common Use Cases and Queries

The view supports benchmarking reports, statistical analysis of sub test components, and integrations that need denormalized ACT score data with norms attached. A representative query returns scores and norms for a given reporting year:

• Filter by REPORTING_YEAR and STATISTIC_CATEGORY_CODE to produce year-specific category summaries.
• Compare SCORE against NATIONAL_NORM and LOCAL_NORM to compute above/below reference variance for a person.
• Join PERSON_IDENTIFIER back to person records for roster-level reporting.

The view may be queried directly as documented:

SELECT PERSON_IDENTIFIER, SEGMENT_GROUP, REPORTING_YEAR, ACT_IDENTIFIER, TEST_TYPE, TEST_DATE_TXT, STATISTIC_CATEGORY_CODE, _LA:STATISTIC_CATEGORY, _LA:STATISTIC_CATEGORY_DESC, SCORE, NATIONAL_NORM, LOCAL_NORM, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE FROM APPS.IGSBV_AD_ACT_STATS_SUBSCORE;

Because the _LA: prefixed columns contain characters that require quoting in standard SQL, report authors typically reference the decoded description column with double quotes, for example "SELECT NATIONAL_NORM FROM APPS.IGSBV_AD_ACT_STATS_SUBSCORE WHERE REPORTING_YEAR = :p_year".