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_IVNSTARC_2006

Object Details

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

View Type

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

Dummy View for IVNSTARC for the UCAS 2006 Cycle

[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
RESIDENTIAL	VARCHAR2	(1)	Residential Accommodation required
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
ENTRYMONTH	NUMBER	(22)	Month course starts
ENTRYYEAR	NUMBER	(22)	Year the course starts
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

Query Text

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


SELECT APPNO
,      CHOICENO
,      TIMESTAMP
,      LASTCHANGE
,      INST
,      COURSE
,      CAMPUS
,      RESIDENTIAL
,      DECISION
,      DECISIONDATE
,      DECISIONNUMBER
,      REPLY
,      ENTRYMONTH
,      ENTRYYEAR
,      CHOICECANCELLED
,      ACTION
,      SUBSTITUTION
,      DATESUBSTITUTED
,      PREVIOUSINST
,      PREVIOUSCOURSE
,      PREVIOUSCAMPUS
FROM APPS.IGS_UC_IVNSTARC_2006;

Dependencies

[top of page]

APPS.IGS_UC_IVNSTARC_2006 references the following:

APPS: IGS_UC_ISTARC_INTS

APPS.IGS_UC_IVNSTARC_2006 is referenced by following:

APPS: IGS_UC_N_IVNSTARC_2006