Module Navigation

Data Sources for Designing Reports for LMS Advanced Analytics

  Upcoming Update

This article contains information for an upcoming release and is subject to change.

Use the following search box to search and filter the table below. When searching with multiple words, it will search for the exact combination of words (e.g. Searching for "Every Employee" will not filter results using "Every" and/or "Employee", but will only show results with "Every Employee" exactly.

User Every employee and their information
  • Employee ID
  • Name
  • Job Title
  • Hire Date
  • Active
  • Department
  • Location
Joins to other tables on AcroroUserId
UserCertification Every employee and most of their information as well as any certifications they have taken.
  • Employee ID
  • Name
  • Job Title
  • Hire Date
  • Active
  • Department
  • Location
  • Certification Name
  • Certification Start Date
  • Certification End Date
Joins to other tables on AcroroUserId
UserLearningPlan

Every employee and most of their information as well as any Learning Plans they have taken or been assigned to.

This table combines User, User Learning Plan, Learning Plan Task, and Learning Plan

  • Employee ID
  • Name
  • Job Title
  • Hire Date
  • Active
  • Department
  • Location
  • Learning Plan Title
  • Learning Plan Task Title
  • Days To Complete
  • Completed Date
  • Learning Plan Status
  • Task Status
Joins to other tables on AcroroUserId
UserTranscript

Every employee and most of their information as well as any classess they have taken.

This table combines User, and Transcript

  • Employee ID
  • Name
  • Job Title
  • Hire Date
  • Active
  • Department
  • Location
  • Course Title
  • Class Start Date
  • Class End Date
  • Completion Status
  • Completion Date
  • Grade
Joins to other tables on AcroroUserId
Transcript Record of all classes taken by employees
  • Course Title
  • Class Start Date
  • Class End Date
  • Completion Status
  • Completion Date
  • Grade
Joins to other tables on AcroroUserId
TranscriptLastCompeleted The last completed date for each employee for each class
  • Course Title
  • Last Completed Date
  • Name
Joins to other tables on AcroroUserId
Course All available courses and related details
  • Title
  • TrainingType
  • Description
  • Cost
  • Ceu
  • ReviewFrequency
  • Categories
  • Instructors
Joins to CourseTranscript on Title
CourseTranscript Every course enrollment with the student that enrolled.
For most reports that pull class information you will probably use Transcript or UserTranscript; this table would be used to see which courses have not been taken.
  • Title
  • TrainingType
  • Description
  • Cost
  • Ceu
  • ReviewFrequency
  • Categories
  • Instructors
  • ArcoroUserId

Joins to Course on Title

Joins to other tables on AcroroUserId

LearningPlan Every learning plan
  • Learning Plan Title
  • Active
  • ModifiedDate
Joins to LearningPlanTask on LearningPlanId
LearningPlanTask Every learning plan task
  • Learning Plan Task Title
  • Days To Complete
  • Type

Joins to LearningPlan on LearningPlanId

Joins to UserLearningPlanTask on LearningPlanTaskId

UserLearningPlanTask Employees and learning plan tasks they are assinged to whether completed or not.
  • Assigned Date
  • Task Status
  • Learning Plan Status
  • Completed Date

Joins to LearningPlanTask on LearningPlanTaskId

Joins to other tables on AcroroUserId

Company Contains company name and unique Arcoro Id
There shouldn't be any need to use this table
  • Arcoro Tenant Id
  • Name
You will not need to join to this table
Was this article helpful?
0 out of 0 found this helpful