SELECT appno ,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_U_IVSTARJ_2004
SELECT APPNO
, 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_U_IVSTARJ_2004
|
|
|