Chat Messages

The chat message view object provides details about chat messages.

Data Store Key : CrmAnalyticsAM.ServiceExtractAM.SvcMgmtBiccExtractAM.ChatMessageExtractPVO

Primary Keys : MessageId

Initial Extract Date : CreationDate

Incremental Extract Date : LastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

Name	Description
ChatId	The unique identifier of the associated chat. This is a foreign key to the Chat view object.
ChatRoleCd	The role of the person that posted the message such as AGENT or END_USER.
CreatedBy	The user who created the row.
CreationDate	The date and time when the row was created.
DeletedFlag	Indicates whether the record is logically deleted.
LastUpdateDate	The date and time when the row was last updated.
LastUpdateLogin	The session login of the user who last updated the row.
LastUpdatedBy	The user who last updated the row.
MercuryWorkId	The Mercury work identifier, if available.
MessageContent	The content of the chat message, null for system messages.
MessageDate	The date when the message was sent, if the message was sent.
MessageId	The unique identifier of the record. This is the primary key for the view object.
MessageTypeCd	The type of message as received from the chat service.
ObjectVersionNumber	The number of times the row has been updated.
PostedByPartyId	The unique identifier of the person who posted the message. This person can be an internal resource or a customer contact. This is a foreign key to the Party view object.
RichTextFlag	Indicates if the message content is in rich text format.
VisibilityCd	Indicates the audience of the message such as ALL or NOT_END_USER.