Student course details from student course attempts and admission applications.
Implementation/DBA Data:
Not implemented in this database
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).
[Home] [Help]