[Home] [Help]
View: IGS_UC_CVSCHOOLCONTACT_2003
Product: | IGS - Student System (Obsolete) |
Description: | Dummy view which is a copy of UCAS View CVSCHOOLCONTACT, used for compilation |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT SCHOOL
, SITECODE
, CONTACTCODE
, SYSDATE TIMESTAMP
, CONTACTPOST
, CONTACTNAME
, TELEPHONE
, FAX
, EMAIL
, PRINCIPAL
, LISTS
, ORDERS
, FORMS
, REFEREE
, CAREERS
, EASCONTACT
FROM IGS_UC_CSCHCNT_INTS
WHERE 1 = 2
Columns
Name |
SCHOOL |
SITECODE |
CONTACTCODE |
TIMESTAMP |
CONTACTPOST |
CONTACTNAME |
TELEPHONE |
FAX |
EMAIL |
PRINCIPAL |
LISTS |
ORDERS |
FORMS |
REFEREE |
CAREERS |
EASCONTACT |