Search Results system_stat_element




Overview
Explore in AI Chat

Overview

IGS_PS_AWD_HNR_BASE_V is an Oracle E-Business Suite view owned by the APPS schema and defined in the Student System (IGS) product family. It presents award honor basis records, providing a denormalized, reporting-friendly projection of the IGS_PS_AWD_HNR_BASE table joined to unit level and lookup value reference data. The view exists to shield reporting tools, concurrent programs, and integration interfaces from the underlying normalized schema, resolving foreign key codes into human-readable descriptions without requiring the consuming process to perform its own joins.

The view is particularly relevant to the search term "system_stat_element," because it exposes the S_STAT_ELEMENT column and resolves that code through the IGS_LOOKUP_VALUES table restricted to LOOKUP_TYPE of 'SYSTEM_STAT_ELEMENT'. This makes the view the natural entry point for any report or interface that needs to present statistical element context for award honors calculations. It is a read-only construct; all DML must be directed at the base table.

Underlying Base Objects

The view is defined over three objects using Oracle's outer-join syntax (the legacy (+) operator), which renders it compatible with both EBS 12.1.1 and 12.2.2 database tiers although the 12.2.2 metadata does not enumerate base objects explicitly.

  • IGS_PS_AWD_HNR_BASE AHB — the driving table, holding the award honor basis rows, including award code, unit level, weighting and statistical element attributes.
  • IGS_PS_UNIT_LEVEL_ALL UL — joined on AHB.UNIT_LEVEL = UL.UNIT_LEVEL to supply the unit level description; the outer join ensures rows survive when no unit level description exists.
  • IGS_LOOKUP_VALUES LKUP — joined on AHB.S_STAT_ELEMENT = LKUP.LOOKUP_CODE with the constant LOOKUP_TYPE = 'SYSTEM_STAT_ELEMENT'. This is the join that gives the view its statistical element meaning.

Because all reference joins are outer joins, the view never loses a base row due to missing reference data, which is important for interfaces that must process every award honor basis record regardless of setup completeness.

Key Columns

Common Use Cases and Queries

Typical uses include awards reporting, validation of statistical element setup, and extracts feeding honor or progression calculations. A baseline query follows.

  • SELECT awd_hnr_basis_id, award_cd, unit_level_desc, s_stat_element, s_stat_ele_meaning, weighted_average FROM apps.igs_ps_awd_hnr_base_v ORDER BY award_cd, unit_level;
  • SELECT * FROM apps.igs_ps_awd_hnr_base_v WHERE s_stat_element = :p_stat_element; — retrieves all honor basis rows for a given statistical element code.
  • SELECT DISTINCT s_stat_element, s_stat_ele_meaning FROM apps.igs_ps_awd_hnr_base_v ORDER BY 1; — lists the statistical elements actually referenced, independent of the full lookup set.

Filtering on S_STAT_ELEMENT is preferable to filtering on S_STAT_ELE_MEANING, since codes are stable while meanings are subject to translation.