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

TABLE: IGS.IGS_UC_ISTARZ1_INTS

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


Holds Application Clearing information loaded from UCAS


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGS_UC_ISTARZ1_INTS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnRECORD_STATUS
ColumnAPPNO
Columns
Name Datatype Length Mandatory Comments
APPNO NUMBER (22)
Application Number
DATECEFSENT DATE

Date Clearing Entry Form sent
CEFNO NUMBER (22)
Clearing Entry Form Number
CENTRALCLEARING VARCHAR2 (1)
Central Clearing was discontinued in 1999. This field is no longer used, but contains the constant N for backward compatibility.
INST VARCHAR2 (3)
Institution Code
COURSE VARCHAR2 (6)
Course Code
CAMPUS VARCHAR2 (1)
Campus Code
FACULTY VARCHAR2 (1)
Faculty Code
ENTRYYEAR NUMBER (22)
Entry Year
ENTRYMONTH NUMBER (22)
Entry Month
ENTRYPOINT VARCHAR2 (1)
Point of Entry
RESULT VARCHAR2 (1)
Result. Previously used in Central Clearing. Now only contains A (Accept) if Inst or Course are not null. Null otherwise
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
,      DATECEFSENT
,      CEFNO
,      CENTRALCLEARING
,      INST
,      COURSE
,      CAMPUS
,      FACULTY
,      ENTRYYEAR
,      ENTRYMONTH
,      ENTRYPOINT
,      RESULT
,      RECORD_STATUS
,      ERROR_CODE
FROM IGS.IGS_UC_ISTARZ1_INTS;

Dependencies

[top of page]

IGS.IGS_UC_ISTARZ1_INTS does not reference any database object

IGS.IGS_UC_ISTARZ1_INTS is referenced by following:

SchemaAPPS
SynonymIGS_UC_ISTARZ1_INTS