The University of Alabama at Birmingham

Data Dictionary

There are two different Data Dictionaries for the Campus Learning System:  Course & Training Material Report Data Dictionary & Pre-Built Report: Data Dictionary.


Course & Training Material Report:


The Course and Training Material report in Docebo allows power users to quickly and easily check individual and overall course progress and statistics.


 For assistance with running this report, view our step-by-step guide.



Field/ColumnDescription
UsernameThe username of the user enrolled in the course
First nameUser's first name
Last NameUser's last name
Enrollment DateThe date when the user enrolled in the course
First Access DateDate and time that the user first accessed the course
Completion DateDate and time when the user completed the course
Last Access DateDate and time when the user last accessed the course.
ProgressThe user's progress in the course, in percentage
Training Material TimeThe total time* spent by the learner on the training materials composing the course (both on desktop and mobile) since the first time they accessed the course after their enrollment.
Session TimeThe total time the user has been marked as present in sessions (both online and onsite)**
StatusThe user's current status in the course.
Possible values are: Not Yet Started, In Progress, or Completed.
ScoreThe course score calculated on the basis of tests, assignments, or any other training material associated with a score


*The time is calculated on the actual time the user spends in the course, removing breaks caused by inactivity, pop-up blockers, and tab closing


**Session time applies to instructor-led training (ILT) courses




Pre-Built Report: Data Dictionary

Pre-built reports are configured to provide additional data about a person's employment and student affiliations with UAB. While there may be minor differences in each report, most will include similar information. Deactivated accounts (employees or students who left UAB) are not included in reports.


 For assistance with running this report, view our step-by-step guide.



Field/Column
Description
Username
Person's BlazerID
Full Name
Person's full name
Email
Person's email
Employment Details
EMPLOYEE_STATUS
Whether the person has an employment affiliation (Y/Yes, N/No, P/Pre-hire)
EMPLOYEE_NUMBER
Employee's ID number
JOB_TITLE
Employee's job title
ORG
Employee's organization
AVP_ORG
(If applicable) Employee organization's (Org's) higher-level AVP organization or department
VP_ORG
Employee organization's (Org's) highest-level VP unit or school/college
WORKFORCE_GROUP
Employee's workforce group
Student Details
STUDENT_STATUS
Whether the person has a student affiliation (Y or N)
BANNER_ID
Student's Banner ID (B00#)
STUDENT_COLLEGE
Student's school or college
STUDENT_MAJOR
Student's major
STUDENT_PROGRAM
Student's program of study
STUDENT_PROG_START_DATE
Student's program start date
Course Details
Course Enrollment Status
Person's status for the course (Enrolled, not started; In Progress; Completed)
Course Enrollment Date
Date the person was enrolled into the course
Course First Access Date
Date the person first accessed (opened) the course
Course Last Access Date
Date the person most recently accessed (opened) the course
Completion Date
Date the person completed the course
Deactivated
Whether the person is currently deactivated in the Campus Learning System (Yes/No)

∎ End of article | Modified on: Mon, 10 Feb, 2025 at 10:22 AM

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.