FCT_RECORD_STORE_ACTIVITY_IS_REGISTERED

Activity Duration

VARCHAR(16777216)

Duration of the activity

PT55.5S

Activity Duration (secs)

NUMBER(38,3)

Duration of the activity converted to seconds

55.500

Activity ID

VARCHAR(16777216)

Identifier for the activity

123a12b3cd4e5f67g890h1ij

Activity Rank

NUMBER(18,0)

Provides a ranking order of the activity based on the Activity Timestamp with 1 being the earliest activity

1

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

answered

Attempt Percentage

NUMBER(19,2)

The score a user achieved on this attempt as a percentage (1.00 = 100%)

1.00

Attempt Score

NUMBER(38,0)

The score a user achieved on this attempt

1

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

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 Max Score

NUMBER(38,0)

The maximum score a user can achieve on this attempt

1

Potential Min Score

NUMBER(38,0)

The minimum score a user can achieve on this attempt

0

Raw Doc

OBJECT

The raw json document for the activity statement

”_v”:0, “_id:”123a12b3cd4e5f67g890h1ij”, “actor: {……

Registration ID

VARCHAR(16777216)

A unique identifier for the activity

123a12b3-cd4e-5f67-g890-h1ij12345678

Tenant ID

VARCHAR(16777216)

Identifier for the tenant

eu-west-2_abcdefGh1

User ID

VARCHAR(16777216)

Identifier for the user

123a12b3cd4e5f67g890h1ij