VIEW: APPS.IGS_AS_SUAO_V

Source

View Text - Preformatted

SELECT PERSON_ID , COURSE_CD , UNIT_CD , cal_type , CI_SEQUENCE_NUMBER , CI_START_DT , CI_END_DT , OUTCOME_DT , GRADING_SCHEMA_CD , VERSION_NUMBER , GRADE , S_GRADE_CREATION_METHOD_TYPE , FINALISED_OUTCOME_IND , MARK , NUMBER_TIMES_KEYED , TRANSLATED_GRADING_SCHEMA_CD , TRANSLATED_VERSION_NUMBER , TRANSLATED_GRADE , TRANSLATED_DT , created_by , creation_date , last_updated_by , last_update_date , last_update_login ,uoo_id, mark_capped_flag, SHOW_ON_ACADEMIC_HISTRY_FLAG, release_date, manual_override_flag FROM IGS_AS_SU_STMPTOUT SUAO WHERE outcome_dt IN (SELECT MAX(outcome_dt) FROM IGS_AS_SU_STMPTOUT WHERE person_id = suao.person_id AND course_cd = suao.course_cd AND uoo_id = suao.uoo_id AND grading_period_cd <> 'MIDTERM') AND grading_period_cd <> 'MIDTERM'

View Text - HTML Formatted

SELECT PERSON_ID
, COURSE_CD
, UNIT_CD
, CAL_TYPE
, CI_SEQUENCE_NUMBER
, CI_START_DT
, CI_END_DT
, OUTCOME_DT
, GRADING_SCHEMA_CD
, VERSION_NUMBER
, GRADE
, S_GRADE_CREATION_METHOD_TYPE
, FINALISED_OUTCOME_IND
, MARK
, NUMBER_TIMES_KEYED
, TRANSLATED_GRADING_SCHEMA_CD
, TRANSLATED_VERSION_NUMBER
, TRANSLATED_GRADE
, TRANSLATED_DT
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, UOO_ID
, MARK_CAPPED_FLAG
, SHOW_ON_ACADEMIC_HISTRY_FLAG
, RELEASE_DATE
, MANUAL_OVERRIDE_FLAG
FROM IGS_AS_SU_STMPTOUT SUAO
WHERE OUTCOME_DT IN (SELECT MAX(OUTCOME_DT)
FROM IGS_AS_SU_STMPTOUT
WHERE PERSON_ID = SUAO.PERSON_ID
AND COURSE_CD = SUAO.COURSE_CD
AND UOO_ID = SUAO.UOO_ID
AND GRADING_PERIOD_CD <> 'MIDTERM')
AND GRADING_PERIOD_CD <> 'MIDTERM'