---
title: "FCT_ENGAGEMENT_RECORD_STORE_ACTIVITY"
slug: "fct-engagement-record-store-activity"
updated: 2026-07-22T16:02:21Z
published: 2026-07-22T16:02:21Z
canonical: "docs.thrivelearning.com/fct-engagement-record-store-activity"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.thrivelearning.com/llms.txt
> Use this file to discover all available pages before exploring further.

# FCT_ENGAGEMENT_RECORD_STORE_ACTIVITY

> [!NOTE]
> FCT_ENGAGEMENT_RECORD_STORE_ACTIVITY relates to all activity within the platform. This could be progression through a pathway, a space view, a content like or a user logging in for example. The table can be joined to DIM_CONTENT_SERVICE_CONTENTS on Content ID, many to 1, to show content items which have activity. It can also be joined to DIM_USER_SERVICE_USER on User ID, many to 1, to show which users have activity
> 
> 
> 
> Space Object ID can also be joined to DIM_SPACES to show space engagement

| **COLUMN NAME** | **DATA TYPE (FIELD SIZE)** | **DESCRIPTION** | CURRENT AVAILABLE VALUES | EXAMPLE |
| --- | --- | --- | --- | --- |
| **Activity Date** | DATE | Date of the activity |  | 2025-01-01 |
| **Activity Duration** | NUMBER(38,0) | Duration in seconds of the activity |  | 120 |
| **Activity ID** | VARCHAR(16777216) | Identifier for the activity |  | 123a12b3cd4e5f67g890h1ij |
| **Activity Origin** | VARCHAR(16777216) | Where the activity originated from | mobile-app, web, null | mobile-app |
| **Activity Source** | VARCHAR(16777216) | Impression for the activity (e.g. - feed, campaign, search etc.) |  | search |
| **Activity Time** | VARCHAR(16777216) | Time of the activity |  | 00:00:00 |
| **Activity Timestamp** | TIMESTAMP_NTZ(9) | Datetime of the activity |  | 2025-01-01T00:00:00.000+0000 |
| **Activity Type** | VARCHAR(16777216) | The type of activity which occurred (e.g. - viewed, liked, shared etc.) |  | viewed |
| **Content ID** | VARCHAR(16777216) | Identifier for the content |  | 123a12b3cd4e5f67g890h1ij |
| **Content Type** | VARCHAR(16777216) | Type of content (e.g. - url, file, video etc.) |  | video |
| **Doc Created At** | TIMESTAMP_NTZ(9) | Timestamp inherited from parent snowflake object(s) |  | 2025-01-01T00:00:00.000+0000 |
| **Doc Updated At** | TIMESTAMP_NTZ(9) | Timestamp inherited from parent snowflake object(s) |  | 2025-01-01T00:00:00.000+0000 |
| **Potential Content ID Variations** | VARCHAR(16777216) | Comma seperated list of up to four potential IDs which could identify which content item this record relates to Useful where content ID has been marked as invalid due to multiple matches |  | 123a12b3cd4e5f67g890h1ij, 321a12b3cd4e5f67g890h1ik |
| **Raw Doc** | OBJECT | Raw JSON document for this activity record store statement |  | {”_v”:0, “_id:”123a12b3cd4e5f67g890h1ij”, “actor: {……} |
| **Source** | VARCHAR(16777216) | Impression for viewed activity (e.g. - feed, campaign, search etc.) |  | search |
| Space Object ID | VARCHAR(16777216) | This is the content object ID and where the activity is space related it will identify the space, page, subpage or post |  | 123a12b3cd4e5f67g890h1ij |
| **Tenant ID** | VARCHAR(16777216) | Identifier for the tenant |  | eu-west-2_abcdefGh1 |
| **Thrive Role** | VARCHAR(16777216) | Users role within the platform | learner, learneradmin, null, administrator | learner |
| **Thrive Status** | VARCHAR(16777216) | Users status on the platform | active, suspended, new, null | active |
| **User Full Name** | VARCHAR(16777216) | User full name |  | John Smith |
| **User ID** | VARCHAR(16777216) | Identifier for the user |  | 123a12b3cd4e5f67g890h1ij |
| **Username(Email)** | VARCHAR(16777216) | User username(email) |  | john.smith@emailaddress.com |