VIEW: APPS.IGSBV_AS_SU_ATMPT_OUTCOMES

Source

View Text - Preformatted

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

View Text - HTML Formatted

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