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

VIEW: APPS.IGS_UC_CVCONTROL_2003_V

Object Details
Object Name: IGS_UC_CVCONTROL_2003_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGS_UC_CVCONTROL_2003_V
Subobject Name:
Status: VALID

View Type

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


From 2004, Control information will be held in different Hercules views for different systems. This View selects the Control information belonging to all the systems.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ENTRYYEAR NUMBER (22)
Entry Year
TIMEOFYEAR VARCHAR2 (1)
Space - Clearing not started,A - CEF's 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 or 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_V;

Dependencies

[top of page]

APPS.IGS_UC_CVCONTROL_2003_V references the following:

SchemaAPPS
SynonymIGS_UC_U_CVCONTROL_2003

APPS.IGS_UC_CVCONTROL_2003_V is not referenced by any database object