[Home] [Help]
View: IGS_UC_UVCOURSE_2003
Product: | IGS - Student System (Obsolete) |
Description: | Dummy view which is a copy of UCAS View UVCOURSE, used for compilation |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT COURSE
, CAMPUS
, SYSDATE TIMESTAMP
, UPDATER
, FACULTY
, SHORTTITLE
, LONGTITLE
, VALIDCURR
, VALIDDEFER
, TERM1START
, TERM1END
, TERM2START
, TERM2END
, TERM3START
, TERM3END
, TERM4START
, TERM4END
, JOINTADMISSION
, OPENEXTRA
FROM IGS_UC_UCRSE_INTS
WHERE 1 = 2
Columns
Name |
COURSE |
CAMPUS |
TIMESTAMP |
UPDATER |
FACULTY |
SHORTTITLE |
LONGTITLE |
VALIDCURR |
VALIDDEFER |
TERM1START |
TERM1END |
TERM2START |
TERM2END |
TERM3START |
TERM3END |
TERM4START |
TERM4END |
JOINTADMISSION |
OPENEXTRA |