Results for “award_title”

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

Overview

IGS_PS_AWD_V is a reporting and integration view owned by the APPS schema in Oracle E-Business Suite, belonging to the IGS (Student System) product family. In both EBS 12.1.1 and 12.2.2 the view is documented with a VALID status and is described in the ETRM metadata as storing the award setup. It presents the institution's award definitions — the credentials, certificates, and prizes that a student body may be granted — together with descriptive attributes resolved from related setup tables. Rather than exposing the raw award table alone, the view denormalizes three related sources into a single row per award, which makes it convenient for concurrent programs, Oracle Forms LOVs, OBIEE/XML Publisher extracts, and outbound integration feeds that need human-readable award descriptions without performing their own lookups.

Underlying Base Objects

The view is defined over three tables, joined with outer joins on the two lookup tables so that an award remains visible even when its grading schema or testamur type has not been configured:

• IGS_PS_AWD (alias AWD) — the driving table holding the award setup record.
• IGS_AS_GRD_SCHEMA (alias GRD) — the grading schema definition, joined on GRADING_SCHEMA_CD and VERSION_NUMBER using (+) outer-join syntax.
• IGS_GR_TESTAMUR_TYPE (alias GTST) — the testamur/award-type lookup, joined on TESTAMUR_TYPE using (+) outer-join syntax.

The ETRM record for 12.2.2 lists no separately documented referenced base objects, so the view text itself is the authoritative definition of the relationship. The outer joins guarantee that rows in IGS_PS_AWD are never suppressed by missing reference data, although the corresponding description columns return NULL in that case.

Key Columns

• ROW_ID — the ROWID of the underlying IGS_PS_AWD row, useful for updates or row identification.
• AWARD_CD — the primary business key of the award.
• AWARD_TITLE — the descriptive name of the award.
• S_AWARD_TYPE — the system award type classification.
• TESTAMUR_TYPE — the testamur type code, resolved to text via DSP_DESCRIPTION from IGS_GR_TESTAMUR_TYPE. The user search term "dsp_description" maps directly to this column, which is the display description of the testamur type.
• CLOSED_IND — indicates whether the award is closed to new assignments.
• NOTES — free-text notes held against the award.
• GRADING_SCHEMA_CD and GS_VERSION_NUMBER — the grading schema and version in use, with GS_DESCRIPTION supplying the schema description from IGS_AS_GRD_SCHEMA.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard WHO audit columns.

Common Use Cases and Queries

Typical uses include award validation lists in enrollment or graduation processing, extract programs that publish award catalogues to a data warehouse, and reporting where the testamur type must be displayed descriptively. A basic query returning open awards with their descriptions:

SELECT award_cd, award_title, dsp_description,
       gs_description, closed_ind
  FROM   apps.igs_ps_awd_v
 WHERE  closed_ind = 'N'
 ORDER BY award_title;

To locate an award by its testamur description, filter on the searched column directly:

SELECT award_cd, award_title, dsp_description
  FROM   apps.igs_ps_awd_v
 WHERE  UPPER(dsp_description) LIKE UPPER('%:search%');

Because DSP_DESCRIPTION and GS_DESCRIPTION originate from outer joins, reports should tolerate NULLs in those columns and fall back to the raw codes TESTAMUR_TYPE or GRADING_SCHEMA_CD where necessary. Callers should also apply the standard IGS security and MOAC predicates appropriate to their implementation, since the view itself carries no operating unit filter.