Search Results program_type_attempted




Overview
Explore in AI Chat

Overview

IGSBV_PERSON_EDUCATION_EXTS is a read-only Oracle EBS view belonging to the IGS (Student System) product family. The ETRM documentation classifies the object as Obsolete and records that it is not implemented in the reference database. It therefore carries no supported functionality in Oracle E-Business Suite 12.1.1 or 12.2.2 and is retained only as historical metadata.

Functionally, the view exposes external education and academic history data associated with a person record. Its column set combines two parallel categories of academic measures: values recalculated by the institution (RECALC_*) and values self-reported by the person (SELFREP_*). This dual structure supports the reporting of prior educational achievement captured during admissions or prospect processing, where external data is recorded alongside internally derived equivalents. The view was intended for reporting and integration consumption rather than for transactional maintenance, as confirmed by the WITH READ ONLY clause in its defining text.

Underlying Base Objects

The documented definition is a single-table projection:

  • IGS_AD_HZ_ACAD_HIST — the sole source object, identified by the FROM clause and constrained with WITH READ ONLY.
  • ETRM records no other referenced base objects. No joins, aggregations, or unions are present in the documented view text.

The view is a straight column rename and subselect over the academic history table. The HZ_ACAD_HIST_ID and EDUCATION_ID columns are carried through unchanged and serve as the identifying keys linking each row to its underlying academic history and education records. Because the definition is unobscured by joins, performance characteristics mirror those of the base table, subject to the absence of any predicate pushdown restrictions beyond the inherent read-only status.

Key Columns

The view exposes twenty-six columns. The most significant, particularly in relation to the search term SELFREP_TOTAL_CP_ATTEMPTED, are:

Common Use Cases and Queries

Because the object is documented as obsolete and unimplemented, production queries against it are not supported. Historical or migration-oriented usage would target the academic history data directly. A representative query, had the view been available, would resemble:

  • SELECT hz_acad_hist_id, education_id, selfrep_total_cp_attempted, selfrep_total_cp_earned, selfrep_institution_gpa FROM igsbv_person_education_exts WHERE selfrep_total_cp_attempted > 0;
  • Comparison reporting: selecting both RECALC_* and SELFREP_* columns to identify discrepancies between applicant-reported and institution-calculated academic measures.
  • Admissions review: filtering on transcript_required_indicator or planned_completion_date to flag incomplete external education records.

For current releases, equivalent data should be sourced from the supported academic history objects in the Student System, or from Oracle Student Cloud where applicable.