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_MERGE_ID_ROWS

Object Details

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

IGS_EN_MERGE_ID_ROWS contains the rows of tables involved in merge ID process

Storage Details

Tablespace:	APPS_TS_NOLOGGING
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_EN_MERGE_ID_ROWS_U1	NORMAL	UNIQUE	APPS_TS_NOLOGGING	SMIR_ID
IGS_EN_MERGE_ID_ROWS_N1	NORMAL	NONUNIQUE	APPS_TS_NOLOGGING	TABLE_ALIAS

Columns

Name	Datatype	Length	Mandatory	Comments
SMIR_ID	NUMBER	(6)	Yes	Contains the unique identifier for a row containing the information to that an action is to be applied for the rows identified in the merge ID process.
TABLE_ALIAS	VARCHAR2	(10)	Yes	Contains the table alias of the table involved in the merge ID process.
OBSOLETE_PERSON_ID	NUMBER	(15)	Yes	ID number of the person that is no longer in use. Data from the this ID will be merged into the current ID.
OBSOLETE_ID_ROW_INFO	VARCHAR2	(1000)		Contains information identifying the row that is no longer required but involved in the merge ID process with the current ID.
OBSOLETE_ID_ROWID	ROWID	(10)		Stores the ID of the row that is no longer required, that is involved in the merge process.
OBSOLETE_UPDATE_ON	DATE			Holds the timestamp of when the row was last updated. This will be used in the merge process to verify that no details have altered when performing the merge.
CURRENT_PERSON_ID	NUMBER	(15)	Yes	ID number of the person identified as the current ID. Data from the ID that is no longer used is merged into the current ID.
CURRENT_ID_ROW_INFO	VARCHAR2	(1000)		Contains information identifying the current row involved in the merge ID process with the ID of the student that is no longer used.
CURRENT_ID_ROWID	ROWID	(10)		Stores the ID of the current row involved in the merge process.
CURRENT_UPDATE_ON	DATE			Holds the timestamp of when the row was last updated. This will be used in the merge process to verify that no details have altered when performing the merge.
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column

Query Text

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


SELECT SMIR_ID
,      TABLE_ALIAS
,      OBSOLETE_PERSON_ID
,      OBSOLETE_ID_ROW_INFO
,      OBSOLETE_ID_ROWID
,      OBSOLETE_UPDATE_ON
,      CURRENT_PERSON_ID
,      CURRENT_ID_ROW_INFO
,      CURRENT_ID_ROWID
,      CURRENT_UPDATE_ON
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM IGS.IGS_EN_MERGE_ID_ROWS;

Dependencies

[top of page]

IGS.IGS_EN_MERGE_ID_ROWS does not reference any database object

IGS.IGS_EN_MERGE_ID_ROWS is referenced by following:

APPS: IGS_EN_MERGE_ID_ROWS