Search Results course_version




Overview
Explore in AI Chat

Overview

IGS_GR_CRMN_ROUND_V is an Oracle E-Business Suite (EBS) view owned by the APPS schema and defined within the Student System / Graduation Management (IGS) product family. It presents a consolidated, hierarchical listing of graduation ceremony scheduling data, combining four levels of granularity into a single reporting structure: the graduation round, the ceremony, the award-level ceremony association, and the award/course-version ceremony unit/group association. This UNION-based design allows a single query to traverse the graduation ceremony hierarchy without the caller needing to understand the individual base tables involved.

The view is typically used in graduation management reporting, ceremony rosters, and downstream integrations where a flattened listing of ceremony-related records — including identifying the course version associated with an award — is required. It is read-only reference data and is not designed for direct DML.

Underlying Base Objects

The view is defined as a four-way UNION over the following base tables:

  • IGS_GR_AWD_CRM_US_GP — Award/ceremony unit-group associations. This is the most detailed level and contributes the award code, award course code, award course version number, and unit-set group number.
  • IGS_GR_AWD_CEREMONY — Award-to-ceremony associations, contributing award and course-version details without a unit-set group.
  • IGS_GR_CRMN — Ceremony header records, populated only with the graduation calendar/sequence and ceremony identifiers.
  • IGS_GR_CRMN_ROUND — Graduation round records, the highest-level grouping, carrying only the graduation calendar type and sequence number.

The UNION progressively nullifies lower-level attributes as it moves up the hierarchy, so each row reflects its true level of granularity. The ETRM documentation records no explicitly documented referenced base objects beyond the view text itself.

Key Columns

Common Use Cases and Queries

A frequent requirement is to list all ceremonies and their associated course versions for a given graduation round:

  • Reporting course versions tied to a specific ceremony.
  • Resolving award titles via the TITLE column for output listings.
  • Feeding ceremony rosters or attendance systems with course-version identifiers.

Sample query:

SELECT GRD_CAL_TYPE, GRD_CI_SEQUENCE_NUMBER, CEREMONY_NUMBER, AWARD_CD, COURSE_VERSION, US_GROUP_NUMBER, TITLE FROM APPS.IGS_GR_CRMN_ROUND_V WHERE GRD_CAL_TYPE = :calendar AND GRD_CI_SEQUENCE_NUMBER = :seq AND COURSE_VERSION IS NOT NULL ORDER BY CEREMONY_NUMBER, AWARD_CD;

Because COURSE_VERSION and TITLE are derived, filtering on them directly avoids callers having to invoke the underlying GRDP_GET_ACUSG_TITLE function themselves. Rows where COURSE_VERSION is null represent higher hierarchy levels (ceremony or round) and should be excluded when the report focuses strictly on course versions.