Product: | IGS - Student System (Obsolete) |
---|---|
Description: | This view provides the information about the targeted awards for each student program attempt. |
Implementation/DBA Data: | Not implemented in this database |
SELECT SAA.PERSON_ID
, HP.PARTY_NUMBER
, HP.PARTY_NAME
, SAA.COURSE_CD
, PV.TITLE
, SAA.AWARD_CD
, PA.AWARD_TITLE
, SAA.START_DT
, SAA.END_DT
, SAA.COMPLETE_IND
, '_LA:COMPLETE_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, SAA.CONFERRAL_DATE
, SAA.AWARD_MARK
, SAA.AWARD_GRADE
, GSG.FULL_GRADE_NAME
, SAA.GRADING_SCHEMA_CD
, SAA.GS_VERSION_NUMBER
, SAA.CREATED_BY
, SAA.CREATION_DATE
, SAA.LAST_UPDATED_BY
, SAA.LAST_UPDATE_DATE
FROM IGS_EN_SPA_AWD_AIM SAA
, IGS_EN_STDNT_PS_ATT_ALL SPA
, HZ_PARTIES HP
, IGS_PS_VER_ALL PV
, IGS_PS_AWD PA
, IGS_AS_GRD_SCH_GRADE GSG
, IGS_AS_GRD_SCHEMA GS
WHERE SAA.AWARD_CD = PA.AWARD_CD
AND SAA.PERSON_ID = SPA.PERSON_ID
AND SAA.COURSE_CD = SPA.COURSE_CD
AND PV.COURSE_CD = SPA.COURSE_CD
AND PV.VERSION_NUMBER = SPA.VERSION_NUMBER
AND SAA.PERSON_ID = HP.PARTY_ID
AND SAA.AWARD_GRADE = GSG.GRADE (+)
AND SAA.GRADING_SCHEMA_CD = GSG.GRADING_SCHEMA_CD (+)
AND SAA.GS_VERSION_NUMBER = GSG.VERSION_NUMBER (+)
AND SAA.GRADING_SCHEMA_CD = GS.GRADING_SCHEMA_CD (+)
AND SAA.GS_VERSION_NUMBER = GS.VERSION_NUMBER (+) WITH READ ONLY