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_AS_ITEM_ASSESSOR

Object Details

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

IGS_AS_ITEM_ASSESSOR describes assessors applicable for assessment items.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_AS_ITEM_ASSESSOR_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ASS_ID PERSON_ID SEQUENCE_NUMBER
IGS_AS_ITEM_ASSESSOR_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	UNIT_CLASS
IGS_AS_ITEM_ASSESSOR_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	UNIT_MODE
IGS_AS_ITEM_ASSESSOR_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PERSON_ID
IGS_AS_ITEM_ASSESSOR_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LOCATION_CD
IGS_AS_ITEM_ASSESSOR_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ASS_ASSESSOR_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
ASS_ID	NUMBER	(10)	Yes	The ID number of the assessment item to which the assessor is allocated. The assessment ID is a system generated number which is used to uniquely identify an assessment item.
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
PERSON_ID	NUMBER	(15)	Yes	The person ID of the assessor.
SEQUENCE_NUMBER	NUMBER	(6)	Yes	The internal sequence number, required as a person can be an assessor for more than one location, mode or class.
ASS_ASSESSOR_TYPE	VARCHAR2	(10)	Yes	The assessor type of the assessment item assessor. Assessor type is a means of classifying assessors. For example, external marker, Internal marker, chief assessor.
PRIMARY_ASSESSOR_IND	VARCHAR2	(1)	Yes	An indicator which specifies whether this assessor is the primary assessor chief assessor for the assessment item. Setting the checkbox ticked identifies the assessor as the primary assessor.
ITEM_LIMIT	NUMBER	(5)		The maximum number of assessment items-usually assignments that the assessor should be allocated. This value is used by the assignment tracking process to limit the number of assignments sent to each assessor for marking.
LOCATION_CD	VARCHAR2	(10)		The location to which the assessor is allocated for the assessment item. If a location is not specified, the assessor is considered to be available for all locations.
UNIT_MODE	VARCHAR2	(10)		The unit mode to which the assessor is allocated for the assessment item. If the mode is not specified, the assessor is considered to be available to all modes.
UNIT_CLASS	VARCHAR2	(10)		The class to which the assessor is allocated for the assessment item. If a class is not specified, the assessor is considered to be available to all classes.
COMMENTS	VARCHAR2	(2000)		Provides any additional information or details about the assessment item assessor

Query Text

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


SELECT ASS_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PERSON_ID
,      SEQUENCE_NUMBER
,      ASS_ASSESSOR_TYPE
,      PRIMARY_ASSESSOR_IND
,      ITEM_LIMIT
,      LOCATION_CD
,      UNIT_MODE
,      UNIT_CLASS
,      COMMENTS
FROM IGS.IGS_AS_ITEM_ASSESSOR;

Dependencies

[top of page]

IGS.IGS_AS_ITEM_ASSESSOR does not reference any database object

IGS.IGS_AS_ITEM_ASSESSOR is referenced by following:

APPS: IGS_AS_ITEM_ASSESSOR