[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGS_UC_UCAS_CONTROL |
|---|---|
| Object Type: | TABLE |
| Owner: | IGS |
| FND Design Data: |  IGS.IGS_UC_UCAS_CONTROL
|
| Subobject Name: | |
| Status: | VALID |
Holds the control information provided by UCAS. It will always contain only one record at any given time. It synchronizes with UCAS view 'cvControl' and will be synchronized every time import is done.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| IGS_UC_UCAS_CONTROL_PK | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 SYSTEM_CODE
UCAS_CYCLE
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ENTRY_YEAR | NUMBER | (2) | Entry year | |
| TIME_OF_YEAR | VARCHAR2 | (1) | Time of Year (null - clearing not started, A - CEF sent to applicants, C - Clearing started) | |
| TIME_OF_DAY | VARCHAR2 | (1) | Time of day | |
| ROUTEB_TIME_OF_YEAR | VARCHAR2 | (1) | Route B phase (0 - Route B supplementary forms sent, 1 - Round 1 sent, 2 - Round 2 sent, 3 - Round 3 sent etc.) | |
| APPNO_FIRST | NUMBER | (8) | First application number | |
| APPNO_MAXIMUM | NUMBER | (8) | Maximum application number this year | |
| APPNO_LAST_USED | NUMBER | (8) | Last application number in use | |
| APPNO_FIRST_OPF | NUMBER | (8) | Yes | First Application Number for overseas partnership forms |
| APPNO_FIRST_RPA_NONEU | NUMBER | (8) | Yes | First Application Number for record of prior acceptance - nonEU |
| APPNO_FIRST_RPA_EU | NUMBER | (8) | Yes | First Application Number for record of prior acceptance - EU |
| LAST_DAILY_RUN_NO | NUMBER | (3) | Last daily run number | |
| LAST_DAILY_RUN_DATE | DATE | Last daily run date | ||
| APPNO_15DEC | NUMBER | (8) | Last application number by 15 December (decision deadline) | |
| RUN_DATE_15DEC | DATE | Run date of last application number by 15 December | ||
| APPNO_24MAR | NUMBER | (8) | Last application number by 24 March | |
| RUN_DATE_24MAR | DATE | Run date of last application number by 24 March | ||
| APPNO_16MAY | NUMBER | (8) | Last application number by 16 May | |
| RUN_DATE_16MAY | DATE | Run date of last application number by 16 May | ||
| APPNO_DECISION_PROC | NUMBER | (8) | Last application number is decision processing | |
| RUN_DATE_DECISION_PROC | DATE | Run date of last application number in decision processing | ||
| APPNO_FIRST_PRE_NUM | NUMBER | (8) | First application number for pre-numbered late application forms | |
| NEWS | VARCHAR2 | (48) | News / Announcements | |
| NO_MORE_LA_TRAN | VARCHAR2 | (1) | 'Y' indicates it's too late for 'Amended Decision' transactions (Y - yes, N - no) | |
| STAR_X_AVAIL | VARCHAR2 | (1) | 'Y' indicates that ivStarX data in available (Y - yes, N - no) | |
| CREATED_BY | NUMBER | (15) | Yes | Standard WHO column |
| CREATION_DATE | DATE | Yes | Standard WHO column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard WHO column |
| LAST_UPDATE_DATE | DATE | Yes | Standard WHO column | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard WHO column | |
| EXTRA_START_DATE | DATE | Start date of UCAS EXTRA processing. | ||
| LAST_PASSPORT_DATE | DATE | Last day UCAS will accept applications for EXTRA passports. | ||
| LAST_LE_DATE | DATE | Last day that UCAS will accept LE transactions | ||
| SYSTEM_CODE | VARCHAR2 | (1) | Yes | UCAS System Code |
| UCAS_CYCLE | NUMBER | (15) | Yes | UCAS Cycle to which this control information belongs to |
| GTTR_CLEAR_TOY_CODE | VARCHAR2 | (30) | GTTR Clearing Time of Year Code | |
| TRANSACTION_TOY_CODE | VARCHAR2 | (30) | Transaction Time of Year Code |
Cut, paste (and edit) the following text to query this object:
SELECT ENTRY_YEAR
, TIME_OF_YEAR
, TIME_OF_DAY
, ROUTEB_TIME_OF_YEAR
, APPNO_FIRST
, APPNO_MAXIMUM
, APPNO_LAST_USED
, APPNO_FIRST_OPF
, APPNO_FIRST_RPA_NONEU
, APPNO_FIRST_RPA_EU
, LAST_DAILY_RUN_NO
, LAST_DAILY_RUN_DATE
, APPNO_15DEC
, RUN_DATE_15DEC
, APPNO_24MAR
, RUN_DATE_24MAR
, APPNO_16MAY
, RUN_DATE_16MAY
, APPNO_DECISION_PROC
, RUN_DATE_DECISION_PROC
, APPNO_FIRST_PRE_NUM
, NEWS
, NO_MORE_LA_TRAN
, STAR_X_AVAIL
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, EXTRA_START_DATE
, LAST_PASSPORT_DATE
, LAST_LE_DATE
, SYSTEM_CODE
, UCAS_CYCLE
, GTTR_CLEAR_TOY_CODE
, TRANSACTION_TOY_CODE
FROM IGS.IGS_UC_UCAS_CONTROL;
IGS.IGS_UC_UCAS_CONTROL does not reference any database object
IGS.IGS_UC_UCAS_CONTROL is referenced by following:
APPS
IGS_UC_UCAS_CONTROL
|
|
|
|