Chats
The chat view object provides details about chats. It's referenced by the Chat Message view object.
Data Store Key : CrmAnalyticsAM.ServiceExtractAM.SvcMgmtBiccExtractAM.ChatExtractPVO
Primary Keys : ChatId
Initial Extract Date : CreationDate
Incremental Extract Date : LastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| AccountPartyId | The unique identifier of the account associated with the contact. This is a foreign key to the Party view object. |
| AssigneeResourceId | The unique identifier of the assigned resource. This is a foreign key to the Party view object. |
| CategoryId | The unique identifier of the category. This is a foreign key to the Categories view object. |
| ChatDirectionCd | Indicates who initiated the chat. The values are Inbound for customer initiated and Outbound for agent initiated. |
| ChatId | The unique identifier of the record. This is the primary key for the view object. |
| ChatSource | The source of the chat, such as WCFS, RW UI, or Facebook. |
| ContactPartyId | The customer contact of this work request. This is a foreign key to the Party view object. |
| 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. |
| The email address as entered by the customer in the Request Chat form. | |
| EndUserSessionId | The end user session identifier in the chat server. |
| FirstName | The first name as entered by the customer in the Request Chat form. |
| IncidentName | The number or name of the referenced Business Object for which the chat was created. |
| IncidentType | The incident type associated to the chat, as received in the request engagement message. |
| InventoryItemId | The inventory item that the chat is related to. |
| InventoryOrgId | The organization of the inventory item that the chat is related to. |
| LastName | The last name as entered by the customer in the Request Chat form. |
| 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. |
| MercConvDoneFlag | Indicates if the Mercury Conversation is done. Value is null if there is no conversation. |
| MercuryConversationId | The alternate identifier that references conversation_alternate_id in table SVC_MC_CONVERSATION. |
| ObjectVersionNumber | The number of times the row has been updated. |
| OsvcChatId | The Oracle Service (Right Now) chat Id from the Right Now Server. |
| ProdGroupId | The product group for the product. This is a foreign key reference to the Product Group view object. |
| Question | The question as entered by the customer in the Request Chat form. |
| QueueId | The unique identifier of the assigned queue. This is foreign key to the Queue view object. |
| StatusCd | The lookup code that indicates the status code. |
| SubstatusCd | The lookup code that indicates the substatus code. |
| TierOneSessionId | The unique identifier of the end user's session in application context. |