FCT_RECORD_STORE_ACTIVITY_ANSWERED

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

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