[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | This view describes a unit-set, being a logical sub-grouping of course. e.g. Major, Minor, Stream, Strand. A unit-set is typically related to the rules, which govern its completion via the Rules Sub-system. - Obsolete |
| Implementation/DBA Data: | Not implemented in this database |
SELECT USET.UNIT_SET_CD
, USET.VERSION_NUMBER
, USET.UNIT_SET_STATUS
, USET.UNIT_SET_CAT
, USET.START_DT
, USET.REVIEW_DT
, USET.EXPIRY_DT
, USET.END_DT
, USET.TITLE
, USET.SHORT_TITLE
, USET.ABBREVIATION
, USET.RESPONSIBLE_ORG_UNIT_CD
, USET.RESPONSIBLE_OU_START_DT
, USET.ADMINISTRATIVE_IND
, '_LA:ADMINISTRATIVE_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, AUTHORISATION_RQRD_IND
, '_LA:AUTHORISATION_RQRD_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, STAT.DESCRIPTION
, CAT.DESCRIPTION
, ORG.PARTY_NAME
, '_DF:IGS:IGS_PS_UNIT_SET_FLEX:USET'
, USET.CREATED_BY
, USET.CREATION_DATE
, USET.LAST_UPDATED_BY
, USET.LAST_UPDATE_DATE
FROM IGS_EN_UNIT_SET_ALL USET
, IGS_EN_UNIT_SET_STAT STAT
, IGS_EN_UNIT_SET_CAT CAT
, HZ_PARTIES ORG
, IGS_PE_HZ_PARTIES IHP
WHERE STAT.UNIT_SET_STATUS = USET.UNIT_SET_STATUS
AND CAT.UNIT_SET_CAT = USET.UNIT_SET_CAT
AND USET.RESPONSIBLE_ORG_UNIT_CD = IHP.OSS_ORG_UNIT_CD (+)
AND ORG.PARTY_ID = IHP.PARTY_ID WITH READ ONLY