VIEW: APPS.IGS_AS_SCAH_EFFECTIVE_H_V

Source

View Text - Preformatted

SELECT UNIQUE person_id, course_cd, IGS_EN_GET_SCAEH_DTL.enrp_get_scaeh_eff_st( person_id, course_cd, hist_start_dt, course_attempt_status), IGS_EN_GET_SCAEH_DTL.enrp_get_scaeh_eff_end( person_id, course_cd, hist_end_dt, course_attempt_status), TO_NUMBER(IGS_EN_GET_SCAEH_DTL.enrp_get_scaeh_col('VERSION_NUMBER', version_number, person_id, course_cd, hist_start_dt, course_attempt_status)), SUBSTR(IGS_EN_GET_SCAEH_DTL.enrp_get_scaeh_col('CAL_TYPE', cal_type, person_id, course_cd, hist_start_dt, course_attempt_status),1,10), SUBSTR(IGS_EN_GET_SCAEH_DTL.enrp_get_scaeh_col('LOCATION_CD', location_cd, person_id, course_cd, hist_start_dt, course_attempt_status),1,10), SUBSTR(IGS_EN_GET_SCAEH_DTL.enrp_get_scaeh_col('ATTENDANCE_MODE', attendance_mode, person_id, course_cd, hist_start_dt, course_attempt_status),1,2), SUBSTR(IGS_EN_GET_SCAEH_DTL.enrp_get_scaeh_col('ATTENDANCE_TYPE', attendance_type, person_id, course_cd, hist_start_dt, course_attempt_status),1,2), SUBSTR(IGS_EN_GET_SCAEH_DTL.enrp_get_scaeh_col('STUDENT_CONFIRMED_IND', attendance_type, person_id, course_cd, hist_start_dt, course_attempt_status),1,1), igs_ge_date.igsdate(IGS_EN_GET_SCAEH_DTL.enrp_get_scaeh_col('COMMENCEMENT_DT', igs_ge_date.igschardt(commencement_dt), person_id, course_cd, hist_start_dt, course_attempt_status)), SUBSTR(IGS_EN_GET_SCAEH_DTL.enrp_get_scaeh_col('COURSE_ATTEMPT_STATUS', course_attempt_status, person_id, course_cd, hist_start_dt, course_attempt_status),1,10), SUBSTR(IGS_EN_GET_SCAEH_DTL.enrp_get_scaeh_col('DERIVED_ATT_TYPE', derived_att_type, person_id, course_cd, hist_start_dt, course_attempt_status),1,10), SUBSTR(IGS_EN_GET_SCAEH_DTL.enrp_get_scaeh_col('DERIVED_ATT_MODE', derived_att_mode, person_id, course_cd, hist_start_dt, course_attempt_status),1,10), SUBSTR(IGS_EN_GET_SCAEH_DTL.enrp_get_scaeh_col('PROVISIONAL_IND', provisional_ind, person_id, course_cd, hist_start_dt, course_attempt_status),1,1), igs_ge_date.igsdate(IGS_EN_GET_SCAEH_DTL.enrp_get_scaeh_col('DISCONTINUED_DT', igs_ge_date.igschardt(discontinued_dt), person_id, course_cd, hist_start_dt, course_attempt_status)), SUBSTR(IGS_EN_GET_SCAEH_DTL.enrp_get_scaeh_col('IGS_EN_DCNT_REASONCD', discontinuation_reason_cd, person_id, course_cd, hist_start_dt, course_attempt_status),1,10), SUBSTR(IGS_EN_GET_SCAEH_DTL.enrp_get_scaeh_col('FUNDING_SOURCE', funding_source, person_id, course_cd, hist_start_dt, course_attempt_status),1,10), SUBSTR(IGS_EN_GET_SCAEH_DTL.enrp_get_scaeh_col('EXAM_LOCATION_CD', exam_location_cd, person_id, course_cd, hist_start_dt, course_attempt_status),1,10), TO_NUMBER(IGS_EN_GET_SCAEH_DTL.enrp_get_scaeh_col('DERIVED_COMPLETION_YR', derived_completion_yr, person_id, course_cd, hist_start_dt, course_attempt_status)), SUBSTR(IGS_EN_GET_SCAEH_DTL.enrp_get_scaeh_col('DERIVED_COMPLETION_PERD', derived_completion_perd, person_id, course_cd, hist_start_dt, course_attempt_status),1,1), TO_NUMBER(IGS_EN_GET_SCAEH_DTL.enrp_get_scaeh_col('NOMINATED_COMPLETION_YR', nominated_completion_yr, person_id, course_cd, hist_start_dt, course_attempt_status)), SUBSTR(IGS_EN_GET_SCAEH_DTL.enrp_get_scaeh_col('NOMINATED_COMPLETION_PERD', nominated_completion_perd, person_id, course_cd, hist_start_dt, course_attempt_status),1,1), SUBSTR(IGS_EN_GET_SCAEH_DTL.enrp_get_scaeh_col('RULE_CHECK_IND', rule_check_ind, person_id, course_cd, hist_start_dt, course_attempt_status),1,1), SUBSTR(IGS_EN_GET_SCAEH_DTL.enrp_get_scaeh_col('WAIVE_OPTION_CHECK_IND', waive_option_check_ind, person_id, course_cd, hist_start_dt, course_attempt_status),1,1), igs_ge_date.igsdate(IGS_EN_GET_SCAEH_DTL.enrp_get_scaeh_col('LAST_RULE_CHECK_DT', igs_ge_date.igschardt(last_rule_check_dt), person_id, course_cd, hist_start_dt, course_attempt_status)), SUBSTR(IGS_EN_GET_SCAEH_DTL.enrp_get_scaeh_col('PUBLISH_OUTCOMES_IND', publish_outcomes_ind, person_id, course_cd, hist_start_dt, course_attempt_status),1,1), SUBSTR(IGS_EN_GET_SCAEH_DTL.enrp_get_scaeh_col('COURSE_RQRMNT_COMPLETE_IND', course_rqrmnt_complete_ind, person_id, course_cd, hist_start_dt, course_attempt_status),1,1), TO_NUMBER(IGS_EN_GET_SCAEH_DTL.enrp_get_scaeh_col('OVERRIDE_TIME_LIMITATION', override_time_limitation, person_id, course_cd, hist_start_dt, course_attempt_status)), SUBSTR(IGS_EN_GET_SCAEH_DTL.enrp_get_scaeh_col('ADVANCED_STANDING_IND', advanced_standing_ind, person_id, course_cd, hist_start_dt, course_attempt_status),1,1), SUBSTR(IGS_EN_GET_SCAEH_DTL.enrp_get_scaeh_col('FEE_CAT', fee_cat, person_id, course_cd, hist_start_dt, course_attempt_status),1,10), SUBSTR(IGS_EN_GET_SCAEH_DTL.enrp_get_scaeh_col('CORRESPONDENCE_CAT', correspondence_cat, person_id, course_cd, hist_start_dt, course_attempt_status),1,10), SUBSTR(IGS_EN_GET_SCAEH_DTL.enrp_get_scaeh_col('SELF_HELP_GROUP_IND', self_help_group_ind, person_id, course_cd, hist_start_dt, course_attempt_status),1,1), created_by, creation_date, last_updated_by, last_update_date, last_update_login , SUBSTR(IGS_EN_GET_SCAEH_DTL.enrp_get_scaeh_col('PRIMARY_PROGRAM_TYPE', PRIMARY_PROGRAM_TYPE, person_id, course_cd, hist_start_dt, course_attempt_status),1,10), SUBSTR(IGS_EN_GET_SCAEH_DTL.enrp_get_scaeh_col('KEY_PROGRAM', KEY_PROGRAM, person_id, course_cd, hist_start_dt, course_attempt_status),1,1) FROM IGS_AS_SCA_H_V

View Text - HTML Formatted

SELECT UNIQUE PERSON_ID
, COURSE_CD
, IGS_EN_GET_SCAEH_DTL.ENRP_GET_SCAEH_EFF_ST( PERSON_ID
, COURSE_CD
, HIST_START_DT
, COURSE_ATTEMPT_STATUS)
, IGS_EN_GET_SCAEH_DTL.ENRP_GET_SCAEH_EFF_END( PERSON_ID
, COURSE_CD
, HIST_END_DT
, COURSE_ATTEMPT_STATUS)
, TO_NUMBER(IGS_EN_GET_SCAEH_DTL.ENRP_GET_SCAEH_COL('VERSION_NUMBER'
, VERSION_NUMBER
, PERSON_ID
, COURSE_CD
, HIST_START_DT
, COURSE_ATTEMPT_STATUS))
, SUBSTR(IGS_EN_GET_SCAEH_DTL.ENRP_GET_SCAEH_COL('CAL_TYPE'
, CAL_TYPE
, PERSON_ID
, COURSE_CD
, HIST_START_DT
, COURSE_ATTEMPT_STATUS)
, 1
, 10)
, SUBSTR(IGS_EN_GET_SCAEH_DTL.ENRP_GET_SCAEH_COL('LOCATION_CD'
, LOCATION_CD
, PERSON_ID
, COURSE_CD
, HIST_START_DT
, COURSE_ATTEMPT_STATUS)
, 1
, 10)
, SUBSTR(IGS_EN_GET_SCAEH_DTL.ENRP_GET_SCAEH_COL('ATTENDANCE_MODE'
, ATTENDANCE_MODE
, PERSON_ID
, COURSE_CD
, HIST_START_DT
, COURSE_ATTEMPT_STATUS)
, 1
, 2)
, SUBSTR(IGS_EN_GET_SCAEH_DTL.ENRP_GET_SCAEH_COL('ATTENDANCE_TYPE'
, ATTENDANCE_TYPE
, PERSON_ID
, COURSE_CD
, HIST_START_DT
, COURSE_ATTEMPT_STATUS)
, 1
, 2)
, SUBSTR(IGS_EN_GET_SCAEH_DTL.ENRP_GET_SCAEH_COL('STUDENT_CONFIRMED_IND'
, ATTENDANCE_TYPE
, PERSON_ID
, COURSE_CD
, HIST_START_DT
, COURSE_ATTEMPT_STATUS)
, 1
, 1)
, IGS_GE_DATE.IGSDATE(IGS_EN_GET_SCAEH_DTL.ENRP_GET_SCAEH_COL('COMMENCEMENT_DT'
, IGS_GE_DATE.IGSCHARDT(COMMENCEMENT_DT)
, PERSON_ID
, COURSE_CD
, HIST_START_DT
, COURSE_ATTEMPT_STATUS))
, SUBSTR(IGS_EN_GET_SCAEH_DTL.ENRP_GET_SCAEH_COL('COURSE_ATTEMPT_STATUS'
, COURSE_ATTEMPT_STATUS
, PERSON_ID
, COURSE_CD
, HIST_START_DT
, COURSE_ATTEMPT_STATUS)
, 1
, 10)
, SUBSTR(IGS_EN_GET_SCAEH_DTL.ENRP_GET_SCAEH_COL('DERIVED_ATT_TYPE'
, DERIVED_ATT_TYPE
, PERSON_ID
, COURSE_CD
, HIST_START_DT
, COURSE_ATTEMPT_STATUS)
, 1
, 10)
, SUBSTR(IGS_EN_GET_SCAEH_DTL.ENRP_GET_SCAEH_COL('DERIVED_ATT_MODE'
, DERIVED_ATT_MODE
, PERSON_ID
, COURSE_CD
, HIST_START_DT
, COURSE_ATTEMPT_STATUS)
, 1
, 10)
, SUBSTR(IGS_EN_GET_SCAEH_DTL.ENRP_GET_SCAEH_COL('PROVISIONAL_IND'
, PROVISIONAL_IND
, PERSON_ID
, COURSE_CD
, HIST_START_DT
, COURSE_ATTEMPT_STATUS)
, 1
, 1)
, IGS_GE_DATE.IGSDATE(IGS_EN_GET_SCAEH_DTL.ENRP_GET_SCAEH_COL('DISCONTINUED_DT'
, IGS_GE_DATE.IGSCHARDT(DISCONTINUED_DT)
, PERSON_ID
, COURSE_CD
, HIST_START_DT
, COURSE_ATTEMPT_STATUS))
, SUBSTR(IGS_EN_GET_SCAEH_DTL.ENRP_GET_SCAEH_COL('IGS_EN_DCNT_REASONCD'
, DISCONTINUATION_REASON_CD
, PERSON_ID
, COURSE_CD
, HIST_START_DT
, COURSE_ATTEMPT_STATUS)
, 1
, 10)
, SUBSTR(IGS_EN_GET_SCAEH_DTL.ENRP_GET_SCAEH_COL('FUNDING_SOURCE'
, FUNDING_SOURCE
, PERSON_ID
, COURSE_CD
, HIST_START_DT
, COURSE_ATTEMPT_STATUS)
, 1
, 10)
, SUBSTR(IGS_EN_GET_SCAEH_DTL.ENRP_GET_SCAEH_COL('EXAM_LOCATION_CD'
, EXAM_LOCATION_CD
, PERSON_ID
, COURSE_CD
, HIST_START_DT
, COURSE_ATTEMPT_STATUS)
, 1
, 10)
, TO_NUMBER(IGS_EN_GET_SCAEH_DTL.ENRP_GET_SCAEH_COL('DERIVED_COMPLETION_YR'
, DERIVED_COMPLETION_YR
, PERSON_ID
, COURSE_CD
, HIST_START_DT
, COURSE_ATTEMPT_STATUS))
, SUBSTR(IGS_EN_GET_SCAEH_DTL.ENRP_GET_SCAEH_COL('DERIVED_COMPLETION_PERD'
, DERIVED_COMPLETION_PERD
, PERSON_ID
, COURSE_CD
, HIST_START_DT
, COURSE_ATTEMPT_STATUS)
, 1
, 1)
, TO_NUMBER(IGS_EN_GET_SCAEH_DTL.ENRP_GET_SCAEH_COL('NOMINATED_COMPLETION_YR'
, NOMINATED_COMPLETION_YR
, PERSON_ID
, COURSE_CD
, HIST_START_DT
, COURSE_ATTEMPT_STATUS))
, SUBSTR(IGS_EN_GET_SCAEH_DTL.ENRP_GET_SCAEH_COL('NOMINATED_COMPLETION_PERD'
, NOMINATED_COMPLETION_PERD
, PERSON_ID
, COURSE_CD
, HIST_START_DT
, COURSE_ATTEMPT_STATUS)
, 1
, 1)
, SUBSTR(IGS_EN_GET_SCAEH_DTL.ENRP_GET_SCAEH_COL('RULE_CHECK_IND'
, RULE_CHECK_IND
, PERSON_ID
, COURSE_CD
, HIST_START_DT
, COURSE_ATTEMPT_STATUS)
, 1
, 1)
, SUBSTR(IGS_EN_GET_SCAEH_DTL.ENRP_GET_SCAEH_COL('WAIVE_OPTION_CHECK_IND'
, WAIVE_OPTION_CHECK_IND
, PERSON_ID
, COURSE_CD
, HIST_START_DT
, COURSE_ATTEMPT_STATUS)
, 1
, 1)
, IGS_GE_DATE.IGSDATE(IGS_EN_GET_SCAEH_DTL.ENRP_GET_SCAEH_COL('LAST_RULE_CHECK_DT'
, IGS_GE_DATE.IGSCHARDT(LAST_RULE_CHECK_DT)
, PERSON_ID
, COURSE_CD
, HIST_START_DT
, COURSE_ATTEMPT_STATUS))
, SUBSTR(IGS_EN_GET_SCAEH_DTL.ENRP_GET_SCAEH_COL('PUBLISH_OUTCOMES_IND'
, PUBLISH_OUTCOMES_IND
, PERSON_ID
, COURSE_CD
, HIST_START_DT
, COURSE_ATTEMPT_STATUS)
, 1
, 1)
, SUBSTR(IGS_EN_GET_SCAEH_DTL.ENRP_GET_SCAEH_COL('COURSE_RQRMNT_COMPLETE_IND'
, COURSE_RQRMNT_COMPLETE_IND
, PERSON_ID
, COURSE_CD
, HIST_START_DT
, COURSE_ATTEMPT_STATUS)
, 1
, 1)
, TO_NUMBER(IGS_EN_GET_SCAEH_DTL.ENRP_GET_SCAEH_COL('OVERRIDE_TIME_LIMITATION'
, OVERRIDE_TIME_LIMITATION
, PERSON_ID
, COURSE_CD
, HIST_START_DT
, COURSE_ATTEMPT_STATUS))
, SUBSTR(IGS_EN_GET_SCAEH_DTL.ENRP_GET_SCAEH_COL('ADVANCED_STANDING_IND'
, ADVANCED_STANDING_IND
, PERSON_ID
, COURSE_CD
, HIST_START_DT
, COURSE_ATTEMPT_STATUS)
, 1
, 1)
, SUBSTR(IGS_EN_GET_SCAEH_DTL.ENRP_GET_SCAEH_COL('FEE_CAT'
, FEE_CAT
, PERSON_ID
, COURSE_CD
, HIST_START_DT
, COURSE_ATTEMPT_STATUS)
, 1
, 10)
, SUBSTR(IGS_EN_GET_SCAEH_DTL.ENRP_GET_SCAEH_COL('CORRESPONDENCE_CAT'
, CORRESPONDENCE_CAT
, PERSON_ID
, COURSE_CD
, HIST_START_DT
, COURSE_ATTEMPT_STATUS)
, 1
, 10)
, SUBSTR(IGS_EN_GET_SCAEH_DTL.ENRP_GET_SCAEH_COL('SELF_HELP_GROUP_IND'
, SELF_HELP_GROUP_IND
, PERSON_ID
, COURSE_CD
, HIST_START_DT
, COURSE_ATTEMPT_STATUS)
, 1
, 1)
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, SUBSTR(IGS_EN_GET_SCAEH_DTL.ENRP_GET_SCAEH_COL('PRIMARY_PROGRAM_TYPE'
, PRIMARY_PROGRAM_TYPE
, PERSON_ID
, COURSE_CD
, HIST_START_DT
, COURSE_ATTEMPT_STATUS)
, 1
, 10)
, SUBSTR(IGS_EN_GET_SCAEH_DTL.ENRP_GET_SCAEH_COL('KEY_PROGRAM'
, KEY_PROGRAM
, PERSON_ID
, COURSE_CD
, HIST_START_DT
, COURSE_ATTEMPT_STATUS)
, 1
, 1)
FROM IGS_AS_SCA_H_V