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_ITM_EXAM_MTRL

Object Details

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

IGS_AS_ITM_EXAM_MTRL describes allowed, disallowed, and supplied materials for an examination.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_AS_ITM_EXAM_MTRL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ASS_ID EXAM_MATERIAL_TYPE
IGS_AS_ITM_EXAM_MTRL_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EXAM_MATERIAL_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
ASS_ID	NUMBER	(10)	Yes	The ID number of the assessment item to which the exam materials apply to. The assessment ID is a system generated number which is used to uniquely identify an assessment item.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
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
EXAM_MATERIAL_TYPE	VARCHAR2	(10)	Yes	The code of an allowed, not allowed or supplied examination material type for the examination. For example, calculator, textbooks, multichoice answer sheets, ten page writing booklet.
S_MATERIAL_CAT	VARCHAR2	(10)	Yes	The system category of the examination material type. The three categories are allowable, non-allowable, and supplied.
QUANTITY_PER_STUDENT	NUMBER	(3)		The quantity of the exam material type to be supplied to each student for the assessment item. For example, the number of answer booklets. Quantity is applicable only for supplied materials.
COMMENTS	VARCHAR2	(2000)		Any additional information or detail about the examination materials.

Query Text

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


SELECT ASS_ID
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      EXAM_MATERIAL_TYPE
,      S_MATERIAL_CAT
,      QUANTITY_PER_STUDENT
,      COMMENTS
FROM IGS.IGS_AS_ITM_EXAM_MTRL;

Dependencies

[top of page]

IGS.IGS_AS_ITM_EXAM_MTRL does not reference any database object

IGS.IGS_AS_ITM_EXAM_MTRL is referenced by following:

APPS: IGS_AS_ITM_EXAM_MTRL