This is the base view which describes the award to students on completion of the program. The allowance has been made for zero to many awards per program.
Implementation/DBA Data:
Not implemented in this database
View Text
SELECT AW.COURSE_CD , AW.VERSION_NUMBER , AW.AWARD_CD , AW.AWARD_TITLE , AW.DEFAULT_IND , PSV.TITLE , AW.CREATED_BY , AW.CREATION_DATE , AW.LAST_UPDATED_BY , AW.LAST_UPDATE_DATE FROM IGS_PS_AWARD AW , IGS_PS_VER_ALL PSV , IGS_PS_AWD AWD WHERE AW.COURSE_CD = PSV.COURSE_CD AND AW.VERSION_NUMBER = PSV.VERSION_NUMBER AND AW.AWARD_CD = AWD.AWARD_CD WITH READ ONLY