Product: | IGS - Student System (Obsolete) |
---|---|
Description: | This is history view to for tracking the student assessment items outcomes. |
Implementation/DBA Data: | Not implemented in this database |
SELECT SUAAI.ROWID ROW_ID
, SUAAI.PERSON_ID
, SUAAI.COURSE_CD
, SUAAI.UNIT_CD
, SUAAI.CAL_TYPE
, SUAAI.CI_SEQUENCE_NUMBER
, SUAAI.ASS_ID
, SUAAI.CREATION_DT
, SUAAI.GRADING_SCHEMA_CD
, SUAAI.GS_VERSION_NUMBER
, SUAAI.GRADE
, SUAAI.OUTCOME_DT
, SUAAI.MARK
, SUAAI.OUTCOME_COMMENT_CODE
, DECODE(IGS_GE_GEN_004.GENP_GET_LOOKUP('MARKS_GRADE_CHANGE_COMMENT'
, SUAAI.OUTCOME_COMMENT_CODE )
, 'ALL'
, NULL
, IGS_GE_GEN_004.GENP_GET_LOOKUP('MARKS_GRADE_CHANGE_COMMENT'
, SUAAI.OUTCOME_COMMENT_CODE)) OUTCOME_COMMENT_MEANING
, SUAAI.LAST_UPDATE_DATE HIST_START_DT
, TO_DATE(NULL
, 'YYYY-MM-DD') HIST_END_DT
, SUAAI.LAST_UPDATED_BY HIST_WHO
, SUAAI.CREATED_BY
, SUAAI.CREATION_DATE
, SUAAI.LAST_UPDATED_BY
, SUAAI.LAST_UPDATE_DATE
, SUAAI.LAST_UPDATE_LOGIN
, SUAAI.UOO_ID
, SUAAI.SUA_ASS_ITEM_GROUP_ID
, SUAAI.MIDTERM_MANDATORY_TYPE_CODE
, SUAAI.MIDTERM_WEIGHT_QTY
, SUAAI.FINAL_MANDATORY_TYPE_CODE
, SUAAI.FINAL_WEIGHT_QTY
, SUAAI.SUBMITTED_DATE
, SUAAI.WAIVED_FLAG
, SUAAI.PENALTY_APPLIED_FLAG
FROM IGS_AS_SU_ATMPT_ITM SUAAI
, IGS_AS_SUAAI_OUHIST SUAAIH
WHERE SUAAI.PERSON_ID = SUAAIH.PERSON_ID
AND SUAAI.COURSE_CD = SUAAIH.COURSE_CD
AND SUAAI.CREATION_DT = SUAAIH.CREATION_DT
AND SUAAI.ASS_ID = SUAAIH.ASS_ID
AND SUAAI.UOO_ID = SUAAIH.UOO_ID UNION SELECT SUAAIH.ROWID
, SUAAIH.PERSON_ID
, SUAAIH.COURSE_CD
, SUAAIH.UNIT_CD
, SUAAIH.CAL_TYPE
, SUAAIH.CI_SEQUENCE_NUMBER
, SUAAIH.ASS_ID
, SUAAIH.CREATION_DT
, SUAAIH.GRADING_SCHEMA_CD
, SUAAIH.GS_VERSION_NUMBER
, SUAAIH.GRADE
, SUAAIH.OUTCOME_DT
, SUAAIH.MARK
, SUAAIH.OUTCOME_COMMENT_CODE
, DECODE(IGS_GE_GEN_004.GENP_GET_LOOKUP('MARKS_GRADE_CHANGE_COMMENT'
, SUAAIH.OUTCOME_COMMENT_CODE )
, 'ALL'
, NULL
, IGS_GE_GEN_004.GENP_GET_LOOKUP('MARKS_GRADE_CHANGE_COMMENT'
, SUAAIH.OUTCOME_COMMENT_CODE))
, SUAAIH.HIST_START_DT
, SUAAIH .HIST_END_DT
, SUAAIH.HIST_WHO
, SUAAIH.CREATED_BY
, SUAAIH.CREATION_DATE
, SUAAIH.LAST_UPDATED_BY
, SUAAIH.LAST_UPDATE_DATE
, SUAAIH.LAST_UPDATE_LOGIN
, SUAAIH.UOO_ID
, SUAAIH.SUA_ASS_ITEM_GROUP_ID
, SUAAIH.MIDTERM_MANDATORY_TYPE_CODE
, SUAAIH.MIDTERM_WEIGHT_QTY
, SUAAIH.FINAL_MANDATORY_TYPE_CODE
, SUAAIH.FINAL_WEIGHT_QTY
, SUAAIH.SUBMITTED_DATE
, SUAAIH.WAIVED_FLAG
, SUAAIH.PENALTY_APPLIED_FLAG
FROM IGS_AS_SU_ATMPT_ITM SUAAI
, IGS_AS_SUAAI_OUHIST SUAAIH
WHERE SUAAI.PERSON_ID = SUAAIH.PERSON_ID
AND SUAAI.COURSE_CD = SUAAIH.COURSE_CD
AND SUAAI.CREATION_DT = SUAAIH.CREATION_DT
AND SUAAI.ASS_ID = SUAAIH.ASS_ID
AND SUAAI.UOO_ID = SUAAIH.UOO_ID