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

TABLE: IGS.IGS_UC_CCRSE_INTS

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


Holds Course information loaded from UCAS


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGS_UC_CCRSE_INTS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnRECORD_STATUS
ColumnCOURSE
ColumnCAMPUS
ColumnINST
Columns
Name Datatype Length Mandatory Comments
INST VARCHAR2 (3)
Institution Code
COURSE VARCHAR2 (6)
Course Code
CAMPUS VARCHAR2 (1)
Campus Code
FACULTY VARCHAR2 (20)
Faculty Code
SHORTNAME VARCHAR2 (20)
Short Course Name
LONGNAME VARCHAR2 (100)
Long Course Name
VALIDCURRENT VARCHAR2 (1)
Null - not valid this year, D - discontinued, R - running
VALIDDEFER VARCHAR2 (1)
Null - not valid this year, D - discontinued, R - running
JOINTADMISSION VARCHAR2 (1)
Joint admission indicator
OPENEXTRA VARCHAR2 (1)
Extra processing open indicator
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
SYSTEM_CODE VARCHAR2 (1)
UCAS System Code: U, G or N
Query Text

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


SELECT INST
,      COURSE
,      CAMPUS
,      FACULTY
,      SHORTNAME
,      LONGNAME
,      VALIDCURRENT
,      VALIDDEFER
,      JOINTADMISSION
,      OPENEXTRA
,      RECORD_STATUS
,      ERROR_CODE
,      SYSTEM_CODE
FROM IGS.IGS_UC_CCRSE_INTS;

Dependencies

[top of page]

IGS.IGS_UC_CCRSE_INTS does not reference any database object

IGS.IGS_UC_CCRSE_INTS is referenced by following:

SchemaAPPS
SynonymIGS_UC_CCRSE_INTS