[Home] [Help]
View: IGSBV_HIGH_EDU_PRG_GRP_MEMBERS
Product: | IGS - Student System (Obsolete) |
Description: | This is a base view, which describes the programs that are members in a program grouping. |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT GRM.COURSE_CD PROGRAM_CODE
, GRM.VERSION_NUMBER PROGRAM_VERSION_NUMBER
, GRM.COURSE_GROUP_CD PROGRAM_GROUP_CODE
, VE.TITLE PROGRAM_TITLE
, GRA.DESCRIPTION PROGRAM_GROUP_DESCRIPTION
, GRM.CREATED_BY
, GRM.CREATION_DATE
, GRM.LAST_UPDATED_BY
, GRM.LAST_UPDATE_DATE
FROM IGS_PS_GRP_MBR GRM
, IGS_PS_VER_ALL VE
, IGS_PS_GRP_ALL GRA
WHERE GRM.COURSE_CD = VE.COURSE_CD
AND GRM.VERSION_NUMBER = VE.VERSION_NUMBER
AND GRM.COURSE_GROUP_CD = GRA.COURSE_GROUP_CD WITH READ ONLY
Columns
Name |
PROGRAM_CODE |
PROGRAM_VERSION_NUMBER |
PROGRAM_GROUP_CODE |
PROGRAM_TITLE |
PROGRAM_GROUP_DESCRIPTION |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |