VIEW: APPS.IGS_AS_SUAH_EFFECTIVE_H_V

Source

View Text - Preformatted

SELECT UNIQUE person_id, course_cd, unit_cd, version_number, CAL_TYPE, ci_sequence_number, created_by, creation_date, last_updated_by, last_update_date, last_update_login, IGS_EN_GET_SUAEH_DTL.enrp_get_suaeh_eff_st( person_id, course_cd, unit_cd, CAL_TYPE, ci_sequence_number, hist_start_dt, unit_attempt_status, uoo_id), IGS_EN_GET_SUAEH_DTL.enrp_get_suaeh_eff_end( person_id, course_cd, unit_cd, CAL_TYPE, ci_sequence_number, hist_end_dt, unit_attempt_status, uoo_id), SUBSTR(IGS_EN_GET_SUAEH_DTL.enrp_get_suaeh_col( 'LOCATION_CD', location_cd, person_id, course_cd, unit_cd, CAL_TYPE, ci_sequence_number, hist_start_dt, unit_attempt_status, uoo_id),1,10), SUBSTR(IGS_EN_GET_SUAEH_DTL.enrp_get_suaeh_col( 'UNIT_CLASS', UNIT_CLASS, person_id, course_cd, unit_cd, CAL_TYPE, ci_sequence_number, hist_start_dt, unit_attempt_status, uoo_id),1,10), igs_ge_date.igsdate(IGS_EN_GET_SUAEH_DTL.enrp_get_suaeh_col( 'ENROLLED_DT', igs_ge_date.igschardt(enrolled_dt), person_id, course_cd, unit_cd, CAL_TYPE, ci_sequence_number, hist_start_dt, unit_attempt_status, uoo_id)), SUBSTR(IGS_EN_GET_SUAEH_DTL.enrp_get_suaeh_col( 'UNIT_ATTEMPT_STATUS', unit_attempt_status, person_id, course_cd, unit_cd, CAL_TYPE, ci_sequence_number, hist_start_dt, unit_attempt_status, uoo_id),1,10), SUBSTR(IGS_EN_GET_SUAEH_DTL.enrp_get_suaeh_col( 'ADMINISTRATIVE_UNIT_STATUS', ADMINISTRATIVE_UNIT_STATUS, person_id, course_cd, unit_cd, CAL_TYPE, ci_sequence_number, hist_start_dt, unit_attempt_status, uoo_id),1,10), igs_ge_date.igsdate(IGS_EN_GET_SUAEH_DTL.enrp_get_suaeh_col( 'DISCONTINUED_DT', igs_ge_date.igschardt(discontinued_dt), person_id, course_cd, unit_cd, CAL_TYPE, ci_sequence_number, hist_start_dt, unit_attempt_status, uoo_id)), igs_ge_date.igsdate(IGS_EN_GET_SUAEH_DTL.enrp_get_suaeh_col( 'RULE_WAIVED_DT', igs_ge_date.igschardt(rule_waived_dt), person_id, course_cd, unit_cd, CAL_TYPE, ci_sequence_number, hist_start_dt, unit_attempt_status, uoo_id)), TO_NUMBER(IGS_EN_GET_SUAEH_DTL.enrp_get_suaeh_col( 'RULE_WAIVED_PERSON_ID', TO_CHAR(rule_waived_person_id), person_id, course_cd, unit_cd, CAL_TYPE, ci_sequence_number, hist_start_dt, unit_attempt_status, uoo_id)), SUBSTR(IGS_EN_GET_SUAEH_DTL.enrp_get_suaeh_col( 'NO_ASSESSMENT_IND', no_assessment_ind, person_id, course_cd, unit_cd, CAL_TYPE, ci_sequence_number, hist_start_dt, unit_attempt_status, uoo_id),1,1), SUBSTR(IGS_EN_GET_SUAEH_DTL.enrp_get_suaeh_col( 'EXAM_LOCATION_CD', exam_location_cd, person_id, course_cd, unit_cd, CAL_TYPE, ci_sequence_number, hist_start_dt, unit_attempt_status, uoo_id),1,10), SUBSTR(IGS_EN_GET_SUAEH_DTL.enrp_get_suaeh_col( 'SUP_UNIT_CD', sup_unit_cd, person_id, course_cd, unit_cd, CAL_TYPE, ci_sequence_number, hist_start_dt, unit_attempt_status, uoo_id),1,10), TO_NUMBER(IGS_EN_GET_SUAEH_DTL.enrp_get_suaeh_col( 'SUP_VERSION_NUMBER', TO_CHAR(sup_version_number), person_id, course_cd, unit_cd, CAL_TYPE, ci_sequence_number, hist_start_dt, unit_attempt_status, uoo_id)), SUBSTR(IGS_EN_GET_SUAEH_DTL.enrp_get_suaeh_col( 'ALTERNATIVE_TITLE', alternative_title, person_id, course_cd, unit_cd, CAL_TYPE, ci_sequence_number, hist_start_dt, unit_attempt_status, uoo_id),1,90), TO_NUMBER(IGS_EN_GET_SUAEH_DTL.enrp_get_suaeh_col( 'OVERRIDE_ENROLLED_CP', TO_CHAR(override_enrolled_cp), person_id, course_cd, unit_cd, CAL_TYPE, ci_sequence_number, hist_start_dt, unit_attempt_status, uoo_id)), TO_NUMBER(IGS_EN_GET_SUAEH_DTL.enrp_get_suaeh_col( 'OVERRIDE_EFTSU', TO_CHAR(override_eftsu), person_id, course_cd, unit_cd, CAL_TYPE, ci_sequence_number, hist_start_dt, unit_attempt_status, uoo_id)), TO_NUMBER(IGS_EN_GET_SUAEH_DTL.enrp_get_suaeh_col( 'OVERRIDE_ACHIEVABLE_CP', TO_CHAR(override_achievable_cp), person_id, course_cd, unit_cd, CAL_TYPE, ci_sequence_number, hist_start_dt, unit_attempt_status, uoo_id)), igs_ge_date.igsdate(IGS_EN_GET_SUAEH_DTL.enrp_get_suaeh_col( 'OVERRIDE_OUTCOME_DUE_DT', igs_ge_date.igschardt(override_outcome_due_dt), person_id, course_cd, unit_cd, CAL_TYPE, ci_sequence_number, hist_start_dt, unit_attempt_status, uoo_id)), IGS_EN_GET_SUAEH_DTL.enrp_get_suaeh_col( 'OVERRIDE_CREDIT_REASON', override_credit_reason, person_id, course_cd, unit_cd, CAL_TYPE, ci_sequence_number, hist_start_dt, unit_attempt_status, uoo_id) ,uoo_id FROM IGS_AS_SUA_H_V

View Text - HTML Formatted

SELECT UNIQUE PERSON_ID
, COURSE_CD
, UNIT_CD
, VERSION_NUMBER
, CAL_TYPE
, CI_SEQUENCE_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, IGS_EN_GET_SUAEH_DTL.ENRP_GET_SUAEH_EFF_ST( PERSON_ID
, COURSE_CD
, UNIT_CD
, CAL_TYPE
, CI_SEQUENCE_NUMBER
, HIST_START_DT
, UNIT_ATTEMPT_STATUS
, UOO_ID)
, IGS_EN_GET_SUAEH_DTL.ENRP_GET_SUAEH_EFF_END( PERSON_ID
, COURSE_CD
, UNIT_CD
, CAL_TYPE
, CI_SEQUENCE_NUMBER
, HIST_END_DT
, UNIT_ATTEMPT_STATUS
, UOO_ID)
, SUBSTR(IGS_EN_GET_SUAEH_DTL.ENRP_GET_SUAEH_COL( 'LOCATION_CD'
, LOCATION_CD
, PERSON_ID
, COURSE_CD
, UNIT_CD
, CAL_TYPE
, CI_SEQUENCE_NUMBER
, HIST_START_DT
, UNIT_ATTEMPT_STATUS
, UOO_ID)
, 1
, 10)
, SUBSTR(IGS_EN_GET_SUAEH_DTL.ENRP_GET_SUAEH_COL( 'UNIT_CLASS'
, UNIT_CLASS
, PERSON_ID
, COURSE_CD
, UNIT_CD
, CAL_TYPE
, CI_SEQUENCE_NUMBER
, HIST_START_DT
, UNIT_ATTEMPT_STATUS
, UOO_ID)
, 1
, 10)
, IGS_GE_DATE.IGSDATE(IGS_EN_GET_SUAEH_DTL.ENRP_GET_SUAEH_COL( 'ENROLLED_DT'
, IGS_GE_DATE.IGSCHARDT(ENROLLED_DT)
, PERSON_ID
, COURSE_CD
, UNIT_CD
, CAL_TYPE
, CI_SEQUENCE_NUMBER
, HIST_START_DT
, UNIT_ATTEMPT_STATUS
, UOO_ID))
, SUBSTR(IGS_EN_GET_SUAEH_DTL.ENRP_GET_SUAEH_COL( 'UNIT_ATTEMPT_STATUS'
, UNIT_ATTEMPT_STATUS
, PERSON_ID
, COURSE_CD
, UNIT_CD
, CAL_TYPE
, CI_SEQUENCE_NUMBER
, HIST_START_DT
, UNIT_ATTEMPT_STATUS
, UOO_ID)
, 1
, 10)
, SUBSTR(IGS_EN_GET_SUAEH_DTL.ENRP_GET_SUAEH_COL( 'ADMINISTRATIVE_UNIT_STATUS'
, ADMINISTRATIVE_UNIT_STATUS
, PERSON_ID
, COURSE_CD
, UNIT_CD
, CAL_TYPE
, CI_SEQUENCE_NUMBER
, HIST_START_DT
, UNIT_ATTEMPT_STATUS
, UOO_ID)
, 1
, 10)
, IGS_GE_DATE.IGSDATE(IGS_EN_GET_SUAEH_DTL.ENRP_GET_SUAEH_COL( 'DISCONTINUED_DT'
, IGS_GE_DATE.IGSCHARDT(DISCONTINUED_DT)
, PERSON_ID
, COURSE_CD
, UNIT_CD
, CAL_TYPE
, CI_SEQUENCE_NUMBER
, HIST_START_DT
, UNIT_ATTEMPT_STATUS
, UOO_ID))
, IGS_GE_DATE.IGSDATE(IGS_EN_GET_SUAEH_DTL.ENRP_GET_SUAEH_COL( 'RULE_WAIVED_DT'
, IGS_GE_DATE.IGSCHARDT(RULE_WAIVED_DT)
, PERSON_ID
, COURSE_CD
, UNIT_CD
, CAL_TYPE
, CI_SEQUENCE_NUMBER
, HIST_START_DT
, UNIT_ATTEMPT_STATUS
, UOO_ID))
, TO_NUMBER(IGS_EN_GET_SUAEH_DTL.ENRP_GET_SUAEH_COL( 'RULE_WAIVED_PERSON_ID'
, TO_CHAR(RULE_WAIVED_PERSON_ID)
, PERSON_ID
, COURSE_CD
, UNIT_CD
, CAL_TYPE
, CI_SEQUENCE_NUMBER
, HIST_START_DT
, UNIT_ATTEMPT_STATUS
, UOO_ID))
, SUBSTR(IGS_EN_GET_SUAEH_DTL.ENRP_GET_SUAEH_COL( 'NO_ASSESSMENT_IND'
, NO_ASSESSMENT_IND
, PERSON_ID
, COURSE_CD
, UNIT_CD
, CAL_TYPE
, CI_SEQUENCE_NUMBER
, HIST_START_DT
, UNIT_ATTEMPT_STATUS
, UOO_ID)
, 1
, 1)
, SUBSTR(IGS_EN_GET_SUAEH_DTL.ENRP_GET_SUAEH_COL( 'EXAM_LOCATION_CD'
, EXAM_LOCATION_CD
, PERSON_ID
, COURSE_CD
, UNIT_CD
, CAL_TYPE
, CI_SEQUENCE_NUMBER
, HIST_START_DT
, UNIT_ATTEMPT_STATUS
, UOO_ID)
, 1
, 10)
, SUBSTR(IGS_EN_GET_SUAEH_DTL.ENRP_GET_SUAEH_COL( 'SUP_UNIT_CD'
, SUP_UNIT_CD
, PERSON_ID
, COURSE_CD
, UNIT_CD
, CAL_TYPE
, CI_SEQUENCE_NUMBER
, HIST_START_DT
, UNIT_ATTEMPT_STATUS
, UOO_ID)
, 1
, 10)
, TO_NUMBER(IGS_EN_GET_SUAEH_DTL.ENRP_GET_SUAEH_COL( 'SUP_VERSION_NUMBER'
, TO_CHAR(SUP_VERSION_NUMBER)
, PERSON_ID
, COURSE_CD
, UNIT_CD
, CAL_TYPE
, CI_SEQUENCE_NUMBER
, HIST_START_DT
, UNIT_ATTEMPT_STATUS
, UOO_ID))
, SUBSTR(IGS_EN_GET_SUAEH_DTL.ENRP_GET_SUAEH_COL( 'ALTERNATIVE_TITLE'
, ALTERNATIVE_TITLE
, PERSON_ID
, COURSE_CD
, UNIT_CD
, CAL_TYPE
, CI_SEQUENCE_NUMBER
, HIST_START_DT
, UNIT_ATTEMPT_STATUS
, UOO_ID)
, 1
, 90)
, TO_NUMBER(IGS_EN_GET_SUAEH_DTL.ENRP_GET_SUAEH_COL( 'OVERRIDE_ENROLLED_CP'
, TO_CHAR(OVERRIDE_ENROLLED_CP)
, PERSON_ID
, COURSE_CD
, UNIT_CD
, CAL_TYPE
, CI_SEQUENCE_NUMBER
, HIST_START_DT
, UNIT_ATTEMPT_STATUS
, UOO_ID))
, TO_NUMBER(IGS_EN_GET_SUAEH_DTL.ENRP_GET_SUAEH_COL( 'OVERRIDE_EFTSU'
, TO_CHAR(OVERRIDE_EFTSU)
, PERSON_ID
, COURSE_CD
, UNIT_CD
, CAL_TYPE
, CI_SEQUENCE_NUMBER
, HIST_START_DT
, UNIT_ATTEMPT_STATUS
, UOO_ID))
, TO_NUMBER(IGS_EN_GET_SUAEH_DTL.ENRP_GET_SUAEH_COL( 'OVERRIDE_ACHIEVABLE_CP'
, TO_CHAR(OVERRIDE_ACHIEVABLE_CP)
, PERSON_ID
, COURSE_CD
, UNIT_CD
, CAL_TYPE
, CI_SEQUENCE_NUMBER
, HIST_START_DT
, UNIT_ATTEMPT_STATUS
, UOO_ID))
, IGS_GE_DATE.IGSDATE(IGS_EN_GET_SUAEH_DTL.ENRP_GET_SUAEH_COL( 'OVERRIDE_OUTCOME_DUE_DT'
, IGS_GE_DATE.IGSCHARDT(OVERRIDE_OUTCOME_DUE_DT)
, PERSON_ID
, COURSE_CD
, UNIT_CD
, CAL_TYPE
, CI_SEQUENCE_NUMBER
, HIST_START_DT
, UNIT_ATTEMPT_STATUS
, UOO_ID))
, IGS_EN_GET_SUAEH_DTL.ENRP_GET_SUAEH_COL( 'OVERRIDE_CREDIT_REASON'
, OVERRIDE_CREDIT_REASON
, PERSON_ID
, COURSE_CD
, UNIT_CD
, CAL_TYPE
, CI_SEQUENCE_NUMBER
, HIST_START_DT
, UNIT_ATTEMPT_STATUS
, UOO_ID)
, UOO_ID
FROM IGS_AS_SUA_H_V