[Home] [Help]
View: IGSBV_HIGH_EDU_PRG_GROUPS
Product: | IGS - Student System (Obsolete) |
Description: | This is a base view, which describes a grouping of programs,which are used for a variety of purposes within the system. |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT GR.COURSE_GROUP_CD PROGRAM_GROUP_CODE
, GR.DESCRIPTION PROGRAM_GROUP_DESCRIPTION
, GR.RESPONSIBLE_ORG_UNIT_CD RESP_ORG_UNIT_CODE
, GR.RESPONSIBLE_OU_START_DT RESP_ORG_UNIT_START_DATE
, GR.COURSE_GROUP_TYPE PROGRAM_GROUP_TYPE
, GR.CLOSED_IND PROGRAM_CLOSED_INDICATOR
, GR.CREATED_BY
, GR.CREATION_DATE
, GR.LAST_UPDATED_BY
, GR.LAST_UPDATE_DATE
FROM IGS_PS_GRP_ALL GR WITH READ ONLY
Columns
Name |
PROGRAM_GROUP_CODE |
PROGRAM_GROUP_DESCRIPTION |
RESP_ORG_UNIT_CODE |
RESP_ORG_UNIT_START_DATE |
PROGRAM_GROUP_TYPE |
PROGRAM_CLOSED_INDICATOR |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |