CHAT_PART_LIST_CHANGE

Description:

Monitors participant changes in secure chat messages.

Primary Key

Column Name	Ordinal Position
CONVERSATION_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	CONVERSATION_ID	NUMERIC	No
	The unique identifier (.1 item) for the secure chat conversation 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	CM_PHY_OWNER_ID	VARCHAR	No
	The Community ID (CID) of the instance that owns this record or line. This is only populated if you use IntraConnect.
4	CHANGED_USER_ID	VARCHAR	No
	This tracks which user joined or left the conversation
5	CHANGED_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
6	CHANGED_BY_USER_ID	VARCHAR	No
	This tracks which user changed another user's status in the conversation
7	CHANGED_BY_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
8	CHANGE_INSTANT_DTTM	DATETIME (UTC)	No
	This tracks when a participant change happened
9	CHANGE_TYPE_5_C_NAME	VARCHAR	No
	This tracks what sort of participant change occurred: a user joined the conversation, a user left the conversation, etc. May contain organization-specific values: No Category Entries: Participant Joined Participant Left Participant Auto Added Participant Added From Group Participant Turned Off Chat Participant Removed From Group Participant Added To Treatment Team Participant Removed From Treatment Team Group Detached Rename Conversation Participant Removed by Another User Participant Rejoined
10	CHANGED_TGR_ID_UC_GROUP_ID	NUMERIC	No
	This tracks which group was added or removed from the conversation