VIEW: APPS.IGS_AS_SUA_H_V

Source

View Text - Preformatted

SELECT SUAH1.person_id, SUAH1.course_cd, SUAH1.unit_cd, TO_NUMBER(NVL(Igs_Au_Gen_003.audp_get_suah_col('VERSION_NUMBER', SUAH1.person_id, SUAH1.course_cd, SUAH1.hist_end_dt,SUAH1.uoo_id), SUA1.version_number)), SUAH1.cal_type, SUAH1.ci_sequence_number, SUAH1.hist_start_dt, SUAH1.hist_end_dt, SUAH1.hist_who, SUBSTR(NVL(SUAH1.location_cd, NVL(Igs_Au_Gen_003.audp_get_suah_col('LOCATION_CD', SUAH1.person_id, SUAH1.course_cd, SUAH1.hist_end_dt, SUAH1.uoo_id ), SUA1.location_cd)),1,10), SUBSTR(NVL(SUAH1.unit_class, NVL(Igs_Au_Gen_003.audp_get_suah_col('UNIT_CLASS', SUAH1.person_id, SUAH1.course_cd, SUAH1.hist_end_dt, SUAH1.uoo_id ), SUA1.unit_class)),1,10), NVL(SUAH1.enrolled_dt, NVL(IGS_GE_DATE.IGSDATE(Igs_Au_Gen_003.audp_get_suah_col('ENROLLED_DT', SUAH1.person_id, SUAH1.course_cd, SUAH1.hist_end_dt, SUAH1.uoo_id )), SUA1.enrolled_dt)), SUBSTR(NVL(SUAH1.unit_attempt_status, NVL(Igs_Au_Gen_003.audp_get_suah_col('UNIT_ATTEMPT_STATUS', SUAH1.person_id, SUAH1.course_cd, SUAH1.hist_end_dt, SUAH1.uoo_id ), SUA1.unit_attempt_status)),1,10) , SUBSTR(NVL(SUAH1.administrative_unit_status, NVL(Igs_Au_Gen_003.audp_get_suah_col('ADMINISTRATIVE_UNIT_STATUS', SUAH1.person_id, SUAH1.course_cd, SUAH1.hist_end_dt, SUAH1.uoo_id ), SUA1.administrative_unit_status)),1,10), NVL(SUAH1.discontinued_dt, NVL(IGS_GE_DATE.IGSDATE(Igs_Au_Gen_003.audp_get_suah_col('DISCONTINUED_DT', SUAH1.person_id, SUAH1.course_cd, SUAH1.hist_end_dt, SUAH1.uoo_id )), SUA1.discontinued_dt)), suah1.DCNT_REASON_CD, NVL(SUAH1.rule_waived_dt, NVL(IGS_GE_DATE.IGSDATE(Igs_Au_Gen_003.audp_get_suah_col('RULE_WAIVED_DT', SUAH1.person_id, SUAH1.course_cd, SUAH1.hist_end_dt, SUAH1.uoo_id )), SUA1.rule_waived_dt)), NVL(SUAH1.rule_waived_person_id, NVL(Igs_Au_Gen_003.audp_get_suah_col('RULE_WAIVED_PERSON_ID', SUAH1.person_id, SUAH1.course_cd, SUAH1.hist_end_dt, SUAH1.uoo_id ), SUA1.rule_waived_person_id)), hz.party_number, SUBSTR(NVL(SUAH1.no_assessment_ind, NVL(Igs_Au_Gen_003.audp_get_suah_col('NO_ASSESSMENT_IND', SUAH1.person_id, SUAH1.course_cd, SUAH1.hist_end_dt, SUAH1.uoo_id ), SUA1.no_assessment_ind)),1,1), SUBSTR(NVL(SUAH1.sup_unit_cd, NVL(Igs_Au_Gen_003.audp_get_suah_col('SUP_UNIT_CD', SUAH1.person_id, SUAH1.course_cd, SUAH1.hist_end_dt, SUAH1.uoo_id ), SUA1.sup_unit_cd)),1,10), NVL(SUAH1.sup_version_number, NVL(Igs_Au_Gen_003.audp_get_suah_col('SUP_VERSION_NUMBER', SUAH1.person_id, SUAH1.course_cd, SUAH1.hist_end_dt, SUAH1.uoo_id ), SUA1.sup_version_number)), SUBSTR(NVL(SUAH1.exam_location_cd, NVL(Igs_Au_Gen_003.audp_get_suah_col('EXAM_LOCATION_CD', SUAH1.person_id, SUAH1.course_cd, SUAH1.hist_end_dt, SUAH1.uoo_id ), SUA1.exam_location_cd)),1,10), SUBSTR(NVL(SUAH1.alternative_title, NVL(Igs_Au_Gen_003.audp_get_suah_col('ALTERNATIVE_TITLE', SUAH1.person_id, SUAH1.course_cd, SUAH1.hist_end_dt, SUAH1.uoo_id ), SUA1.alternative_title)),1,90), NVL(SUAH1.override_enrolled_cp, NVL(Igs_Au_Gen_003.audp_get_suah_col('OVERRIDE_ENROLLED_CP', SUAH1.person_id, SUAH1.course_cd, SUAH1.hist_end_dt, SUAH1.uoo_id ), SUA1.override_enrolled_cp)), NVL(SUAH1.override_eftsu, NVL(Igs_Au_Gen_003.audp_get_suah_col('OVERRIDE_EFTSU', SUAH1.person_id, SUAH1.course_cd, SUAH1.hist_end_dt, SUAH1.uoo_id ), SUA1.override_eftsu)), NVL(SUAH1.override_achievable_cp, NVL(Igs_Au_Gen_003.audp_get_suah_col('OVERRIDE_ACHIEVABLE_CP', SUAH1.person_id, SUAH1.course_cd, SUAH1.hist_end_dt, SUAH1.uoo_id ), SUA1.override_achievable_cp)), NVL(SUAH1.override_outcome_due_dt, NVL(IGS_GE_DATE.IGSDATE(Igs_Au_Gen_003.audp_get_suah_col('OVERRIDE_OUTCOME_DUE_DT', SUAH1.person_id, SUAH1.course_cd, SUAH1.hist_end_dt, SUAH1.uoo_id )), SUA1.override_outcome_due_dt)), NVL(SUAH1.override_credit_reason, NVL(Igs_Au_Gen_003.audp_get_suah_col('OVERRIDE_CREDIT_REASON', SUAH1.person_id, SUAH1.course_cd, SUAH1.hist_end_dt, SUAH1.uoo_id ), SUA1.override_credit_reason)), SUBSTR( NVL(SUAH1.enr_method_type, NVL(Igs_Au_Gen_003.audp_get_suah_col('ENR_METHOD_TYPE', SUAH1.person_id, SUAH1.course_cd, SUAH1.hist_end_dt, SUAH1.uoo_id ), SUA1.enr_method_type)),1,10), SUBSTR( NVL(SUAH1.grading_schema_code, NVL(Igs_Au_Gen_003.audp_get_suah_col('GRADING_SCHEMA_CODE', SUAH1.person_id, SUAH1.course_cd, SUAH1.hist_end_dt, SUAH1.uoo_id ), SUA1.grading_schema_code)) ,1,10), suah1.created_by, suah1.creation_date, suah1.last_updated_by, suah1.last_update_date, suah1.last_update_login ,sua1.deg_aud_detail_id , suah1.uoo_id, NVL(SUAH1.core_indicator_code, NVL(Igs_Au_Gen_003.audp_get_suah_col ('CORE_INDICATOR_CODE', SUAH1.person_id, SUAH1.course_cd, SUAH1.hist_end_dt, SUAH1.uoo_id), SUA1.core_indicator_code)) FROM IGS_EN_SU_ATTEMPT_H suah1, IGS_EN_SU_ATTEMPT sua1, HZ_PARTIES HZ WHERE SUA1.person_id = SUAH1.person_id AND SUA1.course_cd = SUAH1.course_cd AND SUA1.uoo_id = SUAH1.uoo_id AND Igs_Au_Gen_003.enrp_RET_WAIVE_PERSON_ID(SUAH1.rule_waived_person_id, SUAH1.person_id, SUAH1.course_cd, SUAH1.hist_end_dt, SUAH1.uoo_id)= HZ.PARTY_ID(+) UNION ALL SELECT SUA2.person_id, SUA2.course_cd, SUA2.unit_cd, SUA2.version_number, SUA2.cal_type, SUA2.ci_sequence_number, NVL(MAX(SUAH2.hist_end_dt),SUA2.last_update_date), TO_DATE(NULL), SUA2.last_updated_by, SUA2.location_cd, SUA2.unit_class, SUA2.enrolled_dt, SUA2.unit_attempt_status, SUA2.administrative_unit_status, SUA2.discontinued_dt, SUA2.dcnt_reason_cd, SUA2.rule_waived_dt, SUA2.rule_waived_person_id, hz.party_number, SUA2.no_assessment_ind, SUA2.sup_unit_cd, SUA2.sup_version_number, SUA2.exam_location_cd, SUA2.alternative_title, SUA2.override_enrolled_cp, SUA2.override_eftsu, SUA2.override_achievable_cp, SUA2.override_outcome_due_dt, SUA2.override_credit_reason, sua2.enr_method_type, sua2.grading_schema_code, sua2.created_by, sua2.creation_date, sua2.last_updated_by, sua2.last_update_date, sua2.last_update_login ,sua2.deg_aud_detail_id ,sua2.uoo_id ,sua2.core_indicator_code FROM IGS_EN_SU_ATTEMPT SUA2, IGS_EN_SU_ATTEMPT_H SUAH2, HZ_PARTIES HZ WHERE SUA2.person_id = SUAH2.person_id(+) AND SUA2.course_cd = SUAH2.course_cd(+) AND SUA2.uoo_id = SUAH2.uoo_id(+) AND SUA2.rule_waived_person_id = HZ.PARTY_ID(+) GROUP BY SUA2.person_id, SUA2.course_cd, SUA2.unit_cd, SUA2.version_number, SUA2.cal_type, SUA2.ci_sequence_number, SUA2.location_cd, SUA2.unit_class, SUA2.enrolled_dt, SUA2.unit_attempt_status, SUA2.administrative_unit_status, SUA2.discontinued_dt, SUA2.dcnt_reason_cd, SUA2.rule_waived_dt, SUA2.rule_waived_person_id, hz.party_number, SUA2.no_assessment_ind, SUA2.sup_unit_cd, SUA2.sup_version_number, SUA2.exam_location_cd, SUA2.alternative_title, SUA2.override_enrolled_cp, SUA2.override_eftsu, SUA2.override_achievable_cp, SUA2.override_outcome_due_dt, SUA2.override_credit_reason, sua2.enr_method_type, sua2.grading_schema_code, sua2.created_by, sua2.creation_date, sua2.last_updated_by, sua2.last_update_date, sua2.last_update_login ,sua2.deg_aud_detail_id ,sua2.uoo_id ,sua2.core_indicator_code

View Text - HTML Formatted

SELECT SUAH1.PERSON_ID
, SUAH1.COURSE_CD
, SUAH1.UNIT_CD
, TO_NUMBER(NVL(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('VERSION_NUMBER'
, SUAH1.PERSON_ID
, SUAH1.COURSE_CD
, SUAH1.HIST_END_DT
, SUAH1.UOO_ID)
, SUA1.VERSION_NUMBER))
, SUAH1.CAL_TYPE
, SUAH1.CI_SEQUENCE_NUMBER
, SUAH1.HIST_START_DT
, SUAH1.HIST_END_DT
, SUAH1.HIST_WHO
, SUBSTR(NVL(SUAH1.LOCATION_CD
, NVL(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('LOCATION_CD'
, SUAH1.PERSON_ID
, SUAH1.COURSE_CD
, SUAH1.HIST_END_DT
, SUAH1.UOO_ID )
, SUA1.LOCATION_CD))
, 1
, 10)
, SUBSTR(NVL(SUAH1.UNIT_CLASS
, NVL(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('UNIT_CLASS'
, SUAH1.PERSON_ID
, SUAH1.COURSE_CD
, SUAH1.HIST_END_DT
, SUAH1.UOO_ID )
, SUA1.UNIT_CLASS))
, 1
, 10)
, NVL(SUAH1.ENROLLED_DT
, NVL(IGS_GE_DATE.IGSDATE(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('ENROLLED_DT'
, SUAH1.PERSON_ID
, SUAH1.COURSE_CD
, SUAH1.HIST_END_DT
, SUAH1.UOO_ID ))
, SUA1.ENROLLED_DT))
, SUBSTR(NVL(SUAH1.UNIT_ATTEMPT_STATUS
, NVL(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('UNIT_ATTEMPT_STATUS'
, SUAH1.PERSON_ID
, SUAH1.COURSE_CD
, SUAH1.HIST_END_DT
, SUAH1.UOO_ID )
, SUA1.UNIT_ATTEMPT_STATUS))
, 1
, 10)
, SUBSTR(NVL(SUAH1.ADMINISTRATIVE_UNIT_STATUS
, NVL(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('ADMINISTRATIVE_UNIT_STATUS'
, SUAH1.PERSON_ID
, SUAH1.COURSE_CD
, SUAH1.HIST_END_DT
, SUAH1.UOO_ID )
, SUA1.ADMINISTRATIVE_UNIT_STATUS))
, 1
, 10)
, NVL(SUAH1.DISCONTINUED_DT
, NVL(IGS_GE_DATE.IGSDATE(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('DISCONTINUED_DT'
, SUAH1.PERSON_ID
, SUAH1.COURSE_CD
, SUAH1.HIST_END_DT
, SUAH1.UOO_ID ))
, SUA1.DISCONTINUED_DT))
, SUAH1.DCNT_REASON_CD
, NVL(SUAH1.RULE_WAIVED_DT
, NVL(IGS_GE_DATE.IGSDATE(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('RULE_WAIVED_DT'
, SUAH1.PERSON_ID
, SUAH1.COURSE_CD
, SUAH1.HIST_END_DT
, SUAH1.UOO_ID ))
, SUA1.RULE_WAIVED_DT))
, NVL(SUAH1.RULE_WAIVED_PERSON_ID
, NVL(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('RULE_WAIVED_PERSON_ID'
, SUAH1.PERSON_ID
, SUAH1.COURSE_CD
, SUAH1.HIST_END_DT
, SUAH1.UOO_ID )
, SUA1.RULE_WAIVED_PERSON_ID))
, HZ.PARTY_NUMBER
, SUBSTR(NVL(SUAH1.NO_ASSESSMENT_IND
, NVL(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('NO_ASSESSMENT_IND'
, SUAH1.PERSON_ID
, SUAH1.COURSE_CD
, SUAH1.HIST_END_DT
, SUAH1.UOO_ID )
, SUA1.NO_ASSESSMENT_IND))
, 1
, 1)
, SUBSTR(NVL(SUAH1.SUP_UNIT_CD
, NVL(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('SUP_UNIT_CD'
, SUAH1.PERSON_ID
, SUAH1.COURSE_CD
, SUAH1.HIST_END_DT
, SUAH1.UOO_ID )
, SUA1.SUP_UNIT_CD))
, 1
, 10)
, NVL(SUAH1.SUP_VERSION_NUMBER
, NVL(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('SUP_VERSION_NUMBER'
, SUAH1.PERSON_ID
, SUAH1.COURSE_CD
, SUAH1.HIST_END_DT
, SUAH1.UOO_ID )
, SUA1.SUP_VERSION_NUMBER))
, SUBSTR(NVL(SUAH1.EXAM_LOCATION_CD
, NVL(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('EXAM_LOCATION_CD'
, SUAH1.PERSON_ID
, SUAH1.COURSE_CD
, SUAH1.HIST_END_DT
, SUAH1.UOO_ID )
, SUA1.EXAM_LOCATION_CD))
, 1
, 10)
, SUBSTR(NVL(SUAH1.ALTERNATIVE_TITLE
, NVL(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('ALTERNATIVE_TITLE'
, SUAH1.PERSON_ID
, SUAH1.COURSE_CD
, SUAH1.HIST_END_DT
, SUAH1.UOO_ID )
, SUA1.ALTERNATIVE_TITLE))
, 1
, 90)
, NVL(SUAH1.OVERRIDE_ENROLLED_CP
, NVL(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('OVERRIDE_ENROLLED_CP'
, SUAH1.PERSON_ID
, SUAH1.COURSE_CD
, SUAH1.HIST_END_DT
, SUAH1.UOO_ID )
, SUA1.OVERRIDE_ENROLLED_CP))
, NVL(SUAH1.OVERRIDE_EFTSU
, NVL(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('OVERRIDE_EFTSU'
, SUAH1.PERSON_ID
, SUAH1.COURSE_CD
, SUAH1.HIST_END_DT
, SUAH1.UOO_ID )
, SUA1.OVERRIDE_EFTSU))
, NVL(SUAH1.OVERRIDE_ACHIEVABLE_CP
, NVL(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('OVERRIDE_ACHIEVABLE_CP'
, SUAH1.PERSON_ID
, SUAH1.COURSE_CD
, SUAH1.HIST_END_DT
, SUAH1.UOO_ID )
, SUA1.OVERRIDE_ACHIEVABLE_CP))
, NVL(SUAH1.OVERRIDE_OUTCOME_DUE_DT
, NVL(IGS_GE_DATE.IGSDATE(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('OVERRIDE_OUTCOME_DUE_DT'
, SUAH1.PERSON_ID
, SUAH1.COURSE_CD
, SUAH1.HIST_END_DT
, SUAH1.UOO_ID ))
, SUA1.OVERRIDE_OUTCOME_DUE_DT))
, NVL(SUAH1.OVERRIDE_CREDIT_REASON
, NVL(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('OVERRIDE_CREDIT_REASON'
, SUAH1.PERSON_ID
, SUAH1.COURSE_CD
, SUAH1.HIST_END_DT
, SUAH1.UOO_ID )
, SUA1.OVERRIDE_CREDIT_REASON))
, SUBSTR( NVL(SUAH1.ENR_METHOD_TYPE
, NVL(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('ENR_METHOD_TYPE'
, SUAH1.PERSON_ID
, SUAH1.COURSE_CD
, SUAH1.HIST_END_DT
, SUAH1.UOO_ID )
, SUA1.ENR_METHOD_TYPE))
, 1
, 10)
, SUBSTR( NVL(SUAH1.GRADING_SCHEMA_CODE
, NVL(IGS_AU_GEN_003.AUDP_GET_SUAH_COL('GRADING_SCHEMA_CODE'
, SUAH1.PERSON_ID
, SUAH1.COURSE_CD
, SUAH1.HIST_END_DT
, SUAH1.UOO_ID )
, SUA1.GRADING_SCHEMA_CODE))
, 1
, 10)
, SUAH1.CREATED_BY
, SUAH1.CREATION_DATE
, SUAH1.LAST_UPDATED_BY
, SUAH1.LAST_UPDATE_DATE
, SUAH1.LAST_UPDATE_LOGIN
, SUA1.DEG_AUD_DETAIL_ID
, SUAH1.UOO_ID
, NVL(SUAH1.CORE_INDICATOR_CODE
, NVL(IGS_AU_GEN_003.AUDP_GET_SUAH_COL ('CORE_INDICATOR_CODE'
, SUAH1.PERSON_ID
, SUAH1.COURSE_CD
, SUAH1.HIST_END_DT
, SUAH1.UOO_ID)
, SUA1.CORE_INDICATOR_CODE))
FROM IGS_EN_SU_ATTEMPT_H SUAH1
, IGS_EN_SU_ATTEMPT SUA1
, HZ_PARTIES HZ
WHERE SUA1.PERSON_ID = SUAH1.PERSON_ID
AND SUA1.COURSE_CD = SUAH1.COURSE_CD
AND SUA1.UOO_ID = SUAH1.UOO_ID
AND IGS_AU_GEN_003.ENRP_RET_WAIVE_PERSON_ID(SUAH1.RULE_WAIVED_PERSON_ID
, SUAH1.PERSON_ID
, SUAH1.COURSE_CD
, SUAH1.HIST_END_DT
, SUAH1.UOO_ID)= HZ.PARTY_ID(+) UNION ALL SELECT SUA2.PERSON_ID
, SUA2.COURSE_CD
, SUA2.UNIT_CD
, SUA2.VERSION_NUMBER
, SUA2.CAL_TYPE
, SUA2.CI_SEQUENCE_NUMBER
, NVL(MAX(SUAH2.HIST_END_DT)
, SUA2.LAST_UPDATE_DATE)
, TO_DATE(NULL)
, SUA2.LAST_UPDATED_BY
, SUA2.LOCATION_CD
, SUA2.UNIT_CLASS
, SUA2.ENROLLED_DT
, SUA2.UNIT_ATTEMPT_STATUS
, SUA2.ADMINISTRATIVE_UNIT_STATUS
, SUA2.DISCONTINUED_DT
, SUA2.DCNT_REASON_CD
, SUA2.RULE_WAIVED_DT
, SUA2.RULE_WAIVED_PERSON_ID
, HZ.PARTY_NUMBER
, SUA2.NO_ASSESSMENT_IND
, SUA2.SUP_UNIT_CD
, SUA2.SUP_VERSION_NUMBER
, SUA2.EXAM_LOCATION_CD
, SUA2.ALTERNATIVE_TITLE
, SUA2.OVERRIDE_ENROLLED_CP
, SUA2.OVERRIDE_EFTSU
, SUA2.OVERRIDE_ACHIEVABLE_CP
, SUA2.OVERRIDE_OUTCOME_DUE_DT
, SUA2.OVERRIDE_CREDIT_REASON
, SUA2.ENR_METHOD_TYPE
, SUA2.GRADING_SCHEMA_CODE
, SUA2.CREATED_BY
, SUA2.CREATION_DATE
, SUA2.LAST_UPDATED_BY
, SUA2.LAST_UPDATE_DATE
, SUA2.LAST_UPDATE_LOGIN
, SUA2.DEG_AUD_DETAIL_ID
, SUA2.UOO_ID
, SUA2.CORE_INDICATOR_CODE
FROM IGS_EN_SU_ATTEMPT SUA2
, IGS_EN_SU_ATTEMPT_H SUAH2
, HZ_PARTIES HZ
WHERE SUA2.PERSON_ID = SUAH2.PERSON_ID(+)
AND SUA2.COURSE_CD = SUAH2.COURSE_CD(+)
AND SUA2.UOO_ID = SUAH2.UOO_ID(+)
AND SUA2.RULE_WAIVED_PERSON_ID = HZ.PARTY_ID(+) GROUP BY SUA2.PERSON_ID
, SUA2.COURSE_CD
, SUA2.UNIT_CD
, SUA2.VERSION_NUMBER
, SUA2.CAL_TYPE
, SUA2.CI_SEQUENCE_NUMBER
, SUA2.LOCATION_CD
, SUA2.UNIT_CLASS
, SUA2.ENROLLED_DT
, SUA2.UNIT_ATTEMPT_STATUS
, SUA2.ADMINISTRATIVE_UNIT_STATUS
, SUA2.DISCONTINUED_DT
, SUA2.DCNT_REASON_CD
, SUA2.RULE_WAIVED_DT
, SUA2.RULE_WAIVED_PERSON_ID
, HZ.PARTY_NUMBER
, SUA2.NO_ASSESSMENT_IND
, SUA2.SUP_UNIT_CD
, SUA2.SUP_VERSION_NUMBER
, SUA2.EXAM_LOCATION_CD
, SUA2.ALTERNATIVE_TITLE
, SUA2.OVERRIDE_ENROLLED_CP
, SUA2.OVERRIDE_EFTSU
, SUA2.OVERRIDE_ACHIEVABLE_CP
, SUA2.OVERRIDE_OUTCOME_DUE_DT
, SUA2.OVERRIDE_CREDIT_REASON
, SUA2.ENR_METHOD_TYPE
, SUA2.GRADING_SCHEMA_CODE
, SUA2.CREATED_BY
, SUA2.CREATION_DATE
, SUA2.LAST_UPDATED_BY
, SUA2.LAST_UPDATE_DATE
, SUA2.LAST_UPDATE_LOGIN
, SUA2.DEG_AUD_DETAIL_ID
, SUA2.UOO_ID
, SUA2.CORE_INDICATOR_CODE