Best practice forum (Archived)

Totara 2.7 Report Builder "Course Completion" data source columns

 
Wen Hao Chuang
Totara 2.7 Report Builder "Course Completion" data source columns
di Wen Hao Chuang - Thursday, 10 September 2015, 09:56
 

Hi all, sorry to bug the forum again.

We are using 2.5.30 and are evaluating 2.7 for our future upgrade.

I noticed that in Report Builder, the data source "Course Completion," 2.7 seems to have added quite a few new columns:

Under the "Course Completion" section:

  • Date Started
  • Date Enrolled

Then under the "Course" section, there is also another

  • Course Start Date

My questions:

1. Is the "Date Started" and "Course Start Date" the same?

2. From 2.5.30 to 2.7.x, is there any DB table level changes that added new DB fields in those "course/program/cert completion" related tables??

3. If the answer to #2 is no, then is it possible to backport (thru our partner) these newly added columns to 2.5.30 "Course Completion" data source??

Thanks!

Peter Pappas
Re: Totara 2.7 Report Builder "Course Completion" data source columns
di Peter Pappas - Thursday, 10 September 2015, 10:05
 

Hi Wen,

 

The course start date is the date in the course setting for the start date. (it might be helpful for courses that are part of a recurring program not sure since I did not find value in it)

The date started is the date that a learner started the course.

Peter

 

Wen Hao Chuang
Re: Totara 2.7 Report Builder "Course Completion" data source columns
di Wen Hao Chuang - Thursday, 10 September 2015, 13:21
 

Hi Peter, thanks for the explanation! This is very helpful.

By the way, does people care about a "course" level due date at all (e.g. for compliances and/or auditing purposes), even though that "due" dates might have to come from program or certification level? I'm just curious, as this seems to be common use case, but I don't think it's in the current implementation yet. Thanks!