Product: | IGS - Student System (Obsolete) |
---|---|
Description: | This is the full 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 |
SELECT UNL.UNIT_CD
, UNL.VERSION_NUMBER
, UNL.COURSE_TYPE
, UNL.UNIT_LEVEL
, UNL.WAM_WEIGHTING
, UNL.COURSE_CD PROGRAM_CODE
, UNL.COURSE_VERSION_NUMBER PROGRAM_VERSION_NUMBER
, UNV.TITLE PROGRAM_TITLE
, TY.DESCRIPTION
, UNL1.DESCRIPTION
, 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_TYPE_ALL TY
, IGS_PS_UNIT_LEVEL_ALL UNL1
, IGS_PS_VER_ALL VE
WHERE UNL.UNIT_CD = UNV.UNIT_CD
AND UNL.VERSION_NUMBER = UNV.VERSION_NUMBER
AND UNL.COURSE_TYPE = TY.COURSE_TYPE(+)
AND UNL.UNIT_LEVEL = UNL1.UNIT_LEVEL
AND UNL.COURSE_CD=VE.COURSE_CD
AND UNL.COURSE_VERSION_NUMBER=VE.VERSION_NUMBER WITH READ ONLY