Product: | IGS - Student System (Obsolete) |
---|---|
Description: | Describes assessment items allocated to a unit version within nominated teaching calendar instance. |
Implementation/DBA Data: | Not implemented in this database |
SELECT UAI.REFERENCE
, UAI.DESCRIPTION
, UAI.UNIT_CD
, UAI.VERSION_NUMBER
, UAI.CAL_TYPE
, UAI.CI_SEQUENCE_NUMBER
, UAI.CI_START_DT
, UAI.CI_END_DT
, UAI.ASS_ID
, UAI.SEQUENCE_NUMBER
, UAI.UNIT_ASS_ITEM_GROUP_ID
, '_LA:UAI.MIDTERM_MANDATORY_TYPE_CODE:IGS_LOOKUP_VALUES:IGS_AS_AI_MANDATORY_TYPES:MEANING'
, UAI.MIDTERM_WEIGHT_QTY
, '_LA:UAI.FINAL_MANDATORY_TYPE_CODE:IGS_LOOKUP_VALUES:IGS_AS_AI_MANDATORY_TYPES:MEANING'
, UAI.FINAL_WEIGHT_QTY
, UAI.GRADING_SCHEMA_CD
, UAI.GS_VERSION_NUMBER
, UAI.DUE_DT
, UAI.RELEASE_DATE
, UAI.EXAM_CAL_TYPE
, UAI.EXAM_CI_SEQUENCE_NUMBER
, UAI.ACTION_DT
, '_LA:UAI.DFLT_ITEM_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, UAI.LOGICAL_DELETE_DT
, UAI.UNIT_ASS_ITEM_ID
, UAI.CREATED_BY
, UAI.CREATION_DATE
, UAI.LAST_UPDATED_BY
, UAI.LAST_UPDATE_DATE
FROM IGS_AS_UNITASS_ITEM_ALL UAI WITH READ ONLY