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. |