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_ASSESSOR_TYPE

Object Details

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

IGS_AS_ASSESSOR_TYPE describes available user-defined assessor types.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_AS_ASSESSOR_TYPE_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ASS_ASSESSOR_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
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
ASS_ASSESSOR_TYPE	VARCHAR2	(10)	Yes	Describes the assessor type name. Assessor type describes the type of assessor allocated to an assessment item. For example, EXT-MARKER - external marker, Int Marker- Internal Marker, and UNIT_CHAIR - Chair of assessment panel.
DESCRIPTION	VARCHAR2	(60)	Yes	Describes assessor type. Assessor type describes the type of assessor allocated to an assessment item. For example, EXT-MARKER-external marker, Int-Marker-internal marker, and UNIT_CHAIR- Chair of assessment panel.
DFLT_IND	VARCHAR2	(1)	Yes	Specifies whether the assessor type is the default type assigned to the assessor record which is created by the system each time a unit assessment item is created. Selecting the check box ticked makes the assessor type the default. There can be only one default assessor type.
CLOSED_IND	VARCHAR2	(1)	Yes	Specifies if the assessor type is open or closed. Selecting the checkbox to 'closed' ticked prevents further use of the assessor type in assessor records. Existing assessor records are not affected.
CREATED_BY	NUMBER	(15)	Yes	Standard Who column

Query Text

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


SELECT CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ASS_ASSESSOR_TYPE
,      DESCRIPTION
,      DFLT_IND
,      CLOSED_IND
,      CREATED_BY
FROM IGS.IGS_AS_ASSESSOR_TYPE;

Dependencies

[top of page]

IGS.IGS_AS_ASSESSOR_TYPE does not reference any database object

IGS.IGS_AS_ASSESSOR_TYPE is referenced by following:

APPS: IGS_AS_ASSESSOR_TYPE