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_2003_V

Object Details

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

View Type

A public view which may be useful for custom reporting or other data
requirements.

From 2004, application choices information will be held in different Hercules views for different systems. This View selects the application choice information belonging to all the systems.

[View Source]

Columns

Name	Datatype	Length	Comments
APPNO	NUMBER	(22)	Application Number
CHOICENO	NUMBER	(22)	Choice Number
TIMESTAMP	DATE		Time stamp - date and time of last change
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	(22)	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	(22)	Month course starts
ENTRYYEAR	NUMBER	(22)	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 or applied after 15th Dec 3 - substitution or 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	(22)	Route B preference, Rounds Priority 1, 2 or 3
ROUTEBROUND	NUMBER	(22)	Route B Actual Round
DETAIL	VARCHAR2	(20)	Detail
EXTRAROUND	NUMBER	(22)	Extra round choice number

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
,      DETAIL
,      EXTRAROUND
FROM APPS.IGS_UC_IVSTARC_2003_V;

Dependencies

[top of page]

APPS.IGS_UC_IVSTARC_2003_V references the following:

APPS: IGS_UC_U_IVSTARC_2003

APPS.IGS_UC_IVSTARC_2003_V is referenced by following:

APPS: IGS_UC_LOAD_HERCULES_DATA - show dependent code