This article lists all of the objects and fields related to articles and product updates in the communities data lake.
content_topic_author_changed (fact)
This object table contains a list of fields related to when the author of the topic was changed.
| 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 | 
| topic_public_id | string | refers to the unique identifier of the topic that identifies the opening topic platform-wide | 
| executed_by | string | identifies the person who executed the activity (zero, if system event) | 
| topic_private_id | string | refers to the unique identifier of the topic, that identifies the opening topic within the Content Type | 
| user_id | string | refers to the unique identifier of the person that identifies the user platform-wide | 
| new_author_id | string | 			 refers to unique identifier of the user who created a piece of content, topic, reply, or event, identifying the original creator within the community  | 		
| new_author_username | string | refers to the new name of a user within the community | 
| old_author_id | string | 			 refers to unique identifier of the user who created a piece of content, topic, reply, or event, identifying the original creator within the community  | 		
| content_type | string | Identifies the type of content, such as article, product update, question, idea, discussion | 
content_topic_featured_image_changed (fact)
This object table contains a list of fields related to when the featured image of the article or product update was changed.
| 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 | 
| topic_public_id | string | refers to the unique identifier of the topic that identifies the opening topic platform-wide | 
| executed_by | string | identifies the person who executed the activity (zero, if system event) | 
| topic_private_id | string | refers to the unique identifier of the topic, that identifies the opening topic within the Content Type | 
| user_id | string | refers to the unique identifier of the person that identifies the user platform-wide | 
| is_published | string | indicates whether content, such as an article or product update, is published and visible to users within the community | 
| featured_image | string | refers to the primary image attached to a post, representing the content visually | 
| content_type | string | Identifies the type of content, such as article, product update, question, idea, discussion | 
content_topic_preview_changed (fact)
This object table contains a list of fields related to when the preview of an article or product update is changed.
| 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 | 
| topic_public_id | string | refers to the unique identifier of the topic that identifies the opening topic platform-wide | 
| 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 | 
| topic_private_id | string | refers to the unique identifier of the topic, that identifies the opening topic within the Content Type | 
| is_preview_public | string | 			 indicates whether the preview of content, such as an article or product update, is restricted to moderators or available to all users.  | 		
| content_type | string | Identifies the type of content, such as article, product update, question, idea, discussion | 
content_topic_published (fact)
This object table contains a list of fields related to when an article or product update is published and become visible in the community.
| 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 | 
| topic_public_id | string | refers to the unique identifier of the topic that identifies the opening topic platform-wide | 
| executed_by | string | identifies the person who executed the activity (zero, if system event) | 
| topic_private_id | string | refers to the unique identifier of the topic, that identifies the opening topic within the Content Type | 
| user_id | string | refers to the unique identifier of the person that identifies the user platform-wide | 
| author_id | string | 			 refers to unique identifier of the user who created a piece of content, topic, reply, or event, identifying the original creator within the community  | 		
| author_username | string | contains the name of the user at the time of creating a content | 
| author_avatar | string | refers to the graphical representation or image associated with a user profile | 
| title | string | refers to the headline or name given to a topic, summarizing its content | 
| featured_image | string | refers to the primary image attached to a post, representing the content visually | 
| public_label | string | represents a user-friendly title or identifier that serves as a concise description of the topic's content or purpose | 
| content | string | refers to the main body of the post. If empty the event did not affect the body of the post | 
| ip_address | string | 			 refers to the unique numerical label assigned to a user's device by an Internet Service Provider (ISP) to identify and locate it on a network  | 		
| public_tags_name | string | refers to a keyword or phrase used to categorize and organize content, making it easily searchable and accessible to everyone. | 
| is_sticky | string | indicates whether a topic is set to stick to the top of the page, making it always visible to users within the community | 
| is_closed | string | indicates whether a topic is closed, meaning it is not allowed to receive further replies but is still visible. | 
| moderator_tags_name | string | refers to a keyword or phrase used by moderators to categorize and manage the content | 
| poll | string | refers to a feature within the community where users can participate in voting or surveys on various topics | 
| is_published | string | indicates whether content, such as an article or product update, is published and visible to users within the community | 
| last_edited_at | string | refers to the date and time when the most recent edit or modification was made to a piece of content | 
| last_edited_by | string | refers to the user ID of the moderator who most recently reviewed or managed community content. | 
| category_id | string | refers to the unique identifier assigned to a specific category within the community | 
| content_type | string | Identifies the type of content, such as article, product update, question, idea, discussion | 
content_topic_schedule_canceled (fact)
This object table contains a list of fields related to when an article or product update that had a future publish date that was canceled.
| 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 | 
| executed_by | string | identifies the person who executed the activity (zero, if system event) | 
| topic_public_id | string | refers to the unique identifier of the topic that identifies the opening topic platform-wide | 
| user_id | string | refers to the unique identifier of the person that identifies the user platform-wide | 
| topic_private_id | string | refers to the unique identifier of the topic, that identifies the opening topic within the Content Type | 
| content_type | string | Identifies the type of content, such as article, product update, question, idea, discussion | 
content_topic_scheduled (fact)
This object table contains a list of fields related to when an article or product update has a future publish date scheduled.
| 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 | 
| executed_by | string | identifies the person who executed the activity (zero, if system event) | 
| topic_public_id | string | refers to the unique identifier of the topic that identifies the opening topic platform-wide | 
| user_id | string | refers to the unique identifier of the person that identifies the user platform-wide | 
| topic_private_id | string | refers to the unique identifier of the topic, that identifies the opening topic within the Content Type | 
| content_type | string | Identifies the type of content, such as article, product update, question, idea, discussion | 
content_topic_scheduled_published (fact)
This object table contains a list of fields related to when an article or product update that had a future publish date was published.
| 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 | 
| topic_public_id | string | refers to the unique identifier of the topic that identifies the opening topic platform-wide | 
| executed_by | string | identifies the person who executed the activity (zero, if system event) | 
| topic_private_id | string | refers to the unique identifier of the topic, that identifies the opening topic within the Content Type | 
| user_id | string | refers to the unique identifier of the person that identifies the user platform-wide | 
| author_username | string | contains the name of the user at the time of creating a content | 
| author_avatar | string | refers to the graphical representation or image associated with a user profile | 
| author_id | string | 			 refers to unique identifier of the user who created a piece of content, topic, reply, or event, identifying the original creator within the community  | 		
| category_id | string | refers to the unique identifier assigned to a specific category within the community | 
| title | string | refers to the headline or name given to a topic, summarizing its content | 
| featured_image | string | refers to the primary image attached to a post, representing the content visually | 
| public_label | string | represents a user-friendly title or identifier that serves as a concise description of the topic's content or purpose | 
| content | string | refers to the main body of the post. If empty the event did not affect the body of the post | 
| ip_address | string | 			 refers to the unique numerical label assigned to a user's device by an Internet Service Provider (ISP) to identify and locate it on a network  | 		
| public_tags_name | string | refers to a keyword or phrase used to categorize and organize content, making it easily searchable and accessible to everyone. | 
| is_sticky | string | indicates whether a topic is set to stick to the top of the page, making it always visible to users within the community | 
| is_closed | string | indicates whether a topic is closed, meaning it is not allowed to receive further replies but is still visible. | 
| moderator_tags_name | string | refers to a keyword or phrase used by moderators to categorize and manage the content | 
| poll | string | refers to a feature within the community where users can participate in voting or surveys on various topics | 
| is_published | string | indicates whether content, such as an article or product update, is published and visible to users within the community | 
| last_edited_at | string | refers to the date and time when the most recent edit or modification was made to a piece of content | 
| last_edited_by | string | refers to the user ID of the moderator who most recently reviewed or managed community content. | 
| content_type | string | Identifies the type of content, such as article, product update, question, idea, discussion |