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_IVGSTARK_2006

Object Details

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

View Type

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

Dummy View for IVGSTARK for the UCAS 2006 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
CODEDCHANGEDATE	DATE		Coded information changed date
RESCAT	VARCHAR2	(1)	Residency category code
FEEPAYER	NUMBER	(22)	Fee Payer Code see cvRefFee
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
EAS	VARCHAR2	(1)	Y - Applied through EAS
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
UKENTRYDATE	DATE		Date of first entry to UK
STATUS	VARCHAR2	(3)	See cvRefStatus
FIRMNOW	NUMBER	(22)	Firm choice number
EXTRASTATUS	NUMBER	(22)	Indicates whether the applicant is in extra processing

Query Text

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


SELECT APPNO
,      TIMESTAMP
,      APPLICATIONDATE
,      CODEDCHANGEDATE
,      RESCAT
,      FEEPAYER
,      APR
,      COUNTRYBIRTH
,      NATIONALITY
,      WITHDRAWN
,      WITHDRAWNDATE
,      EAS
,      SPECIALNEEDS
,      UKENTRYDATE
,      STATUS
,      FIRMNOW
,      EXTRASTATUS
FROM APPS.IGS_UC_IVGSTARK_2006;

Dependencies

[top of page]

APPS.IGS_UC_IVGSTARK_2006 references the following:

APPS: IGS_UC_ISTARK_INTS

APPS.IGS_UC_IVGSTARK_2006 is referenced by following:

APPS: IGS_UC_G_IVGSTARK_2006