[Home] [Help]
View: IGS_PR_CS_SCHDL_V
Product: | IGS - Student System (Obsolete) |
Description: | Shows the Class Standing schedule |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT PCSCV.ROWID
, PCSCV.IGS_PR_CS_SCHDL_ID
, PCSCV.COURSE_TYPE
, PT.DESCRIPTION
, PCSCV.CONSIDER_CHANGES
, LKUP.MEANING
, PCSCV.START_DT
, PCSCV.END_DT
, PCSCV.CREATED_BY
, PCSCV.CREATION_DATE
, PCSCV.LAST_UPDATED_BY
, PCSCV.LAST_UPDATE_DATE
, PCSCV.LAST_UPDATE_LOGIN
FROM IGS_PR_CS_SCHDL PCSCV
, IGS_PS_TYPE PT
, IGS_LOOKUPS_VIEW LKUP
WHERE PCSCV.COURSE_TYPE = PT.COURSE_TYPE
AND PCSCV.CONSIDER_CHANGES = LKUP.LOOKUP_CODE
AND LKUP.LOOKUP_TYPE = 'CS_CONSIDER_CHANGES'
Columns
Name |
ROW_ID |
IGS_PR_CS_SCHDL_ID |
COURSE_TYPE |
COURSE_TYPE_DESC |
CONSIDER_CHANGES |
CONSIDER_CHANGES_DESC |
START_DT |
END_DT |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |