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_IVNSTARK_2007

Object Details

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

View Type

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

View for IVNSTARK for the UCAS 2007 Cycle

[View Source]

Columns

Name	Datatype	Length	Comments
APPNO	NUMBER	(22)	Application Number
TIMESTAMP	DATE		Time stamp - date and time of last change
APPLICATIONDATE	DATE		Application Date
SENTDATE	DATE		Date sent out
RUNSENT	NUMBER	(22)	Run or Batch number when sent
CODEDCHANGEDATE	DATE		Coded information changed date
RESCAT	VARCHAR2	(1)	Residency category code
FEELEVEL	VARCHAR2	(1)	F-full fee, S-single entry fee, UCAS fee level received from applicant
APR	NUMBER	(22)	Refers to cvrefAPR - all values
COUNTRYBIRTH	NUMBER	(22)	Refers to cvrefAPR - Countries
NATIONALITY	NUMBER	(22)	Refers to cvrefAPR - Countries
WITHDRAWN	VARCHAR2	(1)	Null - not withdrawn, C - candidate withdrew, R - reinstated, W - UF withdrawal
WITHDRAWNDATE	DATE		Date candidate withdrew or was reinstated
QUALENGLISH	VARCHAR2	(1)	Qualified in English
QUALMATHS	VARCHAR2	(1)	Qualified in Maths
QUALSCIENCE	VARCHAR2	(1)	Qualified in Science
QUAL5POINT	VARCHAR2	(1)	Qualified with 5 Points
QUALMAIN	VARCHAR2	(1)	Main qualification
NATIONALINSURANCE	VARCHAR2	(12)	National Insurance Number
STARTDATE	VARCHAR2	(4)	Earliest Start Date
NEARESTINST	VARCHAR2	(4)	Nearest Institution
PREFREGION	NUMBER	(22)	Preferred Region
SPECIALNEEDS	VARCHAR2	(1)	0 - No disability, 1 - Dyslexia, 2 - Blind or partial sight, 3 - Deaf or partial hearing, 4 - Wheelchair or mobility, 5 - Personal care, 6 - Mental health, 7 - Unseen disability, 8 - Multiple disabilities, 9 - Other disability
STATUS	VARCHAR2	(3)	See cvRefStatus
FIRMNOW	NUMBER	(22)	Firm choice number
UKENTRYDATE	DATE		Date of first entry to UK
EAS	VARCHAR2	(1)	EAS
DISABILITY	VARCHAR2	(1)	See cvRefDis

Query Text

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


SELECT APPNO
,      TIMESTAMP
,      APPLICATIONDATE
,      SENTDATE
,      RUNSENT
,      CODEDCHANGEDATE
,      RESCAT
,      FEELEVEL
,      APR
,      COUNTRYBIRTH
,      NATIONALITY
,      WITHDRAWN
,      WITHDRAWNDATE
,      QUALENGLISH
,      QUALMATHS
,      QUALSCIENCE
,      QUAL5POINT
,      QUALMAIN
,      NATIONALINSURANCE
,      STARTDATE
,      NEARESTINST
,      PREFREGION
,      SPECIALNEEDS
,      STATUS
,      FIRMNOW
,      UKENTRYDATE
,      EAS
,      DISABILITY
FROM APPS.IGS_UC_IVNSTARK_2007;

Dependencies

[top of page]

APPS.IGS_UC_IVNSTARK_2007 references the following:

APPS: IGS_UC_ISTARK_INTS

APPS.IGS_UC_IVNSTARK_2007 is referenced by following:

APPS: IGS_UC_N_IVNSTARK_2007