Product: | IGS - Student System (Obsolete) |
---|---|
Description: | Describes a student unit attempt outcome |
Implementation/DBA Data: | Not implemented in this database |
SELECT HP.PARTY_NAME
, HP.PARTY_NUMBER
, SUAO.COURSE_CD
, CRV.TITLE
, SUAO.UNIT_CD
, UV.TITLE
, SUAO.CAL_TYPE
, SUAO.CI_SEQUENCE_NUMBER
, CI.DESCRIPTION
, SUAO.OUTCOME_DT
, SUAO.MARK
, SUAO.GRADE
, '_LA:SUAO.FINALISED_OUTCOME_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, '_LA:SUAO.GRADING_PERIOD_CD:IGS_LOOKUP_VALUES:AS_GRADING_PERIOD:MEANING'
, SUAO.TRANSLATED_DT
, SUAO.TRANSLATED_GRADE
, SUAO.CI_START_DT
, SUAO.CI_END_DT
, SUAO.NUMBER_TIMES_KEYED
, SUAO.INCOMP_DEADLINE_DATE
, SUAO.INCOMP_DEFAULT_GRADE
, SUAO.INCOMP_DEFAULT_MARK
, SUAO.COMMENTS
, '_LA:SUAO.S_GRADE_CREATION_METHOD_TYPE:IGS_LOOKUP_VALUES:GRADE_CREATION_METHOD_TYPE:MEANING'
, SUAO.PERSON_ID
, SUAO.GRADING_SCHEMA_CD
, SUAO.VERSION_NUMBER
, SUA.VERSION_NUMBER
, SCA.VERSION_NUMBER
, SUAO.INCOMP_GRADING_SCHEMA_CD
, SUAO.INCOMP_VERSION_NUMBER
, SUAO.TRANSLATED_GRADING_SCHEMA_CD
, SUAO.TRANSLATED_VERSION_NUMBER
, SUAO.CREATED_BY
, SUAO.CREATION_DATE
, SUAO.LAST_UPDATED_BY
, SUAO.LAST_UPDATE_DATE
, SUAO.UOO_ID
, '_LA:SUAO.MARK_CAPPED_FLAG:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, '_LA:SUAO.SHOW_ON_ACADEMIC_HISTRY_FLAG:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, SUAO.RELEASE_DATE
, '_LA:SUAO.MANUAL_OVERRIDE_FLAG:IGS_LOOKUP_VALUES:YES_NO:MEANING'
FROM IGS_AS_SU_STMPTOUT_ALL SUAO
, IGS_EN_SU_ATTEMPT_ALL SUA
, IGS_EN_STDNT_PS_ATT_ALL SCA
, HZ_PARTIES HP
, IGS_CA_INST_ALL CI
, IGS_PS_UNIT_VER_ALL UV
, IGS_PS_VER_ALL CRV
WHERE SUAO.PERSON_ID = HP.PARTY_ID AND SUAO.PERSON_ID = SUA.PERSON_ID
AND SUAO.COURSE_CD = SUA.COURSE_CD AND SUAO.UOO_ID = SUA.UOO_ID
AND SUAO.PERSON_ID = SCA.PERSON_ID
AND SUAO.COURSE_CD = SCA.COURSE_CD
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 SUAO.CAL_TYPE = CI.CAL_TYPE AND SUAO.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER WITH READ ONLY