[Home] [Help]
View: IGS_PR_OU_AWD_V
Product: | IGS - Student System (Obsolete) |
Description: | This view stores the awards associated with the rule for positive outcomes. |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT POA.ROWID
, POA.PROGRESSION_RULE_CAT
, POA.PRA_SEQUENCE_NUMBER
, POA.PRO_SEQUENCE_NUMBER
, POA.AWARD_CD
, AWD.AWARD_TITLE
, POA.CREATED_BY
, POA.CREATION_DATE
, POA.LAST_UPDATED_BY
, POA.LAST_UPDATE_DATE
, POA.LAST_UPDATE_LOGIN
FROM IGS_PR_OU_AWD POA
, IGS_PS_AWD AWD
WHERE AWD.AWARD_CD = POA.AWARD_CD
Columns
Name |
ROW_ID |
PROGRESSION_RULE_CAT |
PRA_SEQUENCE_NUMBER |
PRO_SEQUENCE_NUMBER |
AWARD_CD |
AWARD_TITLE |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |