This is the base view which describes the level of a unit within a particular university program type. This value will override the default value stored against the unit.
Implementation/DBA Data:
Not implemented in this database
View Text
SELECT UNL.UNIT_CD , UNL.VERSION_NUMBER , UNL.COURSE_TYPE , UNL.UNIT_LEVEL , UNL.WAM_WEIGHTING , UNL.COURSE_CD , UNL.COURSE_VERSION_NUMBER , UNV.TITLE , VE.TITLE , UNL.CREATED_BY , UNL.CREATION_DATE , UNL.LAST_UPDATED_BY , UNL.LAST_UPDATE_DATE FROM IGS_PS_UNIT_LVL_ALL UNL , IGS_PS_UNIT_VER_ALL UNV , IGS_PS_VER_ALL VE WHERE UNL.UNIT_CD = UNV.UNIT_CD AND UNL.VERSION_NUMBER = UNV.VERSION_NUMBER AND UNL.COURSE_CD=VE.COURSE_CD AND UNL.COURSE_VERSION_NUMBER=VE.VERSION_NUMBER WITH READ ONLY