[Home] [Help]
View: IGSBV_HIGH_EDU_PRG_GRP_TYPES
Product: | IGS - Student System (Obsolete) |
Description: | This is a base view, which describes the available types of program groups that can be defined on the system. |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT GR.COURSE_GROUP_TYPE PROGRAM_GROUP_TYPE
, GR.DESCRIPTION PROGRAM_GROUP_TYPE_DESCRIPTION
, GR.CLOSED_IND PROG_GRP_TYPE_CLOSED_INDICATOR
, '_LA:GR.S_COURSE_GROUP_TYPE:IGS_LOOKUP_VALUES:COURSE_GROUP_TYPE:MEANING'
, GR.CREATED_BY
, GR.CREATION_DATE
, GR.LAST_UPDATED_BY
, GR.LAST_UPDATE_DATE
FROM IGS_PS_GRP_TYPE GR WITH READ ONLY
Columns
Name |
PROGRAM_GROUP_TYPE |
PROGRAM_GROUP_TYPE_DESCRIPTION |
PROG_GRP_TYPE_CLOSED_INDICATOR |
"_LA:SYS_PROG_GROUP_TYPE_DESC" |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |