Learning Modules Analytics Schema v1

Overview

The Learning Modules Analytics bundle contains an organized collection of education content items with a specific focus.

Character Separated Values (CSV) Properties

Property	Value
Header Record	Yes
Field Delimiter	Comma
Record Delimiter	CR/LF
Character Encoding	UTF-8

Files

File Name	Description
Consumer_Engagement_F_LM_Learning_Modules	This table contains information about a learning module, which is an organized collection of education content items.
Consumer_Engagement_F_LM_Module_Usages	This table contains information to track the user enrollments and completion of learning modules.
Consumer_Engagement_F_LM_Learning_Module_Translations	This table contains information about all the translations present for a learning module.
Consumer_Engagement_F_LM_Module_Task_Usages	This table contains information to track the user enrollments and completion of learning module tasks.
Consumer_Engagement_F_LM_Categories	This table contains information about focus areas into which learning modules can be categorized.
Consumer_Engagement_F_LM_Category_Translations	This table contains information about all the translations present for a learning module category.
Consumer_Engagement_F_LM_Tasks	This table contains information about education items in a learning module.
Consumer_Engagement_F_LM_Task_Translations	This table contains information about all the translations into which a learning module task can be translated.
Consumer_Engagement_F_LM_Module_Categories	This table contains information about groups of learning modules organized into logical focus areas, for example, learning modules related to physical fitness or nutrition.
Consumer_Engagement_F_LM_Consumer_Groups	This table contains information about all the users who have access to a learning module based on the group to which they belong.

Field Definitions

Consumer_Engagement_F_LM_Learning_Modules

Field	Definition	Data Type
learning_module_id	The ID of the learning module.	VARCHAR(36)
tenant_id	The ID of the tenant.	VARCHAR(36)
definition_id	An optional ID for a tenant to uniquely identify a learning module.	VARCHAR(36)
display_name	The title of the learning module for a given locale.	VARCHAR(255)
learning_module_description	The description of the learning module.	VARCHAR(65000)
learning_module_status	The status (DRAFT, PUBLISHED, or RETIRED) of the learning module.	INTEGER
thumbnail_url	An image URL for a wellness learning module.	VARCHAR(255)
keywords	A list of keywords related to the learning module that help in search criteria.	VARCHAR(65000)
create_dt_tm	The date and time when the learning module was created.	TIMESTAMPTZ
update_dt_tm	The date and time when the learning module was last updated.	TIMESTAMPTZ

Consumer_Engagement_F_LM_Module_Usages

Field	Definition	Data Type
module_usage_id	The ID of the learning module usage.	VARCHAR(36)
tenant_id	The ID of the tenant.	VARCHAR(36)
consumer_id	The ID of the consumer.	VARCHAR(36)
learning_module_id	The ID of the learning module content.	VARCHAR(36)
module_usage_status	The current status that states the usage of the learning module (NOT_STARTED, IN_PROGRESS, COMPLETED, or UNENROLLED) by the consumer.	INTEGER
status_updated_at	The date and time when the learning module usage status was last updated.	TIMESTAMPTZ
create_dt_tm	The date and time when the learning module was created.	TIMESTAMPTZ
update_dt_tm	The date and time when the learning module was last updated.	TIMESTAMPTZ

Consumer_Engagement_F_LM_Learning_Module_Translations

Field	Definition	Data Type
learning_module_translation_id	The ID of the learning module translation.	VARCHAR(36)
learning_module_id	The ID of the learning module.	VARCHAR(36)
locale	The locale of the learning module.	VARCHAR(255)
learning_module_translation_display_name	The learning module display name.	VARCHAR(255)
learning_module_translation_description	The description of the learning module content.	VARCHAR(65000)
learning_module_translation_keywords	A list of keywords related to the learning module that help in search criteria.	VARCHAR(65000)
create_dt_tm	The date and time when the learning module translation was created.	TIMESTAMPTZ
update_dt_tm	The date and time when the learning module translation was last updated.	TIMESTAMPTZ

Consumer_Engagement_F_LM_Module_Task_Usages

Field	Definition	Data Type
module_task_usage_id	The ID of the learning module task usage.	VARCHAR(36)
tenant_id	The ID of the tenant.	VARCHAR(36)
consumer_id	The ID of the consumer.	VARCHAR(36)
module_usage_id	The ID of the learning module usage.	VARCHAR(36)
task_id	The ID of the learning module task.	VARCHAR(36)
status	The current status that states the usage of the learning module task by the consumer.	INTEGER
order	The order of the learning module task usage.	INTEGER
consumer_source_id	The ID of the event that satisfied the learning module task.	VARCHAR(36)
create_dt_tm	The date and time when the learning module task usage was created.	TIMESTAMPTZ
update_dt_tm	The date and time when the learning module task usage was last updated.	TIMESTAMPTZ

Consumer_Engagement_F_LM_Categories

Field	Definition	Data Type
category_id	The ID of the learning module category.	VARCHAR(36)
tenant_id	The ID of the tenant.	VARCHAR(36)
external_id	The ID of an external reference of the learning module category in a source system if applicable, for example, the SNOMED code.	VARCHAR(191)
create_dt_tm	The date and time when the learning module category was created.	TIMESTAMPTZ
update_dt_tm	The date and time when the learning module category was last updated.	TIMESTAMPTZ

Consumer_Engagement_F_LM_Category_Translations

Field	Definition	Data Type
category_translation_id	The ID of the learning module category translation.	VARCHAR(36)
category_id	The ID of the learning module category.	VARCHAR(36)
locale	The locale of the learning module category.	VARCHAR(36)
title	A list of titles for the locales.	VARCHAR(191)
create_dt_tm	The date and time when the learning module category translation was created.	TIMESTAMPTZ
update_dt_tm	The date and time when the learning module category translation was last updated.	TIMESTAMPTZ

Consumer_Engagement_F_LM_Tasks

Field	Definition	Data Type
task_id	The ID of a learning module task.	VARCHAR(36)
learning_module_id	The ID of the learning module to which the task belongs.	VARCHAR(36)
tenant_id	The ID of the tenant.	VARCHAR(36)
external_id	The ID of entity that needs to be completed to satisfy a learning module task.	VARCHAR(191)
task_type	The type of a learning module task.	VARCHAR(191)
order	The order of the learning module task in a learning module to be accomplished.	INTEGER
pace_by_week	The number of weeks that must pass after enrolling in a learning module before the task can be completed by the consumer.	INTGER
create_dt_tm	The date and time when the learning module task was created.	TIMESTAMPTZ
update_dt_tm	The date and time when the learning module task was last updated.	TIMESTAMPTZ

Consumer_Engagement_F_LM_Task_Translations

Field	Definition	Data Type
task_translation_id	The ID of the task translation.	VARCHAR(36)
task_id	The ID of the learning module task to be translated.	VARCHAR(36)
locale	The locale of the learning module task.	VARCHAR(36)
display_name	The learning module task name.	VARCHAR(191)
description	The learning module task description.	LONG VARCHAR
create_dt_tm	The date and time when the learning module task translation was created.	TIMESTAMPTZ
update_dt_tm	The date and time when the learning module task translation was last updated.	TIMESTAMPTZ

Consumer_Engagement_F_LM_Module_Categories

Field	Definition	Data Type
module_category_id	The ID of the learning module category.	BIGINT
learning_module_id	The ID of the learning module.	VARCHAR(36)
category_id	The ID of the learning module category.	VARCHAR(36)
create_dt_tm	The date and time when the learning module category was created.	TIMESTAMPTZ
update_dt_tm	The date and time when the learning module category was last updated.	TIMESTAMPTZ

Consumer_Engagement_F_LM_Consumer_Groups

Field	Definition	Data Type
consumer_group_pk_id	The ID of the learning module consumer group.	VARCHAR(36)
consumer_group_id	The ID of the consumer group for which the learning module (education) content is created.	VARCHAR(36)
learning_module_id	The ID of the learning module.	VARCHAR(36)
create_dt_tm	The date and time when the learning module consumer group was created.	TIMESTAMPTZ
update_dt_tm	The date and time when the learning module consumer group was last updated.	TIMESTAMPTZ