Results for “award_code”

29 results




Overview
Explore in AI Chat

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

Overview

IGSBV_AWARDS is a base database view owned by the APPS schema within the IGS (Student System) product family of Oracle E-Business Suite, documented in ETRM for releases 12.1.1 and 12.2.2. The view presents the awards offered by a university — the qualification records such as degrees, diplomas, and certificates that an institution confers on students. In the EBS reporting and integration architecture, IGSBV_AWARDS functions as a read-only, denormalized projection layer that shields downstream consumers from the physical column naming of the underlying award table. The view is explicitly declared WITH READ ONLY, meaning it cannot be used for DML; it serves exclusively as a query surface for reports, concurrent programs, Oracle Reports/.rdf layouts, OBIEE or BI Publisher datasets, and inbound/outbound interface extracts that reference award definitions.

Underlying Base Objects

The view text is defined over a single base table, IGS_PS_AWD, aliased as AWD:

The relationship is a straightforward one-to-one column mapping: every row in the view corresponds to exactly one row in IGS_PS_AWD, with no joins, aggregation, or filtering applied. The view performs no data transformation beyond renaming — the AWARD_CD column becomes AWARD_CODE, and so on — which means filters, joins, and ordering applied against the view are pushed down directly to the award table. This also implies that the view inherits the full row population of IGS_PS_AWD, including closed or inactive awards, and that no row-level security is enforced by the view definition itself.

Key Columns

  • AWARD_CODE — The primary business key and the unique identifier of the award (source column AWARD_CD). This is the term most commonly used in joins to student award or program records and is the natural target of the user search for "award_code."
  • AWARD_TITLE — The descriptive name of the award as presented to users and on official documents.
  • SYSTEM_AWARD_TYPE — The system-defined classification of the award (source S_AWARD_TYPE), typically a lookup code that drives institutional rules and reporting groupings.
  • TESTAMUR_DEGREE_TYPE — Identifies the testamur or degree type associated with the award.
  • CLOSED_INDICATOR — Flag indicating whether the award is closed and therefore unavailable for new association.
  • NOTES — Free-text descriptive information about the award.
  • GRADING_SCHEMA_CODE and GRADING_SCHEMA_VERSION_NUMBER — The grading schema and its version applied to the award.
  • CREATED_BY, CREATED_DATE, LAST_UPDATED_BY, LAST_UPDATED_DATE — Standard EBS audit columns supporting lineage and change tracking.

Common Use Cases and Queries

Typical uses include award validation during student record loads, award-type distribution reporting, and populating LOVs in custom forms and OAF pages. The view also supports reconciliation of award definitions against external student information systems.

Retrieve all active awards:

  • SELECT award_code, award_title, system_award_type FROM igsbv_awards WHERE closed_indicator = 'N';

Look up a specific award by code:

  • SELECT award_code, award_title, grading_schema_code FROM igsbv_awards WHERE award_code = :p_award_code;

Group awards by type for a summary report:

  • SELECT system_award_type, COUNT(*) FROM igsbv_awards WHERE closed_indicator = 'N' GROUP BY system_award_type;

Because the view is read-only and unindexed by definition, queries returning single rows by AWARD_CODE rely on the primary key index on IGS_PS_AWD and perform efficiently; broad scans against AWARD_TITLE should be avoided in high-volume reconciliation processes.