Datamart - Data Meanings

Analytics (sometimes referred to as Insights) now has a new data model. This new data model should bring the need for 2 data models (depending on what information you want to display) into 1, which covers both the LXP & xAPI Data Models.

Below is a breakdown of all the information that can be found as standard within the data that can be displayed on a dashboard within Analytics. These are broken down by tables as displayed within Analytics.

Content

Data Table Name	What is it pulling?
All Content	The column is automatically set to 0 for all records
Current Version	Returns a boolean value based on whether the hidden field "end_ts" is equal to'3000-01-0'

Content - Course Tags

Data Table Name	What is it pulling?
Course Tag Description	Description given to tags within the LXP (created at Org level), then tagged at LX level
Course Tag Name	Name given to the tag (created at Org level), then tagged at LX level

Content - Courses

Note: Those highlighted in red will show automatically in Years (E.g. 2022), use the More option to change this to days, months, weeks etc.)

Data Table Name	What is it pulling?
Activity Object	Short version of Game Type (online course)
Activity Type	Longer version of Game Type (Study an online course)
Activity Verb	Descriptive of what the LX is (study or learn)
Comment XP	If the user places a comment, how much XP will they gain
Continuous Professional Development	How much CPD points are attached to the LX
Course Alias	Identifier for the LX (normally the name of the LX in lowercase letters and no spaces)
Course Category	Category that the LX sits within (Formal, Informal or Social)
Course Closing Date	Close date added to the LX settings
Course Creation Date	Date in which the LX was created
Course Deletion Date	Date in which the LX was deleted
Course ID	Identifier given to the LX by the LXP (not visible on the front end)
Course Name	Name given to the LX
Course Start Date	Date given when the LX will start (different from creation date)
Days to Complete	Due after days within the LX settings
Durations (Minutes)	Duration set at LX settings (How long the LX will take to complete)
Expiry Method	Will tell if set up to be a recurrence (no_expiry, completion_date etc)
External Reference	Held in the LX settings (Normally given for content ingestions or Completion Import)
Is Promoted	Tickbox within the LX settings
Language	Language of the LX (not seen on the front end)
Mandatory	Tick box within the LX settings
Provider	Name of the course provider (LinkedIn Learning for example)
Short Description	Provided at LX level
View XP	Once the object has been completed how much XP is awarded. This is at LX level but can be changed at Object Level
Visibility	Public or Secret

Content - Level Groups

Data Table Name	What is it pulling?
Level Group Name	Level Group name (only applicable with the Branching game type)
Level Group Order	The order of the level group names (1,2 etc)
Level Group Type	Indicates either if the group is a a group or a workspace. 1 = Group & 2 = Workspace

Content - Levels

Note: Those highlighted in red will show automatically in Years (E.g. 2022), use the More option to change this to days, months, weeks etc.)

Data Table Name	What is it pulling?
Level Deletion Date	Date in which the level was deleted
Level Description	Description set at the level (Manage content in the LXP)
Level Difficulty	Percentage added to the level/s within the LX
Level ID	ID given to the Level (Typically not visible within the LXP, but can be seen in the LRS)
Level Name	Name given to the level
Level Order	Order in which the levels are ordered within the LX
Level Start Date	Date in which the level started (can be used to prevent people from entering until the date has passed)
Level Target Points	XP that the user must achieve to pass the level
Level Total Points	Total points available within the level

Content - Object Tags

Data Table Name	What is it pulling?
Object Tag Description	Description given to tags within the LXP (created at Org level) then tagged at Object level
Object Tag Name	Name given to the tag (created at Org level) then tagged at Object level

Content - Objects

Note: Those highlighted in red will show automatically in Years (E.g. 2022), use the More option to change this to days, months, weeks etc.)

Data Table Name	What is it pulling?
Comment XP	XP that the user achieves if they comment (can be disabled per LX and changed per LX). May be different from what is set at LX level.
Object Completion Type	Completion type set within the Game Settings (Timed or xAPI)
Object Creation Date	Date in which the object was created
Object Deletion Date	Date in which the object was deleted
Object Description	Description given to the object within the LX.
Object External ID	Held in the Manage Content section (Normally given for content ingestions or Completion Import)
Object ID	ID given to the object. Visible by hovering over the object in the LXP or in the LRS
Object Name	Name given to the Object within the LX
Object Order	Order in which each object is laid out
View Time	If set to Timed, what is the view time
View XP	Once complete, how much XP will the user obtain

Content - Playlists

Data Table Name	What is it pulling?
Mandatory Course	If there are any LX’s within the playlist that are marked as mandatory.
Playlist Description	Description given to the Playlist - Set at Playlist settings.
Playlist Name	Name given to the Playlist - Set at Playlist settings.
Playlist Order	Order in which the Playlist shows on learner’s dashboards - Set at Playlist settings.
Playlist UUID	Unique ID given by the LXP to the Playlist - not typically seen on the front end.
Recommended Course	If there are any recommended courses attached to the Playlist the course will show as true.

Content - Resources

Note: Those highlighted in red will show automatically in Years (E.g. 2022), use the More option to change this to days, months, weeks etc.)

Data Table Name	What is it pulling?
Resource Activity ID	If there are a custom ID set at resource level it would appear here. Think of Rise content for this.
Resource Content
Resource Creation Date	Date the resource was created
Resource Deletion Date	Date the resource was deleted
Resource Description	Description provided at resource level then carries through to Object level.
Resource ID	ID given by the LXP to the Resource
Resource Name	Name given to the Resource
Resource Type	Type of resource, this will appear as numbers. What they mean can be found at the bottom of this page.

Content - Custom Fields

Note: These will be the custom fields added to the Learning Experience Custom Fields within the LXP.

Content - Date Filter

Note: Those highlighted in red will show automatically in Years (E.g. 2022), use the More option to change this to days, months, weeks etc.)

Data Table Name	What is it pulling?
Date	Dates since the LXP was running from
Day	Days of the week
Day Name	Days of the week (in text form)
Month	Month of the year
Weekend?	Tells if the date is a weekend or weekday - can be used to tell how many completions happen on the weekend

Events - Comments

Data Table Name	What is it pulling?
Depth
Number of Comments	Count for the specific scope. Say if you report on "User Name", "Number of Comments", you will get the number of comments by user.
Presence
Private Comment
Score	How many XP does the user get from commenting.
Sentiment	A number (to 2 decimal places) showing how positive or negative the comment was. With a value above 0 being a positive comment and below 0 being a negative comment.
Word Count	How many words does the comment have.

Events - Course Launches

Note: Those highlighted in red will show automatically in Years (E.g. 2022), use the More option to change this to days, months, weeks etc.)

Data Table Name	What is it pulling?
Course Launch Hour	Hours of the day (24 hours)
Course Visit Date	Date of the visit to the course (can be used in conjunction with ‘Number of Course Launches’
Number of Course Launches	Count of how many times the course has been launched

Events - Course Ratings

Data Table Name	What is it pulling?
Is Downvoted	If the LX has received a thumbs down from a learner
Is Upvoted	If the LX has received a thumbs up from a learner
Number of Down Votes	Total amount of thumbs up
Number of Up Votes	Total amount of thumbs down
Rating	Overall rating of the LX (done once an LX is complete).

Events - Enrolments

Note: Those highlighted in red will show automatically in Years (E.g. 2022), use the More option to change this to days, months, weeks etc.)

Data Table Name	What is it pulling?
Completion Note	If manually marked as complete - this will be the note provided (visible in the Enrolments table in the LXP).
Completion Reason	List of reasons given when a user is manually marked as complete.
Compliance - Due Date	When the user who is assigned an LX with a recurrence attached will Expire. Different from due date on the enrolments report within the LX.
Compliance - Expiry Date	When the user who is assigned an LX with a recurrence attached will Expire.
Compliance - Status	Whether the LX is Due, Completed or overdue
Compliance - Status Code	Numerical for the above statues: 1 - Completed, 2 - Due & 3 - Overdue
Days since Completion	Total count of days since the users completion.
Days since Enrolment	Total count of days since the users enrolment.
Days to Complete	Total count of days taken from enrolment to completion.
Enrolment Completion Date	Date in which the Enrolment was complete.
Enrolment Completion Status	Shows if the LX was completed late, completed on time, outstanding or overdue.
Enrolment Creation Date	Date the user was enrolled onto the Learning Experience.
Enrolment Deletion Date	Date the user was un-enrolled from the Learning Experience (If applicable)
Enrolment Due Date	Due date set within the enrolments table within the Learning Experience. Can be set via ‘Due after (days)’ within the LX Settings.
Enrolment Expiration Date	Date in which the users enrolment will expire (no longer have access to the LX). Can be set via Enrolment Length (days) within the LX settings.
Enrolment ID	Unique ID given to each person enrolled onto the LX.
Enrolment Start Date	Date set within the enrolments table within the Learning Experience. This will dynamically change with recurrences & un-enrolment and re-enrolment
Levels Completed	Sum of all total levels completed within the enrolment.
Mandatory	0 or 1 representing if the LX have been marked as mandatory within the LX settings.
Number of Completed Enrolments	Total number of Completed enrolments per user.
Number of Enrolments	Total number of Enrolments per user.
Points	Overall XP obtained within the LX.
Score	Total score obtained within the LX
With Enrolments	Boolean field automatically set to true for all records

Event Level Progress

Note: Those highlighted in red will show automatically in Years (E.g. 2022), use the More option to change this to days, months, weeks etc.)

Data Table Name	What is it pulling?
Level Completion Date	Date in which the level was completed by the user.
Level Start Date	Date in which the level was started by the user.
Points	Total amount of XP obtained from the level

Events - Object Completions

Note: Those highlighted in red will show automatically in Years (E.g. 2022), use the More option to change this to days, months, weeks etc.)

Data Table Name	What is it pulling?
Completion Date	Data in which the object was completed by the user.
Number of Object Completions	Total amount of object completions per user or overall.

Events - Object Launches

Note: Those highlighted in red will show automatically in Years (E.g. 2022), use the More option to change this to days, months, weeks etc.)

Data Table Name	What is it pulling?
Number of Object Launches	Number of times a user has launched the object within an LX.
Object Launch Date	Date in which the user had launched the object.

Events - xAPI

Note: Those highlighted in red will show automatically in Years (E.g. 2022), use the More option to change this to days, months, weeks etc.)

Data Table Name	What is it pulling?
Completion
LRS Store ID	Store within the LRS that the statement is stored within.
Max Score	Max score available (for example within an Assessment).
Raw Score	Score that the user has achieved.
Response	Response provided by the end user to a question given to them.
Response (Numeric)	If the response is numeric.
Scaled Score	Percentage correct (will show as 0.8 for example, but can be put to a percentage in Analytics).
Statement ID	Unique identifier that is given to the statement within the LRS.
Success	If the action has been successful.
Timestamp	Date in which the action was triggered. Remember, this is different from the stored date which is the date in which the statement was stored.

Users

Note: Those highlighted in red will show automatically in Years (E.g. 2022), use the More option to change this to days, months, weeks etc.)

Data Table Name	What is it pulling?
Is Deleted	If the user is deleted within the LXP
Skill Builder User	Is the user attached to Skill’s Builder - typically this would always be Yes.
User Creation Date	Date in which the user was created within the LXP.
User Deletion Date	Date in which the user was deleted within the LXP.
User Email	Email address of the user.
User Expiration Date	Expires at field within the users profile.
User First Name	First name of the user.
User Full Name	User’s first and last name.
User Function	Field within the users profile.
User Language	User Language set within their profile.
User Last Login	Last time the user logged in.
User Last Name	User’s last name.
User Location	Users location set within their profile.
User Org Ref	Field within the users profile.
User SSO ID	User SSO ID held within the users profile - if applicable.
User Seniority	The seniority of the user within their organisation
User Timezone	Timezone of the user set within their profile.
User UUID	ID given to the user from the LXP when created.
Username	Username of the user held within their profile

Users - Custom Fields

Note: These will be the custom fields added to the User Profile Custom Fields within the LXP.

Users - Framework 1

Data Table Name	What is it pulling?
Entity Chained Name	Flow of the hierarchy of where the user sits within the organisation without needing to add seperate fields.
Entity Description	Description provided when an entity is created. * Not typically used so may appear as N\A.
Entity External Reference	Reference provided to the users job within the LXP.
Entity Name	Held within the users job role (Job title typically).

Users - Framework 2

Data Table Name	What is it pulling?
Entity Chained Name	Flow of the hierarchy of where the user sits within the organisation without needing to add seperate fields.
Entity Description	Description provided when an entity is created. * Not typically used so may appear as N\A.
Entity External Reference	Reference provided to the users job within the LXP.
Entity Name	Held within the users job role (Job title typically).

Users - Group Tags

Data Table Name	What is it pulling?
Group Tag Description	Description given to the Tag.
Group Tag Name	Tag attached at group level.

Users - Hierarchy

Data Table Name	What is it pulling?
All Users	Column automatically set to 0 for all records
Current Version	Returns a boolean value based on whether the hidden field "end_ts" is equal to'3000-01-0'

Users - Manager

Data Table Name	What is it pulling?
Manager Email	The email address of the user's manager.
Manager First Name	First name of the users manager.
Manager Full Name	Managers full name.
Manager Function	Held within the Manager’s profile.
Manager Last Name	Managers last name.
Manager Location	Managers location held in their profile.
Manager SSO ID	Managers SSO ID held in their profile.
Manager Username	Managers username held in their profile

Users - Organisation

Data Table Name	What is it pulling?
Organisation Language	The default language is set at the Org Level (Held at Settings > Edit Organisation).
Organisation Name	Name given to the LXP site (Held at Settings > Edit Organisation).

Users - Primary Positions

Note: Those highlighted in red will show automatically in Years (E.g. 2022), use the More option to change this to days, months, weeks etc.)

Data Table Name	What is it pulling?
Position Description	Description given to the users Primary Job Role.
Position End Date	End date added to the users Primary Job Role.
Position External ID	Role ID added to the user Primary Job Role.
Position Start Date	Start Date added to the users Primary Job Role.
Title	Typically job title added to the users Primary Job Role.

Users - User Groups

Data Table Name	What is it pulling?
User Group Description	Description given to the Group.
User Group External ID	External ID given to the group (set at Group settings).
User Group ID	ID given by the LXP to the group (Can be seen in the URL when within the group).
User Group Name	Name given to the group.

User - User Types

Data Table Name	What is it pulling?
User Tag Description	Description given to the Tag.
User Tag Name	Tag attached at user level.

xAPI - Activities

Data Table Name	What is it pulling?
Activity Description	If there is a question being asked of the user.
Activity ID	ID provided to the activity (Resource, Level or Object ID for example).
Activity Name	Name given to the activity (Assessment Question for example).
Activity Number	Numeric value detected in the Activity Name. Say if an activity name is "Question 18", it will be 18.
Activity Type	This indicates the type of activity (course, question, interaction etc) For example - http://adlnet.gov/expapi/activities/course
Interaction Type	Type of interaction undertaken within the course (Choice, Fill-In or Matching for example)

xAPI - Verbs

Data Table Name	What is it pulling?
Verb ID	ID provided to the verb within the LRS
Verb Name	Verb that has been triggered from the host platform (Joined, Left, Completed & Passed)