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








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




"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"  

 

 

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"