Transcript No Slide Title

Northwest DUG – Session 128
Custom Tools for
Waitlist and Scheduling
Presenter: Sylvia Mossey, Centre for Education Information
Objectives

Identify AnswerNet documents
that contain fixes for problems in
these two areas

Demonstrate custom tools
Miscellaneous Scheduling

Conflicts with same start and end
times

Can’t rebuild section meeting
dates in the past

Difficult to find an available room
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.
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 insert:
CORE\S.BOOK.CALENDAR
CORE\S.CHECK.CALENDAR
CORE\S.GET.RESOURCES,
ST\S.BUILD.SEC.SCHEDULES
ST\S.CHECK.FAC.SCHEDULES
ST\S.CHECK.SEC.SCHEDULES
ST\S.CHK.CONFLICT
Can’t 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
08:30AM 03:30PM MTuThF
04-23-01 05-17-01 |
|
Weekly
|
| 2: Lecture CBA 211
08:30AM 03:30PM F
05-18-01 05-18-01 |
|
Weekly
|
| 3 Rebuild Meeting Dates:
4 * Actual Meeting Times:
|
+------------------------------------------------------------------------------+
Can’t 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.
Difficult to find an available room
VAVR versus XVAR
+------------------------------------------------------------------------------+
| 06-24-01
18:06
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:
|
|aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa|
Difficult to find an available room
VAVR versus XVAR
+------------------------------------------------------------------------------+
| 06-24-01
18:09
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:
|
|aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa|
XVAR - Features

Ability to search using:






Ability to limit search by:






Date range
Time range
Duration
Number of meetings per week
Days of the week
Room capacity
Location
Building
Room Type, Usage, Categories and Characteristics
Equipment Type
Detail on room to BRCS or RMSM
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
Course Waitlist

Waitlist data not showing on
STWM

Can’t waitlist for multiple
sections of a course

Difficult to manage waitlist using
CWLM
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.
Waitlist data not showing on STWM
(AnswerNet doc #1924.56)
SOLUTION:
In ST.INSERTS S.GET.WAITLIST:
217: **
LOCATE X.FLD IN XL.SORTED.LIST<1,1> BY "AR" SETTING XX ELSE
218: **
INS X.FLD BEFORE XL.SORTED.LIST<1,XX>
219: **
INS V.WAIT.LIST.ID BEFORE AL.WAIT.LIST.ID<1,XX>
220: **
END
221:
LOCATE X.FLD IN XL.SORTED.LIST<1,1> BY "AR" SETTING XX THEN
222:
INS X.FLD BEFORE XL.SORTED.LIST<1,XX>
223:
INS V.WAIT.LIST.ID BEFORE AL.WAIT.LIST.ID<1,XX>
224:
END
225: ELSE
226:
INS X.FLD BEFORE XL.SORTED.LIST<1,XX>
227:
INS V.WAIT.LIST.ID BEFORE AL.WAIT.LIST.ID<1,XX>
228: END
Comment out the first locate and replace with the second locate
to ensure that all the WAIT.LIST records get added.
Can’t 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.
Colleague’s default behavior is to allow a student to
waitlist in only one section of a course.
Can’t waitlist for multiple sections of a
course
SOLUTION:
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":@FM:"WAIT.STUDENT"
A.OPER = "EQ":@FM:"EQ"
A.VALUE = V.SEC.COURSE:@FM:A.STUDENTS.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":@FM:"WAIT.STUDENT”:@FM:”WAIT.COURSE.
SECTION”
A.OPER = "EQ":@FM:"EQ“:@FM:”EQ”
A.VALUE = V.SEC.COURSE:@FM:A.STUDENTS.ID:@VM:A.CS.ID
CALL S.GET.INDEX(V.WAIT.LIST.ID,"WAIT.LIST",A.INDEX,A.OPER,A.VALUE)
Difficult to manage waitlists using CWLM
CWLM versus XWLM
+------------------------------------------------------------------------------+
| 06-24-01 20:51
|
COURSE WAITLIST MANAGEMENT
Course Name: ENGL-101
CWLM |
Title: English Composition
|
|==============================================================================|
|
| 1 * Current Waitlist
|
1:
|
244557
Rating Stat
Status
Pref
Home
|
Date
Sect
Telephone
|
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
| 2 Previous Waitlist
Stat
Date
|
1: 0244550
Duck, Donald
Enrol 06-24-01
|
2: 0244559
Mulder, Fox
Dropp 06-18-01
Enrolled Enrolled
|
Section
Term
|
2001F
|
002
|
|aa Controller Current Waitlist aaaaaaaaaaaaaaaaaaaaaaaaaaa Value 1/17 aaaaaaaa|
Difficult to manage waitlists using CWLM
CWLM versus XWLM
+------------------------------------------------------------------------------+
| 06-24-01 20:50
|
COURSE WAITLIST MANAGEMENT
Course Name: ENGL-101
XWLM |
Title: English Composition
|
|==============================================================================|
|
Status
| 1 * Current Waitlist
Rating Stat Date
Status
Time
Preferred
Term
Sect
Home
|
Telephone
|
|
1: Peter Pan
0 A
06-04-01 06:57PM 2001F
002
|
|
2: Bart Simpson
0 A
06-04-01 08:08PM 2001F
003
|
|
3: Big Bird
0 A
06-06-01 06:50PM 2001F
001
|
|
4: Captain Hook
0 A
06-09-01 06:57PM 2001F
001
|
|
5: Scooby Doo
0 A
06-11-01 06:52PM 2001F
004
|
|
6: Bugs Bunny
0 A
06-12-01 06:54PM 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|
XWLM - Features

Additional LookUps by Student and Section

Search by Student capability after records
displayed

Ability to modify Status Time

Ability to modify student’s preferred section
(section must be full)

Ability to modify status of student on previous
waitlist

Previous waitlist section shows original preferred
term and section