Search Results igsbv_ad_act_stats_interest

Overview

The Oracle E-Business Suite view IGSBV_AD_ACT_STATS_INTEREST belongs to the IGS (Student System) product family. The IGS module, historically known as Oracle Student Systems, was designed to support admissions, academic records, and standardized test data for higher-education institutions. This particular view is classified as obsolete within the ETRM metadata and, critically, is documented as not implemented in this database, meaning no deployed 12.1.1 or 12.2.2 instance exposes it as a live database object.

The view presents ACT statistical test components and their associated category details, filtered specifically to records where the statistical test type is INTEREST. It joins person identification data to the ACT statistics table, exposing both the normalized person identifier and the raw ACT identifier simultaneously. Because it is a "BV" (business view) object, any reporting or integration layer that previously consumed it would have accessed it as a read-only, denormalized projection.

The user search term reporting_year maps directly to the REPORTING_YEAR column of the view, which is sourced from the underlying IGS_AD_ACT_STATISTICS table and serves as the principal temporal qualifier for ACT test statistics.

Underlying Base Objects

The view is defined over two base objects:

• IGS_AD_ACT_STATISTICS (aliased ACTST) — the driving table containing ACT statistical test records. The view restricts this set with the predicate STATISTIC_TYPE = 'INTEREST'.
• IGS_PE_ALT_PERS_ID (aliased PEA) — the alternate person identifier table, joined via a non-key-preserving outer join on API_PERSON_ID with the additional filter PERSON_ID_TYPE = 'ACTID'.

The join is deliberately asymmetric. A DECODE expression strips a leading hyphen from ACT_IDENTIFIER before comparison, accommodating legacy ACT identifier formats that may carry a negative sign prefix. The (+) syntax on the PEA side confirms the person identifier is optional; statistics rows without a matching ACT person identifier are still returned. The presence of the WITH READ ONLY clause enforces that no DML can be issued against the view. Because no base objects are documented beyond those visible in the view text, any extension to additional tables should be treated as unsupported.

Key Columns

• PERSON_IDENTIFIER — the institution's person identifier resolved from IGS_PE_ALT_PERS_ID; may be null.
• REPORTING_YEAR — the reporting year of the ACT statistical record, the primary reporting axis.
• ACT_IDENTIFIER — the ACT-assigned candidate identifier, pre-cleaned of hyphen prefixes.
• TEST_TYPE and TEST_DATE_TXT — test classification and free-text test date.
• STATISTIC_CATEGORY_CODE with _LA:STATISTIC_CATEGORY and _LA:STATISTIC_CATEGORY_DESC — lookup-decoded descriptions derived from IGS_LOOKUP_VALUES against the ACT_STATISTIC_CATEGORY lookup type.
• SCORE, STANDARD_SCORE, PERCENTILE_RANK — the numeric outcome measures.
• Audit columns CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE.

Common Use Cases and Queries

Historically the view would have supported admission-review reporting, trend analysis of applicant interest scores across reporting years, and interfaces that extract ACT interest statistics into institutional data warehouses. A representative query and a year-trend variant follow.

SELECT PERSON_IDENTIFIER, REPORTING_YEAR, ACT_IDENTIFIER, SCORE, PERCENTILE_RANK FROM IGSBV_AD_ACT_STATS_INTEREST WHERE REPORTING_YEAR = 2010;

SELECT REPORTING_YEAR, STATISTIC_CATEGORY_CODE, COUNT(*), AVG(SCORE) FROM IGSBV_AD_ACT_STATS_INTEREST GROUP BY REPORTING_YEAR, STATISTIC_CATEGORY_CODE ORDER BY REPORTING_YEAR;

Given the object's obsolete and unimplemented status, no production query against IGSBV_AD_ACT_STATS_INTEREST should be expected to succeed; equivalent logic must be recreated directly against IGS_AD_ACT_STATISTICS if the data is retained.