View: IGS_UC_IVSTARC_V

Product:	IGS - Student System
Description:	This view selects the Application Choice information for the FTUG System as well as for the Small Systems - OBSOLETE
Implementation/DBA Data:	APPS.IGS_UC_IVSTARC_V

View Text

SELECT UCAS.APPNO
, UCAS.CHOICENO
, UCAS.TIMESTAMP
, UCAS.LASTCHANGE
, UCAS.INST
, UCAS.COURSE
, UCAS.CAMPUS
, UCAS.FACULTY
, UCAS.HOME
, UCAS.DECISION
, UCAS.DECISIONDATE
, UCAS.DECISIONNUMBER
, UCAS.REPLY
, UCAS.SUMMARYCONDITIONS
, UCAS.ENTRYMONTH
, UCAS.ENTRYYEAR
, UCAS.ENTRYPOINT
, UCAS.CHOICECANCELLED
, UCAS.ACTION
, UCAS.SUBSTITUTION
, UCAS.DATESUBSTITUTED
, UCAS.PREVIOUSINST
, UCAS.PREVIOUSCOURSE
, UCAS.PREVIOUSCAMPUS
, UCAS.UCASAMENDMENT
, UCAS.ROUTEBPREF
, UCAS.ROUTEBROUND
, UCAS.EXTRAROUND
, SSYS.RESIDENTIAL
FROM IGS_UC_MV_IVSTARC UCAS
, IGS_UC_SS_IVSTARC SSYS
WHERE UCAS.APPNO = SSYS.APPNO
AND UCAS.CHOICENO = SSYS.CHOICENO UNION ALL SELECT UCAS.APPNO
, UCAS.CHOICENO
, UCAS.TIMESTAMP
, UCAS.LASTCHANGE
, UCAS.INST
, UCAS.COURSE
, UCAS.CAMPUS
, UCAS.FACULTY
, UCAS.HOME
, UCAS.DECISION
, UCAS.DECISIONDATE
, UCAS.DECISIONNUMBER
, UCAS.REPLY
, UCAS.SUMMARYCONDITIONS
, UCAS.ENTRYMONTH
, UCAS.ENTRYYEAR
, UCAS.ENTRYPOINT
, UCAS.CHOICECANCELLED
, UCAS.ACTION
, UCAS.SUBSTITUTION
, UCAS.DATESUBSTITUTED
, UCAS.PREVIOUSINST
, UCAS.PREVIOUSCOURSE
, UCAS.PREVIOUSCAMPUS
, UCAS.UCASAMENDMENT
, UCAS.ROUTEBPREF
, UCAS.ROUTEBROUND
, UCAS.EXTRAROUND
, NULL
FROM IGS_UC_MV_IVSTARC UCAS
WHERE NOT EXISTS (SELECT 1
FROM IGS_UC_SS_IVSTARC SSYS
WHERE UCAS.APPNO = SSYS.APPNO
AND UCAS.CHOICENO = SSYS.CHOICENO )

Columns