Product: | IGS - Student System (Obsolete) |
---|---|
Description: | Defines the configuration details like core type indicator, priority in selecting the units for marks calculation etc. |
Implementation/DBA Data: | Not implemented in this database |
SELECT ULMD.ROWID ROW_ID
, ULMD.MARK_CONFIG_ID
, ULMD.CORE_INDICATOR_CODE
, LKUP1.MEANING AS CORE_INDICATOR_DESC
, ULMD.TOTAL_CREDITS
, ULMD.REQUIRED_FLAG
, ULMD.PRIORITY_NUM
, ULMD.UNIT_SELECTION_CODE
, LKUP2.MEANING AS UNIT_SELECTION_DESC
, ULMD.CREATED_BY
, ULMD.CREATION_DATE
, ULMD.LAST_UPDATED_BY
, ULMD.LAST_UPDATE_DATE
, ULMD.LAST_UPDATE_LOGIN
FROM IGS_PR_UL_MARK_DTL ULMD
, IGS_LOOKUP_VALUES LKUP1
, IGS_LOOKUP_VALUES LKUP2
WHERE ULMD.CORE_INDICATOR_CODE = LKUP1.LOOKUP_CODE
AND LKUP1.LOOKUP_TYPE = 'IGS_PS_CORE_IND'
AND ULMD.UNIT_SELECTION_CODE = LKUP2.LOOKUP_CODE
AND LKUP2.LOOKUP_TYPE = 'IGS_PR_UNIT_SELECTION'