[Home] [Help]
View: IGSFV_HIGH_EDU_PRG_GRP_MEMBERS
| Product: | IGS - Student System (Obsolete) |
|---|
| Description: | This is a full 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 |