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

TABLE: IGS.IGS_UC_IOFFER_INTS

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


Holds offer information loaded from UCAS


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGS_UC_IOFFER_INTS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnRECORD_STATUS
ColumnAPPNO
ColumnCHOICENO
ColumnUCAS_CYCLE
Columns
Name Datatype Length Mandatory Comments
APPNO NUMBER (22)
Application Number
CHOICENO NUMBER (22)
Choice Number
UCAS_CYCLE NUMBER (4)
UCAS Cycle to which this interface record belongs to
OFFERCOURSE VARCHAR2 (6)
Change Course
OFFERCAMPUS VARCHAR2 (1)
Change Campus
OFFERCOURSELENGTH NUMBER (22)
Change Duration
OFFERENTRYMONTH VARCHAR2 (2)
Change Entry Month
OFFERENTRYYEAR VARCHAR2 (2)
Change Entry Year
OFFERENTRYPOINT VARCHAR2 (1)
Change entry point
OFFERTEXT VARCHAR2 (2000)
Semi-expanded offer letter
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
,      CHOICENO
,      UCAS_CYCLE
,      OFFERCOURSE
,      OFFERCAMPUS
,      OFFERCOURSELENGTH
,      OFFERENTRYMONTH
,      OFFERENTRYYEAR
,      OFFERENTRYPOINT
,      OFFERTEXT
,      RECORD_STATUS
,      ERROR_CODE
FROM IGS.IGS_UC_IOFFER_INTS;

Dependencies

[top of page]

IGS.IGS_UC_IOFFER_INTS does not reference any database object

IGS.IGS_UC_IOFFER_INTS is referenced by following:

SchemaAPPS
SynonymIGS_UC_IOFFER_INTS