[Home] [Help] [Dependency Information]

TABLE: IES.IES_DATA_TABLES

Object Details

Object Name:	IES_DATA_TABLES
Object Type:	TABLE
Owner:	IES
FND Design Data:	IES.IES_DATA_TABLES
Subobject Name:
Status:	VALID

The IES_DATA_TABLES table lists the names of all tables which are to be used for storing footprinting and question data collected for any script listed in the IES_DEPLOYED_SCRIPTS table. The IES_PANEL_DATA and IES_QUESTION_DATA tables are always listed in the IES_DATA_TABLES table, with TABLE_IDs of 1 and 2.
At the end of an interaction, the Scripting Engine writes the list of panels that were accessed during the script, along with the start and end times for each panel, known as "footprinting" data, to the PANEL_DATA table.
In addition at the end of an interaction, the Scripting Engine writes the list of answers to questions marked "collectable" to the QUESTION DATA table.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IES_DATA_TABLES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TABLE_ID

Columns

Query Text

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

SELECT TABLE_ID
,      TABLE_NAME
,      SECURITY_GROUP_ID
,      OBJECT_VERSION_NUMBER
FROM IES.IES_DATA_TABLES;

Dependencies

[top of page]

IES.IES_DATA_TABLES does not reference any database object

IES.IES_DATA_TABLES is referenced by following:

APPS

IES_DATA_TABLES