Search Results person_identifier




Overview
Explore in AI Chat

Overview

The view IGSBV_AD_ACT_STATS_PREDIC belongs to the IGS – Student System product family within Oracle E-Business Suite. It is catalogued in the ETRM metadata as an obsolete object, and the documentation explicitly records that it is not implemented in the database against which the reference material was captured. Functionally, the view exposes ACT (American College Testing) statistical test components together with their associated category details, filtered to records whose statistical type is 'PREDICTED'. In other words, it presents predicted ACT statistical outcomes — percentile rank, grade point average, and probability — joined to the person identifier of the student.

Within the Oracle EBS 12.1.1 / 12.2.2 reporting landscape, such a view served as a read-only presentation layer over the Student System tables, intended to support institutional reporting on standardized test prediction data. The WITH READ ONLY clause confirms the object is query-only and cannot be used for DML. Because the view is obsolete, it should be treated as a legacy component that may be absent from a fresh 12.2.2 installation, and any dependent custom report should be validated against the target instance before use.

Underlying Base Objects

The view definition references two base objects. The primary source is IGS_AD_ACT_STATISTICS (aliased ACTST), which stores ACT statistical test component records. The secondary source is IGS_PE_ALT_PERS_ID (aliased PEA), which holds alternate person identifiers — in this case the ACT identifier used to cross-reference the student.

The join is an outer join (PEA.API_PERSON_ID (+)) on a decoded key: the leading hyphen of ACT_IDENTIFIER is stripped before comparison, and the join is further constrained by PEA.PERSON_ID_TYPE(+) = 'ACTID'. The metadata lists no documented referenced base objects, and the owner is not specified, which is consistent with its obsolete status.

Key Columns

Common Use Cases and Queries

Typical use is institutional reporting on predicted ACT statistics keyed by person identifier. A representative query is:

SELECT person_identifier,
       reporting_year,
       act_identifier,
       percentile_rank,
       grade_point_average,
       probability
FROM   igsbv_ad_act_stats_predic
WHERE  reporting_year = :year;

Because PERSON_IDENTIFIER derives from an outer join, callers should account for possible null values where no matching ACTID alternate identifier exists. Given the obsolete designation and the "not implemented" note, any query should first verify object existence via ALL_VIEWS before being deployed in a 12.1.1 or 12.2.2 environment.