[Home] [Help]
View: IGS_UC_CVNAME_2003
Product: | IGS - Student System (Obsolete) |
Description: | Dummy view which is a copy of UCAS View CVNAME, used for compilation |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT APPNO
, SYSDATE TIMESTAMP
, CHECKDIGIT
, NAMECHANGEDATE
, TITLE
, FORENAMES
, SURNAME
, INDEXSURN
, CANCELLED
, WITHDRAWN
, STATUS
, BIRTHDATE
, SEX
, CHOICESALLTRANSPARENT
, EXTRASTATUS
FROM IGS_UC_CVNAME_INTS
WHERE 1 = 2
Columns
Name |
APPNO |
TIMESTAMP |
CHECKDIGIT |
NAMECHANGEDATE |
TITLE |
FORENAMES |
SURNAME |
INDEXSURN |
CANCELLED |
WITHDRAWN |
STATUS |
BIRTHDATE |
SEX |
CHOICESALLTRANSPARENT |
EXTRASTATUS |