Search Results interface_transfer_date




Overview
Explore in AI Chat

Overview

IGSFV_AD_ACT_ASSESSMENTS is a read-only Oracle EBS view owned by the APPS schema and defined over the Student Systems assessment tables. It consolidates assessment record data captured against the ACT standardized test identifier into a single, denormalized reporting structure. In Oracle Student Systems, the ACT assessment is one of several admissions test records that feed applicant and prospect data into the admissions pipeline. The view flattens the parent assessment row together with selected person alternate identifier information, producing one row per assessment record qualified by an ACT identifier.

The view is intended for reporting, extracts, and third-party interfacing rather than for transaction entry. Because the DDL is created WITH READ ONLY, no DML may be issued against it; any data maintenance must be performed against the underlying base table. The view is commonly used within EBS reporting layers, Discoverer worksheets, and custom interfaces where a stable, pre-joined projection of ACT assessment data is required. The local_identifier column, referenced by the search that surfaced this object, exposes the institutionally assigned local identifier associated with the assessment record.

Underlying Base Objects

The view is defined over two objects:

  • IGS_AD_ACT_ASSESSMENTS (alias ACTAS) — the driving table, containing the ACT assessment rows themselves, including test type, test date, batch, biographical data, high school attributes, scale score totals, college choice, norms type, release information, and audit columns.
  • IGS_PE_ALT_PERS_ID (alias PEA) — the alternate person identifier table, restricted by the predicate PEA.PERSON_ID_TYPE(+) = 'ACTID'.

The join is written as an outer join (indicated by the (+) notation, which remains valid in EBS 12.1.1 and 12.2.2 for views not yet migrated to ANSI syntax). The join condition normalizes the ACT identifier by stripping a leading hyphen:

DECODE(SUBSTR(ACTAS.ACT_IDENTIFIER,1,1),'-',SUBSTR(ACTAS.ACT_IDENTIFIER,2), ACTAS.ACT_IDENTIFIER) = PEA.API_PERSON_ID (+)

This ensures that an ACT identifier stored with a leading hyphen prefix still resolves to the corresponding alternate person identifier record. Where no matching ACTID row exists, the outer join returns null for the person identifier columns, which causes PERSON_IDENTIFIER (aliased from PEA.PE_PERSON_ID) to be null.

Key Columns

Common Use Cases and Queries

Typical scenarios include reconciling inbound ACT assessment feeds against institutional local identifiers, producing admissions test score extracts, and validating that each assessment resolved to a person record. To list unresolved assessments, query for a null person identifier:

  • SELECT act_identifier, local_identifier, last_name, first_name FROM igsfv_ad_act_assessments WHERE person_identifier IS NULL;
  • SELECT reporting_year, local_identifier, sum_of_scale_scores FROM igsfv_ad_act_assessments WHERE reporting_year = :year ORDER BY local_identifier;
  • SELECT a.local_identifier, a.college_choice, a.corrected_report_indicator FROM igsfv_ad_act_assessments a WHERE a.interface_transfer_date >= :from_date;

All queries are read-only; no insert, update, or delete is permitted against the view.