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

TABLE: IGS.IGS_UC_TRANIN_INTS

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


Holds application choice transaction information loaded from UCAS


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
TRANSACTIONID NUMBER (22)
Unique identifier , UCAS Applicant Number
INSTREFERENCE VARCHAR2 (8)
Institution reference
UPDATER VARCHAR2 (20)
Record updater in Hercules
ERRORCODE NUMBER (22)
Error code when transaction fails in Hercules
TRANSACTIONTYPE VARCHAR2 (2)
Transaction type
APPNO NUMBER (22)
Application Number
CHOICENO NUMBER (22)
Choice Number
DECISION VARCHAR2 (1)
Decision code
COURSE VARCHAR2 (4)
Course code
CAMPUS VARCHAR2 (1)
Campus code
ENTRYYEAR NUMBER (22)
Entry year
ENTRYMONTH NUMBER (22)
Entry month
ENTRYPOINT NUMBER (22)
Entry point
SOC VARCHAR2 (6)
Summary of condition
FREEFORMAT VARCHAR2 (591)
Free format
RETURN1 NUMBER (22)
Return 1 value, returned from Hercules
RETURN2 VARCHAR2 (1280)
Return 2 value, returned from Hercules
SYSCODE VARCHAR2 (1)
System code
ROUNDNO NUMBER (15)
Round number
MODULAR VARCHAR2 (1)
Modular indicator
PARTTIME VARCHAR2 (1)
Part time indicator
Query Text

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


SELECT TRANSACTIONID
,      INSTREFERENCE
,      UPDATER
,      ERRORCODE
,      TRANSACTIONTYPE
,      APPNO
,      CHOICENO
,      DECISION
,      COURSE
,      CAMPUS
,      ENTRYYEAR
,      ENTRYMONTH
,      ENTRYPOINT
,      SOC
,      FREEFORMAT
,      RETURN1
,      RETURN2
,      SYSCODE
,      ROUNDNO
,      MODULAR
,      PARTTIME
FROM IGS.IGS_UC_TRANIN_INTS;

Dependencies

[top of page]

IGS.IGS_UC_TRANIN_INTS does not reference any database object

IGS.IGS_UC_TRANIN_INTS is referenced by following:

SchemaAPPS
SynonymIGS_UC_TRANIN_INTS