[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | Contains Items for which a student can be assessed |
| Implementation/DBA Data: | Not implemented in this database |
SELECT ROW_ID ROW_ID
, AI.ASS_ID
, AI.ASSESSMENT_TYPE
, AI.DESCRIPTION
, AI.EXAM_SHORT_PAPER_NAME
, AI.EXAM_PAPER_NAME
, AI.EXAM_WORKING_TIME
, AI.EXAM_PERUSAL_TIME
, AI.EXAM_SCHEDULED_IND
, 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.CREATED_BY
, AI.CREATION_DATE
, AI.LAST_UPDATED_BY
, AI.LAST_UPDATE_DATE
, AI.LAST_UPDATE_LOGIN
, AI.COMMENTS
, AST.DESCRIPTION
, AST.EXAMINABLE_IND
, AST.CLOSED_IND
, AST.ANON_GRADING_IND
, AI.ATTRIBUTE_CATEGORY
, AI.ATTRIBUTE1
, AI.ATTRIBUTE2
, AI.ATTRIBUTE3
, AI.ATTRIBUTE4
, AI.ATTRIBUTE5
, AI.ATTRIBUTE6
, AI.ATTRIBUTE7
, AI.ATTRIBUTE8
, AI.ATTRIBUTE9
, AI.ATTRIBUTE10
, AI.ATTRIBUTE11
, AI.ATTRIBUTE12
, AI.ATTRIBUTE13
, AI.ATTRIBUTE14
, AI.ATTRIBUTE15
, AI.ATTRIBUTE16
, AI.ATTRIBUTE17
, AI.ATTRIBUTE18
, AI.ATTRIBUTE19
, AI.ATTRIBUTE20
, AI.CLOSED_IND
FROM IGS_AS_ASSESSMNT_ITM AI
, IGS_AS_ASSESSMNT_TYP AST
WHERE AST.ASSESSMENT_TYPE = AI.ASSESSMENT_TYPE