eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.IGSFV_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, CA.DESCRIPTION, LOC1.DESCRIPTION, AM1.DESCRIPTION, ATT1.DESCRIPTION, AM2.DESCRIPTION, ATT2.DESCRIPTION, CC.DESCRIPTION, CI.DESCRIPTION, DR.DESCRIPTION, ENCP.DESCRIPTION, FC.DESCRIPTION, FS.DESCRIPTION, LOC2.DESCRIPTION, PCS.CLASS_STANDING, '_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', '_DF:IGS:IGS_EN_STDNT_ATT_FLEX:SCA', 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, IGS_CA_TYPE CA, IGS_AD_LOCATION_ALL LOC1, IGS_EN_ATD_MODE_ALL AM1, IGS_EN_ATD_TYPE_ALL ATT1, IGS_EN_ATD_MODE_ALL AM2, IGS_EN_ATD_TYPE_ALL ATT2, IGS_CO_CAT CC, IGS_CA_INST_ALL CI, IGS_EN_DCNT_REASONCD_ALL DR, IGS_EN_NOM_CMPL_PRD ENCP, IGS_FI_FEE_CAT_ALL FC, IGS_FI_FUND_SRC_ALL FS, IGS_AD_LOCATION_ALL LOC2, IGS_PR_CLASS_STD PCS WHERE SCA.PERSON_ID = HP.PARTY_ID AND SCA.COURSE_CD = PSV.COURSE_CD AND SCA.VERSION_NUMBER = PSV.VERSION_NUMBER AND SCA.CAL_TYPE = CA.CAL_TYPE AND SCA.LOCATION_CD = LOC1.LOCATION_CD AND SCA.ATTENDANCE_MODE = AM1.ATTENDANCE_MODE AND SCA.ATTENDANCE_TYPE = ATT1.ATTENDANCE_TYPE AND SCA.DERIVED_ATT_MODE = AM2.ATTENDANCE_MODE (+) AND SCA.DERIVED_ATT_TYPE = ATT2.ATTENDANCE_TYPE (+) AND SCA.CORRESPONDENCE_CAT = CC.CORRESPONDENCE_CAT (+) AND SCA.CATALOG_CAL_TYPE = CI.CAL_TYPE (+) AND SCA.CATALOG_SEQ_NUM = CI.SEQUENCE_NUMBER (+) AND SCA.DISCONTINUATION_REASON_CD = DR.DISCONTINUATION_REASON_CD (+) AND SCA.NOMINATED_COMPLETION_PERD = ENCP.COMPLETION_PERD (+) AND SCA.FEE_CAT = FC.FEE_CAT (+) AND SCA.FUNDING_SOURCE = FS.FUNDING_SOURCE (+) AND SCA.EXAM_LOCATION_CD = LOC2.LOCATION_CD (+) AND SCA.IGS_PR_CLASS_STD_ID = PCS.IGS_PR_CLASS_STD_ID (+) 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
, CA.DESCRIPTION
, LOC1.DESCRIPTION
, AM1.DESCRIPTION
, ATT1.DESCRIPTION
, AM2.DESCRIPTION
, ATT2.DESCRIPTION
, CC.DESCRIPTION
, CI.DESCRIPTION
, DR.DESCRIPTION
, ENCP.DESCRIPTION
, FC.DESCRIPTION
, FS.DESCRIPTION
, LOC2.DESCRIPTION
, PCS.CLASS_STANDING
, '_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'
, '_DF:IGS:IGS_EN_STDNT_ATT_FLEX:SCA'
, 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
, IGS_CA_TYPE CA
, IGS_AD_LOCATION_ALL LOC1
, IGS_EN_ATD_MODE_ALL AM1
, IGS_EN_ATD_TYPE_ALL ATT1
, IGS_EN_ATD_MODE_ALL AM2
, IGS_EN_ATD_TYPE_ALL ATT2
, IGS_CO_CAT CC
, IGS_CA_INST_ALL CI
, IGS_EN_DCNT_REASONCD_ALL DR
, IGS_EN_NOM_CMPL_PRD ENCP
, IGS_FI_FEE_CAT_ALL FC
, IGS_FI_FUND_SRC_ALL FS
, IGS_AD_LOCATION_ALL LOC2
, IGS_PR_CLASS_STD PCS
WHERE SCA.PERSON_ID = HP.PARTY_ID
AND SCA.COURSE_CD = PSV.COURSE_CD
AND SCA.VERSION_NUMBER = PSV.VERSION_NUMBER
AND SCA.CAL_TYPE = CA.CAL_TYPE
AND SCA.LOCATION_CD = LOC1.LOCATION_CD
AND SCA.ATTENDANCE_MODE = AM1.ATTENDANCE_MODE
AND SCA.ATTENDANCE_TYPE = ATT1.ATTENDANCE_TYPE
AND SCA.DERIVED_ATT_MODE = AM2.ATTENDANCE_MODE (+)
AND SCA.DERIVED_ATT_TYPE = ATT2.ATTENDANCE_TYPE (+)
AND SCA.CORRESPONDENCE_CAT = CC.CORRESPONDENCE_CAT (+)
AND SCA.CATALOG_CAL_TYPE = CI.CAL_TYPE (+)
AND SCA.CATALOG_SEQ_NUM = CI.SEQUENCE_NUMBER (+)
AND SCA.DISCONTINUATION_REASON_CD = DR.DISCONTINUATION_REASON_CD (+)
AND SCA.NOMINATED_COMPLETION_PERD = ENCP.COMPLETION_PERD (+)
AND SCA.FEE_CAT = FC.FEE_CAT (+)
AND SCA.FUNDING_SOURCE = FS.FUNDING_SOURCE (+)
AND SCA.EXAM_LOCATION_CD = LOC2.LOCATION_CD (+)
AND SCA.IGS_PR_CLASS_STD_ID = PCS.IGS_PR_CLASS_STD_ID (+) WITH READ ONLY