Product: | IGS - Student System (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT AE.ROWID ROW_ID
, AE.POST_EDUGOAL_ID POST_EDUGOAL_ID
, AE.PERSON_ID PERSON_ID
, AE.ADMISSION_APPL_NUMBER ADMISSION_APPL_NUMBER
, AE.NOMINATED_COURSE_CD NOMINATED_COURSE_CD
, AE.SEQUENCE_NUMBER SEQUENCE_NUMBER
, AE.EDU_GOAL_ID EDU_GOAL_ID
, CC.NAME NAME
, CC.DESCRIPTION DESCRIPTION
, AE.CREATED_BY CREATED_BY
, AE.CREATION_DATE CREATION_DATE
, AE.LAST_UPDATED_BY LAST_UPDATED_BY
, AE.LAST_UPDATE_DATE LAST_UPDATE_DATE
, AE.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM IGS_AD_EDUGOAL AE
, IGS_AD_CODE_CLASSES CC
WHERE CC.CODE_ID = AE.EDU_GOAL_ID