[Home] [Help]
View: IGS_UC_IVSTARK_2003
Product: | IGS - Student System |
Description: | Dummy view which is a copy of UCAS View IVSTARK, used for compilation |
Implementation/DBA Data: |
APPS.IGS_UC_IVSTARK_2003
|
View Text
SELECT APPNO
, SYSDATE 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_ISTARK_INTS
WHERE 1 = 2
Columns
Name |
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 |