Skip to content

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

TABLE: IGS.IGS_UC_ISTARZ2_INTS

Object Details
Object Name: IGS_UC_ISTARZ2_INTS
Object Type: TABLE
Owner: IGS
FND Design Data: TableIGS.IGS_UC_ISTARZ2_INTS
Subobject Name:
Status: VALID


Holds Application Clearing round information loaded from UCAS


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGS_UC_ISTARZ2_INTS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnRECORD_STATUS
ColumnAPPNO
ColumnINST
ColumnCOURSE
ColumnCAMPUS
Columns
Name Datatype Length Mandatory Comments
APPNO NUMBER (22)
Application Number
ROUNDNO NUMBER (22)
Round Number - previously used in Central Clearing - should be null
INST VARCHAR2 (3)
Institution Code
COURSE VARCHAR2 (6)
Course Code
CAMPUS VARCHAR2 (1)
Campus Code
FACULTY VARCHAR2 (1)
Faculty Code
ROUNDTYPE VARCHAR2 (1)
Previously used in Central Clearing, now only contains F (Form Request)
RESULT VARCHAR2 (1)
blank = Form request , star = New form request , I = Accepted at this institution, R = Rejected by institution, D = Declined by applicant C = Cancelled by applicant,X = Form request cancelled by UCAS
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
Query Text

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


SELECT APPNO
,      ROUNDNO
,      INST
,      COURSE
,      CAMPUS
,      FACULTY
,      ROUNDTYPE
,      RESULT
,      RECORD_STATUS
,      ERROR_CODE
FROM IGS.IGS_UC_ISTARZ2_INTS;

Dependencies

[top of page]

IGS.IGS_UC_ISTARZ2_INTS does not reference any database object

IGS.IGS_UC_ISTARZ2_INTS is referenced by following:

SchemaAPPS
SynonymIGS_UC_ISTARZ2_INTS