eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.IGS_UC_IVSTARC_V

Object Details

Object Name:	IGS_UC_IVSTARC_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGS_UC_IVSTARC_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Comments
APPNO	NUMBER	(8)	UCAS Application Number
CHOICENO	NUMBER	(2)	Choice number
TIMESTAMP	DATE		Time stamp - date and time of last change to any choice for this applicant
LASTCHANGE	DATE		Date and time of last change to this choice
INST	VARCHAR2	(3)	Institution Code
COURSE	VARCHAR2	(6)	Course Code
CAMPUS	VARCHAR2	(1)	Campus Code
FACULTY	VARCHAR2	(1)	Faculty Code
HOME	VARCHAR2	(1)	H - Live at home
DECISION	VARCHAR2	(1)	UCAS Decision. Values are C,U,R,W or Blank
DECISIONDATE	DATE		Date when the decision was made
DECISIONNUMBER	NUMBER	(1)	Pre SOD reply: 0 - no decision , 1 - 1st decision (LD) , 2-9 - 2nd etc decision (LA). Post SOD reply: 0 - SOD reply in ,1 - Confirmation decision in ,2 - UF amendment
REPLY	VARCHAR2	(1)	UCAS Reply. Values can be, F, I, D or Blank
SUMMARYCONDITIONS	VARCHAR2	(6)	Summary of conditions column
ENTRYMONTH	NUMBER	(2)	Month course starts
ENTRYYEAR	NUMBER	(2)	Year the course starts
ENTRYPOINT	VARCHAR2	(1)	Null = year 1 entry, 1-4 = Year of entry, 0 = Foundation Year entry
CHOICECANCELLED	VARCHAR2	(1)	Y means Choice cancelled
ACTION	VARCHAR2	(1)	D - DBD (Decline by Default), R - RBD (Reject by Default), U - up rated (UI-UF, CI-CF), X - assumed decline (no answer on AS6C, AS6F, AS6R, AS6W, AS7)
SUBSTITUTION	VARCHAR2	(1)	Space - no substitution ,1 - substitution up to 15th Dec, 2 - substitution/applied after 15th Dec ,3 - substitution/applied after 16th May ,C - substitution in confirmation (UF only)
DATESUBSTITUTED	DATE		Date a substitution was made or applied post 15th Dec
PREVIOUSINST	VARCHAR2	(3)	Previous institution
PREVIOUSCOURSE	VARCHAR2	(6)	Previous course
PREVIOUSCAMPUS	VARCHAR2	(1)	Previous campus
UCASAMENDMENT	VARCHAR2	(1)	Null - No UCAS amendment ,A - latest amendment ,P - previous amendment
ROUTEBPREF	NUMBER	(1)	Route B preference, Rounds Priority 1,2 or3
ROUTEBROUND	NUMBER	(1)	Route B Actual Round
EXTRAROUND	NUMBER	(3)	Extra round choice number
RESIDENTIAL	VARCHAR2	(1)	NMAS- Residential Accommodation Required

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT APPNO
,      CHOICENO
,      TIMESTAMP
,      LASTCHANGE
,      INST
,      COURSE
,      CAMPUS
,      FACULTY
,      HOME
,      DECISION
,      DECISIONDATE
,      DECISIONNUMBER
,      REPLY
,      SUMMARYCONDITIONS
,      ENTRYMONTH
,      ENTRYYEAR
,      ENTRYPOINT
,      CHOICECANCELLED
,      ACTION
,      SUBSTITUTION
,      DATESUBSTITUTED
,      PREVIOUSINST
,      PREVIOUSCOURSE
,      PREVIOUSCAMPUS
,      UCASAMENDMENT
,      ROUTEBPREF
,      ROUTEBROUND
,      EXTRAROUND
,      RESIDENTIAL
FROM APPS.IGS_UC_IVSTARC_V;

Dependencies

[top of page]

APPS.IGS_UC_IVSTARC_V references the following:

APPS: IGS_UC_MV_IVSTARC; IGS_UC_SS_IVSTARC

APPS.IGS_UC_IVSTARC_V is not referenced by any database object