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_STUDENT_PRG_AWARD_AIMS

Product:	IGS - Student System (Obsolete)
Description:	This view provides the information about the targeted awards for each student program attempt.
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT SAA.PERSON_ID
, HP.PARTY_NUMBER
, HP.PARTY_NAME
, SAA.COURSE_CD
, PV.TITLE
, SAA.AWARD_CD
, PA.AWARD_TITLE
, SAA.START_DT
, SAA.END_DT
, SAA.COMPLETE_IND
, '_LA:COMPLETE_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, SAA.CONFERRAL_DATE
, SAA.AWARD_MARK
, SAA.AWARD_GRADE
, SAA.GRADING_SCHEMA_CD
, SAA.GS_VERSION_NUMBER
, SAA.CREATED_BY
, SAA.CREATION_DATE
, SAA.LAST_UPDATED_BY
, SAA.LAST_UPDATE_DATE
FROM IGS_EN_SPA_AWD_AIM SAA
, IGS_EN_STDNT_PS_ATT_ALL SPA
, HZ_PARTIES HP
, IGS_PS_VER_ALL PV
, IGS_PS_AWD PA
WHERE SAA.AWARD_CD = PA.AWARD_CD
AND SAA.PERSON_ID = SPA.PERSON_ID
AND SAA.COURSE_CD = SPA.COURSE_CD
AND PV.COURSE_CD = SPA.COURSE_CD
AND PV.VERSION_NUMBER = SPA.VERSION_NUMBER
AND SAA.PERSON_ID = HP.PARTY_ID WITH READ ONLY

Columns

Name
PERSON_IDENTIFIER
PERSON_NUMBER
PERSON_NAME
PROGRAM_CODE
PROGRAM_TITLE
AWARD_CODE
AWARD_TITLE
START_DATE
END_DATE
COMPLETE_FLAG
"_LA:COMPLETE_FLAG_DESC"
CONFERRAL_DATE
AWARD_MARK
AWARD_GRADE
GRADING_SCHEMA_CODE
GRADING_SCH_VERSION_NUMBER
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE