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.

DBA Data [Home] [Help] [Dependency Information]

TABLE: IGS.IGS_DA_CNFG_FTR

Object Details

Object Name:	IGS_DA_CNFG_FTR
Object Type:	TABLE
Owner:	IGS
FND Design Data:	IGS.IGS_DA_CNFG_FTR
Subobject Name:
Status:	VALID

Storage of Degree Audit configuration on Features allowed on the Request Screen.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_DA_CNFG_FTR_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	REQUEST_TYPE_ID FEATURE_CODE
IGS_DA_CNFG_FTR_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	FEATURE_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
REQUEST_TYPE_ID	NUMBER	(15)	Yes	Sequence ID for the table to have multiple request types allowed to choose for request
FEATURE_CODE	VARCHAR2	(30)	Yes	Holds the feature code for relation to FTR_VAL_MAP
FEATURE_NAME	VARCHAR2	(30)		Configuration screen choice. Indicates value from lookup Degree Audit Request Features selected for configuration which is associated with request mode + person type + request type combination -- Obsolete
CONFIGURE_FLAG	VARCHAR2	(1)		Configuration screen choice. Indicates if the selected request feature value is selected to be configured for the request type + person type + request mode combination.
DISPLAY_FLAG	VARCHAR2	(1)		Configuration screen choice. Indicates if the selected request feature should be displayed on the degree audit/transfer evaluation request screen for the request type + person type + request mode combination
FEATURE_VALUE	VARCHAR2	(30)		Selected feature value from the options given for feature values
FORCE_VALUE_FLAG	VARCHAR2	(1)		Configuration screen choice. Y or N. Indicates that the selected feature value is the pre-selected value
DEFAULT_VALUE_FLAG	VARCHAR2	(1)		Configuration screen choice. Y or N
CREATION_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT REQUEST_TYPE_ID
,      FEATURE_CODE
,      FEATURE_NAME
,      CONFIGURE_FLAG
,      DISPLAY_FLAG
,      FEATURE_VALUE
,      FORCE_VALUE_FLAG
,      DEFAULT_VALUE_FLAG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM IGS.IGS_DA_CNFG_FTR;

Dependencies

[top of page]

IGS.IGS_DA_CNFG_FTR does not reference any database object

IGS.IGS_DA_CNFG_FTR is referenced by following:

APPS: IGS_DA_CNFG_FTR