VIEW: APPS.IGS_EN_STDNT_COURSE_ATTEMPT_V

Source

View Text - Preformatted

SELECT sca.person_id, sca.course_cd, sca.version_number, crv.TITLE, sca.course_attempt_status, sca.created_by, sca.creation_date, sca.last_updated_by, sca.last_update_date, sca.last_update_login FROM IGS_EN_STDNT_PS_ATT sca, IGS_PS_VER crv WHERE sca.course_cd = crv.course_cd AND sca.version_number = crv.version_number AND sca.course_attempt_status in ('ENROLLED','INACTIVE','INTERMIT','UNCONFIRM','DISCONTIN') -- In future needs to include courses which have been applied for via IGS_PS_COURSE -- admission applications (include UNION statement).

View Text - HTML Formatted

SELECT SCA.PERSON_ID
, SCA.COURSE_CD
, SCA.VERSION_NUMBER
, CRV.TITLE
, SCA.COURSE_ATTEMPT_STATUS
, SCA.CREATED_BY
, SCA.CREATION_DATE
, SCA.LAST_UPDATED_BY
, SCA.LAST_UPDATE_DATE
, SCA.LAST_UPDATE_LOGIN
FROM IGS_EN_STDNT_PS_ATT SCA
, IGS_PS_VER CRV
WHERE SCA.COURSE_CD = CRV.COURSE_CD
AND SCA.VERSION_NUMBER = CRV.VERSION_NUMBER
AND SCA.COURSE_ATTEMPT_STATUS IN ('ENROLLED'
, 'INACTIVE'
, 'INTERMIT'
, 'UNCONFIRM'
, 'DISCONTIN') -- IN FUTURE NEEDS TO INCLUDE COURSES WHICH HAVE BEEN APPLIED FOR VIA IGS_PS_COURSE -- ADMISSION APPLICATIONS (INCLUDE UNION STATEMENT).