View: IGS_UC_CVSCHOOL_2003

Product:	IGS - Student System
Description:	Dummy view which is a copy of UCAS View CVSCHOOL, used for compilation
Implementation/DBA Data:	APPS.IGS_UC_CVSCHOOL_2003

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