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]

VIEW: APPS.IGSFV_AS_ASSESSMENT_ITEMS

Object Details

Object Name:	IGSFV_AS_ASSESSMENT_ITEMS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGSFV_AS_ASSESSMENT_ITEMS
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

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.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ASSESSMENT_ITEM_DESCRIPTION	VARCHAR2	(180)	Yes	Describes an assessment item.
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_TYPE_DESCRIPTION	VARCHAR2	(60)	Yes	Describes the assessment type.
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.
_LA:EXAM_SCHEDULED_INDICATOR	CHAR	(58)		Specifies whether or not the examinable assessment item is to be included in the exam time table.
EXAM_SUPERVISOR_INSTRUCTIONS	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_INSTRUCTIONS	VARCHAR2	(2000)		Displays textual information about materials that students are allowed to take into the examination.
EXAM_NON_ALLOWED_INSTRUCTIONS	VARCHAR2	(2000)		Displays textual information about materials that students are not allowed to take into the examination.
EXAM_SUPPLIED_INSTRUCTIONS	VARCHAR2	(2000)		Displays textual information about materials to be supplied to students undertaking the examination.
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.
ASSESSMENT_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.
COMMENTS	VARCHAR2	(2000)		Displays additional information or details about a non-examinable assessment item.
_LA:CLOSED_INDICATOR	CHAR	(50)		Indicates whether the assessment item is closed or not
_DF	CHAR	(35)
ASSESSMENT_ID	NUMBER	(10)	Yes	System generated number 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

Query Text

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


SELECT ASSESSMENT_ITEM_DESCRIPTION
,      ASSESSMENT_TYPE
,      ASSESSMENT_TYPE_DESCRIPTION
,      EXAM_SHORT_PAPER_NAME
,      EXAM_PAPER_NAME
,      EXAM_WORKING_TIME
,      EXAM_PERUSAL_TIME
,      _LA:EXAM_SCHEDULED_INDICATOR
,      EXAM_SUPERVISOR_INSTRUCTIONS
,      EXAM_ANNOUNCEMENTS
,      EXAM_ALLOWABLE_INSTRUCTIONS
,      EXAM_NON_ALLOWED_INSTRUCTIONS
,      EXAM_SUPPLIED_INSTRUCTIONS
,      EXAM_CONSTRAINTS
,      QUESTION_OR_TITLE
,      ASSESSMENT_LENGTH_OR_DURATION
,      COMMENTS
,      _LA:CLOSED_INDICATOR
,      _DF
,      ASSESSMENT_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSFV_AS_ASSESSMENT_ITEMS;

Dependencies

[top of page]

APPS.IGSFV_AS_ASSESSMENT_ITEMS references the following:

APPS: IGS_AS_ASSESSMNT_ITM_ALL; IGS_AS_ASSESSMNT_TYP

APPS.IGSFV_AS_ASSESSMENT_ITEMS is not referenced by any database object