Hi there,
Got some quick Totara Db table questions here:
1. in mdl_course_completion_criteria, which are the possible values for criteriatype and role, and what are their meaning?
2. In mdl_certif_completion (and the mdl_certif_completion_history) tables the Renewalstatus can be 0, 1, or 2. What does those mean? Also I think the Status field can be 1,2,3,or 4. What does each value mean?
Thanks!
Hi Wen,
Can you please ask your Totara Partner to submit a help request via out ticketing site..
regards,
George.
I figured out the answers by myself.
Just in case anyone is interested, here are what each criteriatype value means in the mdl_course_completion_criteria table:
| 1 | enabled condition "Condition: Manual self completion" |
| 2 | enabled condition "Condition: Date" |
| 4 | enabled condition "Condition: Activity completion" |
| 5 | enabled condition "Condition: Enrollment duration" |
| 6 | enabled condition "Condition: Course grade" |
| 7 | enabled condition "Condition: Manual completion by others" |
| 8 | enabled "Condition: Completion of other courses" |
