Waitlists - Genius CE & Enterprise

Waitlists

A learner can be put on the waitlist for several reasons:

1) Section cap – not more than a number of learners can be enrolled in a particular course section.  This cap is set under the Section tab.  The default is set as a parameter under the Administration tab.

2) Instructor cap – not more than a number of learners can be enrolled in any course-section that a particular instructor is teaching.  This cap is set under the Instructor tab.  The default is set as a parameter under the Administration tab.

3) Affiliation cap - not more than a number of learners can be enrolled in any course-section from a particular affiliation.  This cap is used to prevent one affiliation from taking all the seats in a particular course section.  This cap is set as a parameter under the Administration tab.

As learners are enrolled in course-sections, the number of seats available counts down towards zero.  When they reach zero, the Register button will change to Add to Waitlist.  When the learner is added to the waitlist, an email will automatically be sent by Genius CE or Enterprise to the Support_Email parameter value, under the Administration tab.

Subscription Report of Waitlist

You can also set up a subscription report to notify one or more email addresses who is on the waitlist.  The following query should tell you who is on the waitlist and why.

SELECT 

wl.waitinglistindex as ID, students.studentindex as SID, students.lastname+', '+students.firstname as Learner, courses.name as Course, lmsterms.name as Term, wl.Reason as Status, wl.startdate as [Start Date], users.lastname+', '+users.firstname as RequestedBy, wl.requestedon as RequestedOn,

            Stuff((SELECT ', ' + aff.Name 

                   FROM   Affiliations aff

                   INNER JOIN StudentToAffiliation sa on sa.AffiliationIndex = aff.AffiliationIndex

                   WHERE  sa.StudentIndex = students.StudentIndex

                   FOR XML PATH('')), 1, 2, '') School 

            from waitinglist wl

            left join students on wl.studentindex = students.studentindex

            left join sections on wl.SectionIndex = sections.SectionIndex

            left join courses on (wl.courseindex = courses.courseindex OR sections.CourseIndex = courses.CourseIndex)

            left join departments on courses.departmentindex = departments.departmentindex

            left join lmsterms on wl.lmstermindex = lmsterms.lmstermindex

            left join users on wl.requestedby = users.userindex

The waitlist can be overridden by an Administrator, from the Reports tab, Waiting List report.  The Administrator can choose to enroll the user or remove their request from the waitlist.