---
title: "FCT_RECORD_STORE_ACTIVITY_ANSWERED"
slug: "fct-record-store-activity-answered"
updated: 2026-03-10T14:20:16Z
published: 2026-03-10T14:20:16Z
canonical: "docs.thrivelearning.com/fct-record-store-activity-answered"
---

> ## 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_RECORD_STORE_ACTIVITY_ANSWERED

> [!NOTE]
> FCT_RECORD_STORE_ACTIVITY_ANSWERED relates to any quiz, assessment or elearning attempts within the platform and the question and answer level detail within them. The table can be joined to DIM_CONTENT_SERVICE_CONTENTS on Content ID, many to 1, to show content items which have attempts and answer. It can also be joined to DIM_USER_SERVICE_USER on User ID, many to 1, to show which users have attempts and answers

> [!WARNING]
> Only statements with a registration ID and those that can be linked to a content ID are included within this dataset. If multiple content IDs can be linked to the attempt this is marked as invalid and removed

| **COLUMN NAME** | **DATA TYPE (FIELD SIZE)** | **DESCRIPTION** | CURRENT AVAILABLE VALUES | EXAMPLE |
| --- | --- | --- | --- | --- |
| **Activity Date** | DATE | Date of the answered activity |  | 2025-01-01 |
| **Activity Duration** | VARCHAR(16777216) | Duration of the answered activity |  | PT2.1S |
| **Activity Duration (secs)** | NUMBER(38,3) | Duration in seconds of the answered activity |  | 2.100 |
| **Activity ID** | VARCHAR(16777216) | Identifier for the answered activity |  | 123a12b3cd4e5f67g890h1ij |
| **Activity Time** | VARCHAR(16777216) | Time of the answered activity |  | 00:00:00 |
| **Activity Timestamp** | TIMESTAMP_NTZ(9) | Datetime of the answered activity |  | 2025-01-01T00:00:00.000+0000 |
| **Activity Type** | VARCHAR(16777216) | The type of activity which occurred - this will always be answered for this table | answered | answered |
| **Answered Rank** | NUMBER(38,0) | Provides a ranking order of the questions answered based on Activity Timestamp with 1 being the earliest question answered |  | 1 |
| **Available Response** | ARRAY | A text array of available responses to the question |  | [ “Promote Offers”, “Offer a Free Trial”, “Use Discounts” ] |
| **Available Response ID** | ARRAY | An ID array of available responses to the question |  | [ “123a12b3cd4e5f67g890h1ij”, “123a12b3cd4e5f67g890h1ijl”, “123a12b3cd4e5f67g890h1ij” ] |
| **Content ID** | VARCHAR(16777216) | Identifier for the content |  | 123a12b3cd4e5f67g890h1ij |
| **Content Title** | VARCHAR(16777216) | Content title |  | How to boost your sales this quarter |
| **Content Type** | VARCHAR(16777216) | Type of content (e.g. - quiz, elearn, mixed, assessment) |  | quiz |
| **Correct Response** | ARRAY | A text array of the correct response(s) to the question |  | [ “Promote Offers”, “Offer a Free Trial” ] |
| **Correct Response ID** | ARRAY | An ID array of correct response(s) to the question |  | [ “123a12b3cd4e5f67g890h1ij”, “123a12b3cd4e5f67g890h1ijl” ] |
| **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 |
| **Is Correct** | BOOLEAN | Boolean flag (true/false) | TRUE, FALSE | TRUE |
| **Observed Assessor Email** | VARCHAR(16777216) | The observed assessors email address |  | john.smith@emailaddress.com |
| **Observed Assessor First Name** | VARCHAR(16777216) | The observed assessors first name |  | John |
| **Observed Assessor Full Name** | VARCHAR(16777216) | The observed assessors full name |  | John Smith |
| **Observed Assessor ID** | VARCHAR(16777216) | The observed assessors ID |  | 123a12b3cd4e5f67g890h1ij |
| **Observed Assessor Last Name** | VARCHAR(16777216) | The observed assessors last name |  | Smith |
| **Observed Assessor Ref** | VARCHAR(16777216) | The observed assessors reference |  | 123456A |
| **Question Description** | VARCHAR(16777216) | Text question description |  | Which of these methods are most effective, multiple may apply |
| **Question Language** | VARCHAR(16777216) | What langage the question is in |  | en-GB |
| **Question Name** | VARCHAR(16777216) | Text question name |  | What is the recommended technique(s) to boost performance? |
| **Question Type** | VARCHAR(16777216) | The type of question being asked |  | choice |
| **Raw Doc** | OBJECT | The raw json document for this answered statement |  | { ”_v”:0, “_id:”123a12b3cd4e5f67g890h1ij”, “actor: {…… } |
| **Registration ID** | VARCHAR(16777216) | A unique identifier for the attempt |  | 123a12b3-cd4e-5f67-g890-h1ij12345678 |
| **Response** | ARRAY | A text array of the response(s) given to the question |  | [ “Promote Offers”, “Offer a Free Trial” ] |
| **Response ID** | ARRAY | An ID array of response(s) given to the question |  | [ “123a12b3cd4e5f67g890h1ij”, “123a12b3cd4e5f67g890h1ijl” ] |
| **Tenant ID** | VARCHAR(16777216) | Identifier for the tenant |  | eu-west-2_abcdefGh1 |
| **User ID** | VARCHAR(16777216) | Identifier for the user |  | 123a12b3cd4e5f67g890h1ij |