Skip to content
[Home] [Help]
View: IGS_UC_IVSTARK_2007
| Product: | IGS - Student System (Obsolete) |
|---|
| Description: | Dummy View that points to the IGS_UC_ISTARK_INTS Interface Table |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
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
, SPECIALNEEDS
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 |
| DISABILITY |