Channels Via
The channel via view object provides details about the channel instances used by service requests, SR messages, or other objects. Examples of channel instances are Facebook - Page, Facebook - Corporate Account, Twitter handle.
Data Store Key : CrmAnalyticsAM.ServiceExtractAM.SvcMgmtBiccExtractAM.ChannelViaExtractPVO
Primary Keys : ViaId
Initial Extract Date : CreationDate
Incremental Extract Date : LastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
Name | Description |
---|---|
ChannelId | The unique identifier of the channel used as a foreign Key to the Channels object. |
CollabResourceId | The unique identifier of the collaboration resource. This is a foreign key that references the Collaboration Resource view object. The COLLAB_NAME field in this table indicates the resource name as shown on the native collaboration channel. |
ContactPointId | The unique identifier of the contact point. This is a foreign key that references Contact Points view object. The CONTACT_POINT_TYPE column in Contact Point view object indicates the type such as phone, email, and so on. |
CreatedBy | The user who created the row. |
CreationDate | The date and time when the row was created. |
DeletedFlag | Indicates whether this via record is logically deleted. |
InboundObjectId | The unique identifier of the inbound object such as email, social, and so on. |
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. |
ObjectId | The unique identifier of the object associated with the channel. This is a foreign key to the Service Request view object or the SR Messages view object depending on if this is a SR or a SR message. |
ObjectTypeCd | Indicates whether the OBJECT_ID is for SR or for SR_Message. |
ObjectVersionNumber | The number of times the row has been updated. |
PartyId | The unique identifier of the party associated with the record. This is a foreign key to the Parties view object. |
PartyViaEndPoint | The end point used to send the communication to the owner of the PARTY_ID. This column can be an email address, phone number, and so on. When PARTY_ID is null and this column isn't null, this end point belongs to a party. |
PersonId | The unique person ID of the contact. |
PostIdentifier | The unique identifier for the social media posting that can be used to respond via the same channel instance. |
RoutingCd | Lookup code that indicates how the message was routed to the PARTY_VIA_END_POINT. For example, if the message is an email, whether the recipient is a TO, CC, or BCC recipient. |
ViaId | The unique identifier of the record. This is the primary key for the view object. |