VIEW: APPS.IGSBV_STUDENT_PROGRAM_ATTEMPTS

Source

View Text - Preformatted

SELECT SCA.PERSON_ID, SCA.COURSE_CD, SCA.VERSION_NUMBER, SCA.CAL_TYPE, SCA.LOCATION_CD, SCA.ATTENDANCE_MODE, SCA.ATTENDANCE_TYPE, SCA.COO_ID, SCA.STUDENT_CONFIRMED_IND, SCA.COMMENCEMENT_DT, SCA.COURSE_ATTEMPT_STATUS, SCA.PROGRESSION_STATUS, SCA.DERIVED_ATT_TYPE, SCA.DERIVED_ATT_MODE, SCA.PROVISIONAL_IND, SCA.DISCONTINUED_DT, SCA.DISCONTINUATION_REASON_CD, SCA.LAPSED_DT , SCA.FUNDING_SOURCE, SCA.EXAM_LOCATION_CD, SCA.DERIVED_COMPLETION_YR, SCA.DERIVED_COMPLETION_PERD, SCA.NOMINATED_COMPLETION_YR, SCA.NOMINATED_COMPLETION_PERD, SCA.RULE_CHECK_IND, SCA.WAIVE_OPTION_CHECK_IND, SCA.LAST_RULE_CHECK_DT, SCA.PUBLISH_OUTCOMES_IND, SCA.COURSE_RQRMNT_COMPLETE_IND, SCA.COURSE_RQRMNTS_COMPLETE_DT, SCA.S_COMPLETED_SOURCE_TYPE, SCA.OVERRIDE_TIME_LIMITATION, SCA.ADVANCED_STANDING_IND, SCA.FEE_CAT, SCA.CORRESPONDENCE_CAT, SCA.SELF_HELP_GROUP_IND, SCA.LOGICAL_DELETE_DT, SCA.ADM_ADMISSION_APPL_NUMBER, SCA.ADM_NOMINATED_COURSE_CD, SCA.ADM_SEQUENCE_NUMBER, SCA.LAST_DATE_OF_ATTENDANCE, SCA.DROPPED_BY, SCA.IGS_PR_CLASS_STD_ID, SCA.PRIMARY_PROGRAM_TYPE, SCA.PRIMARY_PROG_TYPE_SOURCE, SCA.CATALOG_CAL_TYPE, SCA.CATALOG_SEQ_NUM, SCA.KEY_PROGRAM , SCA.OVERRIDE_CMPL_DT , SCA.MANUAL_OVR_CMPL_DT_IND , HP.PARTY_NUMBER, PSV.TITLE, '_LA:COURSE_ATTEMPT_STATUS:IGS_LOOKUP_VALUES:CRS_ATTEMPT_STATUS:MEANING', '_LA:PROGRESSION_STATUS:IGS_LOOKUP_VALUES:PROGRESSION_STATUS:MEANING', '_LA:PRIMARY_PROG_TYPE_SOURCE:IGS_LOOKUP_VALUES:IGS_EN_PP_SOURCE:MEANING', SCA.CREATED_BY, SCA.CREATION_DATE, SCA.LAST_UPDATED_BY, SCA.LAST_UPDATE_DATE, SCA.FUTURE_DATED_TRANS_FLAG FROM IGS_EN_STDNT_PS_ATT_ALL SCA, HZ_PARTIES HP, IGS_PS_VER_ALL PSV WHERE SCA.PERSON_ID = HP.PARTY_ID AND SCA.COURSE_CD = PSV.COURSE_CD AND SCA.VERSION_NUMBER = PSV.VERSION_NUMBER WITH READ ONLY

View Text - HTML Formatted

SELECT SCA.PERSON_ID
, SCA.COURSE_CD
, SCA.VERSION_NUMBER
, SCA.CAL_TYPE
, SCA.LOCATION_CD
, SCA.ATTENDANCE_MODE
, SCA.ATTENDANCE_TYPE
, SCA.COO_ID
, SCA.STUDENT_CONFIRMED_IND
, SCA.COMMENCEMENT_DT
, SCA.COURSE_ATTEMPT_STATUS
, SCA.PROGRESSION_STATUS
, SCA.DERIVED_ATT_TYPE
, SCA.DERIVED_ATT_MODE
, SCA.PROVISIONAL_IND
, SCA.DISCONTINUED_DT
, SCA.DISCONTINUATION_REASON_CD
, SCA.LAPSED_DT
, SCA.FUNDING_SOURCE
, SCA.EXAM_LOCATION_CD
, SCA.DERIVED_COMPLETION_YR
, SCA.DERIVED_COMPLETION_PERD
, SCA.NOMINATED_COMPLETION_YR
, SCA.NOMINATED_COMPLETION_PERD
, SCA.RULE_CHECK_IND
, SCA.WAIVE_OPTION_CHECK_IND
, SCA.LAST_RULE_CHECK_DT
, SCA.PUBLISH_OUTCOMES_IND
, SCA.COURSE_RQRMNT_COMPLETE_IND
, SCA.COURSE_RQRMNTS_COMPLETE_DT
, SCA.S_COMPLETED_SOURCE_TYPE
, SCA.OVERRIDE_TIME_LIMITATION
, SCA.ADVANCED_STANDING_IND
, SCA.FEE_CAT
, SCA.CORRESPONDENCE_CAT
, SCA.SELF_HELP_GROUP_IND
, SCA.LOGICAL_DELETE_DT
, SCA.ADM_ADMISSION_APPL_NUMBER
, SCA.ADM_NOMINATED_COURSE_CD
, SCA.ADM_SEQUENCE_NUMBER
, SCA.LAST_DATE_OF_ATTENDANCE
, SCA.DROPPED_BY
, SCA.IGS_PR_CLASS_STD_ID
, SCA.PRIMARY_PROGRAM_TYPE
, SCA.PRIMARY_PROG_TYPE_SOURCE
, SCA.CATALOG_CAL_TYPE
, SCA.CATALOG_SEQ_NUM
, SCA.KEY_PROGRAM
, SCA.OVERRIDE_CMPL_DT
, SCA.MANUAL_OVR_CMPL_DT_IND
, HP.PARTY_NUMBER
, PSV.TITLE
, '_LA:COURSE_ATTEMPT_STATUS:IGS_LOOKUP_VALUES:CRS_ATTEMPT_STATUS:MEANING'
, '_LA:PROGRESSION_STATUS:IGS_LOOKUP_VALUES:PROGRESSION_STATUS:MEANING'
, '_LA:PRIMARY_PROG_TYPE_SOURCE:IGS_LOOKUP_VALUES:IGS_EN_PP_SOURCE:MEANING'
, SCA.CREATED_BY
, SCA.CREATION_DATE
, SCA.LAST_UPDATED_BY
, SCA.LAST_UPDATE_DATE
, SCA.FUTURE_DATED_TRANS_FLAG
FROM IGS_EN_STDNT_PS_ATT_ALL SCA
, HZ_PARTIES HP
, IGS_PS_VER_ALL PSV
WHERE SCA.PERSON_ID = HP.PARTY_ID
AND SCA.COURSE_CD = PSV.COURSE_CD
AND SCA.VERSION_NUMBER = PSV.VERSION_NUMBER WITH READ ONLY