Search Results ies_panel_data_pk

Overview

IES_PANEL_DATA is a transactional table in the IES (Scripting) product module of Oracle E-Business Suite, owned by the IES schema. Per the ETRM documentation, the table stores footprinting information captured during an interaction. In practice, a "panel" within IES scripting represents a discrete screen or form presented to an agent or end user during a guided interaction, and this table records each panel instance together with its relationship to the parent transaction and the underlying panel definition. It therefore acts as the operational bridge between a scripted session (IES_TRANSACTIONS) and the panel templates (IES_PANELS) that are rendered within it.

From a Data Vault modeling perspective, the heuristic classification of this object is link. This suggestion follows from its structure: the table is dominated by foreign key references to IES_TRANSACTIONS and IES_PANELS, which is characteristic of a link entity that resolves a many-to-many or parent-child relationship between two hubs. It should be treated as a linkage construct rather than a standalone hub or descriptive satellite when mapping to a Data Vault model.

Key Information Stored

The table contains 29 documented columns. The most significant are:

• PANEL_DATA_ID — the surrogate primary key (IES_PANEL_DATA_PK) uniquely identifying each panel footprint record.
• TRANSACTION_ID — foreign key to IES_TRANSACTIONS, tying the panel footprint to its parent interaction.
• PANEL_ID — foreign key to IES_PANELS, identifying which panel template was rendered.
• ELAPSED_TIME — captures the duration associated with the panel footprint, supporting performance and timing analysis.
• SEQUENCE_NUMBER — orders panel data records within a transaction, preserving the navigation path.
• DELETED_STATUS — indicates logical deletion, supporting soft-delete semantics.
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, enabling multi-tenant / security-group data segregation.
• OBJECT_VERSION_NUMBER — used for optimistic locking and concurrency control.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the standard Oracle EBS descriptive flexfield (DFF) columns, providing extensible, customer-defined attributes.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard WHO columns for audit and traceability.

The surrogate key is PANEL_DATA_ID; no separate unique business-key index is documented in the metadata beyond the primary key constraint.

Common Use Cases and Queries

Typical uses include reconstructing an agent's navigation path through a scripted interaction, measuring time spent per panel, and auditing which panels were presented for a given transaction. A representative query joining to the parent transaction is:

• SELECT pd.PANEL_DATA_ID, pd.TRANSACTION_ID, pd.PANEL_ID, pd.SEQUENCE_NUMBER, pd.ELAPSED_TIME FROM IES.IES_PANEL_DATA pd WHERE pd.TRANSACTION_ID = :transaction_id AND NVL(pd.DELETED_STATUS,'N') = 'N' ORDER BY pd.SEQUENCE_NUMBER;
• Panel-level performance aggregation: SELECT PANEL_ID, AVG(ELAPSED_TIME), COUNT(*) FROM IES.IES_PANEL_DATA GROUP BY PANEL_ID;
• Correlating answered questions to panels via the child table IES_QUESTION_DATA.PANEL_DATA_ID.

Related Objects

The following objects are the most significant related entities, per the documented FK relationships:

• IES_TRANSACTIONS — parent transaction; joined on TRANSACTION_ID.
• IES_PANELS — panel template definition; joined on PANEL_ID.
• FND_SECURITY_GROUPS — security group master; joined on SECURITY_GROUP_ID.
• IES_QUESTION_DATA — child table referencing this table via PANEL_DATA_ID, holding question-level footprint data.

Together these objects form the core of the IES scripting footprinting model, with IES_PANEL_DATA serving as the central link between transactions, panels, and the questions captured within them.