Product: | IGS - Student System (Obsolete) |
---|---|
Description: | Defines the configuration for calculating the marks at unt level. |
Implementation/DBA Data: | Not implemented in this database |
SELECT AHB.ROWID ROW_ID
, AHB. AWD_HNR_BASIS_ID
, AHB.AWARD_CD
, AHB.UNIT_LEVEL
, UL.DESCRIPTION UNIT_LEVEL_DESC
, AHB.WEIGHTED_AVERAGE
, AHB. STAT_TYPE
, AHB.S_STAT_ELEMENT
, LKUP.MEANING AS S_STAT_ELE_MEANING
, AHB.TIMEFRAME
, AHB.CREATED_BY
, AHB.CREATION_DATE
, AHB.LAST_UPDATED_BY
, AHB.LAST_UPDATE_DATE
, AHB.LAST_UPDATE_LOGIN
FROM IGS_PS_AWD_HNR_BASE AHB
, IGS_PS_UNIT_LEVEL_ALL UL
, IGS_LOOKUP_VALUES LKUP
WHERE AHB.UNIT_LEVEL = UL.UNIT_LEVEL(+)
AND AHB.S_STAT_ELEMENT = LKUP.LOOKUP_CODE(+)
AND LKUP.LOOKUP_TYPE (+)= 'SYSTEM_STAT_ELEMENT'