ποΈ Advanced Analytics: Data Schema
Here you can find all the data points currently available in our BI tool. You can use these data points to create your own insights and reports.
- 1 People
- 1.1 users
- 1.2 custom fields
- 1.3 groups
- 1.4 group_users
- 1.5 teams
- 1.6 team_users
- 1.7 locations
- 1.8 managers
- 1.9 coaches
- 2 Content
- 2.1 content
- 2.2 quizzes
- 2.3 quiz_attempts
- 2.4 quiz_attempt_answers
- 2.5 surveys
- 2.6 survey_occurrences
- 2.7 survey_attempts
- 2.8 survey_attempt_answers
- 2.9 event_sessions
- 2.10 enrollments
- 2.11 tags
- 2.12 skills (a.k.a Topics)
- 2.13 skill_categories (a.k.a Topic Categories)
- 2.14 skill_category_skills
- 2.15 content_skills
- 2.16 user_skills
- 3 Activity
- 3.1 activities
- 3.2 completions
- 3.3 starts
- 3.4 views
- 3.5 session_tracks
- 4 Compliance
- 4.1 tasks
- 5 Development
- 5.1 one_to_ones
- 5.2 one_to_one_attempts
- 5.3 one_to_one_attempt_answers
- 5.4 objectives
- 5.5 key_results
Β
We are continuously adding new tables and data points.
Please be aware that Advanced Analytics includes data linked to deactivated users and archived content and events, so remember to filter those out if appropriate.
People
users
The users table contains details of each user within the company, including deactivated, and not yet active users.
Data point name in BI tool | Field name | Data type | Description |
|---|---|---|---|
Id | id | Integer | The unique user identifier |
Sign in count | sign_in_count | Integer | Count of the total number of times the user has logged in all-time |
Current sign in at | current_sign_in_at | Timestamp | Timestamp (UTC) of the userβs most recent log in |
Created at | created_at | Timestamp | Timestamp (UTC) when the user was originally created |
First name | first_name | String | First name of the user. (aka given name) |
Last name | last_name | String | Last name of the user. (aka surname) |
Job title | job_title | String | Job title of the user. (e.g. Marketing Assistant). Can be blank. |
Language | language | String | Primary (selected) language for the user in ISO 653-1 format |
Manager | manager | Boolean | True/false flag to identify whether the user is a manager. Includes both primary team managers and override managers. |
Time zone | time_zone | String | Time zone string for the users selected time zone (if any). |
Id | coach_id | Integer | User id of the userβs coach (if any). |
Is coach | is_coach | Boolean | True/false flag to identify if the user is designated as a coach |
Id | manager_id | Integer | User is of the userβs override manager, or primary team manager if user has no override manager set. |
Secondary manager | secondary_manager | Boolean | True/false flag to identify if the user is the secondary manager of any team. |
Hire date | hire_date | Date | Hire date of the employee. Only set if this data is available from an HR system integration or similar. |
Is override manager | is_override_manager | Boolean | True/false false to identify if the user is designated as the override manager of another user. |
Deactivated at | deactivated_at | Timestamp | Timestamp (UTC) for when the user was deactivated |
Deactivated | deactivated | Boolean | True/false flag it identify whether or not the user have been deactivated. |
System role | system_role | String | System role of the user on Learn Amp. |
Location id | location_id | Integer | ID for the userβs primary location. See id in locations table. |
Tenure in days | tenure_in_days | Integer | Total length of the userβs tenure in days (Today or Leave Date minus their Hire Date, in days). Will be null if Hire Date has not been set. |
Leave date | leave_date | Date | Employment termination / leave date, if available/applicable. |
custom fields
The custom_fields table contains each custom field value for each user.
Data point name in BI tool | Field name | Data type | Description |
|---|---|---|---|
Id | id | Integer | Unique id of the userβs custom field. Can be ignored |
Custom field id | custom_field_id | Integer | ID of custom field. This value will be repeated for each occurrence of this custom field |
Custom field name | name | String | name of the custom field, e.g. βEmployee Numberβ |
Value | value | String | value of the custom field for this particular user, e.g. βABC123β |
groups
The groups table contains basic metadata of all groups. A group is a collection of users, defined by a set of filtering criteria. Users are added to groups automatically by the system, and are refreshed on a regular basis.
Data point name in BI tool | Field name | Data type | Description |
|---|---|---|---|
Id | id | Integer | Unique ID of the group. |
Created at | created_at | Timestamp | Timestamp (UTC) for when the group was first created. |
Group name | name | String | Name of the Group |
group_users
The group_users table is a link table, associating users with groups. This table defines who belongs to which groups.
Data point name in BI tool | Field name | Data type | Description |
|---|---|---|---|
Id | group_id | integer | ID of the group, see id in groups table |
Id | id | Integer | Unique ID of the group_user record. |