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_AD_RVGR_EVALTR

Object Details

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

IGS_AD_RVGR_EVALTR is the table where all Evaluator corresponding to Application Review Profile related information will be recorded. Here the Review Group Evaluator IDs will be generated and information like Person Number, Evaluation Sequence will be stored. This is not expected to be a 'high transaction' table. Hence it can be classed as 'CLASS3' table as per the storage clause.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_AD_RVGR_EVALTR_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	REVGR_EVALUATOR_ID
IGS_AD_RVGR_EVALTR_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	APPL_REVPROF_REVGR_ID

Columns

Name	Datatype	Length	Mandatory	Comments
REVGR_EVALUATOR_ID	NUMBER	(15)	Yes	Unique Identifier of a Review Group Evaluator.
APPL_REVPROF_REVGR_ID	NUMBER	(15)	Yes	Unique Identifier of a Application Review Profile Review Group.
PERSON_ID	NUMBER	(15)	Yes	Person ID of the person who is an evaluator for the current Review Group.
PERSON_NUMBER	VARCHAR2	(30)	Yes	Person Number of the person who is an evaluator for the current Review Group.
EVALUATION_SEQUENCE	NUMBER	(5)		Sequence number to designate the order in which evaluators should evaluate the applications for a sequential evaluation. For concurrent evaluation value for this field will be null.
PROGRAM_APPROVER_IND	VARCHAR2	(1)	Yes	Indicator to designate an evaluator who is also authorized to do program approval. Valid values can be Yes - 'Y' or No - 'N'.
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column

Query Text

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


SELECT REVGR_EVALUATOR_ID
,      APPL_REVPROF_REVGR_ID
,      PERSON_ID
,      PERSON_NUMBER
,      EVALUATION_SEQUENCE
,      PROGRAM_APPROVER_IND
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM IGS.IGS_AD_RVGR_EVALTR;

Dependencies

[top of page]

IGS.IGS_AD_RVGR_EVALTR does not reference any database object

IGS.IGS_AD_RVGR_EVALTR is referenced by following:

APPS: IGS_AD_RVGR_EVALTR