VIEW: APPS.IGS_UC_IVSTARK_2007_V

Source

View Text - Preformatted

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 ,disability FROM igs_uc_u_ivstark_2007

View Text - HTML Formatted

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
, DISABILITY
FROM IGS_UC_U_IVSTARK_2007