Canadian Natural Contractor Portal

Deployment

Instructor-Led

ICOM provides Instructor-Led versions select Brain-Flash courses. They differ from the normal course in this way:

• Auto-next lesson

• Lesson unlocked

• Scrubber unlocked

• No certificate

2) Make the class associated to no organizations, it should say "Select One"

Deactivate Course

* Actions:

** Course? Set inactive

** Auto-Enrollments? Delete all

* Result:

** Launchable? Not by anybody

** Reporting? Enrollment data maintained but not visible in Report Builder

Withdraw Enrollments for Contractor Organizations

* Actions:

** Enrollments? Delete "Not Attempted" and inactivate for non-CNRL users

** Auto-Enrollments? Delete all

** Classes? Change global access to CNRL only

* Result:

** Launchable? Only by CNRL

** Reporting? Enrollment data maintained but not visible in Report Builder

Delete all auto-enrollments

DELETE

FROM fm_autoenroll_assn

WHERE curriculum_id = [YOUR_CURRICULUM_ID]

Delete all no-visits

DELETE

FROM enrollments

WHERE curriculum_id = [YOUR_CURRICULUM_ID]

AND visits = 0

AND is_complete = 0

AND id NOT IN

(

SELECT enrollment_id

FROM results

)

Inactivate non-CNRL

UPDATE enrollments

SET is_active = 0

, notes = CONCAT(COALESCE(notes,''),' ~~~~~~~~~~~~

mjohnson 2018-09-20: Withdrawal')

WHERE curriculum_id = [YOUR_CURRICULUM_ID]

AND user_id NOT IN

(

SELECT id

FROM users

WHERE organization_id = 1

)

Set Global Deployments as non-Global

CNRL sometimes asks that Globally deployed courses (everyone is enrolled) be switched to non-Global courses they can still manually enroll specific users.

Delete all auto-enrollments

/* Delete all auto-enrollments */

DELETE

FROM fm_autoenroll_assn

WHERE curriculum_id = [YOUR_CURRICULUM_ID]

Delete all no-visits

/* Delete all no-visits. Filters for no visits, incomplete and no results */

DELETE

FROM enrollments

WHERE curriculum_id = [YOUR_CURRICULUM_ID]

AND visits = 0

AND is_complete = 0

AND id NOT IN

(

SELECT enrollment_id

FROM results

)