Dimension Datasets

assignments_fact_m_v
badges_dim_m_v
cards_dim_m_v
channels_dim_m_v
comments_fact_m_v
quizzes_fact_m_v
custom_fields_dim_m_v
groups_dim_m_v
organizations_dim_m_v
roles_dim_m_v
structured_items_fact_m_v
structures_dim_m_v
team_assignments_fact_m_v
teams_dim_m_v
teams_users_fact_m_v
user_profiles_fact_m_v
users_dim_m_v
card_pack_relations_dim_m_v
journey_pack_relations_dim_m_v
channels_cards_dim_m_v
user_content_completions_dim_m_v
group_assignments_performance_i_v
user_assignments_performance_i_v
user_custom_fields_dim_m_v
user_onboardings_dim_m_v
profiles_dim_m_v
card_reportings_dim_m_v
skills_users_dim_m_v
user_roles_dim_m_v
card_languages_dim_m_v
card_relations_dim_m_v
badgings_dim_m_v

Assignments

(assignments_fact_m_v)

Name	Type	Description
id	Integer	ID of the assignment
user_id	Integer	ID of the user who is assigned to the content
title	String	Title of the assigned content
assignable_type	String	Type of the content that is assigned (e.g. card)
assignable_id	Integer	ID of the assigned content
created_at	Timestamp	Timestamp of the assignment creation
updated_at	Timestamp	Timestamp of the assignment update
state	String	State of the assignment (e.g assigned, started, completed)
started_at	Timestamp	Actual start time of the assignment
completed_at	Timestamp	Actual complete time of the assignment
due_at	Timestamp	Due data of the assignment
start_date	Timestamp	Start date of the assignment
assignor_id	Integer	ID of user who assigned the content
assigned_date	Timestamp	Timestamp of the assignment
org_id_s	Integer	ID of the organisation
record_insert_time	String	Time when record was created in text format
yr	String	Partition information on creation date (year)
month	String	Partition information on creation date (month)
day	String	Partition information on creation date (day)
hour	String	Partition information on creation date (hour)

Badges

(badges_dim_m_v)

Name	Type	Description
id	Integer	ID of the badge
type	String	Type of the badge: ClcBadge, CardBadge
created_at	Timestamp	Timestamp of badge creation
updated_at	Timestamp	Timestamp of badge update
image_file_name	String	File name of the badge image
image_content_type	String	Format of the badge image: image/jpg, image/png etc
image_file_size	Integer	File size of the badge image
image_updated_at	Timestamp	Timestamp of image badge update
image_social_file_name	String	File name of the badge image for social sharing
image_social_content_type	String	Format of the badge image: image/jpg, image/png etc
image_social_file_size	Integer	File size of the badge image
image_social_updated_at	Timestamp	Timestamp of image badge update
is_default	Boolean	Is badge default?
image_original_url	String	URL to the origianal badge image
org_id_s	Integer	ID of the organisation
record_insert_time	String	Time when record was created in text format
yr	String	Partition information on creation date (year)
month	String	Partition information on creation date (month)
day	String	Partition information on creation date (day)
hour	String	Partition information on creation date (hour)

Cards

(cards_dim_m_v)

Name	Type	Description
id	Integer	ID of the smart card
cards_config_id	Integer	Intrernal id of the configuation
card_level	String	Proficiency level: Beginner, Intermediate, Advanced
group_id	Integer	ID of group
author_first_name	String	First name of the smart card author
author_last_name	String	Last name of the smart card author
author_picture_url	String	URL to picture of the smart card author
super_card_id	Integer	Id of.the original card if this card is a clone
author_id	Integer	Id of the smart card author
created_at	Timestamp	Timestamp of the smart card creation
updated_at	Timestamp	Timestamp of the smart card most recent update
is_public	Boolean	Is smart card public or private
is_manual	Boolean	Is smart card created manually
features	String
client_id	Integer
client_item_id	String
comments_count	Integer	Number of comments to the smart card
order_index	Integer	Internal index of the card sequence
slug	String	Slug of the smart card url
impressions_count	Integer	Number of smart card impressions
outbounds_count	Integer
shares_count	Integer	Number of shares of the smart card
answers_count	Integer	Number of answers to the quiz or poll
expansions_count	Integer
plays_count	Integer	Number of plays of the card
hidden	Boolean	Is card hidden?
resource_id	Integer	ID of the card content external resource
state	String	State of the smart card: Draft, Published, Processing, Archived, Deleted
title	String	Title of the smart card
message	String	Message of the smart card (usually title)
published_at	Timestamp	Timestamp of the smart card publication
is_official	Boolean	Is smart card official?
card_type	String	The type of the smart card: poll, media, scorm, project etc
card_subtype	String	The subtype of the smart card: image, video, audio, file etc
votes_count	Integer	Number of votes for the card
promoted_at	Timestamp	Timestamp of card promotion
ecl_id	String	Id of the smart card content reference
ecl_metadata	String	Metadata defining smart card content
taxonomy_topics	String	List of taxonomy topics
filestack	String	Reference to the image of the card
bookmarks_count	Integer	Number of card bookmarks
deleted_at	Timestamp	Timstamp of casd delation
ecl_source_name	String	Source name of the content
readable_card_type	Integer
can_be_reanswered	Boolean	Is card answerable (e.g. poll or quiz)
provider	String	Name of the content provider for the smart card
provider_image	String	ULR to the image the content provider for the smart card
auto_complete	Boolean	Is autocomplete set for this smart card?
user_taxonomy_topics	String	List of user taxonomy topics
duration	String	Descrptive text of the content duration
is_paid	Boolean	Is content of the card free or paid?
language	String	Language of the content
authoritative_all_time_views_count	Integer	Total number of smart card views
is_taxonomy_generated	Boolean	Is skill taxonomy generated automatically
standard_type	String	Standard card type: news, document, article, poll etc
org_id_s	Integer	ID of the organisation
record_insert_time	String	Time when record was created in text format
yr	String	Partition information on creation date (year)
month	String	Partition information on creation date (month)
day	String	Partition information on creation date (day)
hour	String	Partition information on creation date (hour)

Channels

(channels_dim_m_v)

Name	Type	Description
id	Integer	ID of the channel
label	String	Label of the channel
description	String	Description of the channel
card_query_id	Integer
created_at	Timestamp	Timestamp of channel creation
updated_at	Timestamp	Timestamp of the most recent channel update
image_file_name	String	URL to the channel image
image_content_type	String	Format of the channel image: image/jpg, image/png etc
image_file_size	Integer	File size of the channel image
image_updated_at	Timestamp	Timestamp of the image update
slug	String	Slug of the channel url
visible	Boolean	Is channel visible?
mobile_image_file_name	String	URL to the channel mobile image
mobile_image_content_type	String	Format of the channel mobile image: image/jpg, image/png etc
mobile_image_file_size	Integer	File size of the channel mobile image
mobile_image_updated_at	Timestamp	Timestamp of the mobile image update
is_private	Boolean	Is channel private?
client_id	Integer
keywords	String	List of keywords for the channel
autopull_content	Boolean
show_authors	Boolean	Does author of tbhe
visible_during_onboarding	Boolean	Is channel visible during onboarding?
only_authors_can_post	Boolean	Can only owner of the channel post content?
group_id	Integer
content_discovery_freq	String	Test representation of the frequency of channel discovery
last_discovered_at	Timestamp	Timestamp of the most recent channel discory event
is_general	Boolean	Is channel general?
is_promoted	Boolean	Is channel promoted?
auto_follow	Boolean	Is channel set for auto follow?
user_id	Integer	ID of the channel creator
topics	String	Topics of the channel in meta data format
ecl_enabled	Boolean
curate_only	Boolean	Can channel be
provider	String
provider_image	String
is_open	Boolean	Can anyone join the channel?
curate_ugc	Boolean
allow_follow	Boolean	Can anyone follow the channel?
shareable	Boolean	Can channel be shared?
parent_id	Integer
auto_pin_cards	Boolean
language	String	Language of the channel
content_type	String
card_fetch_limit	Integer
org_id_s	Integer	ID of the organisation
record_insert_time	String	Time when record was created in text format
yr	String	Partition information on creation date (year)
month	String	Partition information on creation date (month)
day	String	Partition information on creation date (day)
hour	String	Partition information on creation date (hour)

Comments

(comments_fact_m_v)

Name	Type	Description
id	Integer	ID of the comment
message	String	Content of the comment
type	String	Type of the comment (LiveComment)
commentable_id	Integer	ID of the item that is commented
commentable_type	String	Item that is commented (Team, Card)
user_id	Integer	Id of the commenting user
created_at	Timestamp	Timestamp of comment creation
updated_at	Timestamp	Timestamp of comment the most recent update
votes_count	Integer	Number of votes for the comment
resource_id	Integer
hidden	Boolean	Is commnet hidden?
anonymous	Boolean	Is comment anonymous?
is_mobile	Boolean	Is comment created on mobile?
client_item_id	String
comments_count	Integer
deleted_at	Timestamp	Timestamp of the comment delation
org_id_s	Integer	ID of the organisation
record_insert_time	String	Time when record was created in text format
yr	String	Partition information on creation date (year)
month	String	Partition information on creation date (month)
day	String	Partition information on creation date (day)
hour	String	Partition information on creation date (hour)

Quizzes

(quizzes_fact_m_v)


id	Integer
card_id	Integer
reanswerable	Boolean
passing_criteria	Integer
created_at	Timestamp
updated_at	Timestamp
mandatory	Boolean
org_id_s	Integer
record_insert_time	String
yr	String
month	String
day	String
hour	String

Custom Fields

(custom_fields_dim_m_v)


id	Integer
abbreviation	String
display_name	String
created_at	Timestamp
updated_at	Timestamp
enable_people_search	Boolean
org_id_s	Integer
record_insert_time	String
yr	String
month	String
day	String
hour	String

Groups

(groups_dim_m_v)


id	Integer
name	String
description	String
website_url	String
created_at	Timestamp
updated_at	Timestamp
client_id	Integer
client_resource_id	String
type	String
access	String
users_count	Integer
course_data_url	String
image_url	String
details_locked	Boolean
creator_id	Integer
parent_id	Integer
close_access	Boolean
topic_id	Integer
picture_file_name	String
picture_content_type	String
picture_file_size	Integer
picture_updated_at	Timestamp
is_private	Boolean
start_date	Timestamp
course_term	String
end_date	Timestamp
connect_to_social_mediums	Boolean
enable_mobile_app_download_buttons	Boolean
share_to_social_mediums	Boolean
daily_digest_enabled	Boolean
forum_notifications_enabled	Boolean
language	String
is_promoted	Boolean
is_hidden	Boolean
course_code	String
org_id_s	Integer
record_insert_time	String
yr	String
month	String
day	String
hour	String

Organizations

(organizations_dim_m_v)

Name	Type	Description
name	String
description	String
slug	String
image_file_name	String
image_content_type	String
image_file_size	Integer
image_updated_at	Timestamp
created_at	Timestamp
updated_at	Timestamp
mobile_image_file_name	String
mobile_image_content_type	String
mobile_image_file_size	Integer
mobile_image_updated_at	Timestamp
host_name	String
client_id	Integer
co_branding_logo_file_name	String
co_branding_logo_content_type	String
co_branding_logo_file_size	Integer
co_branding_logo_updated_at	Timestamp
co_branding_mobile_logo_file_name	String
co_branding_mobile_logo_content_type	String
co_branding_mobile_logo_file_size	Integer
co_branding_mobile_logo_updated_at	Timestamp
is_registrable	Boolean
send_weekly_activity	Boolean
status	String
show_sub_brand_on_login	Boolean
savannah_app_id	Integer
redirect_uri	String
social_enabled	Boolean
xapi_enabled	Boolean
users_count	Integer
show_onboarding	Boolean
enable_role_based_authorization	Boolean
splash_image_file_name	String
splash_image_content_type	String
splash_image_file_size	Integer
splash_image_updated_at	Timestamp
favicon_file_name	String
favicon_content_type	String
favicon_file_size	Integer
favicon_updated_at	Timestamp
custom_domain	String
enable_analytics_reporting	Boolean
comments_count	Integer
whitelabel_build_enabled	Boolean
platform_domain	String
org_id_s	Integer
record_insert_time	String
yr	String
month	String
day	String
hour	String

Roles

(roles_dim_m_v)


id	Integer
name	String
master_role	Boolean
created_at	Timestamp
updated_at	Timestamp
image_url	String
threshold	Integer
default_name	String
org_id_s	Integer
record_insert_time	String
yr	String
month	String
day	String
hour	String

Structured Items

(structured_items_fact_m_v)

Name	Type	Description
id	Integer
structure_id	Integer
entity_id	Integer
entity_type	String
enabled	Boolean
created_at	Timestamp
updated_at	Timestamp
position	Integer
org_id_s	Integer
record_insert_time	String
yr	String
month	String
day	String
hour	String

Structures

(structures_dim_m_v)

Name	Type	Description
id	Integer
creator_id	Integer
parent_id	Integer
parent_type	String
display_name	String
context	Integer
slug	String
enabled	Boolean
created_at	Timestamp
updated_at	Timestamp
org_id_s	Integer
record_insert_time	String
yr	String
month	String
day	String
hour	String

Team Assignments

(team_assignments_fact_m_v)


id	Integer
assignment_id	Integer
team_id	Integer
created_at	Timestamp
updated_at	Timestamp
assignor_id	Integer
message	String
org_id_s	Integer
record_insert_time	String
yr	String
month	String
day	String
hour	String

Teams

(teams_dim_m_v)

Name	Type	Description
id	Integer
name	String
description	String
slug	String
image_file_name	String
image_content_type	String
image_file_size	Integer
image_updated_at	Timestamp
created_at	Timestamp
updated_at	Timestamp
is_everyone_team	Boolean
comments_count	Integer
auto_assign_content	Boolean
source_ids	String
is_private	Boolean
is_dynamic	Boolean
is_mandatory	Boolean
domains	String
only_admin_can_post	Boolean
org_id_s	Integer
record_insert_time	String
yr	String
month	String
day	String
hour	String

Teams Users

(teams_users_fact_m_v)

Name	Type	Description
id	Integer
team_id	Integer
user_id	Integer
as_type	String
created_at	Timestamp
updated_at	Timestamp
org_id_s	Integer
record_insert_time	String
yr	String
month	String
day	String
hour	String

User profiles

(user_profiles_fact_m_v)


id	Integer
user_id	Integer
expert_topics	String
learning_topics	String
created_at	Timestamp
updated_at	Timestamp
hr_job_role_id	Integer
hr_organization_id	Integer
hr_location_id	Integer
hr_competency_id	Integer
hr_domain_id	Integer
time_zone	String
onboarding_options	String
language	String
tac_accepted	Boolean
job_title	String
dashboard_info	String
company	String
job_role	String
org_id_s	Integer
record_insert_time	String
dob	Timestamp
tac_accepted_at	Timestamp
gender	Integer
mobile_number	String
work_country	String
domain	String
mobile_verified	Boolean
occupation_id	Integer
occupation_name	String
occupation_category	Integer
yr	String
month	String
day	String
hour	String

Users

(users_dim_m_v)


id	Integer
email	String
first_name	String
last_name	String
created_at	Timestamp
updated_at	Timestamp
sign_in_count	Integer
current_sign_in_at	Timestamp
last_sign_in_at	Timestamp
current_sign_in_ip	String
last_sign_in_ip	String
avatar_file_name	String
avatar_content_type	String
avatar_file_size	Integer
avatar_updated_at	Timestamp
location_id	Integer
confirmed_at	Timestamp
confirmation_sent_at	Timestamp
unconfirmed_email	String
handle	String
is_brand	Boolean
bio	String
coverimage_file_name	String
coverimage_content_type	String
coverimage_file_size	Integer
coverimage_updated_at	Timestamp
password_reset_required	Boolean
is_complete	Boolean
configs	String
organization_role	String
parent_user_id	Integer
job_role_id	Integer
time_in_role	String
is_active	Boolean
showcase	Boolean
is_suspended	Boolean
is_edcast_admin	Boolean
failed_attempts	Integer
locked_at	Timestamp
federated_identifier	String
status	String
exclude_from_leaderboard	Boolean
default_team_id	Integer
data_export_status	Integer
last_data_export_time	Timestamp
is_anonymized	Boolean
invitation_accepted	Boolean
hide_from_leaderboard	Boolean
sign_out_at	Timestamp
welcome_token	String
deleted_at	Timestamp
org_id_s	Integer
record_insert_time	String
yr	String
month	String
day	String
hour	String

Card Pack Relations

(card_pack_relations_dim_m_v)

Name	Type	Description
pathway_id	Integer
card_id	Integer
card_title	String
card_type	String
card_state	String
smart_title	String
pathway_title	String
updated_at	Timestamp
org_id_s	Integer
record_insert_time	String
yr	String
month	String
day	String
hour	String

Journey Pack Relations

(journey_pack_relations_dim_m_v)

Name	Type	Description
journey_id	Integer
card_id	Integer
card_type	String
card_state	String
smart_title	String
journey_title	String
updated_at	Timestamp
org_id_s	Integer
record_insert_time	String
yr	String
month	String
day	String
hour	String

Channels cards

(channels_cards_dim_m_v)

Name	Type	Description
card_id	Integer
card_title	String
card_state	String
ecl_source_name	String
channel_id	Integer
channel_name	String
card_type	String
card_subtype	String
slug	String
created_at	Timestamp
object_id	Integer
updated_at	Timestamp
org_id_s	Integer
record_insert_time	String
yr	String
month	String
day	String
hour	String

User Content completions

(user_content_completions_dim_m_v)

Name	Type	Description
user_id	Integer
completable_id	Integer	same as card_id
completed_at	Timestamp
completed_percentage	Integer
updated_at	Timestamp
org_id_s	Integer
record_insert_time	String
yr	String
month	String
day	String
hour	String
state	String	Possible Values - started, completed, initialized
duration	Integer

Group assignments performance

(group_assignments_performance_i_v)

Name	Type	Description
card_id	Integer
card_author_id	Integer
title	String
card_message	String
card_source_name	String
duration	String
card_type	String
card_level	String
card_author_full_name	String
assignor_name	String
assignor_id	Integer
group_id	Integer
team_name	String
assigned_user_id	Integer
assigned_user_full_name	String
assigned_user_handle	String
assignor_handle	String
assignment_state	String
record_insert_time	String
time_assignment_started	Timestamp
time_completed	Timestamp
assignment_due_date	Timestamp
time_assignment_created	Timestamp
time_assigned	Timestamp
yr	String
month	String
day	String
hour	String

User assignments performance

(user_assignments_performance_i_v)

Name	Type	Description
card_id	Integer
card_author_id	Integer
title	String
card_message	String
card_source_name	String
duration	String
card_type	String
card_level	String
card_author_name	String
assignor_name	String
assignor_id	Integer
assigned_user_id	Integer
assigned_user_full_name	String
assigned_user_handle	String
assignor_handle	String
assignment_state	String
record_insert_time	String
time_assignment_started	Timestamp
time_completed	Timestamp
assignment_due_date	Timestamp
time_assignment_created	Timestamp
time_assigned	Timestamp
yr	String
month	String
day	String
hour	String

User custom fields

(user_custom_fields_dim_m_v)

Name	Type	Description
id	Integer
user_id	Integer
custom_field_id	Integer
value	String
display_name	String
abbreviation	String
enable_people_search	Boolean
created_at	Timestamp
updated_at	Timestamp
org_id_s	Integer
record_insert_time	String
yr	String
month	String
day	String
hour	String

User onboardings

(user_onboardings_dim_m_v)

Name	Type	Description
id	Integer
user_id	Integer
current_step	Integer
status	String
completed_at	Timestamp
created_at	Timestamp
updated_at	Timestamp
org_id_s	Integer
record_insert_time	String
yr	String
month	String
day	String
hour	String

Profiles

(profiles_dim_m_v)

Name	Type	Description
id	Integer
user_id	Integer
external_id	String
uid	String
created_at	Timestamp
updated_at	Timestamp
org_id_s	Integer
record_insert_time	String
yr	String
month	String
day	String
hour	String

Card reportings

(card_reportings_dim_m_v)

Name	Type	Description
id	Integer
card_id	Integer
user_id	Integer
reason	String
deleted_at	Timestamp
created_at	Timestamp
updated_at	Timestamp
status	String
org_id_s	Integer
record_insert_time	String
yr	String
month	String
day	String
hour	String

Skills Users

(skills_users_dim_m_v)

Name	Type	Description
id	Integer
user_id	Integer
skill_id	Integer
description	String
credential	String
created_at	Timestamp
updated_at	Timestamp
experience	String
skill_level	String
credential_name	String
credential_url	String
expiry_date	Timestamp
issue_date	Timestamp
issuer	String
skills	String
credential_id	String
credential_type	String
verified	Boolean
score	Integer
skills_detail_id	Integer
global_user_id	Integer
card_id	Integer
skill_name	String
taxonomy_details	String
org_id_s	Integer
record_insert_time	String
yr	String
month	String
day	String
hour	String

User Roles

(user_roles_dim_m_v)

Name	Type	Description
id	Integer
user_id	Integer
role_id	Integer
created_at	Timestamp
updated_at	Timestamp
deleted_at	Timestamp
org_id_s	Integer
record_insert_time	String
yr	String
month	String
day	String
hour	String

Card Languages

(card_languages_dim_m_v)

Name	Type	Description
id	Integer
card_id	Integer
resource_id	Integer
title	String
message	String
language	String
custom_data	String
deleted_at	Timestamp
created_at	Timestamp
updated_at	Timestamp
media	String
state	String
org_id_s	Integer
record_insert_time	String
yr	String
month	String
day	String
hour	String

Card Relations

(card_relations_dim_m_v)

Name	Type	Description
id	Integer
card_id	Integer
root_id	Integer
parent_id	Integer
name	String
created_at	Timestamp
updated_at	Timestamp
user_id	Integer
state	String
version_type	String
change_log	String
org_id_s	Integer
record_insert_time	String
yr	String
month	String
day	String
hour	String

Badgings

(badgings_dim_m_v)

Name	Type	Description
id	Integer
badge_title	String
badgeable_card_id	Integer
badge_id	Integer
badge_type	String
target_steps	Integer
all_quizzes_answered	String
time_badge_created	Timestamp
time_badge_last_updated	Timestamp
org_id_s	Integer
record_insert_time	String
yr	String
month	String
day	String
hour	String