Product: | IGS - Student System (Obsolete) |
---|---|
Description: | This is a full 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 |
SELECT GRA.COURSE_GROUP_CD PROGRAM_GROUP_CODE
, GRA.DESCRIPTION PROGRAM_GROUP_DESCRIPTION
, GRA.RESPONSIBLE_ORG_UNIT_CD RESP_ORG_UNIT_CODE
, GRA.RESPONSIBLE_OU_START_DT RESP_ORG_UNIT_START_DATE
, GRA.COURSE_GROUP_TYPE PROGRAM_GROUP_TYPE
, GRA.CLOSED_IND PROGRAM_CLOSED_INDICATOR
, GRT.DESCRIPTION PROGRAM_GROUP_TYPE_DESCRIPTION
, PA.PARTY_NAME RESP_ORG_UNIT_DESCRIPTION
, GRA.CREATED_BY
, GRA.CREATION_DATE
, GRA.LAST_UPDATED_BY
, GRA.LAST_UPDATE_DATE
FROM IGS_PS_GRP_ALL GRA
, IGS_PS_GRP_TYPE GRT
, HZ_PARTIES PA
WHERE GRA.COURSE_GROUP_TYPE = GRT.COURSE_GROUP_TYPE
AND GRA.RESPONSIBLE_ORG_UNIT_CD = PA.PARTY_NUMBER(+)
AND PA.STATUS (+) = 'A' WITH READ ONLY