Results for “transcript_required”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGS_AD_ACAD_HISTORY_V is an Oracle EBS 12.1.1 / 12.2.2 view owned by the APPS schema in the IGS (Student System) product family. It consolidates a student's prior academic history — the institutions attended, programs of study, attendance dates, and reported or recalculated grade point information — into a single denormalized reporting structure. The view is used primarily for inquiry screens, self-service pages, admissions evaluation, and integration extracts where a flat representation of external academic history is required. Because it joins admissions history records to trading community party and party-site data, it allows downstream consumers to display both the internal party reference and the human-readable institution name, code, and classification without requiring additional joins.

Underlying Base Objects

The view text references several base objects. The primary driver is HE, an education/history entity keyed on EDUCATION_ID and PARTY_ID, which supplies school attendance details including SCHOOL_PARTY_ID, SCHOOL_ATTENDED_NAME, COURSE_MAJOR, START_DATE_ATTENDED, and LAST_DATE_ATTENDED. A second source, aliased HAH, contributes academic history header attributes such as CURRENT_INST, TRANSCRIPT_REQUIRED, COMMENTS, PLANNED_COMPLETION_DATE, and the full set of RECALC_* and SELFREP_* grade point and credit point measures. Supporting lookups include:

• IGS_PE_HZ_PARTIES — supplies OSS_ORG_UNIT_CD, OI_INSTITUTION_TYPE, and OI_INST_CONTROL_TYPE for the institution.
• HZ_PARTIES — supplies PARTY_NAME for the institution name.
• IGS_PS_VER — supplies the program title matched on COURSE_CD||'/'||VERSION_NUMBER.
• IGS_AD_CODE_CLASSES — supplies the grading scale NAME for both recalculated and self-reported scales.

ETRM 12.2.2 documents no additional referenced base objects beyond those evident in the view text. All lookups are implemented as scalar correlated subqueries nested within DECODE expressions, meaning the view is effectively a single-row-per-history-record projection with no row multiplication from the lookup tables.

Key Columns

• EDUCATION_ID, PARTY_ID, SCHOOL_PARTY_ID — primary identifiers linking the record to the person and the institution.
• INSTITUTION_CODE, INSTITUTION_NAME, INSTITUTION_TYPE, INST_CONTROL_TYPE — institution descriptors; name falls back to SCHOOL_ATTENDED_NAME when no party is linked.
• COURSE_MAJOR and TITLE — the program/version code and its descriptive title.
• START_DATE_ATTENDED, LAST_DATE_ATTENDED, PLANNED_COMPLETION_DATE — attendance and expected completion dates.
• CURRENT_INST, TRANSCRIPT_REQUIRED, COMMENTS — admissions status flags and free-text notes.
• RECALC_TOTAL_CP_ATTEMPTED, RECALC_TOTAL_CP_EARNED, RECALC_INST_GPA, RECALC_TOT_GPA_UTS_ATTEMPTED, RECALC_GRADING_SCALE — institution-calculated credit and GPA values.
• SELFREP_TOTAL_CP_ATTEMPTED, SELFREP_TOTAL_CP_EARNED, SELFREP_INST_GPA, SELFREP_WEIGHTED_GPA, SELFREP_RANK_IN_CLASS, SELFREP_CLASS_SIZE — applicant-declared equivalents.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1..N — DFF columns inherited from the academic history header.

Common Use Cases and Queries

Typical scenarios include displaying a candidate's prior education on an admissions review form, extracting external GPA data for credit transfer or articulation, and populating self-service "my academic history" regions. A representative query retrieves the institution and recalculated GPA for one person:

• SELECT institution_name, course_major, title, recalc_inst_gpa, selfrep_inst_gpa FROM igs_ad_acad_history_v WHERE party_id = :p_party_id;
• SELECT institution_code, COUNT(*) FROM igs_ad_acad_history_v GROUP BY institution_code ORDER BY 2 DESC;
• SELECT party_id, institution_name, start_date_attended, last_date_attended FROM igs_ad_acad_history_v WHERE transcript_required = 'Y';

Because the view performs scalar subqueries against HZ_PARTIES and IGS_PE_HZ_PARTIES, performance is best when filtering by PARTY_ID or EDUCATION_ID, which limits the correlated lookups executed per row.