VIEW: APPS.IGSFV_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', GS1.DESCRIPTION, GS2.DESCRIPTION, 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', igs_as_derive_grade.get_assessment_status( suao.person_id, suao.course_cd, suao.uoo_id, suao.unit_cd) FROM IGS_AS_SU_STMPTOUT_ALL SUAO, HZ_PARTIES HP, IGS_EN_SU_ATTEMPT_ALL SUA, IGS_EN_STDNT_PS_ATT_ALL SCA, IGS_AS_GRD_SCHEMA GS1, IGS_AS_GRD_SCHEMA GS2, 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 AND SUAO.GRADING_SCHEMA_CD = GS1.GRADING_SCHEMA_CD AND SUAO.VERSION_NUMBER = GS1.VERSION_NUMBER AND SUAO.TRANSLATED_GRADING_SCHEMA_CD = GS2.GRADING_SCHEMA_CD (+) AND SUAO.TRANSLATED_VERSION_NUMBER = GS2.VERSION_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'
, GS1.DESCRIPTION
, GS2.DESCRIPTION
, 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'
, IGS_AS_DERIVE_GRADE.GET_ASSESSMENT_STATUS( SUAO.PERSON_ID
, SUAO.COURSE_CD
, SUAO.UOO_ID
, SUAO.UNIT_CD)
FROM IGS_AS_SU_STMPTOUT_ALL SUAO
, HZ_PARTIES HP
, IGS_EN_SU_ATTEMPT_ALL SUA
, IGS_EN_STDNT_PS_ATT_ALL SCA
, IGS_AS_GRD_SCHEMA GS1
, IGS_AS_GRD_SCHEMA GS2
, 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
AND SUAO.GRADING_SCHEMA_CD = GS1.GRADING_SCHEMA_CD
AND SUAO.VERSION_NUMBER = GS1.VERSION_NUMBER
AND SUAO.TRANSLATED_GRADING_SCHEMA_CD = GS2.GRADING_SCHEMA_CD (+)
AND SUAO.TRANSLATED_VERSION_NUMBER = GS2.VERSION_NUMBER (+) WITH READ ONLY