[Home] [Help]
View: IGS_UC_CVSCHOOL_2003
| Product: | IGS - Student System (Obsolete) |
|---|
| Description: | Dummy view which is a copy of UCAS View CVSCHOOL, used for compilation |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT SCHOOL
, SITECODE
, SYSDATE TIMESTAMP
, SCHOOLNAME
, NAMECHANGEDATE
, FORMERNAME
, NCN
, EDEXCELNCN
, DFEECODE
, COUNTRY
, LEA
, UCASSTATUS
, ESTABGRP
, SCHOOLTYPE
, STATSDATE
, NOROLL
, NO5TH
, NO6TH
, NOHE
, ADDRESS1
, ADDRESS2
, ADDRESS3
, ADDRESS4
, POSTCODE
, MAILSORT
, TOWNKEY
, COUNTYKEY
, COUNTRYCODE
FROM IGS_UC_CVSCH_INTS
WHERE 1 = 2
Columns
| Name |
| SCHOOL |
| SITECODE |
| TIMESTAMP |
| SCHOOLNAME |
| NAMECHANGEDATE |
| FORMERNAME |
| NCN |
| EDEXCELNCN |
| DFEECODE |
| COUNTRY |
| LEA |
| UCASSTATUS |
| ESTABGRP |
| SCHOOLTYPE |
| STATSDATE |
| NOROLL |
| NO5TH |
| NO6TH |
| NOHE |
| ADDRESS1 |
| ADDRESS2 |
| ADDRESS3 |
| ADDRESS4 |
| POSTCODE |
| MAILSORT |
| TOWNKEY |
| COUNTYKEY |
| COUNTRYCODE |