This is the full view which describes the discipline areas in which a unit is taught. If required, a percentage allocation may be used across multiple discipline groups.
Implementation/DBA Data:
Not implemented in this database
View Text
SELECT UD.UNIT_CD , UD.VERSION_NUMBER , UD.DISCIPLINE_GROUP_CD , UD.PERCENTAGE , UV.TITLE , DS.DESCRIPTION , UD.CREATED_BY , UD.CREATION_DATE , UD.LAST_UPDATED_BY , UD.LAST_UPDATE_DATE FROM IGS_PS_UNIT_DSCP UD , IGS_PS_UNIT_VER_ALL UV , IGS_PS_DSCP_ALL DS WHERE UD.UNIT_CD = UV.UNIT_CD AND UD.VERSION_NUMBER = UV.VERSION_NUMBER AND UD.DISCIPLINE_GROUP_CD = DS.DISCIPLINE_GROUP_CD WITH READ ONLY