[Home] [Help] [Dependency Information]
Object Name: | IES_FOOTPRINTING_DATA |
---|---|
Object Type: | TABLE |
Owner: | IES |
Subobject Name: | |
Status: | VALID |
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 IES_PANEL_DATA table. Each time that a panel is either added or simply enabled will count as a separate record in the IES_PANEL_DATA table.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IES_FOOTPRINTING_DATA_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PANEL_DATA_ID |
IES_FOOTPRINTING_DATA_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | FOOTPRINTING_DATA_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FOOTPRINTING_DATA_ID | NUMBER | Yes | Unique Identifier for Footprinting Data | |
CREATED_BY | NUMBER | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Standard Who column | ||
CREATION_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATE_DATE | DATE | Standard Who column | ||
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
ELAPSED_TIME | NUMBER | Yes | Stores the number of milliseconds that the Panel was activated for that instance | |
SEQUENCE_NUMBER | NUMBER | Yes | Order/Sequence of panel navigation in the script | |
PANEL_DATA_ID | NUMBER | Yes | Foriegn key to IES_PANEL_DATA panel_data_id | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield | |
SECURITY_GROUP_ID | NUMBER | (15) | Used in hosted environments | |
OBJECT_VERSION_NUMBER | NUMBER | Used in hosted environments |
Cut, paste (and edit) the following text to query this object:
SELECT FOOTPRINTING_DATA_ID
, CREATED_BY
, LAST_UPDATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ELAPSED_TIME
, SEQUENCE_NUMBER
, PANEL_DATA_ID
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, SECURITY_GROUP_ID
, OBJECT_VERSION_NUMBER
FROM IES.IES_FOOTPRINTING_DATA;
IES.IES_FOOTPRINTING_DATA does not reference any database object
IES.IES_FOOTPRINTING_DATA is referenced by following:
|
|
|