eTRM uses javascript that opens and focuses a separate window to display reports.
Your browser does not appear to support javascript. This should not prevent you from using
eTRM but it does mean the window focus feature will not work. Please check the contents of
other windows on your desktop if you click on a link that does not appear to do anything.
[Home] [Help]
View: IGSBV_HIGHER_EDU_PRG_AWARDS
Product: IGS - Student System
Description: 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:
APPS.IGSBV_HIGHER_EDU_PRG_AWARDS
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
Columns
Name
PROGRAM_CODE
VERSION_NUMBER
AWARD_CODE
AWARD_TITLE
DEFAULT_INDICATOR
PROGRAM_TITLE
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE