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.
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)
LXP Courses:
| Data Table Name | What is being pulled from the LRS |
| Course alias | Alias given to the course within the LX settings |
| Course Close at | The date added to the close date under the LX settings |
| Course ID | The ID that the LXP database gives the LX (Not visible on the front end) |
| Course Name | The name given to the LX |
| Course Name En | English name of the course if mlang tags are in use |
| Course start at | The date added to the start date under the LX settings |
| Course Type | A unique number is given to the Resource. View the IDs and what they stand for here |
LXP Levels:
| Data Table Name | What is being pulled from the LRS |
| Level Course ID | The ID that the LXP database gives the LX (Not visible on the front end) |
| Level ID | ID provided for the level. This can be seen in the URL when launching the level. |
| Level Name | Name given to the level within the LX |
| Level Name En | English name of the level if mlang tags are in use |
| Level Ordering | The order in which each level is in. This will work with the level name |
LXP Objects:
| Data Table Name | What is being pulled from the LRS |
| Activity ID | ID given to the activity within the LXP |
| Object ID | The ID given to the object - Visible on the URL when viewing the object, or when you hover over the pencil icon when editing the content. |
| Object Level ID | The ID of the level that the object is within. This can be found by hovering over the pencil icon for the level within manage content |
| Object Name | The name given to the Object within the LX |
| Object Ordering | The order in which each object is in. This will work with the level name |
| Object Type | A unique number is given to the Resource. View the ID’s and what they stand for here |
| Resource ID | ID given to the resource within the LXP database |
| Resource Name | Name given to the resource in the resources tab in the LXP |
LXP Resources:
| Data Table Name | What is being pulled from the LRS |
| Resource ID | ID given to the resource within the LXP database |
| Resource Name | Name given to the resource in the resources tab in the LXP |
| Resource Type | A unique number given to the Resource. |
LXP Users:
| Data Table Name | What is being pulled from the LRS |
| Agent Mbox | The user's email address that is held on their profile (Prefix of Mailto:) |
| User Account | The user's email address that is held on their profile (May differ per site) |
| User created at | The date that the user was created |
| User Deleted at | The date that the user was deleted |
| User Email | The user's email address that is held on their profile |
| User First name | The user's first name held on their profile |
| User function | Linked to the function column on the user profile (not commonly used) |
| User ID | The ID that the LXP database gives the user, visible on the URL when viewing the user profile (the number at the end) |
| User language | Language set within the user profile |
| User last login at | The last time the user logged into the site at |
| User last name | The user's last name held on their profile |
| User location | The location that the user has on their profile (this is not visible on the admin view of the user's profile) |
xAPI Interaction Components (All):
| Data Table Name | What is being pulled from the LRS |
| Activity ID |
This pulls in the activity ID of the component that has been completed. This is found under “activities” in the LRS Example - https://yoursite.streamlxp.com/xapi/activity/ resource/76130#/id/63cfd73d968fa974c0f86474 |
| Component Description |
If it were to be a multiple-choice question in an Adapt module, this would be the option chosen. E.g. |
| Component ID |
This is the choice ID within the module. So example can be seen above. The ID for Medicinal claim is 1. |
| Component Type |
This is the type of component so if it is a multiple choice question, the type would be choice. |
| Correct |
Whether the answer the user provided is correct (true) or incorrect (false) |
| Organisation ID |
Your Learning Locker ID |
xAPI Activities:
| Data Table Name | What is being pulled from the LRS |
| Activity Description | The description given to the level. Can be found under the manage content section in the LX |
| Activity ID |
This is the ID of the activity (Example being a linear LX and you click into the level, ID can be found in the URL) E.g. https://yoursite.streamlxp.com/courses/ coursealias/learn#level/66759 |
| Activity Name | This is the activity name (Can be the level, object & LX name) |
| Activity Type | This is the type of which activity, example being Learning experience, level or lesson) |
| Interaction Type | N/A |
| Is XAPI Object | Shows if the content is XAPI or not |
| Organisation ID | Your Learning Locker ID |
xAPI Activities (Object):
| Data Table Name | What is being pulled from the LRS |
| Activity Description | This can be a question being asked to the user through an Adapt module. Can be found in the XAPI statement under object. |
| Activity ID |
This pulls in the activity ID of the component that has been completed. This is found under “activities” in the LRS - Example - https://yoursite.streamlxp.com/xapi/activity/ resource/76130#/id/63cfd73d968fa974c0f86479 |
| Activity Name |
This is the activity name (Can be the level, object & LX name) |
| Activity Number |
Number extracted from the activity name (can be used to order questions) |
| Activity Type |
This is the type of component so if it is a multiple-choice question, the type would be choice. E.g. http://adlnet.gov/expapi/activities/question |
| Interaction Type |
For activities allowing an interaction, the type of interaction (e.g. fill-in for text boxes, choice for multiple choice questions, etc… ) |
| Is XAPI Object |
Shows if the content is used as an object or a context activity only |
| Organisation ID |
Your Learning Locker ID |
xAPI Actors:
| Data Table Name | What is being pulled from the LRS |
| Actor account |
This is what is appended to the XAPI statement. It could either be an email address or a user account. If it is a user account, it will display like f3693a5d-85a5-473f-adc8-9dca228f3c26 This is found in the XAPI statement under actor - f3693a5d-85a5-473f-adc8-9dca228f3c26 |
| Actor email | This will depend on how the XAPI service is set up on the LXP. If Actor Type and Name is set to Email then the email will appear here. If it is not used then it will be blank. |
| Actor hk | Internal unique identifier for an actor |
| Actor homepage | This is the URL of the LXP site |
| Actor identifier | This is the actor account appended to the start of the actor homepage |
| Organisation ID | Your Learning Locker ID |
| Persona ID |
This is found within the statement, a unique identifier to show the persona of the user on the LXP. This is found under Person in the statement - "person": { |
xAPI Context Activities:
| Data Table Name | What is being pulled from the LRS |
| Activity ID | This is all activities within the LXP grouped together, so it can be level, object, resource and the LXP itself. Example - https://yoursite.streamlxp.com/courses/ coursealias/learn#level/66759 |
| Activity Type | This is the type of activity so example being learning-experience-type, article or level. |
| Context Type | One example of this is grouping, this would apply for say an article and level within an LX so therefore they are grouped together. |
xAPI Interaction Components:
| Data Table Name | What is being pulled from the LRS |
| Activity ID |
This will be the activity ID within the XAPI statement. |
| Component Description |
This is like the options that the user is presented in order to select. These are shown within the XAPI statement under object. Example: { |
| Component ID |
These are the ID’s of the choices within the descriptions, an example can be seen above with the “id”. |
| Component Number |
N/A |
| Component Type |
This is the type of component, so the type would be a choice if it is a multiple-choice question. |
| Correct |
Indicates if this choice is part of the correct answer |
| Organisations ID |
Your Learning Locker ID |
xAPI Personas:
| Data Table Name | What is being pulled from the LRS |
| Organisation ID | Your Learning Locker ID |
| Persona ID |
This is found within the statement, a unique identifier to show the persona of the user on the LXP. This is found under Person in the statement - "person": { |
| Persona Name |
This will be the user's full name (as per what is set in the LXP) |
xAPI Statement Choices:
| Data Table Name | What is being pulled from the LRS |
| Activity ID | This will be the activity ID within the XAPI statement. |
| Component ID |
These are the ID’s of the choices within the description in the XAPI statement. Commonly used when looking for responses to multi-choice questions. |
| Organisation ID |
Your Learning Locker ID |
| Statement ID |
This is the ID given to the statement for the XAPI statement. This can be found under “id”. Example - "timestamp": "2023-08-11T13:51:28.987Z", |
xAPI Statements:
| Data Table Name | What is being pulled from the LRS |
| Activity ID |
This will be the activity ID within the XAPI statement. This can be found under activities, example: "activities": [ |
| Activity Type |
This is the type of activity so example being learning-experience-type, article or level. |
| Actor HK |
N/A |
| Completion |
Indication if the reports back a completion to the LRS. N/A may show for aspects that do not require a completion. True for complete False for incomplete |
| Is Badge |
If a badge was awarded upon completion |
| Is course completion |
1 = Complete 0 = Incomplete |
| Is enrolment |
Looks for enrolments so therefore the verb Joined |
| Is launch |
Looks for level completion |
| Is login |
Looks for logins so therefore the verb logged into |
| Is object activity |
1 = Is Object Activity 0 = Is not object activity |
| Is object completion |
1 = Is Object completion 0 = Is not object completion |
| LXP Award Class ID |
N/A |
| LXP Course ID |
The ID that the LXP database gives the LX |
| LXP Level ID |
The ID that the LXP database gives the level |
| LXP Resource ID |
The ID that the LXP database gives the resource |
| Max Score |
N/A |
| Multi Objects |
If there are multiple objects within the LX |
| Organisation ID |
Your Learning Locker ID |
| Persona ID |
This is found within the statement, a unique identifier to show the persona of the user on the LXP. This is found under Person in the statement |
| Raw Score |
This is the score that a user may have achieved in an Assessment within an Adapt module. This can be found in the XAPI statement. Example - "raw": 8, |
| Registration |
This is code within the statement, normally does not mean anything |
| Response |
The response is what the user has either entered or chosen. This is good if you want to find out what a user has chosen as an answer to the question. |
| Response Int |
This is code within the statement, normally does not mean anything |
| Scaled Score |
This is almost like a percentage-based score from an assessment. Example - "scaled": 0.8 |
| Statement ID |
This is the ID given to the statement for the XAPI statement. This can be found under “id”. Example - "timestamp": "2023-08-11T13:51:28.987Z", |
| Statement Rank |
N/A |
| Store ID |
This is the store within the LRS that the statement has been sent to. This comes into play if there are multiple stores on the instance. |
| Success |
If this was successful in sending |
| Timestamp |
Date in which the statement was placed into the LRS (Can be different from stored) |
| Verb ID |
This is exactly what is on the “Did” section within Learning Locker. Example being joined, completed, passed and opened. This is prefixed with http://adlnet.gov/expapi/verbs/ |
xAPI Verbs:
| Data Table Name | What is being pulled from the LRS |
| Organisation ID |
Your Learning Locker ID |
| Verb Name | This is exactly what is on the “Did” section within Learning Locker. Example being joined, completed, passed and opened |