Interactions Table

Contains static interaction data, which is interaction data that does not change over the interaction lifecycle. Each record contains information about a single interaction.

Column

Type

Description

ID

string(128)

The unique identifier of the report.

FIRST_ID

string(128)

The ID of the first interaction in the chain (for SQL reports).

PREV_ID

string(128)

The ID of the previous interaction in the chain, if there was one.

CREATION_TIME

DateTime

The Interaction creation timestamp.

COMPLETE_TIME

DateTime

The Interaction completion timestamp.

QUEUE_TIME

int

The amount of time in seconds this interaction was queued.

CRN

nvarchar

The identifier of the inbound call leg that initiated the interaction. This identifier is unique only during one Ivanti Voice start session; it can repeat if you restart the voice server.

ANI

nvarchar

The caller ID of the calling party.

DNIS

nvarchar

The phone number dialed.

AGENT_ID

nvarchar

The unique identifier of the agent who handled the interaction.