This article lists all of the objects and fields related to private messages in the communities data lake.
pm_conversation (dimension)
This object table contains a list IDs of private conversations, their participants, last update date and status.
| Field Name | Field Type | Field Description |
|---|---|---|
| sender_user_id | string | refers to the unique identifier of the user who sent a private message |
| last_pm_message_id | string | refers to the unique identifier of the most recent message sent within a private message conversation |
| conversation_id | string | refers to the unique identifier assigned to a specific conversation / private messages thread |
| last_activity_at | timestamp | refers to the date and time of the most recent interaction within a private message conversation |
| read | int | indicates whether a private message has been marked as read by a user |
| receiver_user_id | string | refers to the unique identifier of the user who is the recipient of a message |
pm_message (dimension)
This object table contains a list IDs of private message assignments to the conversation and sent date.
| Field Name | Field Type | Field Description |
|---|---|---|
| conversation_id | string | refers to the unique identifier assigned to a specific conversation / private messages thread |
| pm_message_id | string | refers to the unique identifier of the private message conversation |
| sent_at | timestamp | refers to the date and time when a private message was sent within the community |
| user_id | string | refers to the unique identifier of the person that identifies the user platform-wide |
| deleted_by_user_id | string | refers to the unique identifier of the user who deleted the message |
private_messages_mass_private_message_sent (fact)
This object table contains a list of fields related to when bulk private messages were sent.
| Field Name | Field Type | Field Description |
|---|---|---|
| community_id | string | contains the community ID where the activity was executed |
| correlation_id | string | refers to a unique identifier used to correlate and track related actions within the community platform, used for debugging or monitoring purposes |
| occurred_at | string | refers to the timestamp indicating the precise moment when the activity took place |
| user_id | string | refers to the unique identifier of the person that identifies the user platform-wide |
| executed_by | string | identifies the person who executed the activity (zero, if system event) |
private_messages_private_message_created (fact)
This object table contains a list of fields related to when a private message was created.
| Field Name | Field Type | Field Description |
|---|---|---|
| community_id | string | contains the community ID where the activity was executed |
| correlation_id | string | refers to a unique identifier used to correlate and track related actions within the community platform, used for debugging or monitoring purposes |
| occurred_at | string | refers to the timestamp indicating the precise moment when the activity took place |
| subject | string | contains generic message sent to inform about new private message received |
| user_id | string | refers to the unique identifier of the person that identifies the user platform-wide |
| executed_by | string | identifies the person who executed the activity (zero, if system event) |
private_messages_private_message_deleted (fact)
This object table contains a list of fields related to when a private message was deleted.
| Field Name | Field Type | Field Description |
|---|---|---|
| community_id | string | contains the community ID where the activity was executed |
| correlation_id | string | refers to a unique identifier used to correlate and track related actions within the community platform, used for debugging or monitoring purposes |
| occurred_at | string | refers to the timestamp indicating the precise moment when the activity took place |
| conversation_id | string | refers to the unique identifier assigned to a specific conversation / private messages thread |
| user_from_id | string | refers to the unique identifier of the user who sent a private message |
| user_from_roles | string | refers to the roles of the user who initiated prinvate message thread within the community |
| user_to_id | string | refers to the unique identifier of the user who got a private message |
| user_to_roles | string | refers to the roles of the user who is the recipient of the private message |
| executed_by | string | identifies the person who executed the activity (zero, if system event) |
| user_id | string | refers to the unique identifier of the person that identifies the user platform-wide |
private_messages_private_message_reported (fact)
This object table contains a list of fields related to when a private message was reported.
| Field Name | Field Type | Field Description |
|---|---|---|
| community_id | string | contains the community ID where the activity was executed |
| correlation_id | string | refers to a unique identifier used to correlate and track related actions within the community platform, used for debugging or monitoring purposes |
| occurred_at | string | refers to the timestamp indicating the precise moment when the activity took place |
| message_id | string | refers to the unique identifier of the private message conversation |
| reason | string | contains a description of the grounds for reporting the private message, |
| reported_message_id | string | refers to the unique identifier of the private message conversation |
| reported_to | string | specifies the identifier of the user or moderator to whom the private message has been reported for review or moderation |
| reported_user_id | string | refers to the unique identifier of the person who reported the message |
| executed_by | string | identifies the person who executed the activity (zero, if system event) |
| user_id | string | refers to the unique identifier of the person that identifies the user platform-wide |
private_messages_private_message_sent (fact)
This object table contains a list of fields related to when a private message was sent.
| Field Name | Field Type | Field Description |
|---|---|---|
| community_id | string | contains the community ID where the activity was executed |
| correlation_id | string | refers to a unique identifier used to correlate and track related actions within the community platform, used for debugging or monitoring purposes |
| occurred_at | string | refers to the timestamp indicating the precise moment when the activity took place |
| from | string | refers to the unique identifier of the user who sent a private message |
| to | string | refers to the unique identifier of the user who got a private message |
| user_id | string | refers to the unique identifier of the person that identifies the user platform-wide |
| executed_by | string | identifies the person who executed the activity (zero, if system event) |