Product: | IGS - Student System (Obsolete) |
---|---|
Description: | This view is used to merge student course attempt history with the current student course attempt details enabling all details to be accessed over time, up till the current day. Each entry represents all column values over defined time peri |
Implementation/DBA Data: | Not implemented in this database |
SELECT SCAH1.PERSON_ID
, SCAH1.COURSE_CD
, SCAH1.HIST_START_DT
, SCAH1.HIST_END_DT
, SCAH1.HIST_WHO
, NVL(SCAH1.VERSION_NUMBER
, NVL( IGS_GE_NUMBER.TO_NUM(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('VERSION_NUMBER'
, SCAH1.PERSON_ID
, SCAH1.COURSE_CD
, SCAH1.HIST_END_DT))
, SCA1.VERSION_NUMBER))
, SUBSTR(NVL(SCAH1.CAL_TYPE
, NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('CAL_TYPE'
, SCAH1.PERSON_ID
, SCAH1.COURSE_CD
, SCAH1.HIST_END_DT)
, SCA1.CAL_TYPE))
, 1
, 10)
, SUBSTR(NVL(SCAH1.LOCATION_CD
, NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('LOCATION_CD'
, SCAH1.PERSON_ID
, SCAH1.COURSE_CD
, SCAH1.HIST_END_DT)
, SCA1.LOCATION_CD))
, 1
, 10)
, SUBSTR(NVL(SCAH1.ATTENDANCE_MODE
, NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('ATTENDANCE_MODE'
, SCAH1.PERSON_ID
, SCAH1.COURSE_CD
, SCAH1.HIST_END_DT)
, SCA1.ATTENDANCE_MODE))
, 1
, 10)
, SUBSTR(NVL(SCAH1.ATTENDANCE_TYPE
, NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('ATTENDANCE_TYPE'
, SCAH1.PERSON_ID
, SCAH1.COURSE_CD
, SCAH1.HIST_END_DT)
, SCA1.ATTENDANCE_TYPE))
, 1
, 10)
, SUBSTR(NVL(SCAH1.STUDENT_CONFIRMED_IND
, NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('STUDENT_CONFIRMED_IND'
, SCAH1.PERSON_ID
, SCAH1.COURSE_CD
, SCAH1.HIST_END_DT)
, SCA1.STUDENT_CONFIRMED_IND))
, 1
, 1)
, NVL(SCAH1.COMMENCEMENT_DT
, NVL(IGS_GE_DATE.IGSDATE(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('COMMENCEMENT_DT'
, SCAH1.PERSON_ID
, SCAH1.COURSE_CD
, SCAH1.HIST_END_DT))
, SCA1.COMMENCEMENT_DT))
, SUBSTR(NVL(SCAH1.MANUAL_OVR_CMPL_DT_IND
, NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('MANUAL_OVR_CMPL_DT_IND'
, SCAH1.PERSON_ID
, SCAH1.COURSE_CD
, SCAH1.HIST_END_DT)
, SCA1.MANUAL_OVR_CMPL_DT_IND))
, 1
, 1)
, NVL(SCAH1.OVERRIDE_CMPL_DT
, NVL(IGS_GE_DATE.IGSDATE(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('OVERRIDE_CMPL_DT'
, SCAH1.PERSON_ID
, SCAH1.COURSE_CD
, SCAH1.HIST_END_DT))
, SCA1.OVERRIDE_CMPL_DT))
, SUBSTR(NVL(SCAH1.COURSE_ATTEMPT_STATUS
, NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('COURSE_ATTEMPT_STATUS'
, SCAH1.PERSON_ID
, SCAH1.COURSE_CD
, SCAH1.HIST_END_DT)
, SCA1.COURSE_ATTEMPT_STATUS))
, 1
, 10)
, SUBSTR(NVL(SCAH1.PROGRESSION_STATUS
, NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('PROGRESSION_STATUS'
, SCAH1.PERSON_ID
, SCAH1.COURSE_CD
, SCAH1.HIST_END_DT)
, SCA1.PROGRESSION_STATUS))
, 1
, 10)
, SUBSTR(NVL(SCAH1.DERIVED_ATT_TYPE
, NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('DERIVED_ATT_TYPE'
, SCAH1.PERSON_ID
, SCAH1.COURSE_CD
, SCAH1.HIST_END_DT)
, SCA1.DERIVED_ATT_TYPE))
, 1
, 10)
, SUBSTR(NVL(SCAH1.DERIVED_ATT_MODE
, NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('DERIVED_ATT_MODE'
, SCAH1.PERSON_ID
, SCAH1.COURSE_CD
, SCAH1.HIST_END_DT)
, SCA1.DERIVED_ATT_MODE))
, 1
, 10)
, SUBSTR(NVL(SCAH1.PROVISIONAL_IND
, NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('PROVISIONAL_IND'
, SCAH1.PERSON_ID
, SCAH1.COURSE_CD
, SCAH1.HIST_END_DT)
, SCA1.PROVISIONAL_IND))
, 1
, 1)
, NVL(SCAH1.DISCONTINUED_DT
, NVL(IGS_GE_DATE.IGSDATE(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('DISCONTINUED_DT'
, SCAH1.PERSON_ID
, SCAH1.COURSE_CD
, SCAH1.HIST_END_DT))
, SCA1.DISCONTINUED_DT))
, SUBSTR(NVL(SCAH1.DISCONTINUATION_REASON_CD
, NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('DISCONTINUED_REASON_CD'
, SCAH1.PERSON_ID
, SCAH1.COURSE_CD
, SCAH1.HIST_END_DT)
, SCA1.DISCONTINUATION_REASON_CD))
, 1
, 10)
, NVL(SCAH1.LAPSED_DT
, NVL(IGS_GE_DATE.IGSDATE(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('LAPSED_DT'
, SCAH1.PERSON_ID
, SCAH1.COURSE_CD
, SCAH1.HIST_END_DT))
, SCA1.LAPSED_DT))
, SUBSTR(NVL(SCAH1.FUNDING_SOURCE
, NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('FUNDING_SOURCE'
, SCAH1.PERSON_ID
, SCAH1.COURSE_CD
, SCAH1.HIST_END_DT)
, SCA1.FUNDING_SOURCE))
, 1
, 10)
, SUBSTR(NVL(SCAH1.EXAM_LOCATION_CD
, NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('EXAM_LOCATION_CD'
, SCAH1.PERSON_ID
, SCAH1.COURSE_CD
, SCAH1.HIST_END_DT)
, SCA1.EXAM_LOCATION_CD))
, 1
, 10)
, NVL(SCAH1.DERIVED_COMPLETION_YR
, NVL( IGS_GE_NUMBER.TO_NUM(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('DERIVED_COMPLETION_YR'
, SCAH1.PERSON_ID
, SCAH1.COURSE_CD
, SCAH1.HIST_END_DT))
, SCA1.DERIVED_COMPLETION_YR))
, SUBSTR(NVL(SCAH1.DERIVED_COMPLETION_PERD
, NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('DERIVED_COMPLETION_PERD'
, SCAH1.PERSON_ID
, SCAH1.COURSE_CD
, SCAH1.HIST_END_DT)
, SCA1.DERIVED_COMPLETION_PERD))
, 1
, 1)
, NVL(SCAH1.NOMINATED_COMPLETION_YR
, NVL( IGS_GE_NUMBER.TO_NUM(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('NOMINATED_COMPLETION_YR'
, SCAH1.PERSON_ID
, SCAH1.COURSE_CD
, SCAH1.HIST_END_DT))
, SCA1.NOMINATED_COMPLETION_YR))
, SUBSTR(NVL(SCAH1.NOMINATED_COMPLETION_PERD
, NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('NOMINATED_COMPLETION_PERD'
, SCAH1.PERSON_ID
, SCAH1.COURSE_CD
, SCAH1.HIST_END_DT)
, SCA1.NOMINATED_COMPLETION_PERD))
, 1
, 30)
, SUBSTR(NVL(SCAH1.RULE_CHECK_IND
, NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('RULE_CHECK_IND'
, SCAH1.PERSON_ID
, SCAH1.COURSE_CD
, SCAH1.HIST_END_DT)
, SCA1.RULE_CHECK_IND))
, 1
, 1)
, SUBSTR(NVL(SCAH1.WAIVE_OPTION_CHECK_IND
, NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('WAIVE_OPTION_CHECK_IND'
, SCAH1.PERSON_ID
, SCAH1.COURSE_CD
, SCAH1.HIST_END_DT)
, SCA1.WAIVE_OPTION_CHECK_IND))
, 1
, 1)
, NVL(SCAH1.LAST_RULE_CHECK_DT
, NVL(IGS_GE_DATE.IGSDATE(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('LAST_RUL_CHECK_DT'
, SCAH1.PERSON_ID
, SCAH1.COURSE_CD
, SCAH1.HIST_END_DT))
, SCA1.LAST_RULE_CHECK_DT))
, SUBSTR(NVL(SCAH1.PUBLISH_OUTCOMES_IND
, NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('PUBLISH_OUTCOMES_IND'
, SCAH1.PERSON_ID
, SCAH1.COURSE_CD
, SCAH1.HIST_END_DT)
, SCA1.PUBLISH_OUTCOMES_IND))
, 1
, 1)
, SUBSTR(NVL(SCAH1.COURSE_RQRMNT_COMPLETE_IND
, NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('COURSE_RQRMNT_COMPLETE_IND'
, SCAH1.PERSON_ID
, SCAH1.COURSE_CD
, SCAH1.HIST_END_DT)
, SCA1.COURSE_RQRMNT_COMPLETE_IND))
, 1
, 1)
, NVL(SCAH1.COURSE_RQRMNTS_COMPLETE_DT
, NVL(IGS_GE_DATE.IGSDATE(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('COURSE_RQRMNTS_COMPLETE_DT'
, SCAH1.PERSON_ID
, SCAH1.COURSE_CD
, SCAH1.HIST_END_DT))
, SCA1.COURSE_RQRMNTS_COMPLETE_DT))
, SUBSTR(NVL(SCAH1.S_COMPLETED_SOURCE_TYPE
, NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('S_COMPLETED_SOURCE_TYPE'
, SCAH1.PERSON_ID
, SCAH1.COURSE_CD
, SCAH1.HIST_END_DT)
, SCA1.S_COMPLETED_SOURCE_TYPE))
, 1
, 10)
, NVL(SCAH1.OVERRIDE_TIME_LIMITATION
, NVL( IGS_GE_NUMBER.TO_NUM(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('OVERRIDE_TIME_LIMITATION'
, SCAH1.PERSON_ID
, SCAH1.COURSE_CD
, SCAH1.HIST_END_DT))
, SCA1.OVERRIDE_TIME_LIMITATION))
, SUBSTR(NVL(SCAH1.ADVANCED_STANDING_IND
, NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('ADVANCED_STANDING_IND'
, SCAH1.PERSON_ID
, SCAH1.COURSE_CD
, SCAH1.HIST_END_DT)
, SCA1.ADVANCED_STANDING_IND))
, 1
, 1)
, SUBSTR(NVL(SCAH1.FEE_CAT
, NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('FEE_CAT'
, SCAH1.PERSON_ID
, SCAH1.COURSE_CD
, SCAH1.HIST_END_DT)
, SCA1.FEE_CAT))
, 1
, 10)
, SUBSTR(NVL(SCAH1.CORRESPONDENCE_CAT
, NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('CORRESPONDENCE_CAT'
, SCAH1.PERSON_ID
, SCAH1.COURSE_CD
, SCAH1.HIST_END_DT)
, SCA1.CORRESPONDENCE_CAT))
, 1
, 10)
, SUBSTR(NVL(SCAH1.SELF_HELP_GROUP_IND
, NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('SELF_HELP_GROUP_IND'
, SCAH1.PERSON_ID
, SCAH1.COURSE_CD
, SCAH1.HIST_END_DT)
, SCA1.SELF_HELP_GROUP_IND))
, 1
, 1)
, NVL(SCAH1.ADM_ADMISSION_APPL_NUMBER
, NVL( IGS_GE_NUMBER.TO_NUM(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('ADM_ADMISSION_APPL_NUMBER'
, SCAH1.PERSON_ID
, SCAH1.COURSE_CD
, SCAH1.HIST_END_DT))
, SCA1.ADM_ADMISSION_APPL_NUMBER))
, SUBSTR(NVL(SCAH1.ADM_NOMINATED_COURSE_CD
, NVL(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('ADM_NOMINATED_COURSE_CD'
, SCAH1.PERSON_ID
, SCAH1.COURSE_CD
, SCAH1.HIST_END_DT)
, SCA1.ADM_NOMINATED_COURSE_CD))
, 1
, 6)
, NVL(SCAH1.ADM_SEQUENCE_NUMBER
, NVL( IGS_GE_NUMBER.TO_NUM(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('ADM_SEQUENCE_NUMBER'
, SCAH1.PERSON_ID
, SCAH1.COURSE_CD
, SCAH1.HIST_END_DT))
, SCA1.ADM_SEQUENCE_NUMBER))
, NVL(SCAH1.LAST_DATE_OF_ATTENDANCE
, NVL(IGS_GE_DATE.IGSDATE(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('LAST_DATE_OF_ATTENDANCE'
, SCAH1.PERSON_ID
, SCAH1.COURSE_CD
, SCAH1.HIST_END_DT))
, SCA1.LAST_DATE_OF_ATTENDANCE))
, SUBSTR(NVL(SCAH1.DROPPED_BY
, NVL( IGS_AU_GEN_003.AUDP_GET_SCAH_COL ('DROPPED_BY'
, SCAH1.PERSON_ID
, SCAH1.COURSE_CD
, SCAH1.HIST_END_DT)
, SCA1.DROPPED_BY))
, 1
, 30)
, SUBSTR(NVL(SCAH1.PRIMARY_PROGRAM_TYPE
, NVL( IGS_AU_GEN_003.AUDP_GET_SCAH_COL ('PRIMARY_PROGRAM_TYPE'
, SCAH1.PERSON_ID
, SCAH1.COURSE_CD
, SCAH1.HIST_END_DT)
, SCA1.PRIMARY_PROGRAM_TYPE))
, 1
, 10)
, SUBSTR(NVL(SCAH1.PRIMARY_PROG_TYPE_SOURCE
, NVL( IGS_AU_GEN_003.AUDP_GET_SCAH_COL ('PRIMARY_PROG_TYPE_SOURCE'
, SCAH1.PERSON_ID
, SCAH1.COURSE_CD
, SCAH1.HIST_END_DT)
, SCA1.PRIMARY_PROG_TYPE_SOURCE))
, 1
, 10)
, SUBSTR(NVL(SCAH1.CATALOG_CAL_TYPE
, NVL( IGS_AU_GEN_003.AUDP_GET_SCAH_COL ('CATALOG_CAL_TYPE'
, SCAH1.PERSON_ID
, SCAH1.COURSE_CD
, SCAH1.HIST_END_DT)
, SCA1.CATALOG_CAL_TYPE))
, 1
, 10)
, NVL(SCAH1.CATALOG_SEQ_NUM
, NVL(IGS_GE_NUMBER.TO_NUM(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('CATALOG_SEQ_NUM'
, SCAH1.PERSON_ID
, SCAH1.COURSE_CD
, SCAH1.HIST_END_DT))
, SCA1.CATALOG_SEQ_NUM))
, SUBSTR(NVL(SCAH1.KEY_PROGRAM
, NVL( IGS_AU_GEN_003.AUDP_GET_SCAH_COL ('KEY_PROGRAM'
, SCAH1.PERSON_ID
, SCAH1.COURSE_CD
, SCAH1.HIST_END_DT)
, SCA1.KEY_PROGRAM))
, 1
, 1)
, SCAH1.CREATED_BY
, SCAH1.CREATION_DATE
, SCAH1.LAST_UPDATED_BY
, SCAH1.LAST_UPDATE_DATE
, SCAH1.LAST_UPDATE_LOGIN
, NVL(SCAH1.COO_ID
, NVL(IGS_GE_NUMBER.TO_NUM(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('COO_ID'
, SCAH1.PERSON_ID
, SCAH1.COURSE_CD
, SCAH1.HIST_END_DT))
, SCA1.COO_ID))
, NVL(SCAH1.IGS_PR_CLASS_STD_ID
, NVL(IGS_GE_NUMBER.TO_NUM(IGS_AU_GEN_003.AUDP_GET_SCAH_COL('IGS_PR_CLASS_STD_ID'
, SCAH1.PERSON_ID
, SCAH1.COURSE_CD
, SCAH1.HIST_END_DT))
, SCA1.IGS_PR_CLASS_STD_ID))
FROM IGS_AS_SC_ATTEMPT_H SCAH1
, IGS_EN_STDNT_PS_ATT_ALL SCA1
WHERE SCA1.PERSON_ID = SCAH1.PERSON_ID
AND SCA1.COURSE_CD = SCAH1.COURSE_CD UNION ALL SELECT SCA2.PERSON_ID
, SCA2.COURSE_CD
, NVL(MAX(SCAH2.HIST_END_DT)
, SCA2.LAST_UPDATE_DATE)
, TO_DATE(NULL)
, SCA2.LAST_UPDATED_BY
, SCA2.VERSION_NUMBER
, SCA2.CAL_TYPE
, SCA2.LOCATION_CD
, SCA2.ATTENDANCE_MODE
, SCA2.ATTENDANCE_TYPE
, SCA2.STUDENT_CONFIRMED_IND
, SCA2.COMMENCEMENT_DT
, SCA2.MANUAL_OVR_CMPL_DT_IND
, SCA2.OVERRIDE_CMPL_DT
, SCA2.COURSE_ATTEMPT_STATUS
, SCA2.PROGRESSION_STATUS
, SCA2.DERIVED_ATT_TYPE
, SCA2.DERIVED_ATT_MODE
, SCA2.PROVISIONAL_IND
, SCA2.DISCONTINUED_DT
, SCA2.DISCONTINUATION_REASON_CD
, SCA2.LAPSED_DT
, SCA2.FUNDING_SOURCE
, SCA2.EXAM_LOCATION_CD
, SCA2.DERIVED_COMPLETION_YR
, SCA2.DERIVED_COMPLETION_PERD
, SCA2.NOMINATED_COMPLETION_YR
, SCA2.NOMINATED_COMPLETION_PERD
, SCA2.RULE_CHECK_IND
, SCA2.WAIVE_OPTION_CHECK_IND
, SCA2.LAST_RULE_CHECK_DT
, SCA2.PUBLISH_OUTCOMES_IND
, SCA2.COURSE_RQRMNT_COMPLETE_IND
, SCA2.COURSE_RQRMNTS_COMPLETE_DT
, SCA2.S_COMPLETED_SOURCE_TYPE
, SCA2.OVERRIDE_TIME_LIMITATION
, SCA2.ADVANCED_STANDING_IND
, SCA2.FEE_CAT
, SCA2.CORRESPONDENCE_CAT
, SCA2.SELF_HELP_GROUP_IND
, SCA2.ADM_ADMISSION_APPL_NUMBER
, SCA2.ADM_NOMINATED_COURSE_CD
, SCA2.ADM_SEQUENCE_NUMBER
, SCA2.LAST_DATE_OF_ATTENDANCE
, SCA2.DROPPED_BY
, SCA2.PRIMARY_PROGRAM_TYPE
, SCA2.PRIMARY_PROG_TYPE_SOURCE
, SCA2.CATALOG_CAL_TYPE
, SCA2.CATALOG_SEQ_NUM
, SCA2.KEY_PROGRAM
, SCA2.CREATED_BY
, SCA2.CREATION_DATE
, SCA2.LAST_UPDATED_BY
, SCA2.LAST_UPDATE_DATE
, SCA2.LAST_UPDATE_LOGIN
, SCA2.COO_ID
, SCA2.IGS_PR_CLASS_STD_ID FROM IGS_EN_STDNT_PS_ATT_ALL SCA2
, IGS_AS_SC_ATTEMPT_H SCAH2 WHERE SCA2.PERSON_ID = SCAH2.PERSON_ID(+)
AND SCA2.COURSE_CD = SCAH2.COURSE_CD(+) GROUP BY SCA2.PERSON_ID
, SCA2.COURSE_CD
, SCA2.VERSION_NUMBER
, SCA2.CAL_TYPE
, SCA2.LOCATION_CD
, SCA2.ATTENDANCE_MODE
, SCA2.ATTENDANCE_TYPE
, SCA2.STUDENT_CONFIRMED_IND
, SCA2.COMMENCEMENT_DT
, SCA2.MANUAL_OVR_CMPL_DT_IND
, SCA2.OVERRIDE_CMPL_DT
, SCA2.COURSE_ATTEMPT_STATUS
, SCA2.PROGRESSION_STATUS
, SCA2.DERIVED_ATT_TYPE
, SCA2.DERIVED_ATT_MODE
, SCA2.PROVISIONAL_IND
, SCA2.DISCONTINUED_DT
, SCA2.DISCONTINUATION_REASON_CD
, SCA2.LAPSED_DT
, SCA2.FUNDING_SOURCE
, SCA2.EXAM_LOCATION_CD
, SCA2.DERIVED_COMPLETION_YR
, SCA2.DERIVED_COMPLETION_PERD
, SCA2.NOMINATED_COMPLETION_YR
, SCA2.NOMINATED_COMPLETION_PERD
, SCA2.RULE_CHECK_IND
, SCA2.WAIVE_OPTION_CHECK_IND
, SCA2.LAST_RULE_CHECK_DT
, SCA2.PUBLISH_OUTCOMES_IND
, SCA2.COURSE_RQRMNT_COMPLETE_IND
, SCA2.COURSE_RQRMNTS_COMPLETE_DT
, SCA2.S_COMPLETED_SOURCE_TYPE
, SCA2.OVERRIDE_TIME_LIMITATION
, SCA2.ADVANCED_STANDING_IND
, SCA2.FEE_CAT
, SCA2.CORRESPONDENCE_CAT
, SCA2.SELF_HELP_GROUP_IND
, SCA2.ADM_ADMISSION_APPL_NUMBER
, SCA2.ADM_NOMINATED_COURSE_CD
, SCA2.ADM_SEQUENCE_NUMBER
, SCA2.LAST_DATE_OF_ATTENDANCE
, SCA2.DROPPED_BY
, SCA2.PRIMARY_PROGRAM_TYPE
, SCA2.PRIMARY_PROG_TYPE_SOURCE
, SCA2.CATALOG_CAL_TYPE
, SCA2.CATALOG_SEQ_NUM
, SCA2.KEY_PROGRAM
, SCA2.CREATED_BY
, SCA2.CREATION_DATE
, SCA2.LAST_UPDATED_BY
, SCA2.LAST_UPDATE_DATE
, SCA2.LAST_UPDATE_LOGIN
, SCA2.COO_ID
, SCA2.IGS_PR_CLASS_STD_ID