CAL_CHAT_ASGN_HX

Description:

The CAL_CHAT_ASGN_HX table contains information about the history of a live chat. This table tracks what agent was assigned to a chat and what queue was assigned to a chat. This table also contains data on who updated the chat assignment and when it was updated.

Primary Key

Column Name	Ordinal Position
COMM_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	COMM_ID	VARCHAR	No
	The unique identifier (.1 item) for the communication record.
2	LINE	INTEGER	No
	The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3	CHAT_HX_REASON_C_NAME	VARCHAR	No
	The reason for changing the assignment or queue of a chat. Categories that are below 500 will automatically be set by system in certain automated workflows that change the chat history. Users will only have the ability to select category that have an ID 500 or above. May contain organization-specific values: Yes Category Entries: Agent Sent Chat Back Agent Logged Out Automatic Assignment Chat Ended Documentation Completed Assigned to Wrong Queue New Question Additional Support Needed
4	CHAT_HX_CMT	VARCHAR	No
	Comments on the change of chat history that will be shown to future users reviewing the chat history. The comment is left by the user changing the chat assignment. The comment will be the message to the next agent if the change was done during the transfer workflow.