[Home] [Help]
View: IGS_DA_CNFG_STAT_V
Product: | IGS - Student System (Obsolete) |
Description: | View is used for getting the GPA calculation setups. |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT DCS.ROWID ROW_ID
, DCS.REQUEST_TYPE_ID
, DCS.STAT_TYPE
, DCS.TIMEFRAME
, DCS.CREATION_DATE
, DCS.CREATED_BY
, DCS.LAST_UPDATE_LOGIN
, DCS.LAST_UPDATED_BY
, DCS.LAST_UPDATE_DATE
, PST.DESCRIPTION STAT_TYPE_MEANING
, LKUP.MEANING TIMEFRAME_MEANING
FROM IGS_DA_CNFG_STAT DCS
, IGS_PR_STAT_TYPE PST
, IGS_LOOKUP_VALUES LKUP
WHERE PST.STAT_TYPE = DCS.STAT_TYPE
AND DCS.TIMEFRAME = LKUP.LOOKUP_CODE
AND LKUP.LOOKUP_TYPE = 'IGS_DA_STAT_TIME_FRAME'
Columns
Name |
ROW_ID |
REQUEST_TYPE_ID |
STAT_TYPE |
TIMEFRAME |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_LOGIN |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
STAT_TYPE_MEANING |
TIMEFRAME_MEANING |