[Home] [Help]
View: IGS_UC_IVREFERENCE_2004
Product: | IGS - Student System (Obsolete) |
Description: | Dummy view which is a copy of UCAS View IVREFERENCE, used for compilation |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT APPNO
, SYSDATE TIMESTAMP
, REFEREENAME
, REFEREEPOST
, ESTABNAME
, ADDRESS1
, ADDRESS2
, ADDRESS3
, ADDRESS4
, TELEPHONE
, FAX
, EMAIL
, STATEMENT
FROM IGS_UC_IREFRNC_INTS
WHERE 1 = 2
Columns
Name |
APPNO |
TIMESTAMP |
REFEREENAME |
REFEREEPOST |
ESTABNAME |
ADDRESS1 |
ADDRESS2 |
ADDRESS3 |
ADDRESS4 |
TELEPHONE |
FAX |
EMAIL |
STATEMENT |