FCT_RECORD_STORE_ACTIVITY_EARNED provides information on custom badges within the platform. The table can be joined to DIM_USER_SERVICE_USER on User ID, many to 1, to show which users have obtained custom badges
Only custom badges are included within this dataset. These cannot be linked to Content ID so all entries will show ‘Invalid Content ID’
COLUMN NAME | DATA TYPE (FIELD SIZE) | DESCRIPTION | CURRENT AVAILABLE VALUES | EXAMPLE |
|---|---|---|---|---|
Activity Date | DATE | Date of the earned activity | 2025-01-01 | |
Activity ID | VARCHAR(16777216) | Identifier for the earned activity | 123a12b3cd4e5f67g890h1ij | |
Activity Time | VARCHAR(16777216) | Time of the earned activity | 00:00:00 | |
Activity Timestamp | TIMESTAMP_NTZ(9) | Datetime of the earned activity | 2025-01-01T00:00:00.000+0000 | |
Activity Type | VARCHAR(16777216) | Earned (this is the only activity included in this dataset) | earned | earned |
Award Definition ID | VARCHAR(16777216) | Identifier for the badge | 123a12b3cd4e5f67g890h1ij | |
Badge Description | VARCHAR(16777216) | Description of the badge | Congratulations! You’ve successfully completed your sales training | |
Badge Title | VARCHAR(16777216) | Title of the badge | Sales Superstar | |
Badge Type | VARCHAR(12) | Custom Badge | Custom Badge | Custom Badge |
Content ID | VARCHAR(16777216) | Identifier for the content | Invalid Content ID | Invalid Content ID |
Doc Created At | Timestamp inherited from parent snowflake object(s) | 2025-01-01T00:00:00.000+0000 | ||
Doc Updated At | Timestamp inherited from parent snowflake object(s) | 2025-01-01T00:00:00.000+0000 | ||
Earned Type | VARCHAR(16777216) | What has been earned (badge) | badge | badge |
Tenant ID | VARCHAR(16777216) | Identifier for the tenant | eu-west-2_abcdefGh1 | |
User ID | VARCHAR(16777216) | Identifier for the user | 123a12b3cd4e5f67g890h1ij |