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

TABLE: IGS.IGS_UC_CROFFAB_INTS

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


Holds Offer abbreviation information loaded from UCAS


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGS_UC_CROFFAB_INTS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnRECORD_STATUS
Columns
Name Datatype Length Mandatory Comments
ABBREVCODE VARCHAR2 (2)
Abbreviation code
ABBREVTEXT VARCHAR2 (250)
Abbreviation description
LETTERFORMAT VARCHAR2 (1)
Letter format takes values from A to G
SUMMARYCHAR VARCHAR2 (1)
Summary of conditions character
UNCOND VARCHAR2 (1)
Y - Valid for unconditional offers, N - Not valid for unconditional offers
WITHDRAWAL VARCHAR2 (1)
Y - Valid for withdrawal decisions, N - Not valid for withdrawal decisions
RELEASE VARCHAR2 (1)
Y - Valid for release to clearing, N - Not valid for release to clearing
TARIFF VARCHAR2 (1)
Y - Valid for use in Tariff offers, N - Not valid for use in Tariff offers
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 ABBREVCODE
,      ABBREVTEXT
,      LETTERFORMAT
,      SUMMARYCHAR
,      UNCOND
,      WITHDRAWAL
,      RELEASE
,      TARIFF
,      RECORD_STATUS
,      ERROR_CODE
FROM IGS.IGS_UC_CROFFAB_INTS;

Dependencies

[top of page]

IGS.IGS_UC_CROFFAB_INTS does not reference any database object

IGS.IGS_UC_CROFFAB_INTS is referenced by following:

SchemaAPPS
SynonymIGS_UC_CROFFAB_INTS