eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: IGS_DA_CNFG_FTR_V

Product:	IGS - Student System (Obsolete)
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT DAC.ROWID ROW_ID
, DAC.REQUEST_TYPE_ID
, DAC.CONFIGURE_FLAG
, DAC.DISPLAY_FLAG
, DAC.FEATURE_VALUE
, (SELECT FEATURE_VALUE_MEANING
FROM IGS_DA_FTR_VALUES FVA
WHERE FVA.FEATURE_CODE = DAC.FEATURE_CODE
AND FVA.FEATURE_VALUE = DAC.FEATURE_VALUE UNION SELECT DAC.FEATURE_VALUE
FROM IGS_DA_CNFG_FTR DAC1
WHERE DAC.FEATURE_CODE IN ('DAT'
, 'TIM') ) FEATURE_VALUE_MEANING
, DAC.FORCE_VALUE_FLAG
, DAC.DEFAULT_VALUE_FLAG
, DAC.CREATION_DATE
, DAC.CREATED_BY
, DAC.LAST_UPDATE_LOGIN
, DAC.LAST_UPDATED_BY
, DAC.LAST_UPDATE_DATE
, DAC.FEATURE_CODE
, LKUP1.MEANING FEATURE_CODE_MEANING
, FRT.TRANSFER_EVALUATION_IND
FROM IGS_DA_CNFG_FTR DAC
, IGS_LOOKUP_VALUES LKUP1
, IGS_DA_FTR_VAL_MAP FRT
WHERE LKUP1.LOOKUP_TYPE = 'IGS_DA_RQST_FEATURES'
AND DAC.FEATURE_CODE = LKUP1.LOOKUP_CODE
AND FRT.FEATURE_CODE = DAC.FEATURE_CODE

Columns

Name
ROW_ID
REQUEST_TYPE_ID
CONFIGURE_FLAG
DISPLAY_FLAG
FEATURE_VALUE
FEATURE_VALUE_MEANING
FORCE_VALUE_FLAG
DEFAULT_VALUE_FLAG
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
LAST_UPDATED_BY
LAST_UPDATE_DATE
FEATURE_CODE
FEATURE_CODE_MEANING
TRANSFER_EVALUATION_IND