[Home] [Help]
View: IGSFV_HIGH_EDU_UNIT_CATEGORIES
Product: | IGS - Student System (Obsolete) |
Description: | This is a full view, which describes the categories that are applied to a unit. There can be multiple categories for each unit. |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT UNA.UNIT_CD UNIT_CODE
, UNA.VERSION_NUMBER UNIT_VERSION_NUMBER
, UNA.UNIT_CAT UNIT_CATEGORY
, UNV.TITLE UNIT_TITLE
, UNC.DESCRIPTION UNIT_CATEGORY_DESCRIPTION
, UNA.CREATED_BY
, UNA.CREATION_DATE
, UNA.LAST_UPDATED_BY
, UNA.LAST_UPDATE_DATE
FROM IGS_PS_UNIT_CATEGORY_ALL UNA
, IGS_PS_UNIT_CAT UNC
, IGS_PS_UNIT_VER_ALL UNV
WHERE UNA.UNIT_CAT = UNC.UNIT_CAT
AND UNA.UNIT_CD = UNV.UNIT_CD
AND UNA.VERSION_NUMBER = UNV.VERSION_NUMBER WITH READ ONLY
Columns
Name |
UNIT_CODE |
UNIT_VERSION_NUMBER |
UNIT_CATEGORY |
UNIT_TITLE |
UNIT_CATEGORY_DESCRIPTION |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |