[Home] [Help]
View: IGS_PS_EXP_WL_V
Product: | IGS - Student System (Obsolete) |
Description: | This view stores the set up data regarding excepted workload in a given calendar category. |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT EW.ROWID ROW_ID
, EW.CONTROL_NUM
, EW.CALENDAR_CAT
, LKUP.MEANING CALENDAR_CAT_MEANING
, EW.EXPECTED_WL
, EW.CREATED_BY
, EW.CREATION_DATE
, EW.LAST_UPDATED_BY
, EW.LAST_UPDATE_DATE
, EW.LAST_UPDATE_LOGIN
FROM IGS_PS_EXP_WL EW
, IGS_LOOKUPS_VIEW LKUP
WHERE LKUP.LOOKUP_CODE = EW.CALENDAR_CAT
AND LKUP.LOOKUP_TYPE = 'CAL_CAT'
Columns
Name |
ROW_ID |
CONTROL_NUM |
CALENDAR_CAT |
CALENDAR_CAT_MEANING |
EXPECTED_WL |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |