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_ITM_ALL

Object Details

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

IGS_AS_ASSESSMNT_ITM_ALL describes an item a student might be assessed. All items are of a nominated type, as defined by the assessment type assigned. An assessment item can be either an examinable or non-examinable item. Examinable items may require scheduling during examination cycle.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_AS_ASSESSMNT_ITM_ALL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ASS_ID
IGS_AS_ASSESSMNT_ITM_ALL_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ASSESSMENT_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
ASS_ID	NUMBER	(10)	Yes	System generated number is used to uniquely identify an assessment item. An assessment item is a single piece of assessment, that is required by a student to complete as part of, or entire requirements of a unit. An assessment item must first be assigned to one or more unit offerings, before it can be assigned to student unit attempts.
ASSESSMENT_TYPE	VARCHAR2	(10)	Yes	An assessment type is assigned to the an assessment item in order to classify the item; for example, EXAM-CTL centrally managed examination, assignment. Assessment types can be either examinable or non-examinable.
DESCRIPTION	VARCHAR2	(180)	Yes	Describes an assessment item. An assessment item is a single piece of assessment that a student might be required to complete as part of, or as the entire requirements of a unit. An assessment item must be assigned to one or more unit offerings before it can be assigned to student unit attempts.
EXAM_SHORT_PAPER_NAME	VARCHAR2	(50)		Describes short name of the examination paper.
EXAM_PAPER_NAME	VARCHAR2	(90)		Describes long name of the examination paper that is normally printed on the cover sheet of a theory examination.
EXAM_WORKING_TIME	DATE			Displays the amount of time that student has to complete the examination; for example, 3.00 hours.
EXAM_PERUSAL_TIME	DATE			Displays the amount of time allowed for reading the exam paper prior to commencement of the examination; for example 15 minutes.
EXAM_SCHEDULED_IND	VARCHAR2	(1)	Yes	Specifies whether or not the examinable assessment item is to be included in the exam time table. The process that extracts data and exports it to the time table facility and uses this indicator to determine assessment items to be included. Setting the indicator selected causes the assessment item to be included during drawing a timetable.
EXAM_SUPERVISOR_INSTRCTN	VARCHAR2	(2000)		Special instructions to be conveyed to supervisors who are administering the examination.
EXAM_ANNOUNCEMENTS	VARCHAR2	(2000)		Announcements to be made just prior to commencement of or during the examination; for example, please note all students must answer three of five questions in the paper.
EXAM_ALLOWABLE_INSTRCTN	VARCHAR2	(2000)		Displays textual information about materials that students are allowed to take into the examination. This field is normally used to record details of miscellaneous items not available in the reference list of standard materials; for example, the name of a particular text.
EXAM_NON_ALLOWED_INSTRCTN	VARCHAR2	(2000)		Displays textual information about materials that students are not allowed to take into the examination. This field is normally used to enter details of miscellaneous items that are not available in the reference list of standard materials; for example, particular type of calculator.
EXAM_SUPPLIED_INSTRCTN	VARCHAR2	(2000)		Displays textual information about materials to be supplied to students undertaking the examination. This field is normally used to enter details of miscellaneous items that are not available in the reference list of standard materials.
EXAM_CONSTRAINTS	VARCHAR2	(2000)		Constraints to be taken into consideration when scheduling an examination; for example, must be scheduled after paper 1.
QUESTION_OR_TITLE	VARCHAR2	(180)		Displays the non-examinable assessment item question or title; for example, essay topic or title- seminar topic or title.
ASS_LENGTH_OR_DURATION	VARCHAR2	(30)		Displays the length or duration of a non-examinable assessment item; for example, an essay with a length of 2000 words, a seminar with a duration of 15 min.
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
COMMENTS	VARCHAR2	(2000)		Displays additional information or details about a non-examinable assessment item.
ORG_ID	NUMBER	(15)		Operating unit identifier
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive Flexfield structure defining column.
ATTRIBUTE1	VARCHAR2	(150)		Attribute for Descriptive Flexfield.
ATTRIBUTE2	VARCHAR2	(150)		Attribute for Descriptive Flexfield.
ATTRIBUTE3	VARCHAR2	(150)		Attribute for Descriptive Flexfield.
ATTRIBUTE4	VARCHAR2	(150)		Attribute for Descriptive Flexfield.
ATTRIBUTE5	VARCHAR2	(150)		Attribute for Descriptive Flexfield.
ATTRIBUTE6	VARCHAR2	(150)		Attribute for Descriptive Flexfield.
ATTRIBUTE7	VARCHAR2	(150)		Attribute for Descriptive Flexfield.
ATTRIBUTE8	VARCHAR2	(150)		Attribute for Descriptive Flexfield.
ATTRIBUTE9	VARCHAR2	(150)		Attribute for Descriptive Flexfield.
ATTRIBUTE10	VARCHAR2	(150)		Attribute for Descriptive Flexfield.
ATTRIBUTE11	VARCHAR2	(150)		Attribute for Descriptive Flexfield.
ATTRIBUTE12	VARCHAR2	(150)		Attribute for Descriptive Flexfield.
ATTRIBUTE13	VARCHAR2	(150)		Attribute for Descriptive Flexfield.
ATTRIBUTE14	VARCHAR2	(150)		Attribute for Descriptive Flexfield.
ATTRIBUTE15	VARCHAR2	(150)		Attribute for Descriptive Flexfield.
ATTRIBUTE16	VARCHAR2	(150)		Attribute for Descriptive Flexfield.
ATTRIBUTE17	VARCHAR2	(150)		Attribute for Descriptive Flexfield.
ATTRIBUTE18	VARCHAR2	(150)		Attribute for Descriptive Flexfield.
ATTRIBUTE19	VARCHAR2	(150)		Attribute for Descriptive Flexfield.
ATTRIBUTE20	VARCHAR2	(150)		Attribute for Descriptive Flexfield.
CLOSED_IND	VARCHAR2	(1)		Indicates whether the assessment item is closed or not

Query Text

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


SELECT ASS_ID
,      ASSESSMENT_TYPE
,      DESCRIPTION
,      EXAM_SHORT_PAPER_NAME
,      EXAM_PAPER_NAME
,      EXAM_WORKING_TIME
,      EXAM_PERUSAL_TIME
,      EXAM_SCHEDULED_IND
,      EXAM_SUPERVISOR_INSTRCTN
,      EXAM_ANNOUNCEMENTS
,      EXAM_ALLOWABLE_INSTRCTN
,      EXAM_NON_ALLOWED_INSTRCTN
,      EXAM_SUPPLIED_INSTRCTN
,      EXAM_CONSTRAINTS
,      QUESTION_OR_TITLE
,      ASS_LENGTH_OR_DURATION
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      COMMENTS
,      ORG_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      CLOSED_IND
FROM IGS.IGS_AS_ASSESSMNT_ITM_ALL;

Dependencies

[top of page]

IGS.IGS_AS_ASSESSMNT_ITM_ALL does not reference any database object

IGS.IGS_AS_ASSESSMNT_ITM_ALL is referenced by following:

APPS: IGS_AS_ASSESSMNT_ITM_ALL