[Home] [Help]
View: IGS_EN_UNIT_SET_COURSE_TYPE_V
Product: | IGS - Student System (Obsolete) |
Description: | IGS_EN_UNIT_SET_COURSE_TYPE_V maps the unit set course type to the corresponding unit set course. |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT USCT.COURSE_TYPE
, US.UNIT_SET_CD
, US.VERSION_NUMBER
, US.CREATED_BY
, US.CREATION_DATE
, US.LAST_UPDATED_BY
, US.LAST_UPDATE_DATE
, US.LAST_UPDATE_LOGIN FROM IGS_EN_UNIT_SET US
, IGS_EN_UNITSETPSTYPE USCT
WHERE US.UNIT_SET_CD = USCT.UNIT_SET_CD
AND US.VERSION_NUMBER = USCT.VERSION_NUMBER UNION SELECT CTY.COURSE_TYPE
, US.UNIT_SET_CD
, US.VERSION_NUMBER
, US.CREATED_BY
, US.CREATION_DATE
, US.LAST_UPDATED_BY
, US.LAST_UPDATE_DATE
, US.LAST_UPDATE_LOGIN FROM IGS_PS_TYPE CTY
, IGS_EN_UNIT_SET US WHERE NOT EXISTS ( SELECT USCT.UNIT_SET_CD FROM IGS_EN_UNITSETPSTYPE USCT WHERE USCT.UNIT_SET_CD = US.UNIT_SET_CD
AND USCT.VERSION_NUMBER = US.VERSION_NUMBER)
Columns
Name |
COURSE_TYPE |
UNIT_SET_CD |
VERSION_NUMBER |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |