Product: | IGS - Student System (Obsolete) |
---|---|
Description: | This entity describes a unit-set, being a logical sub-grouping of program. eg .Major, Minor, Stream, Strand. A unit-set is typically related to the rules which governs its completion via the Rules Sub-system. |
Implementation/DBA Data: | Not implemented in this database |
SELECT UST.UNIT_SET_CD UNIT_SET_CODE
, UST.VERSION_NUMBER
, UST.UNIT_SET_STATUS
, UST.UNIT_SET_CAT UNIT_SET_CATEGORY
, UST.START_DT START_DATE
, UST.REVIEW_DT REVIEW_DATE
, UST.EXPIRY_DT EXPIRY_DATE
, UST.END_DT END_DATE
, UST.TITLE
, UST.SHORT_TITLE
, UST.ABBREVIATION
, UST.RESPONSIBLE_ORG_UNIT_CD RESP_ORG_UNIT_CODE
, UST.RESPONSIBLE_OU_START_DT RESP_ORG_UNIT_START_DATE
, UST.ADMINISTRATIVE_IND ADMINISTRATIVE_INDICATOR
, UST.AUTHORISATION_RQRD_IND AUTHORISATION_RQRD_INDICATOR
, '_DF:IGS:IGS_PS_UNIT_SET_FLEX:UST'
, USS.DESCRIPTION UNIT_SET_STATUS_DESC
, USC.DESCRIPTION UNIT_SET_CATEGORY_DESC
, HP.PARTY_NAME RESP_ORG_UNIT_DESC
, UST.CREATED_BY
, UST.CREATION_DATE
, UST.LAST_UPDATED_BY
, UST.LAST_UPDATE_DATE
FROM IGS_EN_UNIT_SET_ALL UST
, IGS_EN_UNIT_SET_STAT USS
, IGS_EN_UNIT_SET_CAT USC
, IGS_OR_INST_ORG_BASE_V HP
WHERE UST.UNIT_SET_STATUS=USS.UNIT_SET_STATUS
AND UST.UNIT_SET_CAT=USC.UNIT_SET_CAT
AND HP.PARTY_NUMBER(+)=UST.RESPONSIBLE_ORG_UNIT_CD WITH READ ONLY