[Home] [Help] [Dependency Information]
Object Name: | IGS_UC_ISTARG_INTS |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_UC_ISTARG_INTS |
Subobject Name: | |
Status: | VALID |
Holds Applicant Choice Records for GTTR System
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_UC_ISTARG_INTS_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE |
RECORD_STATUS
APPNO ROUNDNO UCAS_CYCLE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
APPNO | NUMBER | (22) | Application Number | |
ROUNDNO | NUMBER | (15) | Round Number | |
UCAS_CYCLE | NUMBER | (15) | UCAS Cycle to which this interface record belongs to | |
LASTCHANGE | DATE | Last Change | ||
INST | VARCHAR2 | (3) | Institute Code | |
COURSE | VARCHAR2 | (6) | GTTR Course Code | |
CAMPUS | VARCHAR2 | (1) | GTTR Campus | |
PARTTIME | VARCHAR2 | (1) | Part Time | |
DECISION | VARCHAR2 | (1) | GTTR Decision | |
REPLY | VARCHAR2 | (1) | GTTR Reply | |
ENTRYYEAR | NUMBER | (15) | Entry Year | |
ENTRYMONTH | NUMBER | (15) | Entry Month | |
ACTION | VARCHAR2 | (1) | Action Flag | |
INTERVIEW | DATE | Interview Date | ||
LATEAPPLICATION | VARCHAR2 | (1) | Late Application | |
MODULAR | VARCHAR2 | (1) | Modular | |
CONFIRMED | VARCHAR2 | (1) | Confirmed | |
GCSEENG | VARCHAR2 | (1) | GTTR GCSE English | |
GCSEMATH | VARCHAR2 | (1) | GTTR GCSE Math | |
DEGREESUBJECT | VARCHAR2 | (2) | GTTR Degree Subject | |
DEGREESTATUS | VARCHAR2 | (1) | GTTR Degree Status | |
DEGREECLASS | VARCHAR2 | (2) | GTTR Degree Class | |
GCSESCI | VARCHAR2 | (1) | GTTR GCSE Science | |
RECORD_STATUS | VARCHAR2 | (1) | Status of the interface record , takes values N, O, D etc | |
ERROR_CODE | VARCHAR2 | (4) | Code for the error encountered during processing of this interface record data |
Cut, paste (and edit) the following text to query this object:
SELECT APPNO
, ROUNDNO
, UCAS_CYCLE
, LASTCHANGE
, INST
, COURSE
, CAMPUS
, PARTTIME
, DECISION
, REPLY
, ENTRYYEAR
, ENTRYMONTH
, ACTION
, INTERVIEW
, LATEAPPLICATION
, MODULAR
, CONFIRMED
, GCSEENG
, GCSEMATH
, DEGREESUBJECT
, DEGREESTATUS
, DEGREECLASS
, GCSESCI
, RECORD_STATUS
, ERROR_CODE
FROM IGS.IGS_UC_ISTARG_INTS;
IGS.IGS_UC_ISTARG_INTS does not reference any database object
IGS.IGS_UC_ISTARG_INTS is referenced by following:
|
|
|