Search Results s_graduand_type




Overview
Explore in AI Chat

Overview

IGS_GR_HIST_V is an Oracle E-Business Suite view owned by the APPS schema that exposes the graduation history records maintained by the Student Systems / Higher Education (IGS) product family. It belongs to the graduation (GR) functional area and presents a consolidated, point-in-time image of a person's graduand and award data, drawing together the current graduation record with its historical audit rows. The view is used primarily for reporting, inquiry, and integration of graduation outcomes — conferrals, awards, honours classifications, and graduand approval statuses — against the Oracle EBS 12.1.1 and 12.2.2 data model.

Because graduation records are subject to change over time, IGS_GR_HIST_V applies the IGS audit methodology, resolving each attribute against the history table and, where a history value is absent, falling back to the live graduation record and the audit column retrieval function IGS_AU_GEN_003.AUDP_GET_GRH_COL. This makes the view a faithful, time-aware projection of graduation data suitable for downstream reporting without requiring callers to implement history resolution logic themselves.

Underlying Base Objects

The ETRM metadata records no explicitly documented base objects for this view, so the relationship must be inferred from the view text itself. Two principal sources are evident:

  • grh1 — the graduation history table (IGS_GR_HIST), which supplies the audit columns create_dt, hist_start_dt, hist_end_dt, and hist_who, together with the historical values of graduation attributes.
  • gr1 — the base graduation table (IGS_GR), which supplies the current, effective values of the same attributes.

The view combines these using NVL so that a historical value takes precedence where present, otherwise the current record value is used. Attribute resolution for non-key columns is delegated to the audited lookup function IGS_AU_GEN_003.AUDP_GET_GRH_COL, and dates are converted through IGS_GE_DATE.IGSDATE. The join is keyed on person_id and create_dt, which together identify a graduation history instance.

Key Columns

  • person_id — the identifier of the person (student/graduand) to whom the graduation record belongs.
  • create_dt — the creation timestamp that, with person_id, forms the key of the history record. This is the column most frequently referenced when searching for this view.
  • hist_start_dt / hist_end_dt — the effective start and end dates of the history row, defining the validity window of the recorded values.
  • hist_who — the user or process that created the history record, supporting audit and accountability requirements.
  • grd_cal_type, grd_ci_sequence_number — the graduation calendar type and calendar instance sequence that qualify the graduation event.
  • course_cd, award_course_cd, award_crs_version_number, award_cd — the course and award identifiers associated with the graduand.
  • honours_level — the honours classification awarded, where applicable.
  • conferral_dt — the date the award was conferred.
  • graduand_status, graduand_appr_status — the graduand's status and approval status, the latter resolved via the IGS_GR_APRV_STAT audit attribute.

Common Use Cases and Queries

Typical uses include graduation conferral reporting, award and honours analysis, and audit or point-in-time reconstruction of a graduand's record. A common pattern is to filter on person_id and create_dt to extract a specific history instance:

  • List all graduation history rows for a person, ordered by create_dt, to trace the evolution of awards and statuses.
  • Filter on conferral_dt or hist_end_dt ranges to report conferrals within an academic period.
  • Join to person and course tables for student-facing or regulatory returns.

Sample query:

SELECT person_id, create_dt, hist_start_dt, hist_end_dt, grd_cal_type, course_cd, award_cd, honours_level, conferral_dt, graduand_status, graduand_appr_status FROM apps.igs_gr_hist_v WHERE person_id = :p_person_id ORDER BY create_dt;