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_ASSESSMNT_TYP

Object Details

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

IGS_AS_ASSESSMNT_TYP describes possible types of assessment items.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_AS_ASSESSMNT_TYP_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ASSESSMENT_TYPE
IGS_AS_ASSESSMNT_TYP_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	S_ASSESSMENT_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
LAST_UPDATE_LOGIN	NUMBER	(15)		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
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
ASSESSMENT_TYPE	VARCHAR2	(10)	Yes	Displays the name of the assessment type. Each assessment item is assigned an assessment type, in order to classify the item. Assessment types can be either examinable or non-examinable, and are optionally mapped to a system assessment type; for example, NONCTL - non-centrally managed examination, assignment.
S_ASSESSMENT_TYPE	VARCHAR2	(10)		Displays the system assessment type to that the institution-defined assessment type is optionally mapped. The currently available types are assignment and noncentral examinations that are not centrally managed.
DESCRIPTION	VARCHAR2	(60)	Yes	Describes the assessment type. Each assessment item is assigned an assessment type, in order to classify the item. Assessment types can be either examinable or non-examinable and are optionally mapped to a system assessment type; for example, noncentral - non-centrally managed examination, assignment. Assessment items that have an assessment type that is mapped to a system assessment type are available for specific system functionality; for example, the system assessment type assignment enables the assignment tracking facility for assessment items of type assignment.
EXAMINABLE_IND	VARCHAR2	(1)	Yes	Indicates and specifies that the assessment type is examinable or non-examinable. Selecting the checkbox selected, identifies assessment items with the specified assessment type as examinable and makes the assessment item available for timetabling, if it is also flagged as scheduled. The indicator also determines that fields are displayed in ASSF2100 when assessment items are created or modified.
CLOSED_IND	VARCHAR2	(1)	Yes	Indicates and specifies if the assessment type is open or closed. Setting the checkbox to 'closed' selected prevents allocation of the assessment type to assessment items.
ANON_GRADING_IND	VARCHAR2	(1)		Anonymous Grading Y / N

Query Text

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


SELECT LAST_UPDATE_LOGIN
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      CREATED_BY
,      ASSESSMENT_TYPE
,      S_ASSESSMENT_TYPE
,      DESCRIPTION
,      EXAMINABLE_IND
,      CLOSED_IND
,      ANON_GRADING_IND
FROM IGS.IGS_AS_ASSESSMNT_TYP;

Dependencies

[top of page]

IGS.IGS_AS_ASSESSMNT_TYP does not reference any database object

IGS.IGS_AS_ASSESSMNT_TYP is referenced by following:

APPS: IGS_AS_ASSESSMNT_TYP