Skip to main content

Data Dictionary

Employee Learning Cloud: Understand what each field represents within the Report Builder's different reports

PM team avatar
Written by PM team
Updated over 2 weeks ago

The below tables outline the fields throughout the Trainings, Guide Submissions (New), Libraries and Users reports within the Report Builder. Each field is eligible as a Column & Filter.

For more information the Report Builder see Creating Your First Report

Trainings Report

Field

Category

Type

Description

Date: Last Active

User

Date

The date of the Learner’s last login date to the platform

Email

User

Input

The Learner’s e-mail address

Groups

User

Input

The Group(s) that the Learner belongs to. This field can include multiple results separated by a comma

Is Deactivated

User

Boolean

Whether or not the Learner is Deactivated (yes = deactivated)

Manager Email

User

Input

The Learner’s Manager’s Email. This field can include multiple results separated by a comma

Manager Name

User

Input

The Learner’s Manager’s Name. This field can include multiple results separated by a comma

Name

User

Input

The Learner’s full name

Name: First

User

Input

The Learner’s first name. Specifically the first name in their name field.

Name: Last

User

Input

The Learner’s last name

Roles

User

Input

The Learner’s role within the WorkRamp platform, signaling Admin, Editor, Manager, and/or Learner. This field can include multiple results separated by a comma

Sessions

User

Count

The number of total sessions, or logins to the platform, for a Learner to date

(Custom)

Custom User Attributes

Variable

All Custom User Attributes that exist in your account will appear within the Custom User Attribute subsection

Author Email

Content

Input

The original content creator’s email

Author Name

Content

Input

The original content creator’s name

Badge Awarded

Content

Input

The badge awarded on completion of the content

Challenge: Fully Graded

Content

Boolean

Whether or not a Challenge is Fully Graded. This field is for Challenges only.

Challenge: Learner Submitted

Content

Boolean

Whether or not the Learner has fully submitted. This field is for Challenges only.

Challenge: Submitted Reviews

Content

Count

A count of the number of Reviewers that have submitted so far. This field is for Challenges only.

Challenge: Total Reviewers

Content

Count

The total number of Reviewers set to review a Learner’s submission. This field is for Challenges only.

Challenge: Type

Content

Select

The type of Challenge that was assigned to the Learner. This field is for Challenges only.

Content Type

Content

Select

The type of Content - Guide, Challenge, SCORM, etc

Date: Assigned

Content

Date

The date the learner was assigned the content

Date: Badge Awarded

Content

Date

The date the learner earned a badge from a Training

Date: Completed

Content

Date

The date the content was completed by the Learner (progress of 100% achieved)

Date: Created

Content

Date

The date the content was created by content creators

Date: Due

Content

Date

The due date associated with the content assignment

Date: First Accessed

Content

Date

The date the Learner first accessed the content

Note: data not tracked prior to 5/20/23

Date: Last Accessed

Content

Date

The date the Learner most recently accessed the content

Note: data not tracked prior to 5/20/23

Date: Last Edited

Content

Date

The date the content was last edited by content creators

Days Overdue

Content

Count

Number of Days overdue, based on the Due Date & the Completed Date

Event: Attendance

Content

Input

The attendance status for a Learner within a particular session. This field is for Events only.

Event: Date Declined

Content

Date

The date the Learner declined an event invite. This field is for Events only.

Event: Date Invited

Content

Date

The date the Learner was invited to an event. This field is for Events only.

Event: Date Registered

Content

Date

The date the Learner was registered for an event. This field is for Events only.

Event: Has Declined

Content

Boolean

Whether or not the Learner has declined the event. This field is for Events only.

Event: Instructor

Content

Input

Event session instructor. This field is for Events only.

Event: Is Invited

Content

Boolean

Whether or not the Learner was invited to an event. This field is for Events only.

Event: Is Registered

Content

Boolean

Whether or not the Learner has registered to an event session. This field is for Events only.

Event: Is Unregistered

Content

Boolean

Whether or not the Learner has unregistered from an event session. This field is for Events only.

Event: Session Date

Content

Date

The date of the session the Learner was invited to. This field is for Events only.

Event: Session Length

Content

Count

The length (in minutes) of the session the Learner was invited to, based on the Start & End Time. This field is for Events only.

Event: Session Title

Content

Input

The title of the session the Learner was invited to. This field is for Events only

Event: Sessions Available

Content

Count

The number of total sessions associated with an event. This field is for Events only

Event: Type

Content

Input

The type of event session - Standard or Series. This field is for Events only

Grade

Content

Count

The grade the Learner received within content

Guide: Average SCORM Score

Content

Count

The score the Learner achieved from a SCORM embedded in a Guide. This field is for Guides only

This field is for a deprecated feature

Guide: Completed Tasks

Content

Count

The number of the tasks the Learner completed for this Guide. This field is for Guides only

Guide: Completed Test Questions

Content

Count

The number of questions the Learner submitted an answer for within the Guide. This field is for Guides only

Guide: Correct Test Questions

Content

Count

The number of questions answered correctly by the Learner. This field is for Guides only

Guide: Is Retaken

Content

Boolean

Whether or not a Guide has been retaken, or submitted answers to questions multiple times. This field is for Guides only

Guide: Rating

Content

Count

The rating the Learner gave the Guide - prompted at completion of the guide. This field is for Guides only

Guide: Retake Count

Content

Count

The number of retakes a Learner took of a Guide. This field is for Guides only

Guide: SCORM Time Spent

Content

Count

The Time Spent within an embedded SCORM in a Guide. This field is for Guides only

Guide: Total Tasks

Content

Count

The number of tasks that existed when the Learner was assigned or enrolled in the Guide. This field is for Guides only

Guide: Total Test Questions

Content

Count

The number of test questions that existed when the Learner was assigned or enrolled in the Guide. This field is for Guides only

Is Archived

Content

Boolean

Whether or not the Learner’s assignment of the content was Archived

Is Badge Awarded

Content

Boolean

Whether or not the Learner was awarded a badge from completing the content

Is Completed

Content

Boolean

Whether or not the assignment/enrollment was completed by the Learner

Is Completed On Time

Content

Boolean

Whether or not the Learner completed the assignment on time, based on the associated assignment Due Date

Is Overdue

Content

Boolean

Whether or not the Learner was late to completing the assignment, based on the associated assignment Due Date

Last Edited By Email

Content

Input

Email of the last editor to make changes on the content

Last Edited By Name

Content

Input

Name of the last editor to make changes on the content

Passed

Content

Boolean

Whether or not the Learner passed the required score for a content

Passing Grade Required

Content

Count

For content with the ‘Passing Score Required’ setting enabled, this displays the score minimum the Learner must achieve to pass/complete

Path Source

Content

Input

The Path that the content was assigned from.

Example:

  • Path Source = Onboarding 101, Security Training

    • This content was assigned as part of two separate Paths: Onboarding 101 & Security Training

Path: Completed Modules

Content

Count

The number of modules the Learner has completed. This field is for Paths only

Path: Total Modules

Content

Count

The total number of modules when the Path was assigned to the Learner. This field is for Paths only

Progress

Content

Count

The percentage of content a Learner has completed. This is out of 100, where 100% is complete

SCORM: Content Source

Content

Select

Which WorkRamp Content provider the SCORM file was sourced from.

Source Name

Content

Input

Who or what assigned/enrolled the Learner in content. Examples paired with Source Type include:

  • [Source Type → Source Name]

  • Examples

    • Direct Assignment → Jane Doe: the assignment was made by Jane Doe

    • Path Assignment → Onboarding 101: the assignment of the content was made from Path ‘Onboarding 101’

      • For Path assignment details check the Path’s Source Type & Source Name

    • Automation → New Hire Automation: the assignment of the content was made by Automation ‘New Hire Automation’

    • Self-Assignment → John Doe: John Doe self-assigned the content to himself

    • Development Self-Assignment → jdoe@company.com: the content was enrolled in from the development tab by jdoe@company.com

    • Library Self-Assignment → Sales Library: the Learner self-assigned the content from library ‘Sales Library’

Who (assigner/self) or what (automation/path/library) that assigned/enrolled the content to the Learner.

This result pairs with the Source Type for a full picture of the content assignment/enrollment.

Source Type

Content

Select

How a Learner was assigned/enrolled in content. Options include:

  • Direct Assignment: assigned by an Admin directly

  • Path Assignment: assigned via a Path

  • Automation: assigned via an Automation

  • Self-Assignment: enrolled by the Learner via Search

  • Development Self-Assignment: enrolled by the Learner within a Development course

  • Library Self-Assignment: enrolled by the Learner via a Library

This result pairs with the Source Type for a full picture of the content assignment/enrollment.

Status

Content

Select

The Learner’s status on a Training. Note: A learner will need to complete a task for it to count as 'Started'.

Tag

Content

Input

Tags added to the content by an admin (or editor, creator, etc). This field can include multiple results separated by a comma

Time Estimate

Content

Count

The Time Estimate in minutes admin (or editor, creator, etc) expect Learners to spend on the content

Time Spent

Content

Count

The total time in minutes that the Learner spent in the content

If using SCORM Embedded in a Guide this will be inclusive of that number for the Guide & any linked Paths

Title

Content

Input

The title or name of the content

Aggregate Dimensions

Completion Rate

Aggregate

--

The count of assignments with a status of Completed, divided by the count of all assignments

Grade Average

Aggregate

--

The average of Grade across grouped rows

Guide: Number of Ratings

Aggregate

--

The count of submitted ratings for a Guide

Guide: Ratings Average

Aggregate

--

The average of Guide Ratings across grouped rows

Progress Average

Aggregate

--

The average of Progress across grouped rows. This is made up of:

  • progress across modules within a Path assignment

  • progress across tasks within a Guide assignment

Number of Assignments

Aggregate

--

The number of assignments across grouped rows

Total Badges Awarded

Aggregate

--

The number of badges awarded across grouped rows

Total Time Spent (Min.)

Aggregate

--

The total time spent across grouped rows

Guide Submissions (New) Report

Field

Category

Type

Description

Email

User

Date

The date of the Learner’s last login date to the platform

Is Deactivated

User

Input

The Learner’s e-mail address

Manager Email

User

Email

The Learner’s Manager’s Email. This field can include multiple results separated by a comma

Manager Name

User

Input

The Learner’s Manager’s Name. This field can include multiple results separated by a comma

Name

User

Input

The Learner’s full name

(Custom)

Custom User Attributes

Variable

All Custom User Attributes that exist in your account will appear within the Custom User Attribute subsection

Section

Guide

Input

The name of the Section that the question resides within

Task

Guide

Input

The name of the Task that the question resides within

Title

Guide

Input

The name of the Guide that the question resides within

Date: Submitted

Submissions

Date

The date the question was Submitted by the Learner (full submission of the Guide & attempt)

Is Correct

Submissions

Boolean

Whether or not the Answer is correct

Is Graded

Submissions

Boolean

Whether or not the Answer is graded

Is Most Recent Answer

Submissions

Boolean

Whether or not the Answer is from the Learner's most recent submission

Question Type

Submissions

Input

Which type of question the question is

Aggregate Dimensions

Average Attempts

Aggregate

--

The average number of attempts per Learner

Graded Submissions

Aggregate

--

The count of graded submissions

Number of Submissions

Aggregate

--

The total count of submissions

Percent Correct

Aggregate

--

The percent of submissions that are correct

Libraries Report

Field

Category

Type

Description

Folder

Content

--

The name of the folder the content is in

Users Report

Field

Category

Type

Description

Identifier

User

--

The user profile's external ID for an SSO and/or HRIS integration

Audit Logs Report (Currently limited to select notifications)

This report is only available to full Admins. Users with Reporting only permissions will not have access to this report.

**Complete data is available from 1/23/25 onwards for the four notification events currently available. Any data that is shown in the report prior to that date may be incomplete.

Field

Category

Type

Description

Object Name

Audit Logs

Input

The name of the content the notification was sent for (e.g. the name of the Guide)

Object Field

Audit Logs

Select

The type of notification

Current values are:

  • Email

  • Teams

  • Slack

Event Name

Audit Logs

Select

The type of event that occurred

Current values are:

  • Notification: assignment sent (manual assignments)

  • Notification: due date reminder sent

  • Notification: overdue reminder sent

  • Notification: manual reminder sent

Event Date

Audit Logs

Date

The date when the notification was sent from the WorkRamp platform* (in UTC)

*This does not confirm that an email notification was successfully sent to or received by the recipient, as there are some things that are out of WorkRamp's control (e.g. whether or not the receiving server accepts it)

Did this answer your question?