Search Results order_in_award

Overview

IGS_GR_AWD_CRM_US_GP_V is a public view owned by the APPS schema within the Oracle E-Business Suite 12.1.1 / 12.2.2 environment. It is registered in FND Design Data under the internal identifier IGS.IGS_GR_AWD_CRM_US_GP_V and is documented as a public view intended to support custom reporting and data extraction requirements. The view belongs to the Student System (IGS) graduation and awards product family, specifically to the award ceremony and grouping functionality used by institutions to manage the conferment of awards, group ordering within a ceremony, and the presentation of group titles.

The defining purpose of the view, as stated in the ETRM metadata, is to present the group_title attribute as either the override_title held on the underlying award ceremony group record or a derived value supplied by the supporting IGS_GR_GEN_001 logic. In practice this means report authors receive a single consistent column carrying the resolved display title for a ceremony group, without needing to reproduce the conditional derivation rules themselves.

The object reports a status of VALID and presents a typical view column profile, including the four Standard Who columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE) plus LAST_UPDATE_LOGIN. The view is not referenced by any other database object, which confirms it functions as a terminal reporting surface rather than an intermediate component in a dependency chain.

Underlying Base Objects

The ETRM metadata records two referenced objects for this view: APPS.IGS_GR_AWD_CRM_US_GP and IGS_GR_GEN_001. The first is the base table holding award ceremony US group records and supplies the majority of the projected columns. The second is the graduation generic package or function referenced during the derivation of the group title, invoked when the override title is not populated.

Column-level comments in the metadata map nearly every view column directly to a column of award_ceremony_us_group, the underlying table represented by IGS_GR_AWD_CRM_US_GP. The GROUP_TITLE column is the sole exception, being sourced from award_ceremony_us_group.override_title with the derived fallback applied. The view therefore behaves as a thin projection over the base table, enriched only by the title resolution logic. Because the view is not referenced by any other database object, dependency risk from downstream invalidation is minimal; however, changes to IGS_GR_AWD_CRM_US_GP or to the signature of IGS_GR_GEN_001 may invalidate the view and should be assessed before upgrade or patching activity.

Key Columns

• GRD_CAL_TYPE (VARCHAR2 10) — Graduation calendar type identifying the ceremony calendar context.
• GRD_CI_SEQUENCE_NUMBER (NUMBER) — Sequence number of the graduation calendar instance to which the group belongs.
• CEREMONY_NUMBER (NUMBER) — Identifier of the specific ceremony within the calendar instance.
• AWARD_COURSE_CD (VARCHAR2), AWARD_CRS_VERSION_NUMBER (NUMBER), AWARD_CD (VARCHAR2 10) — The award and course version context for the group.
• US_GROUP_NUMBER (NUMBER) — The group sequence number within the ceremony.
• ORDER_IN_AWARD (NUMBER) — Controls the ordering of the group within the award presentation. This column is directly relevant to the search term "order_in_award" and is typically used in ORDER BY clauses when generating ceremony programs or group listings.
• GROUP_TITLE (VARCHAR2 90) — The resolved display title, returning override_title where present and a derived value otherwise.
• CLOSED_IND (VARCHAR2) — Indicator of whether the group is closed.
• Standard Who columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN for audit and concurrency purposes.

Common Use Cases and Queries

The most common requirement is to list ceremony groups in their correct presentation order using ORDER_IN_AWARD, resolving the display title through GROUP_TITLE rather than the raw override column. A representative query orders groups for a given ceremony, for example selecting GRD_CAL_TYPE, GRD_CI_SEQUENCE_NUMBER, CEREMONY_NUMBER, AWARD_CD, US_GROUP_NUMBER, ORDER_IN_AWARD, and GROUP_TITLE from APPS.IGS_GR_AWD_CRM_US_GP_V where CEREMONY_NUMBER equals a bind value, ordered by ORDER_IN_AWARD ascending.

Other scenarios include filtering with CLOSED_IND to exclude closed groups from a program listing, joining the view to award and course reference tables on AWARD_CD, AWARD_COURSE_CD, and AWARD_CRS_VERSION_NUMBER for institutional reporting extracts, and building CRM or student-facing communication feeds that require the resolved group title. Custom reports should query the view rather than the base table so that the override-and-derived title logic remains centralised and consistent with standard functionality, and should be regression tested against both 12.1.1 and 12.2.2 as part of any patch cycle.