Product: | IGS - Student System (Obsolete) |
---|---|
Description: | This view stores the information about maintenance of a student's targeted awards for each student program attempt, including start/end dates and completion flag. |
Implementation/DBA Data: | Not implemented in this database |
SELECT ESA.ROWID
, ESA.PERSON_ID
, ESA.COURSE_CD
, ESA.AWARD_CD
, AWD.AWARD_TITLE DESCRIPTION
, ESA.START_DT
, ESA.END_DT
, ESA.COMPLETE_IND
, ESA.CONFERRAL_DATE
, ESA.CREATED_BY
, ESA.CREATION_DATE
, ESA.LAST_UPDATED_BY
, ESA.LAST_UPDATE_DATE
, ESA.LAST_UPDATE_LOGIN
, ESA.AWARD_MARK
, ESA.AWARD_GRADE
, ESA.GRADING_SCHEMA_CD
, ESA.GS_VERSION_NUMBER
FROM IGS_EN_SPA_AWD_AIM ESA
, IGS_PS_AWD AWD
WHERE ESA.AWARD_CD = AWD.AWARD_CD