Product: | IGS - Student System (Obsolete) |
---|---|
Description: | Dummy view which is a copy of UCAS View IVSTARJ, used for compilation |
Implementation/DBA Data: | Not implemented in this database |
SELECT APPNO
, SYSDATE TIMESTAMP
, HUSID
, SCOTVEC
, SURNAME
, FNAMES
, /*BIRTHDATE
, */ GENDER
, DOMICILE
, NATION
, ETHNIC
, DISABLE
, YRLLINST
, OCCCODE
, QUALENT2
, SBJQA1
, SBJQA2
, SBJQA3
, SBJBID
, FEEELIG
, POSTCODE
, UCASNUM
, SEC
, SOC2000
, PREVINST
, GCEASN
, GCEASTS
, VCEASN
, VCEASTS
, GCEAN
, GCEATS
, VCEAN
, VCEATS
, KSQN
, KSQTS
, UKSAN
, UKSATS
, SAHN
, SAHTS
, SHN
, SHTS
, SI2N
, SI2TS
, SSGCN
, SSGCTS
, SCSN
, SCSTS
, AEAN
, AEATS
, TOTALTS
, BIRTHDTE
FROM IGS_UC_ISTARJ_INTS
WHERE 1 = 2