0.002/15/94 DIANE LIVELY 1.0 INTRODUCTION ------------ THE RESERVATION SUBSYSTEM IS USED BY THE DIVISION OF CONTINUING EDUCATION TO MAINTAIN A WAITING LIST FOR STUDENTS WISHING TO ENROLL IN A CEU COURSE. THE SUBSYSTEM IS ALSO USED BY OTHER DIVISIONS ON A LIMITED BASIS TO MAINTAIN STUDENT RESERVATIONS FOR CREDIT COURSES PRIOR TO ACTUAL REGISTRATION. THE RESERVATION PROGRAMS ARE ABLE TO HANDLE BOTH TYPES OF DATA WITHIN THE SAME RESERVATION DATA BASES DURING THE SAME TERM. THE RESERVATION SUBSYSTEM WAS ORIGINALLY DESIGNED TO HELP THE DIVISION OF CONTINUING EDUCATION MAINTAIN STUDENT RESERVATIONS AND PREPARE FOR REGISTRATION OF STUDENTS. INDIVIDUALS WOULD CALL IN ADVANCE TO RESERVE A SEAT IN A CLASS, BUT WERE NOT ACTUALLY REGISTERED UNTIL THE CLASS MET. THE ONLINE PROGRAMS, RSV010 AND RSV030 WERE WRITTEN TO ACCOMPLISH THE FOLLOWING OBJECTIVES: 1. ELIMINATE MANUAL SYSTEM 2. GIVE MULTIPLE USERS SIMULTANEOUS ACCESS TO UP-TO-DATE DATA 3. AID IN THE SELECTION OF AN AVAILABLE SECTION OF A COURSE 4. MAINTAIN A RUNNING TOTAL OF RESERVATIONS AND NUMBER WAITING 5. ENSURE THAT RESERVATIONS ARE MAINTAINED IN SEQUENCE 6. DEFAULT STUDENT NAME AND TELEPHONE NUMBERS 7. UPDATE RESERVATIONS BY CLASS 8. DISPLAY RESERVATIONS BY STUDENT 9. IDENTIFY STUDENTS NEEDING TO APPLY TO THE COLLEGE 10. PRODUCE R & I FORMS 11. GENERATE CLASS ROLLS 12. PRINT FILE LABELS 13. CAPTURE THE BUSINESS CODE 14. PROVIDE CAPABILITY TO PRODUCE AD-HOC COMPUTER LISTINGS 15. FORCE CAPTURE OF STUDENT SOCIAL SECURITY NUMBERS IN 1993, CPED CLASSES BECAME CEU CLASSES. A NEW PROGRAM, SIMILAR TO RSV010, WAS WRITTEN. THE NEW PROGRAM, RSV110, MAINTAINS WAITING LISTS FOR CEU CLASSES. IT USES THE SAME RESERVATION DATA BASES TO STORE WAITING-LIST DATA BY STUDENT AND BY CLASS; BUT IT USES THE CEU CLASS DATA BASE INSTEAD OF THE CLASS DATA BASE, AND THE CEU COURSE DATA BASE INSTEAD OF THE COURSE DATA BASE. THE CEU STUDENT MASTER IS READ FIRST IN DEFAULTING STUDENT DATA BUT THE REGULAR STUDENT MASTER SEGMENT IS ALSO READ. 2.0 SYSTEM NARRATIVE ---------------- WHETHER THE SUBSYSTEM IS USED FOR MAINTAINING A RESERVATION LIST FOR CREDIT CLASSES (RSV010) OR A WAITING LIST FOR CEU CLASSES (RSV110), TWO STAND-ALONE DATA BASES ARE USED TO STORE THE DATA. THE RESERVATION CLASS DATA BASE PROVIDES ACCESS TO ALL STUDENTS BY CLASS. IT CONTAINS CLASS DATA AND A RECORD FOR EACH STUDENT SPECIFYING THE SEQUENCE NUMBER AND THE STUDENT'S SOCIAL SECURITY NUMBER. THE RESERVATION STUDENT DATA BASE PROVIDES ACCESS TO ALL CLASSES BY STUDENT. IT CONTAINS STUDENT DATA AND A RECORD FOR EACH CLASS. RSV010 KEEPS TRACK OF THE NUMBER OF STUDENTS AND IDENTIFIES STUDENTS AS BEING ON A WAITING LIST WHEN THE NUMBER OF RESERVATIONS HAS EXCEEDED THE MAXIMUM ENROLLMENT. RECORDS MARKED AS CANCELED ARE SHOWN WITH A 'C' AND ARE NOT INCLUDED IN THE COUNT OF RESERVATIONS OR SEATS ON THE WAITING LIST. A CANCELED RESERVATION CAN BE RE-ACTIVATED. STUDENTS ON THE WAITING LIST ARE SHOWN WITH A 'W'. THESE FEATURES ARE NOT INCLUDED IN RSV110 (CEU WAITING LIST). IF ONLY THE DEPARTMENT AND COURSE NUMBER ARE ENTERED, RSV010 AND RSV110 DISPLAYS ALL CLASSES TO PROVIDE INFORMATION SO A SECTION CAN BE SELECTED. IF THE FULL CLASS ID IS ENTERED, STUDENTS CAN BE DISPLAYED, ADDED, OR UPDATED. THE SEQUENCE NUMBER IS ASSIGNED BY THE PROGRAM WHEN A STUDENT IS ADDED AND IS USED AS THE RECORD IDENTIFIER (KEY) TO ENSURE THAT STUDENTS ARE MAINTAINED IN THE ORDER IN WHICH THEY ARE ENTERED. IF THE SOCIAL SECURITY IS ENTERED WITHOUT A CLASS ID, ALL CLASSES FOUND FOR THE STUDENT DURING THE TERM WILL BE SHOWN. AFTER RESERVATIONS ARE ENTERED VIA RSV010, RSV030 IS AN ONLINE PROGRAM THAT CAN BE USED TO GENERATE CLASS ROLLS, R & I FORMS, AND LABELS WHICH CAN BE PRINTED ON AN IMS PRINTER. STUDENTS NOT FOUND IN THE SIS DATA BASE ARE MARKED AS NEEDING AN APPLICATION. THERE IS AN OPTION TO INCLUDE OR EXCLUDE RESERVED, CANCELED, OR WAITING RESERVATIONS IN ANY COMBINATION. 3.0 DATA BASE DESIGN ---------------- 3.1 RESERVATION STUDENT DATA BASE --------------- ] RSVSTDNT ] ] ] ]KEY: SOCSECNO] --------------- ] --------------- ] RSVCLASS ] ] ] ]KEY: CLSSEQNO] --------------- RSVSTDNT - RESERVATION STUDENT SOCIAL-SECURITY 9 CHARACTERS LAST-NAME 16 CHARACTERS FIRST-NAME 10 CHARACTERS INIT-NAME 1 CHARACTER PHONE-HOME PHONE-HOME-EXCH 3 CHARACTERS PHONE-HOME-EXTEN 4 CHARACTERS PHONE-BUSINESS PHONE-BUS-EXCH 3 CHARACTERS PHONE-BUS-EXTEN 4 CHARACTERS BUSINESS-CODE 5 CHARACTERS RSVCLASS - RESERVATION CLASS CLASS-ID QUARTER-ID QTR-YR 2 CHARACTERS QTR-CODE 1 CHARACTER CAMPUS 1 CHARACTER DEPARTMENT 4 CHARACTERS COURSE-NUM 3 CHARACTERS SECTION-NO 2 CHARACTERS LEC-LAB 1 CHARACTER SEQUENCE-NO 3 NUMBERS 3.2 RESERVATION CLASS DATA BASE --------------- ] CLASSRSV ] ] ] ]KEY: CLASSID ] --------------- ] --------------- ] STDNTRSV ] ] ] ]KEY: SEQNCENO] --------------- CLASSRSV - CLASS RESERVATION CLASS-ID QUARTER-ID QTR-YR 2 CHARACTERS QTR-CODE 1 CHARACTER CAMPUS 1 CHARACTER DEPARTMENT 4 CHARACTERS COURSE-NUM 3 CHARACTERS SECTION-NO 2 CHARACTERS LEC-LAB 1 CHARACTER SEATS-RESERVED 3 NUMBERS (NOT USED BY RSV110) SEATS-WAITING 3 NUMBERS STDNTRSV - CLASS STUDENT RESERVATION SEQUENCE-NO 3 NUMBERS SOCIAL-SECURITY 3 CHARACTERS RSV-CANCELED 1 CHARACTER (NOT USED BY RSV110) * 4.0 PROGRAMS SUMMARIES ------------------ 4.1 RSV010 - CLASS RESERVATION UPDATE THIS PROGRAM IS USED TO MAINTAIN RESERVATIONS FOR CREDIT CLASSES. THE PROGRAM CAN ALSO BE USED TO DISPLAY A LIST OF CLASS SECTIONS OR A LIST OF RESERVATIONS FOR A STUDENT. 4.2 RSV030 - RESERVATION CLASS ROLLS THIS PROGRAM IS USED TO DISPLAY OR PRINT CLASS ROLLS, LABELS, AND R & I FORMS FOR RESERVATIONS ENTERED VIA RSV010. 4.3 RSV110 - CEU CLASS WAITING LIST THIS PROGRAM IS USED TO MAINTAIN WAITING LISTS FOR CEU CLASSES. THE PROGRAM ALSO DISPLAYS A LIST OF CEU CLASSES AND A LIST OF CEU CLASSES FOR WHICH A STUDENT IS WAITING. 4.4 RSV300 - DELETE RESERVATIONS FOR A PAST TERM THIS PROGRAM DELETES DATA BY TERM IN BOTH OF THE RESERVATION DATA BASES AND PRINTS A REPORT OF THE DELETED RECORDS. 5.0 IMPLEMENTATION PROCEDURE ------------------------ CREDIT CLASSES PRIOR TO ENTERING RESERVATIONS, THE CLASS MUST BE ENTERED ON SCH010 WITH A PENDING CLASS STATUS SO THE CLASS INFORMATION IS AVAILABLE WITHOUT THE ABILITY TO ACTUALLY REGISTER STUDENTS AT THIS TIME. STUDENTS DO NOT HAVE TO HAVE A VALID APPLICATION WITH THE COLLEGE PRIOR TO MAKING A RESERVATION. PRIOR TO USING RSV030, ENTER PROGRAM OPTION SEGMENTS (VIA REF070) TO SPECIFY TERMINAL AND PRINTER IDENTIFICATIONS. NON-CREDIT CLASSES CEU CLASSES ARE ENTERED ON CEU110 AND STUDENTS ARE REGISTERED USING CEU020 OR CEU060. WHEN THE MAXIMUM NUMBER OF STUDENTS HAVE BEEN REGISTERED, RSV110 IS USED TO KEEP A LIST OF STUDENTS WHO WANT TO BE ON A WAITING LIST. STUDENTS DO NOT HAVE TO HAVE A VALID APPLICATION WITH THE COLLEGE PRIOR TO BEING PLACED ON A WAITING LIST. 8.0 CHANGE HISTORY -------------- 8.1 VERSION : V4.20 CHANGE DATE : 02/15/91 PROGRAMMER : DIANE LIVELY, JSRCC PROGRAM CHANGE REQUEST NO: 5815 DESCRIPTION OF CHANGE : NEW RELEASE 8.2 VERSION : V5.09 CHANGE DATE : 02/15/94 PROGRAMMER : DIANE LIVELY, JSRCC PROGRAM CHANGE REQUEST NO: 12387 DESCRIPTION OF CHANGE : CHANGED DOCUMENTATION TO INCLUDE A DISCUSSION OF HOW THE RESERVATION DATA BASES CAN BE USED TO MAINTAIN A WAITING LIST FOR CEU CLASSES. ADDED PROGRAM NARRATIVES FOR RSV110 AND RSV300.