[Home] [Help]
View: IGS_DA_REQ_FTRS_V
Product: | IGS - Student System (Obsolete) |
Description: | View over Degree Audit Request Features |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT DRF.ROWID
, DRF.BATCH_ID
, DRF.FEATURE_CODE
, LKV1.MEANING
, DRF.FEATURE_VALUE
, (SELECT FEATURE_VALUE_MEANING
FROM IGS_DA_FTR_VALUES FVA
WHERE FVA.FEATURE_CODE = DRF.FEATURE_CODE
AND FVA.FEATURE_VALUE = DRF.FEATURE_VALUE UNION SELECT DRF.FEATURE_VALUE
FROM IGS_DA_CNFG_FTR DAC1
WHERE DRF.FEATURE_CODE IN ('DAT'
, 'TIM') ) FEATURE_VALUE_MEANING
, DRF.CREATION_DATE
, DRF.CREATED_BY
, DRF.LAST_UPDATE_LOGIN
, DRF.LAST_UPDATED_BY
, DRF.LAST_UPDATE_DATE
FROM IGS_DA_REQ_FTRS DRF
, IGS_DA_FTR_VAL_MAP DFVM
, IGS_LOOKUP_VALUES LKV1
WHERE DRF.FEATURE_CODE = DFVM.FEATURE_CODE
AND LKV1.LOOKUP_TYPE = 'IGS_DA_RQST_FEATURES'
AND LKV1.LOOKUP_CODE = DRF.FEATURE_CODE
Columns
Name |
ROW_ID |
BATCH_ID |
FEATURE_CODE |
FEATURE_CODE_MEANING |
FEATURE_VALUE |
FEATURE_VALUE_MEANING |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_LOGIN |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |