DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.IGS_UC_CVCONTROL_2003

Object Details
Object Name: IGS_UC_CVCONTROL_2003
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGS_UC_CVCONTROL_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 Mandatory Comments
ENTRYYEAR NUMBER (22)
Entry Year
TIMEOFYEAR VARCHAR2 (1)
Space - Clearing not started, A - CEFs sent to applicants (UCAS MU06 run), C - Clearing started
ROUTEBTIMEOFYEAR VARCHAR2 (1)
Space - Route B choices on GA, 0 - Route B supplementary forms sent, 1 - Round 1 sent, 2 - Round 2 sent, 3 - Round 3 sent, 5 - No more supplementary forms, 6 - No more send-offs
APPNOFIRST NUMBER (22)
First application number
APPNOMAXIMUM NUMBER (22)
Maximum application number this year
APPNOLASTUSED NUMBER (22)
Last application number in use
LASTDAILYRUNNO NUMBER (22)
Last daily run number
LASTDAILYRUNDATE DATE

Last daily run date
APPNO15JAN NUMBER (22)
Last application number by 15th January
RUNDATE15JAN DATE

Run date of last application number by 15th January
APPNO24MAR NUMBER (22)
Last application number by 24th March
RUNDATE24MAR DATE

Run date of last application number by 24th March
APPNO16MAY VARCHAR2 (1)
** NO LONGER USED **
RUNDATE16MAY VARCHAR2 (1)
** NO LONGER USED **
APPNODECISIONPROC NUMBER (22)
Last application number in decision processing
RUNDATEDECISIONPROC DATE

Run date of last application number in decision processing
APPNOFIRSTPRENUM VARCHAR2 (1)
** NO LONGER USED **
APPNOFIRSTOPF NUMBER (22)
First application number for Overseas Partnership forms
APPNOFIRSTRPANONEU NUMBER (22)
First application number for Record of Prior Acceptance - non EU
APPNOFIRSTRPAEU NUMBER (22)
First application number for Record of Prior Acceptance - EU
NEWS VARCHAR2 (48)
News
NOMORELATRAN VARCHAR2 (1)
Y - too late for LA transactions.
STARXAVAIL VARCHAR2 (1)
Y - Star X data is available see 3.10
TIMEOFDAY VARCHAR2 (1)
S - Session running - updates allowed, D - Daily run/backup - no updates possible
EXTRASTART DATE

Extra processing start date
LASTPASSPORT DATE

Last passport date
LASTLE DATE

Last LE date
Query Text

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


SELECT ENTRYYEAR
,      TIMEOFYEAR
,      ROUTEBTIMEOFYEAR
,      APPNOFIRST
,      APPNOMAXIMUM
,      APPNOLASTUSED
,      LASTDAILYRUNNO
,      LASTDAILYRUNDATE
,      APPNO15JAN
,      RUNDATE15JAN
,      APPNO24MAR
,      RUNDATE24MAR
,      APPNO16MAY
,      RUNDATE16MAY
,      APPNODECISIONPROC
,      RUNDATEDECISIONPROC
,      APPNOFIRSTPRENUM
,      APPNOFIRSTOPF
,      APPNOFIRSTRPANONEU
,      APPNOFIRSTRPAEU
,      NEWS
,      NOMORELATRAN
,      STARXAVAIL
,      TIMEOFDAY
,      EXTRASTART
,      LASTPASSPORT
,      LASTLE
FROM APPS.IGS_UC_CVCONTROL_2003;

Dependencies

[top of page]

APPS.IGS_UC_CVCONTROL_2003 references the following:

SchemaAPPS
SynonymIGS_UC_CCONTRL_INTS
APPS.IGS_UC_CVCONTROL_2003 is referenced by following:

SchemaAPPS
SynonymIGS_UC_U_CVCONTROL_2003