Search Results selfrep_total_unit_grade_point

Overview

IGSBV_PERSON_EDUCATION_EXTS is an Oracle E-Business Suite read-only view owned by the APPS schema, delivered as part of the Oracle Student System / Student Records (IGS) product family. Its name indicates its purpose: it exposes person-level education and academic history attributes that extend the core person record. The "BV" segment in the object name denotes a business view, and the "_EXTS" suffix signals that the view presents an extended, denormalized projection of education data intended for external consumption.

The view is defined as a straight projection over a single underlying table, IGS_AD_HZ_ACAD_HIST, and is declared WITH READ ONLY. Because it is read-only, it serves strictly as a reporting and integration surface. It does not support DML and should not be used as a staging target. In the context of Oracle EBS 12.1.1 and 12.2.2, the view is typically consumed by concurrent programs, Oracle Reports, BI Publisher data templates, and interface programs that need academic history information joined to the HZ (TCA) party model without navigating the full base table structure.

The user's search term "current_inst" maps directly to the first column of the view. The base column CURRENT_INST is aliased in the view to CURRENT_INSTITUTION, so queries referencing CURRENT_INSTITUTION return the current institution affiliation associated with the academic history record.

Underlying Base Objects

Per the documented view text, the sole referenced base object is IGS_AD_HZ_ACAD_HIST. The view performs no joins, unions, or aggregations; it is a column-renaming projection that exposes a curated subset of columns from that table with more descriptive aliases. The ETRM metadata records no additional base objects, and the FROM clause confirms a single-table definition terminated by WITH READ ONLY.

Because the view resolves to one table, its performance characteristics track those of IGS_AD_HZ_ACAD_HIST. Predicates on the identifier columns HZ_ACAD_HIST_ID and EDUCATION_ID drive the most efficient access paths. The relationship to the TCA party model is expressed through HZ_ACAD_HIST_ID, which links the academic history row back to the corresponding person or party record.

Key Columns

• CURRENT_INSTITUTION (base: CURRENT_INST) — the current institution for the education record; the target of the user's "current_inst" search.
• PROGRAM_TYPE_ATTEMPTED — the program type the person attempted at the institution.
• NOTES (base: COMMENTS) — free-text comments attached to the academic history.
• PLANNED_COMPLETION_DATE — anticipated completion date for the program.
• Calculated metrics — RECALC_TOTAL_CP_ATTEMPTED, RECALC_TOTAL_CP_EARNED, RECALC_TOTAL_UNIT_GRADE_POINT, RECALC_TOT_GPA_UTS_ATTEMPTED, and RECALC_INSTITUTION_GPA expose system-recalculated credit points, earned credit, unit grade points, attempted GPA units, and institutional GPA.
• Self-reported metrics — SELFREP_TOTAL_CP_ATTEMPTED, SELFREP_TOTAL_CP_EARNED, SELFREP_TOTAL_UNIT_GRADE_POINT, SELFREP_TOT_GPA_UTS_ATTEMPTED, SELFREP_INSTITUTION_GPA, SELFREP_WEIGHTED_GPA_INDICATOR, SELFREP_RANK_IN_CLASS, SELFREP_WEIGHED_RANK_INDICATOR, and SELFREP_CLASS_SIZE expose applicant-entered values that may differ from recalculated figures.
• TRANSCRIPT_REQUIRED_INDICATOR (base: TRANSCRIPT_REQUIRED) — flags whether a transcript is required.
• Identifiers and audit columns — HZ_ACAD_HIST_ID, EDUCATION_ID, RECALC_GRADING_SCALE_ID, SELFREP_GRADING_SCALE_ID, plus CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, and LAST_UPDATE_DATE.

Common Use Cases and Queries

Typical uses include admissions review, where recalculated versus self-reported GPA and credit values are compared, and integration extracts that feed external student information systems.

Retrieve all education rows for a person by academic history identifier:

• SELECT CURRENT_INSTITUTION, EDUCATION_ID, RECALC_INSTITUTION_GPA, SELFREP_INSTITUTION_GPA FROM APPS.IGSBV_PERSON_EDUCATION_EXTS WHERE HZ_ACAD_HIST_ID = :p_id;

Identify records where the self-reported GPA differs from the recalculated GPA:

• SELECT HZ_ACAD_HIST_ID, CURRENT_INSTITUTION, RECALC_INSTITUTION_GPA, SELFREP_INSTITUTION_GPA FROM APPS.IGSBV_PERSON_EDUCATION_EXTS WHERE NVL(RECALC_INSTITUTION_GPA,0) <> NVL(SELFREP_INSTITUTION_GPA,0);

List institutions requiring transcripts:

• SELECT CURRENT_INSTITUTION, PROGRAM_TYPE_ATTEMPTED, PLANNED_COMPLETION_DATE FROM APPS.IGSBV_PERSON_EDUCATION_EXTS WHERE TRANSCRIPT_REQUIRED_INDICATOR = 'Y';

Because the view is READ ONLY and defined over a single table, these queries are safe for reporting workloads and can be granted to read-only reporting responsibilities without risk of unintended data modification.