[Home] [Help] [Dependency Information]
Object Name: | IGS_UC_CVCONTROL_2003 |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_UC_CVCONTROL_2003 |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
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 |
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;
|
|
|