SELECT appno ,timestamp ,applicationdate ,sentdate ,runsent ,codedchangedate ,school ,rescat ,feelevel ,feepayer ,feetext ,apr ,lea ,countrybirth ,nationality ,dualnationality ,withdrawn ,withdrawndate ,routeb ,examchangedate ,alevels ,aslevels ,highers ,csys ,gce ,vce ,sqa ,winter ,previousa ,previousas ,keyskills ,vocational ,gnvq ,btec ,ilc ,aice ,ib ,manual ,regno ,scn ,oeq ,prevoeq ,eas ,roa ,specialneeds ,criminalconv ,ukentrydate ,status ,firmnow ,firmreply ,insurancereply ,confhistfirmreply ,confhistinsurancereply ,choicesalltransparent ,extrastatus ,extrapassportno FROM IGS_UC_U_IVSTARK_2003
SELECT APPNO
, TIMESTAMP
, APPLICATIONDATE
, SENTDATE
, RUNSENT
, CODEDCHANGEDATE
, SCHOOL
, RESCAT
, FEELEVEL
, FEEPAYER
, FEETEXT
, APR
, LEA
, COUNTRYBIRTH
, NATIONALITY
, DUALNATIONALITY
, WITHDRAWN
, WITHDRAWNDATE
, ROUTEB
, EXAMCHANGEDATE
, ALEVELS
, ASLEVELS
, HIGHERS
, CSYS
, GCE
, VCE
, SQA
, WINTER
, PREVIOUSA
, PREVIOUSAS
, KEYSKILLS
, VOCATIONAL
, GNVQ
, BTEC
, ILC
, AICE
, IB
, MANUAL
, REGNO
, SCN
, OEQ
, PREVOEQ
, EAS
, ROA
, SPECIALNEEDS
, CRIMINALCONV
, UKENTRYDATE
, STATUS
, FIRMNOW
, FIRMREPLY
, INSURANCEREPLY
, CONFHISTFIRMREPLY
, CONFHISTINSURANCEREPLY
, CHOICESALLTRANSPARENT
, EXTRASTATUS
, EXTRAPASSPORTNO
FROM IGS_UC_U_IVSTARK_2003
|
|
|