Results for “igs_ad_hz_acad_hist”

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

Overview

The IGS_AD_HZ_ACAD_HIST table, owned by the IGS schema within the Oracle EBS Student System product, stores academic history information for individuals that is not captured by the standard TCA (Trading Community Architecture) table HZ_EDUCATION. It extends the TCA education model to accommodate higher-education-specific attributes such as degree attempts, GPA recalculations, self-reported academic achievements, and transcript requirements. In Oracle EBS 12.1.1 and 12.2.2, this table is classified as VALID and is a component of the Student System module used by institutions to track academic progression and admissions data.

Based on the heuristic Data Vault classification mined from the foreign key structure, this table is best modeled as a link — it connects a person's TCA education record (HZ_EDUCATION) to academic program and degree information (IGS_PS_DEGREES, referenced through DEGREE_ATTEMPTED), carrying descriptive measures in the same structure.

Key Information Stored

The table contains 54 documented columns. The primary surrogate key is HZ_ACAD_HIST_ID, enforced by the primary key constraint IGS_AD_HZ_ACAD_HIST_PK. A unique index, IGS_AD_HZ_ACAD_HIST_U1, also exists on HZ_ACAD_HIST_ID, confirming it as the sole business-key candidate. The most significant columns include:

• HZ_ACAD_HIST_ID — Surrogate primary key uniquely identifying each academic history record.
• EDUCATION_ID — Foreign key to HZ_EDUCATION, linking the academic history to the person's TCA education record.
• DEGREE_ATTEMPTED — Foreign key to IGS_PS_DEGREES, identifying the degree program the person attempted.
• CURRENT_INST — The current institution associated with the academic record.
• PROGRAM_TYPE_ATTEMPTED — Classification of the program type attempted.
• PLANNED_COMPLETION_DATE — Expected date of program completion.
• RECALC_INST_GPA — Institution-recalculated grade point average.
• SELFREP_INST_GPA — Self-reported institutional GPA provided by the person.
• RECALC_TOTAL_CP_EARNED and RECALC_TOTAL_CP_ATTEMPTED — Recalculated credit points earned and attempted.
• SELFREP_TOTAL_CP_EARNED and SELFREP_TOTAL_CP_ATTEMPTED — Self-reported equivalents of the same credit point measures.
• SELFREP_RANK_IN_CLASS, SELFREP_WEIGHED_RANK, SELFREP_CLASS_SIZE — Self-reported class ranking and cohort size.
• TRANSCRIPT_REQUIRED — Flag indicating whether a transcript is required.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE20 — DFF-enabled flexible descriptive attributes.

Common Use Cases and Queries

Typical use cases include admissions evaluation, transcript verification, degree audit, and academic reporting. A common query joins this table to HZ_EDUCATION and IGS_PS_DEGREES to retrieve a person's academic profile:

SELECT a.HZ_ACAD_HIST_ID, a.CURRENT_INST, a.RECALC_INST_GPA, a.SELFREP_INST_GPA, d.NAME FROM IGS.IGS_AD_HZ_ACAD_HIST a, HZ_EDUCATION e, IGS.IGS_PS_DEGREES d WHERE a.EDUCATION_ID = e.EDUCATION_ID AND a.DEGREE_ATTEMPTED = d.DEGREE_CD;

Reporting scenarios frequently compare recalculated versus self-reported GPA and credit totals to detect discrepancies during admissions review. The TRANSCRIPT_REQUIRED flag supports workflow-driven transcript collection processes, while the ATTRIBUTE columns enable institution-specific extensions without schema changes.

Related Objects

• HZ_EDUCATION — Referenced through EDUCATION_ID; the TCA parent education record.
• IGS_PS_DEGREES — Referenced through DEGREE_ATTEMPTED; defines the degree program attempted.
• IGS_AD_HZ_ACAD_HIST_PK — Primary key constraint on HZ_ACAD_HIST_ID.
• IGS_AD_HZ_ACAD_HIST_U1 — Unique index on HZ_ACAD_HIST_ID.
• IGS_AD_APPLICATIONS — Related Student System application data typically joined in admissions reporting.
• HZ_PERSON / HZ_PARTIES — Indirectly related through HZ_EDUCATION for person-level reporting.