View: IGS_EN_STDNT_COURSE_ATTEMPT_V

Product:	IGS - Student System
Description:	Student course details from student course attempts and admission applications.
Implementation/DBA Data:	APPS.IGS_EN_STDNT_COURSE_ATTEMPT_V

View Text

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

Columns