Search Results test_date_txt




Overview
Explore in AI Chat

Overview

The IGSFV_AD_ACT_STATS_ACCOMP view is a read-only reporting object owned by the APPS schema within the Oracle E-Business Suite IGS (Student System) product family. Its stated purpose, as documented in the ETRM metadata, is to present ACT Statistical Test Components and category details for type Accomplishments. In practical terms, the view exposes a filtered subset of the ACT statistical test data, restricted to records whose STATISTIC_TYPE equals 'ACCOMPLISHMENT'. This restriction distinguishes the view from the broader underlying statistics table, which may hold several statistic types. The view is defined WITH READ ONLY, meaning it is intended strictly for querying and reporting; no DML operations are permitted against it. It is commonly embedded in Oracle Forms, concurrent program outputs, and custom BI Publisher reports that summarize applicant or student accomplishment scores by reporting year.

Underlying Base Objects

The view is defined over two documented base objects:

  • IGS_AD_ACT_STATISTICS (aliased ACTST) — the primary source of statistic records, including reporting year, ACT identifier, test type, statistic category, and score.
  • IGS_PE_ALT_PERS_ID (aliased PEA) — the alternate person identifier table, joined via an outer join to resolve the ACT person identifier to a PE person identifier.

The join predicate uses PEA.API_PERSON_ID (+) = DECODE(SUBSTR(ACTST.ACT_IDENTIFIER,1,1),'-', SUBSTR(ACTST.ACT_IDENTIFIER,2), ACTST.ACT_IDENTIFIER) and additionally constrains PEA.PERSON_ID_TYPE(+) = 'ACTID'. The DECODE/SUBSTR logic strips a leading hyphen from the ACT identifier where present before matching. The outer-join notation ((+)) ensures that accomplishment records are returned even when no matching alternate person identifier exists.

Key Columns

Common Use Cases and Queries

The view is typically queried to report accomplishment statistics for a given reporting year, optionally restricted by person or category. A representative query follows:

SELECT person_identifier,
       reporting_year,
       act_identifier,
       statistic_category_code,
       score
FROM   apps.igsfv_ad_act_stats_accomp
WHERE  reporting_year = 2023
ORDER  BY person_identifier, statistic_category_code;

Because the view already filters to STATISTIC_TYPE = 'ACCOMPLISHMENT', callers need not reapply that predicate. The reporting year filter is the most common selection criterion, reflecting the user search term. Joins back to IGS_PE_ALT_PERS_ID or person tables may be added when additional demographic detail is required, noting that the view's own person resolution is an outer join. Finally, since the object is read-only, all usage should be limited to SELECT statements within reports, data extracts, and integration payloads.