View: IGS_AS_SCAH_EFFECTIVE_H_V

View Text

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

Columns