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.

[Home] [Help]

View: IGSFV_AS_ASSESSMENT_ITEMS

Product:	IGS - Student System (Obsolete)
Description:	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 dur
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT AI.DESCRIPTION
, AI.ASSESSMENT_TYPE
, ATYP.DESCRIPTION
, AI.EXAM_SHORT_PAPER_NAME
, AI.EXAM_PAPER_NAME
, AI.EXAM_WORKING_TIME
, AI.EXAM_PERUSAL_TIME
, '_LA:AI.EXAM_SCHEDULED_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, AI.EXAM_SUPERVISOR_INSTRCTN
, AI.EXAM_ANNOUNCEMENTS
, AI.EXAM_ALLOWABLE_INSTRCTN
, AI.EXAM_NON_ALLOWED_INSTRCTN
, AI.EXAM_SUPPLIED_INSTRCTN
, AI.EXAM_CONSTRAINTS
, AI.QUESTION_OR_TITLE
, AI.ASS_LENGTH_OR_DURATION
, AI.COMMENTS
, '_LA:AI.CLOSED_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, '_DF:IGS:IGS_AS_ASS_ITM_DESC_FLEX:AI'
, AI.ASS_ID
, AI.CREATED_BY
, AI.CREATION_DATE
, AI.LAST_UPDATED_BY
, AI.LAST_UPDATE_DATE
FROM IGS_AS_ASSESSMNT_ITM_ALL AI
, IGS_AS_ASSESSMNT_TYP ATYP
WHERE AI.ASSESSMENT_TYPE = ATYP.ASSESSMENT_TYPE WITH READ ONLY

Columns

Name
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