[Home] [Help]
View: IGSFV_PR_STDNT_PRG_AWARDS
Product: | IGS - Student System (Obsolete) |
Description: | Describes the award the student will be given when a student progression outcome is applied. |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT HP.PARTY_NAME
, HP.PARTY_NUMBER
, AW.AWARD_TITLE
, SPAW.AWARD_CD
, SPAW.PERSON_ID
, SPAW.COURSE_CD
, SPAW.SPO_SEQUENCE_NUMBER
, SPAW.CREATED_BY
, SPAW.CREATION_DATE
, SPAW.LAST_UPDATED_BY
, SPAW.LAST_UPDATE_DATE
FROM IGS_PR_STDNT_PR_AWD SPAW
, HZ_PARTIES HP
, IGS_PS_AWD AW
WHERE SPAW.PERSON_ID = HP.PARTY_ID
AND SPAW.AWARD_CD = AW.AWARD_CD WITH READ ONLY
Columns
Name |
PERSON_NAME |
PERSON_NUMBER |
AWARD_TITLE |
AWARD_CODE |
PERSON_ID |
SPO_PROGRAM_CODE |
SPO_SEQUENCE_NUMBER |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |