Search Results weighted_average

Overview

IGS_PS_AWD_HNR_BASE_V is an Oracle EBS APPS-owned database view within the IGS (Student System) product family. Its documented purpose is to define the configuration used for calculating marks at the unit level, specifically in the context of award honours (AWD_HNR) basis definitions. The view consolidates configuration rows from the underlying honours basis table with descriptive attributes sourced from the unit level and lookup value tables, presenting a denormalised, read-only representation suitable for reporting, integration, and enquiry screens.

The object carries a status of VALID in the documented 12.1.1 / 12.2.2 environment and resides in the APPS schema. Because it is a view rather than a table, it holds no data of its own; its role is to expose a joined, human-readable projection of configuration data used by the Student System's academic progression and award classification logic.

Underlying Base Objects

The view is defined over three base objects, as evidenced by the documented view text:

• IGS_PS_AWD_HNR_BASE (alias AHB) — the primary driving table, contributing the core honours basis configuration columns including AWD_HNR_BASIS_ID, AWARD_CD, UNIT_LEVEL, WEIGHTED_AVERAGE, STAT_TYPE, S_STAT_ELEMENT, and TIMEFRAME, plus the standard WHO audit columns.
• IGS_PS_UNIT_LEVEL_ALL (alias UL) — joined with an outer join (+) on UNIT_LEVEL to supply the descriptive UNIT_LEVEL_DESC.
• IGS_LOOKUP_VALUES (alias LKUP) — outer-joined on S_STAT_ELEMENT with LOOKUP_TYPE restricted to 'SYSTEM_STAT_ELEMENT', supplying the meaning of the statistical element as S_STAT_ELE_MEANING.

Both secondary joins are outer joins, so rows in IGS_PS_AWD_HNR_BASE without a matching unit level or lookup value are still returned, with NULL descriptions. The ETRM metadata does not document any referenced base objects beyond those revealed in the view text.

Key Columns

• ROW_ID — the ROWID of the underlying base table row, exposed for row-level identification.
• AWD_HNR_BASIS_ID — primary identifier for the honours basis configuration record.
• AWARD_CD — the award code to which the calculation configuration applies.
• UNIT_LEVEL / UNIT_LEVEL_DESC — the unit level code and its decrypted description.
• WEIGHTED_AVERAGE — the flag/indicator controlling whether a weighted average is applied when calculating marks at the unit level. This is the attribute most directly associated with the "weighted_average" search term.
• STAT_TYPE — the statistical type classification for the basis.
• S_STAT_ELEMENT / S_STAT_ELE_MEANING — the statistical element code and its meaning, resolved from the SYSTEM_STAT_ELEMENT lookup type.
• TIMEFRAME — the period over which the calculation basis applies.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

The view is typically used to report or verify how weighted averages and statistical elements are configured per award and unit level. A representative query retrieves all honours basis configurations for a given award:

• SELECT awd_hnr_basis_id, award_cd, unit_level, unit_level_desc, weighted_average, stat_type, s_stat_ele_meaning, timeframe FROM igs_ps_awd_hnr_base_v WHERE award_cd = :award_code ORDER BY unit_level;

To isolate records where a weighted average is applied, a filter on the WEIGHTED_AVERAGE column is used, which directly supports the "weighted_average" enquiry. Integration and interface programs may also query the view to obtain the descriptive unit level and statistical element meanings without re-implementing the lookup joins. Because the view performs only outer joins to descriptive tables, it is safe for reporting purposes and does not introduce row loss when descriptive data is absent.