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_IVGSTARG_2006

Object Details

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

View Type

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

Dummy View for IVGSTARG for the UCAS 2006 Cycle

[View Source]

Columns

Name	Datatype	Length	Comments
APPNO	NUMBER	(22)	Application Number
ROUNDNO	NUMBER	(15)	Round 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
MODULAR	VARCHAR2	(1)	Modular flag
PARTTIME	VARCHAR2	(1)	Part Time flag
DECISION	VARCHAR2	(1)	UCAS Decision. Values are C,U,R,W or Blank
REPLY	VARCHAR2	(1)	UCAS Reply. Values can be, F, I, D or Blank
ENTRYMONTH	NUMBER	(15)	Month course starts
ENTRYYEAR	NUMBER	(15)	Year the course starts
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)
ENGLISH	VARCHAR2	(1)	GCSE English flag
MATHS	VARCHAR2	(1)	GCSE Mathematics flag
SCIENCE	VARCHAR2	(1)	GCSE Science flag
DEGREESTATUS	VARCHAR2	(1)	Degree Status
DEGREESUBJECT	VARCHAR2	(2)	Degree subject
DEGREECLASS	VARCHAR2	(2)	Degree Class
INTERVIEWDATE	DATE		Interview Date
LATEAPPLICATION	VARCHAR2	(1)	Late Application flag

Query Text

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


SELECT APPNO
,      ROUNDNO
,      TIMESTAMP
,      LASTCHANGE
,      INST
,      COURSE
,      CAMPUS
,      MODULAR
,      PARTTIME
,      DECISION
,      REPLY
,      ENTRYMONTH
,      ENTRYYEAR
,      ACTION
,      ENGLISH
,      MATHS
,      SCIENCE
,      DEGREESTATUS
,      DEGREESUBJECT
,      DEGREECLASS
,      INTERVIEWDATE
,      LATEAPPLICATION
FROM APPS.IGS_UC_IVGSTARG_2006;

Dependencies

[top of page]

APPS.IGS_UC_IVGSTARG_2006 references the following:

APPS: IGS_UC_ISTARG_INTS

APPS.IGS_UC_IVGSTARG_2006 is referenced by following:

APPS: IGS_UC_G_IVGSTARG_2006