Results for “previous_qualifications”

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

Overview

IGS_GR_HIST_V is a PL/SQL-based audit/history view owned by the APPS schema within the Oracle E-Business Suite Student System (IGS) product family. It exposes the graduation history data stored in the graduation history audit table, presenting a resolved, reconciled picture of the award and graduation records for a person at a given point in time. The view is defined as VALID in the ETRM 12.1.1 / 12.2.2 data dictionary and is intended for reporting and integration consumption rather than for direct transactional entry.

The distinguishing characteristic of the view is its use of the audit reconstruction function IGS_AU_GEN_003.AUDP_GET_GRH_COL. For each audited column, the view applies NVL logic across three sources in priority order: the current history row value (GRH1), the value reconstructed from the audit trail at the relevant history point, and finally the value from the live graduation record (GR1). This layered NVL resolution means the view returns the most accurate available value for each attribute even when the current history record is sparse or when the underlying audit detail must be decoded.

Underlying Base Objects

The view text references several objects. The primary driving alias is GRH1, which is the graduation history audit table itself (the IGS_GR_HIST table family). GR1 refers to the corresponding live graduation record, providing fallback values where no history or audit value exists. IGS_AU_GEN_003 is the audit package whose AUDP_GET_GRH_COL function decodes audit column values stored in the generic audit infrastructure; it is invoked for every audited attribute (GRD_CAL_TYPE, COURSE_CD, AWARD_CD, and others). IGS_GE_DATE.IGSDATE is a date conversion utility used to transform the audited conferral date back into a usable date value.

Although the documented referenced base objects list is empty in the available metadata, the view text makes clear that the underlying relationship is between the graduation history audit rows and the graduation record, joined through PERSON_ID and the history effective dates (HIST_START_DT, HIST_END_DT).

Key Columns

• PERSON_ID, CREATE_DT, HIST_START_DT, HIST_END_DT, HIST_WHO — the audit identity and effective-dating columns that frame each history record and identify who made the change.
• GRD_CAL_TYPE, GRD_CI_SEQUENCE_NUMBER — the graduation calendar and calendar instance sequence identifying the graduation event.
• COURSE_CD, AWARD_COURSE_CD, AWARD_CRS_VERSION_NUMBER — the course and award programme details applicable to the graduand.
• AWARD_CD, HONOURS_LEVEL — the award being conferred and any honours classification.
• CONFERRAL_DT — the date the award was conferred, resolved through IGS_GE_DATE.IGSDATE.
• GRADUAND_STATUS, GRADUAND_APPR_STATUS — the graduand's progression and approval states, indicating workflow position.

Each of these columns is populated using the NVL/AUDP_GET_GRH_COL reconstruction pattern, meaning the returned value reflects the state of the record at the time defined by HIST_START_DT/HIST_END_DT.

Common Use Cases and Queries

The view supports audit reporting, point-in-time graduation status enquiries, and reconciliation between the live graduation record and its retained history. A representative query returning the award history for a person is:

• SELECT person_id, grd_cal_type, award_cd, conferral_dt, graduand_status, hist_start_dt, hist_end_dt FROM igs_gr_hist_v WHERE person_id = :p_person ORDER BY hist_start_dt;
• SELECT person_id, course_cd, award_course_cd, honours_level FROM igs_gr_hist_v WHERE graduand_appr_status = :status;
• SELECT award_cd, COUNT(*) FROM igs_gr_hist_v WHERE conferral_dt BETWEEN :from_dt AND :to_dt GROUP BY award_cd;

Because the view performs per-column audit decoding, queries returning large row sets may incur performance costs; filtering on PERSON_ID and the history date columns is recommended to restrict the driving audit rows before the AUDP_GET_GRH_COL calls are evaluated.