Search Results hz_acad_hist_id




Overview
Explore in AI Chat

Overview

The IGS_AD_HZ_ACAD_HIST table is a core data object within the Oracle E-Business Suite (EBS) Student System (IGS) module, versions 12.1.1 and 12.2.2. It serves a specific, complementary role to the Trading Community Architecture (TCA) foundation. While TCA's HZ_EDUCATION table stores general educational history for any party (person or organization) across the EBS suite, IGS_AD_HZ_ACAD_HIST is designed to hold the specialized, student-specific academic history details that are not captured in the standard TCA model. This table enables the Student System to maintain a richer, more granular academic record for individuals, extending the foundational data provided by TCA.

Key Information Stored

The table's structure centers on linking to the TCA model and storing supplementary academic data. Its primary key is HZ_ACAD_HIST_ID, which uniquely identifies each extended academic history record. The most critical foreign key is EDUCATION_ID, which establishes a mandatory one-to-one relationship with a corresponding record in the HZ_EDUCATION table. This link ensures data integrity between the generic TCA education record and the specialized IGS extensions. Another significant foreign key is DEGREE_ATTEMPTED, which references the IGS_PS_DEGREES table. This column allows the system to associate the academic history with a specific, defined degree program from the Student System's catalog, a level of detail typically outside the scope of HZ_EDUCATION.

Common Use Cases and Queries

This table is primarily used in scenarios requiring a comprehensive view of a student's academic background, merging standard TCA data with institution-specific details. A common use case is generating enhanced academic transcripts or admission reports that include both the institution and degree name (from HZ_EDUCATION and IGS_PS_DEGREES) alongside any specialized history data stored in IGS_AD_HZ_ACAD_HIST. A typical reporting query would involve joining these tables:

  • Retrieving Extended Academic History: SELECT hz.school, hz.degree, deg.degree_code, ahist.* FROM IGS_AD_HZ_ACAD_HIST ahist, HZ_EDUCATION hz, IGS_PS_DEGREES deg WHERE ahist.education_id = hz.education_id AND ahist.degree_attempted = deg.degree_id AND hz.party_id = :p_party_id;
  • Data Integrity Validation: Queries often check for orphaned records or validate the existence of a corresponding HZ_EDUCATION entry for every IGS_AD_HZ_ACAD_HIST record.

Related Objects

The IGS_AD_HZ_ACAD_HIST table sits at the intersection of the TCA foundation and the Student System. Its most direct and critical relationship is with the HZ_EDUCATION table, via the EDUCATION_ID foreign key. It also has a formal relationship with the IGS_PS_DEGREES table through the DEGREE_ATTEMPTED column. As a table holding key academic data, it is likely referenced by various Student System forms, reports, and PL/SQL APIs (potentially within packages under the IGS_AD_* or IGS_SS_* prefixes) that manage admissions, student records, and academic history. Its primary key constraints (IGS_AD_HZ_ACAD_HIST_PK and IGS_AD_HZ_ACAD_HIST_U1) enforce the uniqueness of its records.