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.IGS_EN_SCA_V

Source

View Text - Preformatted


SELECT sca.ROW_ID , sca.ORG_ID , 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 , lkupv1.meaning CAS_MEANING , 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.CREATED_BY , sca.CREATION_DATE , sca.LAST_UPDATED_BY , sca.LAST_UPDATE_DATE , sca.LAST_UPDATE_LOGIN , sca.REQUEST_ID , sca.PROGRAM_APPLICATION_ID , sca.PROGRAM_ID , sca.PROGRAM_UPDATE_DATE, sca.primary_program_type, sca.primary_prog_type_source, lkupv2.meaning PRM_PRG_SOURCE_MEANING, sca.catalog_cal_type, sca.catalog_seq_num, ci.description CATALOG, psv.course_type COURSE_TYPE, psv.title, sca.key_program , sca.OVERRIDE_CMPL_DT , sca.MANUAL_OVR_CMPL_DT_IND , sca.ATTRIBUTE_CATEGORY ,sca.ATTRIBUTE1 ,sca.ATTRIBUTE2 ,sca.ATTRIBUTE3 ,sca.ATTRIBUTE4 ,sca.ATTRIBUTE5 ,sca.ATTRIBUTE6 ,sca.ATTRIBUTE7 ,sca.ATTRIBUTE8 ,sca.ATTRIBUTE9 ,sca.ATTRIBUTE10 ,sca.ATTRIBUTE11 ,sca.ATTRIBUTE12 ,sca.ATTRIBUTE13 ,sca.ATTRIBUTE14 ,sca.ATTRIBUTE15 ,sca.ATTRIBUTE16 ,sca.ATTRIBUTE17 ,sca.ATTRIBUTE18 ,sca.ATTRIBUTE19 ,sca.ATTRIBUTE20 ,sca.FUTURE_DATED_TRANS_FLAG FROM IGS_EN_STDNT_PS_ATT_SV sca, IGS_CA_INST ci, IGS_PS_VER psv, IGS_LOOKUP_VALUES lkupv1, IGS_LOOKUP_VALUES lkupv2 WHERE sca.catalog_cal_type = ci.cal_type(+) and sca.catalog_seq_num = ci.sequence_number(+) and lkupv1.lookup_type(+) = 'CRS_ATTEMPT_STATUS' and lkupv1.lookup_code(+) = sca.course_attempt_status and lkupv2.lookup_type(+) = 'IGS_EN_PP_SOURCE' and lkupv2.lookup_code(+) = sca.primary_prog_type_source and sca.course_cd = psv.course_cd and sca.version_number = psv.version_number

View Text - HTML Formatted

SELECT SCA.ROW_ID
, SCA.ORG_ID
, 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
, LKUPV1.MEANING CAS_MEANING
, 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.CREATED_BY
, SCA.CREATION_DATE
, SCA.LAST_UPDATED_BY
, SCA.LAST_UPDATE_DATE
, SCA.LAST_UPDATE_LOGIN
, SCA.REQUEST_ID
, SCA.PROGRAM_APPLICATION_ID
, SCA.PROGRAM_ID
, SCA.PROGRAM_UPDATE_DATE
, SCA.PRIMARY_PROGRAM_TYPE
, SCA.PRIMARY_PROG_TYPE_SOURCE
, LKUPV2.MEANING PRM_PRG_SOURCE_MEANING
, SCA.CATALOG_CAL_TYPE
, SCA.CATALOG_SEQ_NUM
, CI.DESCRIPTION CATALOG
, PSV.COURSE_TYPE COURSE_TYPE
, PSV.TITLE
, SCA.KEY_PROGRAM
, SCA.OVERRIDE_CMPL_DT
, SCA.MANUAL_OVR_CMPL_DT_IND
, SCA.ATTRIBUTE_CATEGORY
, SCA.ATTRIBUTE1
, SCA.ATTRIBUTE2
, SCA.ATTRIBUTE3
, SCA.ATTRIBUTE4
, SCA.ATTRIBUTE5
, SCA.ATTRIBUTE6
, SCA.ATTRIBUTE7
, SCA.ATTRIBUTE8
, SCA.ATTRIBUTE9
, SCA.ATTRIBUTE10
, SCA.ATTRIBUTE11
, SCA.ATTRIBUTE12
, SCA.ATTRIBUTE13
, SCA.ATTRIBUTE14
, SCA.ATTRIBUTE15
, SCA.ATTRIBUTE16
, SCA.ATTRIBUTE17
, SCA.ATTRIBUTE18
, SCA.ATTRIBUTE19
, SCA.ATTRIBUTE20
, SCA.FUTURE_DATED_TRANS_FLAG
FROM IGS_EN_STDNT_PS_ATT_SV SCA
, IGS_CA_INST CI
, IGS_PS_VER PSV
, IGS_LOOKUP_VALUES LKUPV1
, IGS_LOOKUP_VALUES LKUPV2
WHERE SCA.CATALOG_CAL_TYPE = CI.CAL_TYPE(+)
AND SCA.CATALOG_SEQ_NUM = CI.SEQUENCE_NUMBER(+)
AND LKUPV1.LOOKUP_TYPE(+) = 'CRS_ATTEMPT_STATUS'
AND LKUPV1.LOOKUP_CODE(+) = SCA.COURSE_ATTEMPT_STATUS
AND LKUPV2.LOOKUP_TYPE(+) = 'IGS_EN_PP_SOURCE'
AND LKUPV2.LOOKUP_CODE(+) = SCA.PRIMARY_PROG_TYPE_SOURCE
AND SCA.COURSE_CD = PSV.COURSE_CD
AND SCA.VERSION_NUMBER = PSV.VERSION_NUMBER