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_IVSTARK_2003

Object Details

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

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[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
SCHOOL	NUMBER	(22)	School code
RESCAT	VARCHAR2	(1)	Residency category code
FEELEVEL	VARCHAR2	(1)	F - full fee, S - single entry fee, (UCAS fee level received from applicant)
FEEPAYER	NUMBER	(22)	Fee Payer Code see cvRefFee
FEETEXT	VARCHAR2	(30)	EAS fee payer name
APR	NUMBER	(22)	Refers to cvrefAPR - all values
LEA	VARCHAR2	(1)	FIELD NO LONGER USED (2002)
COUNTRYBIRTH	NUMBER	(22)	Refers to cvrefAPR - all values
NATIONALITY	NUMBER	(22)	Refers to cvrefAPR - all values
DUALNATIONALITY	NUMBER	(22)	EAS - same format as Nationality, but contains other nationality
WITHDRAWN	VARCHAR2	(1)	Null - not withdrawn, C - candidate withdrew, R - reinstated, W - UF withdrawal
WITHDRAWNDATE	DATE		Date candidate withdrew or was reinstated
ROUTEB	VARCHAR2	(1)	Y - route B is required
EXAMCHANGEDATE	DATE		Exam details changed date
ALEVELS	VARCHAR2	(1)	FIELD NO LONGER USED (2002)
ASLEVELS	VARCHAR2	(1)	FIELD NO LONGER USED (2002)
HIGHERS	VARCHAR2	(1)	FIELD NO LONGER USED (2002)
CSYS	VARCHAR2	(1)	FIELD NO LONGER USED (2002)
GCE	NUMBER	(22)	Number of GCE (A + AS) expected
VCE	NUMBER	(22)	Number of VCE (A + AS + Double) expected
SQA	VARCHAR2	(1)	Y - SQA Candidate
WINTER	NUMBER	(22)	Number of Winter A Levels
PREVIOUSA	NUMBER	(22)	Number of previous Summer A levels
PREVIOUSAS	NUMBER	(22)	Number of previous Summer AS levels
KEYSKILLS	VARCHAR2	(1)	Y - taking Key Skills, N - not taking Key Skills
VOCATIONAL	VARCHAR2	(1)	Null - not taking vocational exams, 1 - taking Higher BTEC (HNC or HND), 2 - taking Lower BTEC (NC or ND), 3 - taking Foundation Art & Design course
GNVQ	VARCHAR2	(1)	FIELD NO LONGER USED (2002)
BTEC	VARCHAR2	(1)	Y - BTEC
ILC	VARCHAR2	(1)	Y - ILC
AICE	VARCHAR2	(1)	Y - AICE
IB	VARCHAR2	(1)	Y - International Baccalaureate
MANUAL	VARCHAR2	(1)	Y - manual investigation of previous results required
REGNO	VARCHAR2	(7)	BTEC registration number
SCN	VARCHAR2	(9)	Scottish Candidate Number
OEQ	VARCHAR2	(1)	Other Examination Qualifications
PREVOEQ	VARCHAR2	(1)	Previous Other Examination Qualifications
EAS	VARCHAR2	(1)	Y - Applied through EAS
ROA	VARCHAR2	(1)	Y - record of achievement (EAS applicants only)
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
CRIMINALCONV	VARCHAR2	(1)	Criminal Conviction, Null - not know, Y - Yes, N - No
UKENTRYDATE	DATE		Date of first entry to UK
STATUS	VARCHAR2	(3)	See cvRefStatus
FIRMNOW	NUMBER	(22)	Firm choice number
FIRMREPLY	NUMBER	(22)	Firm Reply
INSURANCEREPLY	NUMBER	(22)	Insurance Reply
CONFHISTFIRMREPLY	NUMBER	(22)	Confirmation history firm reply
CONFHISTINSURANCEREPLY	NUMBER	(22)	Confirmation history insurance reply
CHOICESALLTRANSPARENT	VARCHAR2	(1)	Applications Choices are visible to institution or not
EXTRASTATUS	NUMBER	(22)	Indicates whether the applicant is in extra processing
EXTRAPASSPORTNO	VARCHAR2	(6)	Passport ID used in UCAS Extra. For applicants applying on web will contain 'WEB'

Query Text

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


SELECT APPNO
,      TIMESTAMP
,      APPLICATIONDATE
,      SENTDATE
,      RUNSENT
,      CODEDCHANGEDATE
,      SCHOOL
,      RESCAT
,      FEELEVEL
,      FEEPAYER
,      FEETEXT
,      APR
,      LEA
,      COUNTRYBIRTH
,      NATIONALITY
,      DUALNATIONALITY
,      WITHDRAWN
,      WITHDRAWNDATE
,      ROUTEB
,      EXAMCHANGEDATE
,      ALEVELS
,      ASLEVELS
,      HIGHERS
,      CSYS
,      GCE
,      VCE
,      SQA
,      WINTER
,      PREVIOUSA
,      PREVIOUSAS
,      KEYSKILLS
,      VOCATIONAL
,      GNVQ
,      BTEC
,      ILC
,      AICE
,      IB
,      MANUAL
,      REGNO
,      SCN
,      OEQ
,      PREVOEQ
,      EAS
,      ROA
,      SPECIALNEEDS
,      CRIMINALCONV
,      UKENTRYDATE
,      STATUS
,      FIRMNOW
,      FIRMREPLY
,      INSURANCEREPLY
,      CONFHISTFIRMREPLY
,      CONFHISTINSURANCEREPLY
,      CHOICESALLTRANSPARENT
,      EXTRASTATUS
,      EXTRAPASSPORTNO
FROM APPS.IGS_UC_IVSTARK_2003;

Dependencies

[top of page]

APPS.IGS_UC_IVSTARK_2003 references the following:

APPS: IGS_UC_ISTARK_INTS

APPS.IGS_UC_IVSTARK_2003 is referenced by following:

APPS: IGS_UC_U_IVSTARK_2003