[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | Describes assessment item allocated to student unit attempt, either manually or by unit's default assessment items. |
| Implementation/DBA Data: | Not implemented in this database |
SELECT HP.PARTY_NAME
, HP.PARTY_NUMBER
, DECODE ( SUAI.UNIT_SECTION_ASS_ITEM_ID
, NULL
, NVL ( (SELECT AUI.DESCRIPTION
FROM IGS_AS_UNITASS_ITEM_ALL AUI
WHERE AUI.UNIT_ASS_ITEM_ID = SUAI.UNIT_ASS_ITEM_ID)
, AI.DESCRIPTION )
, NVL ( (SELECT PS.DESCRIPTION
FROM IGS_PS_UNITASS_ITEM PS
WHERE PS.UNIT_SECTION_ASS_ITEM_ID = SUAI.UNIT_SECTION_ASS_ITEM_ID)
, AI.DESCRIPTION ) ) ASSESSMENT_ITEM
, SUAI.COURSE_CD
, CRV.TITLE
, SUAI.UNIT_CD
, UV.TITLE
, SUAI.CAL_TYPE
, SUAI.CI_SEQUENCE_NUMBER
, CI.DESCRIPTION
, SUAI.GRADE
, SUAI.MARK
, SUAI.CREATION_DT
, '_LA:SUAI.S_DEFAULT_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, SUAI.OUTCOME_DT
, SUAI.OVERRIDE_DUE_DT
, SUAI.PERFORMANCE
, '_LA:SUAI.OUTCOME_COMMENT_CODE:IGS_LOOKUP_VALUES:MARKS_GRADE_CHANGE_COMMENT:MEANING'
, UAP.DESCRIPTION
, TI.TRACKING_STATUS
, GS.DESCRIPTION
, SUAI.GRADING_SCHEMA_CD
, SUAI.GS_VERSION_NUMBER
, SUA.VERSION_NUMBER
, SCA.VERSION_NUMBER
, SUAI.PERSON_ID
, SUAI.ASS_ID
, NULL
, /* SUAI.ASS_PATTERN_ID
, */ SUAI.TRACKING_ID
, SUAI.ATTEMPT_NUMBER
, SUAI.LOGICAL_DELETE_DT
, SUAI.CREATED_BY
, SUAI.CREATION_DATE
, SUAI.LAST_UPDATED_BY
, SUAI.LAST_UPDATE_DATE
, SUAI.UOO_ID
, SUAI.SUA_ASS_ITEM_GROUP_ID
, SUAG.GROUP_NAME SUA_ASS_ITEM_GROUP_NAME
, '_LA:SUAI.MIDTERM_MANDATORY_TYPE_CODE:IGS_LOOKUP_VALUES:IGS_AS_AI_MANDATORY_TYPES:MEANING'
, SUAI.MIDTERM_WEIGHT_QTY
, '_LA:SUAI.FINAL_MANDATORY_TYPE_CODE:IGS_LOOKUP_VALUES:IGS_AS_AI_MANDATORY_TYPES:MEANING'
, SUAI.FINAL_WEIGHT_QTY
, SUAI.SUBMITTED_DATE
, '_LA:SUAI.WAIVED_FLAG:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, '_LA:SUAI.PENALTY_APPLIED_FLAG:IGS_LOOKUP_VALUES:YES_NO:MEANING'
FROM IGS_AS_SU_ATMPT_ITM SUAI
, IGS_AS_SUA_AI_GROUP SUAG
, IGS_EN_SU_ATTEMPT_ALL SUA
, IGS_EN_STDNT_PS_ATT_ALL SCA
, IGS_PS_UNIT_VER_ALL UV
, IGS_PS_VER_ALL CRV
, IGS_AS_ASSESSMNT_ITM_ALL AI
, IGS_CA_INST_ALL CI
, IGS_TR_ITEM_ALL TI
, IGS_AS_UNTAS_PATTERN_ALL UAP
, IGS_AS_GRD_SCHEMA GS
, HZ_PARTIES HP
WHERE SUAI.SUA_ASS_ITEM_GROUP_ID = SUAG.SUA_ASS_ITEM_GROUP_ID
AND SUAI.PERSON_ID = HP.PARTY_ID
AND SUAI.PERSON_ID = SUA.PERSON_ID AND SUAI.COURSE_CD = SUA.COURSE_CD AND SUAI.UOO_ID = SUA.UOO_ID AND SUAI.PERSON_ID = SCA.PERSON_ID AND SUAI.COURSE_CD = SCA.COURSE_CD AND SUAI.ASS_ID = AI.ASS_ID
AND SUA.UNIT_CD = UV.UNIT_CD
AND SUA.VERSION_NUMBER = UV.VERSION_NUMBER AND SCA.COURSE_CD = CRV.COURSE_CD AND SCA.VERSION_NUMBER = CRV.VERSION_NUMBER AND SUAI.CAL_TYPE = CI.CAL_TYPE AND SUAI.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER
AND SUAI.TRACKING_ID = TI.TRACKING_ID (+) AND SUAI.ASS_PATTERN_ID = UAP.ASS_PATTERN_ID (+) AND SUAI.GRADING_SCHEMA_CD = GS.GRADING_SCHEMA_CD (+)
AND SUAI.GS_VERSION_NUMBER = GS.VERSION_NUMBER (+) WITH READ ONLY