Custom Tools for

1
Northwest DUG Session 128
Custom Tools for Waitlist and Scheduling
Presenter Sylvia Mossey, Centre for Education
Information
2
Objectives

• Identify AnswerNet documents that contain fixes
  for problems in these two areas
• Demonstrate custom tools

3
Miscellaneous Scheduling

• Conflicts with same start and end times
• Cant rebuild section meeting dates in the past
• Difficult to find an available room

4
Conflict with same start and end times(AnswerNet
doc 981.52)THE PROBLEM
When you use MSCH or SOFF to set up an event or
class and you try to schedule it with an END TIME
that's the same as the START TIME for an already
established event, it shows a conflict.  When you
schedule an event with a START TIME that is the
same as the END TIME of an already established
event, it DOESN'T show a conflict. Example If
there is a class that is from 10-11 and one from
11-12 and you rebuild them both, you will only
get a conflict message on the 10-11 class. The
11-12 class will build without a problem.
5
Conflict with same start and end times(AnswerNet
doc 981.52)SOLUTION
AE CORE.INSERTS I_SUBR.CHECK.BOOK.CALENDAR
Locate and comment out this line 0355       
IF V.CALS.START.TIME LE V.EVENT.END.TIME THEN
Add this line 0356 IF V.CALS.START.TIME LT
V.EVENT.END.TIME THEN  COMPILE S.CHECK.CALENDAR
in the CORE toolkit. Note that other subroutines
use this insert too.  You should compile all of
these to pick up the changes in the
insertCORE\S.BOOK.CALENDAR CORE\S.CHECK.CALENDA
R CORE\S.GET.RESOURCES, ST\S.BUILD.SEC.SCHEDULES
ST\S.CHECK.FAC.SCHEDULES ST\S.CHECK.SEC.SCHEDUL
ES ST\S.CHK.CONFLICT
6
Cant rebuild section meeting dates in the past
(AnswerNet doc 147.918)PROBLEM
If the first line of meeting dates on SOFF starts
in the past and you try to Rebuild Meeting Dates,
you will get a message Check entries in schedule
print times, meeting dates not built even if
other lines contain future meeting dates.
-------------------------------------------------
----------------------------- 2 Schedule Print
Times
Instr Meth Bldg Room St Time
End Time Days of Week St Date End Date
Room Assign Ind
Frequency 1 Lecture CBA 276
0830AM 0330PM MTuThF 04-23-01
05-17-01
Weekly 2
Lecture CBA 211 0830AM 0330PM F
05-18-01 05-18-01
Weekly
3 Rebuild Meeting Dates 4
Actual Meeting Times
-----------------------------------------------
-------------------------------
7
Cant rebuild section meeting dates in the past
(AnswerNet doc 147.918)SOLUTION
AE CORE.INSERTS I_SUBR.BOOK.CALENDAR Comment
out the line show below (around line 33) IF
X.DATE GE DATE() THEN and also comment out the
corresponding END statement right after the
GOSUB PRINT.DEBUG.SCHED (around line 56)
Access CORE in the toolkit and GEN the process
S.BOOK.CALENDAR.
8
Difficult to find an available roomVAVR versus
XVAR
-------------------------------------------------
----------------------------- 06-24-01 1806
VIEW AVAILABLE ROOMS
VAVR
1
Date Available. 06-24-01
2 Start/End Times

------------------------------------------
------------------------------------ 3
Building Name Room
Capacity Primary Usage 1

2

3
4

5
6

7

8
9

10

aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
9
Difficult to find an available roomVAVR versus
XVAR
-------------------------------------------------
----------------------------- 06-24-01 1809
VIEW AVAILABLE ROOMS
XVAR

Begin End 7
Locations....... 1 1
Dates.......... 06-24-01 8
Buildings....... 1 2
Start/End Times 9 Room
Types...... 1 3 Room
Capacity.. 10 Room
Usages..... 1
11 Room Categories. 1
4 Duration.........
12 Room Characteristics 1 5
Meetings per Week 13 Equipment
Type...... 1 6 Days of the
Week. 1 14
Search Now.. -----------------------------
-------------------------------------------------
15 Building Name Room
Capacity Primary Usage 1

2

3
4

aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
10
XVAR - Features

• Ability to search using
• Date range
• Time range
• Duration
• Number of meetings per week
• Days of the week
• Ability to limit search by
• Room capacity
• Location
• Building
• Room Type, Usage, Categories and Characteristics
• Equipment Type
• Detail on room to BRCS or RMSM

11
XVAR Sample Search

• Classroom (coded as category 110)
• Room for at least 40 people
• In the Young building
• Between June 1 30th
• Two meetings per week
• Weekdays only (Mon Fri)
• Two hour booking
• Anytime between 9 am and 3 pm

12
Course Waitlist

• Waitlist data not showing on STWM
• Cant waitlist for multiple sections of a course
• Difficult to manage waitlist using CWLM

13
Waitlist data not showing on STWM (AnswerNet doc
1924.56)PROBLEM
If a student puts themselves onto several
waitlists through WebAdvisor - one of the records
may not show on STWM or on My Schedule on
WebAdvisor. This will only happen when the
Rating, Status Date and Status Time on more than
one WAIT.LIST record for a student are identical.
14
Waitlist data not showing on STWM (AnswerNet doc
1924.56)SOLUTION
In ST.INSERTS S.GET.WAITLIST 217      
LOCATE X.FLD IN XL.SORTED.LISTlt1,1gt BY "AR"
SETTING XX ELSE 218          INS X.FLD BEFORE
XL.SORTED.LISTlt1,XXgt 219          INS
V.WAIT.LIST.ID BEFORE AL.WAIT.LIST.IDlt1,XXgt 220
      END 221       LOCATE X.FLD IN
XL.SORTED.LISTlt1,1gt BY "AR" SETTING XX THEN
222          INS X.FLD BEFORE
XL.SORTED.LISTlt1,XXgt 223          INS
V.WAIT.LIST.ID BEFORE AL.WAIT.LIST.IDlt1,XXgt
224       END 225 ELSE 226          INS
X.FLD BEFORE XL.SORTED.LISTlt1,XXgt 227         
INS V.WAIT.LIST.ID BEFORE AL.WAIT.LIST.IDlt1,XXgt
228 END Comment out the first locate and
replace with the second locate to ensure that
all the WAIT.LIST records get added.
15
Cant waitlist for multiple sections of a course
PROBLEM
The policy at many of the institutions in B.C. is
to allow students to waitlist in multiple
sections of a course. Colleagues default
behavior is to allow a student to waitlist in
only one section of a course.
16
Cant waitlist for multiple sections of a
courseSOLUTION
If you have access to the Tool-Kit. Edit the ST
subroutine S.REG.STU.WAITLIST and around line 45,
change three lines V.WAIT.LIST.ID "" A.INDEX
"WAIT.COURSE"_at_FM"WAIT.STUDENT" A.OPER
"EQ"_at_FM"EQ" A.VALUE V.SEC.COURSE_at_FMA.STUDENT
S.ID CALL S.GET.INDEX(V.WAIT.LIST.ID,"WAIT.LIST",A
.INDEX,A.OPER,A.VALUE) V.WAIT.LIST.ID
"" A.INDEX "WAIT.COURSE"_at_FM"WAIT.STUDENT_at_FM
WAIT.COURSE. SECTION A.OPER
"EQ"_at_FM"EQ_at_FMEQ A.VALUE
V.SEC.COURSE_at_FMA.STUDENTS.ID_at_VMA.CS.ID CALL
S.GET.INDEX(V.WAIT.LIST.ID,"WAIT.LIST",A.INDEX,A.O
PER,A.VALUE)
17
Difficult to manage waitlists using CWLMCWLM
versus XWLM
-------------------------------------------------
----------------------------- 06-24-01 2051
COURSE WAITLIST MANAGEMENT
CWLM Course Name ENGL-101
Title English Composition


Status Pref
Home 1 Current Waitlist
Rating Stat Date Sect Telephone
1 244557 Peter Pan 0 A
06-04-01 002 2 0244561
Bart Simpson 0 A 06-04-01 003
3 0244547 Big Bird
0 A 06-06-01 001
4 0244558 Captain Hook 0 A
06-09-01 001 5 0244551
Scooby Doo 0 A 06-11-01 004
6 0244554 Bugs Bunny
0 A 06-12-01 003
-----------------------------------------------
-------------------------------
Status
Enrolled Enrolled 2 Previous Waitlist
Stat Date Section Term
1 0244550 Duck, Donald
Enrol 06-24-01 002 2001F 2
0244559 Mulder, Fox Dropp
06-18-01 aa Controller
Current Waitlist aaaaaaaaaaaaaaaaaaaaaaaaaaa
Value 1/17 aaaaaaaa
18
Difficult to manage waitlists using CWLMCWLM
versus XWLM
-------------------------------------------------
----------------------------- 06-24-01 2050
COURSE WAITLIST MANAGEMENT
XWLM Course Name ENGL-101
Title English Composition


Status Status Preferred
Home 1 Current Waitlist Rating
Stat Date Time Term Sect Telephone
1 Peter Pan 0 A 06-04-01
0657PM 2001F 002 2 Bart
Simpson 0 A 06-04-01 0808PM 2001F
003 3 Big Bird
0 A 06-06-01 0650PM 2001F 001
4 Captain Hook 0 A 06-09-01
0657PM 2001F 001 5 Scooby
Doo 0 A 06-11-01 0652PM 2001F
004 6 Bugs Bunny
0 A 06-12-01 0654PM 2001F 003
-----------------------------------------------
-------------------------------
Status Preferred
Enrolled 2 Previous Waitlist
Stat Date Term Sect Term Sect
1 Duck, Donald E 06-24-01
2001F 002 2001F 002 2 Mulder,
Fox D 06-18-01 2001F 003
aa Controller Current Waitlist
aaaaaaaaaaaaaaaaaaaaaaaaaaa Value 1/17 aaaaaaaa
19
XWLM - Features

• Additional LookUps by Student and Section
• Search by Student capability after records
  displayed
• Ability to modify Status Time
• Ability to modify students preferred section
  (section must be full)
• Ability to modify status of student on previous
  waitlist
• Previous waitlist section shows original
  preferred term and section

20
Questions