[Home] [Help]
View: IGS_UC_IVGSTARA_2007
Product: | IGS - Student System (Obsolete) |
Description: | Dummy View for IVGSTARA for the UCAS 2007 Cycle |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT APPNO
, SYSDATE TIMESTAMP
, ADDRESSAREA
, ADDRESS1
, ADDRESS2
, ADDRESS3
, ADDRESS4
, POSTCODE
, MAILSORT
, TELEPHONE
, EMAIL
, HOMEADDRESS1
, HOMEADDRESS2
, HOMEADDRESS3
, HOMEADDRESS4
, HOMEPOSTCODE
, MOBILE
, COUNTRYCODE
, HOMECOUNTRYCODE
FROM IGS_UC_ISTARA_INTS
WHERE 1 = 2
Columns
Name |
APPNO |
TIMESTAMP |
ADDRESSAREA |
ADDRESS1 |
ADDRESS2 |
ADDRESS3 |
ADDRESS4 |
POSTCODE |
MAILSORT |
TELEPHONE |
EMAIL |
HOME_ADDRESS1 |
HOME_ADDRESS2 |
HOME_ADDRESS3 |
HOME_ADDRESS4 |
HOMEPOSTCODE |
MOBILE |
COUNTRYCODE |
HOMECOUNTRYCODE |