Product: | IGS - Student System (Obsolete) |
---|---|
Description: | This view stores the information about maintenance of a student's targeted awards for each student program attempt, including start/end dates and completion flag. |
Implementation/DBA Data: | Not implemented in this database |
SELECT SCA.ROWID
, SCA.PERSON_ID
, PE.PARTY_NUMBER
, SCA.COURSE_CD
, SCA.VERSION_NUMBER
, SCA.COURSE_CD || '/' || SCA.VERSION_NUMBER
, SPA.AWARD_CD
, PE.PARTY_NAME
, CRV.COURSE_TYPE
, SUSA.UNIT_SET_CD
, SUSA.US_VERSION_NUMBER
, SCA.CREATED_BY
, SCA.CREATION_DATE
, SCA.LAST_UPDATED_BY
, SCA.LAST_UPDATE_DATE
, SCA.LAST_UPDATE_LOGIN
, SPA.START_DT
, SPA.END_DT
, SPA.AWARD_MARK
, SPA.AWARD_GRADE
, SPA.GRADING_SCHEMA_CD
, SPA.GS_VERSION_NUMBER
, SCA.COURSE_RQRMNT_COMPLETE_IND
, SPA.COMPLETE_IND
, SPA.CONFERRAL_DATE
FROM HZ_PARTIES PE
, IGS_EN_STDNT_PS_ATT_SV SCA
, IGS_EN_SPA_AWD_AIM_V SPA
, IGS_PS_VER CRV
, IGS_AS_SU_SETATMPT SUSA
WHERE SCA.PERSON_ID = SPA.PERSON_ID(+)
AND SCA.COURSE_CD = SPA.COURSE_CD(+)
AND SCA.PERSON_ID = PE.PARTY_ID
AND SCA.COURSE_CD = CRV.COURSE_CD
AND SCA.VERSION_NUMBER = CRV.VERSION_NUMBER
AND SUSA.PERSON_ID (+) = SCA.PERSON_ID
AND SUSA.COURSE_CD (+) = SCA.COURSE_CD
AND SUSA.STUDENT_CONFIRMED_IND (+) = 'Y'
AND SUSA.END_DT (+) IS NULL
AND SCA.COURSE_ATTEMPT_STATUS IN ('INACTIVE'
, 'ENROLLED'
, 'COMPLETED')