eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: IGS.IGS_EN_LGCY_ERR_INT

Object Details

Object Name:	IGS_EN_LGCY_ERR_INT
Object Type:	TABLE
Owner:	IGS
FND Design Data:	IGS.IGS_EN_LGCY_ERR_INT
Subobject Name:
Status:	VALID

Contains the errors generated by the Legacy Import Process for Enrollment and Records. A row will be created by the process for any warning or error, along with the primary key ID (INT_TABLE_ID) of the related interface table as signified by the INT_TABLE_CODE column.
Scope: public
Product: IGS
Lifecycle: active
Display Name: Export Enrollment Legacy Import Error
Category: BUSINESS_ENTITY IGS_STUDENT_PROGRAM

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_EN_LGCY_ERR_INT_PK	NORMAL	UNIQUE	APPS_TS_INTERFACE	ERR_MESSAGE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ERR_MESSAGE_ID	NUMBER	(15)	Yes	Legacy Message ID
INT_TABLE_CODE	VARCHAR2	(30)	Yes	Table code of the Interface table, for which the current error message is being logged
INT_TABLE_ID	NUMBER	(15)	Yes	The Interface table ID, which identifies a unique row in a particular interface table
MESSAGE_NUM	NUMBER	(9)		Message Number
MESSAGE_TEXT	VARCHAR2	(2000)		Message Text
CREATED_BY	NUMBER	(15)		Standard Who Column
CREATION_DATE	DATE			Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)		Standard Who Column
LAST_UPDATE_DATE	DATE			Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column
REQUEST_ID	NUMBER	(15)		Standard Concurrent program who column
PROGRAM_APPLICATION_ID	NUMBER	(15)		Standard Concurrent program who column
PROGRAM_ID	NUMBER	(15)		Standard Concurrent program who column
PROGRAM_UPDATE_DATE	DATE			Standard Concurrent program who column

Query Text

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


SELECT ERR_MESSAGE_ID
,      INT_TABLE_CODE
,      INT_TABLE_ID
,      MESSAGE_NUM
,      MESSAGE_TEXT
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM IGS.IGS_EN_LGCY_ERR_INT;

Dependencies

[top of page]

IGS.IGS_EN_LGCY_ERR_INT does not reference any database object

IGS.IGS_EN_LGCY_ERR_INT is referenced by following:

APPS: IGS_EN_LGCY_ERR_INT