[Home] [Help]
View: IGS_UC_IVSTARA_2003
Product: | IGS - Student System (Obsolete) |
Description: | Dummy view which is a copy of UCAS View IVSTARA, used for compilation |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT APPNO
, SYSDATE TIMESTAMP
, ADDRESSAREA
, ADDRESS1
, ADDRESS2
, ADDRESS3
, ADDRESS4
, POSTCODE
, MAILSORT
, TELEPHONE
, FAX
, EMAIL
, HOMEADDRESS1
, HOMEADDRESS2
, HOMEADDRESS3
, HOMEADDRESS4
, HOMEPOSTCODE
, HOMEPHONE
, HOMEFAX
, HOMEEMAIL
FROM IGS_UC_ISTARA_INTS
WHERE 1 = 2
Columns
Name |
APPNO |
TIMESTAMP |
ADDRESSAREA |
ADDRESS1 |
ADDRESS2 |
ADDRESS3 |
ADDRESS4 |
POSTCODE |
MAILSORT |
TELEPHONE |
FAX |
EMAIL |
HOMEADDRESS1 |
HOMEADDRESS2 |
HOMEADDRESS3 |
HOMEADDRESS4 |
HOMEPOSTCODE |
HOMEPHONE |
HOMEFAX |
HOMEEMAIL |