Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The following table lists the Tables and Fields populated through the Time Spent Learning plugin. When designing a Domain or View, pull these Tables/Fields in to include Time Spent data:
 

                
TableFieldDescription
local_ld_lastactivity




 Time Spent data collected for the last activity that user has performed.




"id" 
"userid" 
"lastaccess" 
"courseid" 
"coursemoduleid" 
local_ld_course



 Total time spent within a course.



 "id"  
"userid" 
"courseid" 
 "totaldedication" 
local_ld_course_day




 Time spent on a course at day level.




"id" 
 "ldcourseid" 
"daytime" 
"day" 
"dedication" 
local_ld_module



 Time spent on a module.



"id" 
"ldcourseid" 
"coursemoduleid" 
 "totaldedication" 
local_ld_module_day




 Time spent on a module at day level.




"id" 
"ldmoduleid" 
 "daytime" 
"day" 
 "dedication"