[Home] [Help]
View: IGS_UC_IVSTARC_2003
| Product: | IGS - Student System (Obsolete) |
|---|
| Description: | Dummy view which is a copy of UCAS View IVSTARC, used for compilation |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT APPNO
, CHOICENO
, SYSDATE TIMESTAMP
, LASTCHANGE
, INST
, COURSE
, CAMPUS
, FACULTY
, HOME
, DECISION
, DECISIONDATE
, DECISIONNUMBER
, REPLY
, SUMMARYCONDITIONS
, ENTRYMONTH
, ENTRYYEAR
, ENTRYPOINT
, CHOICECANCELLED
, ACTION
, SUBSTITUTION
, DATESUBSTITUTED
, PREVIOUSINST
, PREVIOUSCOURSE
, PREVIOUSCAMPUS
, UCASAMENDMENT
, ROUTEBPREF
, ROUTEBROUND
, DETAIL
, EXTRAROUND
FROM IGS_UC_ISTARC_INTS
WHERE 1 = 2
Columns
| Name |
| APPNO |
| CHOICENO |
| TIMESTAMP |
| LASTCHANGE |
| INST |
| COURSE |
| CAMPUS |
| FACULTY |
| HOME |
| DECISION |
| DECISIONDATE |
| DECISIONNUMBER |
| REPLY |
| SUMMARYCONDITIONS |
| ENTRYMONTH |
| ENTRYYEAR |
| ENTRYPOINT |
| CHOICECANCELLED |
| ACTION |
| SUBSTITUTION |
| DATESUBSTITUTED |
| PREVIOUSINST |
| PREVIOUSCOURSE |
| PREVIOUSCAMPUS |
| UCASAMENDMENT |
| ROUTEBPREF |
| ROUTEBROUND |
| DETAIL |
| EXTRAROUND |