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

TABLE: IGS.IGS_UC_IREFRNC_INTS

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


Holds applicant reference information loaded from UCAS


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGS_UC_IREFRNC_INTS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnRECORD_STATUS
ColumnAPPNO
ColumnREFEREENAME
Columns
Name Datatype Length Mandatory Comments
APPNO NUMBER (22)
Application Number
REFEREENAME VARCHAR2 (50)
Referee name
REFEREEPOST VARCHAR2 (35)
Referee post
ESTABNAME VARCHAR2 (60)
Establishment name
ADDRESS1 VARCHAR2 (50)
Address line 1
ADDRESS2 VARCHAR2 (50)
Address line 2
ADDRESS3 VARCHAR2 (50)
Address line 3
ADDRESS4 VARCHAR2 (50)
Address line 4
TELEPHONE VARCHAR2 (35)
Telephone
FAX VARCHAR2 (35)
Fax number
EMAIL VARCHAR2 (60)
Email address
STATEMENT LONG (0)
Electronic application Statement
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
PREDICTEDGRADES VARCHAR2 (150)
Predicted Grades
Query Text

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


SELECT APPNO
,      REFEREENAME
,      REFEREEPOST
,      ESTABNAME
,      ADDRESS1
,      ADDRESS2
,      ADDRESS3
,      ADDRESS4
,      TELEPHONE
,      FAX
,      EMAIL
,      STATEMENT
,      RECORD_STATUS
,      ERROR_CODE
,      PREDICTEDGRADES
FROM IGS.IGS_UC_IREFRNC_INTS;

Dependencies

[top of page]

IGS.IGS_UC_IREFRNC_INTS does not reference any database object

IGS.IGS_UC_IREFRNC_INTS is referenced by following:

SchemaAPPS
SynonymIGS_UC_IREFRNC_INTS