0.012/15/92 TONY SANTOS 1.0 INTRODUCTION ------------ THE SCHEDULING SUBSYSTEM IS DESIGNED TO ASSIST IN THE PREPARATION AND MANAGEMENT OF CLASS DATA FROM THE TIME AN INITIAL CLASS SCHEDULE BEGINS THROUGH THE END OF THE TERM WHEN CENSUS DATA IS REPORTED. THE SYSTEM IS DESIGNED AROUND A NORMAL CYCLE TERM EVENTS. THE SCHEDULING SUBSYSTEM IS DESIGNED TO OFFER MORE SCHEDULING FLEXIBILITY BY GIVING THE USER THE ABILITY TO CONTROL THE ORDER IN WHICH CLASSES WILL APPEAR ON THEIR PRINTED TERM CLASS SCHEDULE. IN ADDITION, THE VERSATILITY TO OPTIONALLY EXTRACT THE CLASS SCHEDULE DATA AND/OR SELECTIVE CLASSES THEREOF INTO PHYSICAL SEQUENTIAL TSO DATA SETS TO BE USED TO DOWN LOAD INTO A USERS PERSONAL COMPUTER. WITH THIS FEATURE THE SCOPE WITH WHICH THE USER CAN USE THIS DATA FOR THEIR OWN PERSONAL NEEDS IS UNLIMITED. INITIALLY A TERM CLASS SCHEDULE BEGINS BY CREATING A FUTURE TERM FROM A PREVIOUS TERM'S SCHEDULE. ONCE CREATED, ADDITIONS, CHANGES AND/OR DELETION OF CLASSES WILL BE DONE WITH THE CURRENT ONLINE SCHEDULING SOFTWARE. AFTER THE CLASS DATA IS COMPLETE A VARIETY OF BATCH REPORTS ARE AVAILIABLE FOR PRINTING. SOFTWARE IS ALSO AVAILABLE TO SUPPORT REPORTING CLASS DATA TO THE PRODUCTIVITY ANALYSIS SYSTEM (PAS) AND THE VIRGINIA COMMUNITY COLLEGE SYSTEM (VCCS) FOR CENSUS REPORTING. CURRENTLY THERE IS NO HISTORICAL SYSTEM FOR MAINTAINING CLASS DATA; THEREFORE, UNTIL THIS AREA IS DEVELOPED, THE SCHEDULING SUBSYSTEM IS CUMULATIVE WHERE CLASSES WILL BE KEPT TERM UPON TERM. THE EXCEPTION TO THIS IS CLASS REMARKS DATA WHICH MAY BE DELETED BY TERMS, IF DESIRED. OBJECTIVES AND GOALS -------------------- . THE ABILITY TO RUN A TERM CLASS SCHEDULE WITHOUT PROGRAMMER INTERVENTION. . THE ABILITY TO START FROM A PREVIOUS BASE TERM AND CREATE A FUTURE TERM SCHEDULE. . THE ABILITY TO BUILD A SCHEDULE FOR A PARTICULAR CAMPUS, DIVISION, OR GROUP OF UNIQUE CLASSES EG. TELECOMMUNICATION CLASSES. . THE FLEXIBILITY TO ADD OR CHANGE REMARKS AND THEN RESEQUENCE THE DATA FOR SCHEDULE PRINTING. . THE ABILITY TO PROVIDE THIS PRODUCT TO OTHER COLLEGES WITHIN THE VIRGINIA COMMUNITY COLLEGE SYSTEM. . THE ABILITY TO DOWNLOAD SCHEDULE DATA ONTO A PERSONAL COMPUTER WITH MAINFRAME CONNECTIVITY. . THE ABILITY TO GROUP PARTICULAR CLASSES TOGETHER ON THE PRINTED TERM SCHEDULE REPORT. . THE ABILITY TO PRINT AND/OR DISPLAY A SUBSTITUTE TITLE FOR A CLASS. . THE FLEXIBILITY TO PRINT A PARTICULAR CLASS ACROSS SEVERAL CAMPUS SCHEDULES. . THE ABLILTY TO HAVE FREE FORMED MESSAGES. * CONSTRAINTS: ------------ . THE CURRENT DESIGN OF THE CLASS MASTER SEGMENT OF THE CLASS DATA BASE IS NOT LARGE ENOUGH TO HANDLE A CLASS-SEQUENCE-KEY CONSISTING OF CXXXX OCCURING 5 TIMES WHERE: C = CAMPUS WHERE CLASS WILL PRINT XXXX = SEQUENCE NUMBER WHERE CLASS WILL PRINT WITHIN EACH CAMPUS/DEPARTMENT CURRENTLY THE CLASS MASTER SEGMENT HAS NO AVAILABLE BYTES OF FILLER AVAILABLE. THE SEQUENCE NUMBER WOULD NEED A TOTAL OF 25 BYTES WHICH WILL NEED TO BE ADDED TO THIS SEGMENT. . THE CURRENT SIZE OF THE CLASS REMARKS SEGMENT OF THE CLASS DATA BASE HAS NO EXTRA SPACE AVAILABLE. IN ORDER TO SUPPORT THE FLEXIBILITY OF PRINTING CLASS REMARKS BOTH BEFORE AND/OR AFTER A CLASS AN EXTRA 1 BYTE FIELD NEEDS TO BE ADDED, REMARK-PRINT-CODE, WHERE THE VALUES WOULD BE: A = PRINT REMARK AFTER THE CLASS B = PRINT REMARK BEFORE THE CLASS THIS GIVES THE USER THE FLEXIBILITY TO CONTROL WHERE REMARKS SHOULD PRINT IN REGARDS TO THE CLASS. . MANAGEMENT REQUIRES THE FIRST OBJECTIVE AND GOAL TO BE MET BEFORE TIDEWATER CONVERTS ONTO THE NEW STUDENT INFORMATION SYSTEM IN WINTER 1988. TIDEWATER'S SCHEDULE NEEDS SHOULD BE COMPLETE BY AUGUST 1987, THIS WILL ALLOW TWELVE MONTHS TO MAKE THE NECESSARY DATA BASE AND SOFTWARE CHANGES. . A FUTURE TERM SCHEDULE MAY ONLY BE CREATED IF THERE IS A PREVIOUS BASE TERM FROM WHICH TO EXTRACT THE DATA. 2.0 SYSTEM NARRATIVE ---------------- THE SCHEDULING SUBSYSTEM IS DESIGNED TO SUPPORT THE VIRGINIA COMMUNITY COLLEGE SYSTEM (VCCS) USER NEEDS BEGINNING WITH THE TIME OF INITIAL CLASS SCHEDULE PREPARATION; ESTABLISHMENT OF A PRINTER SCHEDULE FOR PUBLICATION ON THRU CLASS REGISTRATION. REPORTS ARE PROVIDED TO SUPPORT THE NEEDS THOUGHOUT THIS PERIOD. FOLLOWING REGISTRATION CENSUS REPORTING NEEDS ARE ALSO SUPPORTED. THE CURRENT DESIGN OF THE CLASS DATA BASE HAS PROVISIONS FOR COLLECTING NOT ONLY CLASS INFORMATION FOR OFFERING SPECIFIC CLASSES, BUT ALSO CLASS REMARKS DATA USED FOR SCHEDULE PRINTING PURPOSES. IN ADDITION, COMBINED CLASS DATA IS COLLECTED WHICH IS THEN USED TO SUPPORT PAS ANALYSIS. CLASS SUBSTITUTE TITLES, AN ALTERNATE TITLE FOR A CLASS, AS OPPOSED TO THE NORMAL MASTER COURSE TITLE IS AVAILABLE. ALSO PROVIDED, IS A LOGICAL CONNECTION FROM THE CLASS DATA BASE TO THE STUDENT DATA BASE FOR ALL STUDENTS REGISTERED FOR A PARTICULAR CLASS. THIS LOGICAL VIEW PROVIDES AN EXTREMELY USEFUL AND EFFICIENT WAY TO SATISFY MANY SCHEDULING REQUIREMENTS. SCHEDULE PROCESSING NORMALLY BEGINS BY FIRST PREPARING AN INITIAL BASE SKELETON CLASS SCHEDULE FROM A PREVIOUS TERM'S CLASS SCHEDULE. SCH310 "CREATE FUTURE TERM SCHEDULE" IS A BATCH UPDATE PROGRAM DESIGNED TO PERFORM THIS TASK. ONCE THE BASE CLASS SCHEDULE HAS BEEN CREATED, A COLLEGE COULD RUN ONE OF THE CLASS SCHEDULE PRINT PROGRAMS, THERE ARE FIVE FORMATS FROM WHICH TO CHOOSE. THIS WILL PROVIDE AN INITIAL LIST FOR DIVISION CHAIRPERSONS OR DESIGNEE FROM WHICH TO BEGIN WORKING. DIVISION CHAIRPERSONS OR DESIGNEE CAN NOW BEGIN CUSTOMIZING THEIR CLASS SCHEDULE WITH ADDITIONS, CHANGES AND/OR DELETIONS VIA SCH010. CLASS REMARKS CAN BE ADDED, MODIFIED AND/OR DELETED VIA SCH020. WHILE THE NEW TERM'S CLASS SCHEDULE IS BEING CREATED, DIVISION CHAIRPERSONS MAY FIND IT HELPFUL TO CONTINUE RUNNING ONE OF THE BATCH SCHEDULE PRINT PROGRAMS UNTIL THE DESIRED FORMAT AND INFORMATION IS OBTAINED. IN ADDITION TO THE SCHEDULE PRINT PROGRAMS, ALSO HELPFUL AT THIS TIME MAY BE THE ROOM AVAILABILITY AND CONFLICT REPORT (SCH520). THIS REPORT IS HELPFUL TO AVOID SCHEDULING CLASSES INTO THE SAME ROOM DURING THE SAME TIME SPAN. ONCE THE INITIAL TERM'S SCHEDULE HAS BEEN COMPLETED, YOU MAY WANT TO LIST A SCHEDULE OF CLASSES TO BE RELEASED FOR PRINTING TO BEGIN THE TERM'S REGISTRATION PROCESS. THE NEWSPAPER SCHEDULE REPORT (SCH501) AND/OR SOME OTHER SCHEDULE OF CLASSES REPORT MIGHT BE USED FOR PUBLIC NEWSPAPER ADVERTISEMENT. DURING REGISTRATION ONE OF THE CLASS CENSUS DATES REPORTS IS HELPFUL TO BE USED BY REGISTRATION PERSONNEL TO REMIND THEM WHEN STUDENTS MAY NO LONGER DROP OR ADD CLASSES WITH FULL REFUNDS AND/OR WITHDRAW FROM CLASSES WITHOUT ACADEMIC PENALTY. ALSO DURING THIS TIME THE "CLASS STATUS REPORT" (SCH600), "CANCELLED CLASS LIST" (SCH730), "LIST OF CLASSES WITH ZERO ENROLLMENT" (SCH740), AND "LIST OF CLASSES FILLED AND CANCELLED" (SCH760) MIGHT BE USED BY BOTH REGISTRATION AND DIVISION PERSONNEL. THESE REPORTS MIGHT BE USED TO PROVIDE SUCH INFORMATION AS; IF A CLASS HAS BEEN OR NEEDS TO BE CANCELLED DUE TO LACK OF ENROLLMENT OR IF A CLASS HAS BEEN FILLED DUE TO MAXIMUM ENROLLMENT OR MAYBE ANOTHER SECTION FOR A PARTICULAR CLASS MAY NEED TO BE ADDED DUE TO ENROLLMENT DEMANDS. IT IS ALSO AT THIS TIME OF THE TERM WHEN THE "MISSING COURSE INFORMATION" REPORT (SCH670) IS RUN FREQUENTLY TO MONITOR THOSE CLASSES WHICH MAY NOT HAVE AN INSTRUCTOR ASSIGNED TO THEM AND/OR BUILDING AND ROOM ASSIGNMENTS OR THEY MAY BE MISSING DAYS AND TIMES. DIVISION PERSONNEL OR DESIGNEE USE THIS REPORT TO CLEAN UP ANY MISSING DATA THAT IS PERTINENT TO CENSUS REPORTING. WHEN USED AS A MANAGEMENT TOOL TO COMPLETE ALL MISSING ELEMENTS OF A TERM'S CLASS SCHEDULE UP FRONT, THE COLLEGE USUALLY FINDS THEIR CENSUS REPORTING PROCEDURES WILL BE A MUCH SMOOTHER PROCESS. ANOTHER CLASS SCHEDULE FEATURE DEALS WITH RELEASE TIME DATA. TO ASSIST PERSONNEL SCH110-RELEASE TIME UPDATE IS AN ONLINE SCREEN AVAILABLE TO ADD, CHANGE OR DELETE RELEASE TIME DATA. THERE IS ONE BATCH REPORT CURRENTLY AVAILABLE THAT USES THE RELEASE TIME DATA ENTERED VIA SCH110, SCH710-RELEASE TIME REPORT WILL PROVIDE INFORMATION ABOUT ALL INSTRUCTORS WHO HAVE RELEASE TIME ASSIGNED TO THEM FOR A PARTICULAR TERM OR RANGE OF TERMS. WITH MORE AND MORE COLLEGES BECOMING PART OF THE SIS SYSTEM EXPECTATIONS ARE THAT IN THE NEAR FUTURE THE PRODUCTIVITY ANALYSIS SYSTEM OR BETTER KNOWN AS 'PAS', WILL BE MODIFIED TO EXTRACT THE NECESSARY CLASS, RELEASE TIME AND REFERENCE DATA FROM THE STUDENT INFORMATION DATA BASES. UNTIL SUCH TIME SCHOOLS CAN GET THEIR CLASS AND REFERENCE DATA INTO FILES IN WHICH PAS WILL READ BY USING THE SIP008 PROCEDURE. SHOULD A COLLEGE HAVE RELEASE TIME DATA THAT PAS NEEDS TO TAKE INTO CONSIDERATION, THE FOLLOWING STEPS WOULD NEED TO BE TAKEN UPON THE COLLEGES PART: 1. UNDER THE COLLEGE'S TSO DATA SET, CREATE A MEMBER TO ENTER RELEASE TIME DATA. 2. THE BEGINNING OF THIS MEMBER SHOULD BE THE NECESSARY JCL TO SUBMIT PAS RELEASE TIME DATA, VCPAS34. PLEASE REFERENCE THE PAS MANUAL FOR DETAILS. BE SURE TO INCLUDE THESE TWO STATEMENTS AFTER THE JOB STATEMENT: /*ROUTE XEQ HOST /*ROUTE PRINT RRRRR WHERE 'RRRRR' IS YOUR REMOTE IDENTIFICATION. THESE TWO STATEMENTS SHOULD BEGIN IN COLUMN ONE. 3. FOLLOWING THE JCL FOR VCPAS34, BEGIN ENTERING ALL RELEASE TIME RECORDS. USE THE GUIDELINES ESTABLISHED IN THE PAS MANUAL FOR THE CORRECT FORMAT. 4. AFTER ALL RELEASE TIME RECORDS HAVE BEEN ENTERED THE LAST LINE IN YOUR TSO MEMBER SHOULD END WITH A '//' IN COLUMNS ONE AND TWO. 5. SAVE YOUR MEMBER. 6. SUBMIT THE MEMBER FOR EXECUTION. OTHER MANAGEMENT REPORTS AVAILABLE WITHIN THE SCHEDULING SUBSYSTEM ARE PROGRAMS TO PROVIDE INFORMATION ON "DEPARTMENT WORK- LOADS" (SCH650), WHICH REPORTS UTILIZATION FIGURES BY DEPARTMENTS. SCH660 IS AN "HOURLY ENROLLMENT REPORT" WHICH LIST BY CLASS STARTING HOUR ENROLLMENT WITHIN DIVISIONS. ALSO PROVIDED, IS A "ROOM UTILIZATION REPORT" (SCH610) LISTING ROOMS BY BEGINNING CLASS TIMES AND CLASSES THAT ARE BEING TAUGHT IN THE ROOM. THE SCHEDULING SYSTEM ALSO OFFERS THE CAPABILITY OF EXTRACTING SELECTED PARTS OF SCHEDULE DATA IN VARIOUS ORDERS TO BE USED TO DOWNLOAD FROM THE MAINFRAME TO A USERS PERSONAL COMPUTER (PC). THERE ARE TWO PROGRAMS WHICH SUPPORT THIS FEATURE; SCH770 WHICH WILL "SELECT AND BUILD PHYSICAL SEQUENTIAL TSO SCHEDULE FILES" AND SCH780 WHICH WILL TAKE THE SELECTED FILE FROM SCH770 AND "LOAD THE SCHEDULE DATA ONTO THE USER'S PERSONAL COMPUTER". ONCE A USER HAS THE CLASS DATA LOADED ONTO THEIR PC, THE USER IS FREE TO MANIPULATE AND TRANSFORM THIS DATA IN ANY WAY THEY DESIRE IN ORDER TO SATISFY THEIR OWN UNIQUE SCHEDULE NEEDS. ONCE THE SCHEDULE DATA IS LOADED ONTO THE USER'S PC THE DATA INTEGRITY, MAINTENANCE, AND BACKUP BECOMES THE RESPONSIBILITY OF THE PC USER. ONCE DOWNLOADED THE SCHEDULE DATA DOES NOT INTERACT WITH THE MAINFRAME SCHEDULE DATA IN ANY WAY. HOWEVER, SHOULD A USER DESIRE A NEW SELECTED SET OF SCHEDULE DATA FROM THE MAINFRAME, IT WOULD CONTAIN ANY MODIFICATIONS THAT HAD BEEN MADE ON THE MAINFRAME VIA SCH010 OR SCH020 SINCE THE USER HAD LAST EXTRACTED SCHEDULE DATA. AT THE CURRENT TIME THERE IS NO HISTORICAL CLASS DATA BASE AVAILABLE WITHIN THE STUDENT INFORMATION SYSTEM; THEREFORE, ALL HISTORICAL CLASS DATA WILL ACCUMULATE WITHIN THE CLASS DATA BASE. ONE EXCEPTION TO THIS IS THE CLASS REMARKS DATA, THERE IS A PROGRAM AVAILABLE TO DELETE CLASS REMARKS DATA BY TERM (SCH300). IF A COLLEGE WISHES THEY MAY RUN THIS PROGRAM AND DELETE OLD CLASS REMARKS DATA. 2.1 SYSTEM FLOWCHART ___________ ___________ ___________ ____________ ___________ ___________ ] CLASS ] ] CONTROL ] ] COURSE ] ]INSTRUCTOR] ] BUILDING] ] STUDENT ] ]DATA BASE] ]DATA BASE] ]DATA BASE] ]DATA BASE ] ]DATA BASE] ]DATA BASE] ]_________] ]_________] ]_________] ]__________] ]_________] ]_________] ] ] ] ] ] ] ]___________]___________]___________]____________]___________] ] ] ______]______ ]__SCH310___] ]CREATE FUT.] ............. INITIAL SCHEDULE ]QTR. SCHED.] GENERATION ]___________] ] ] ______]______ ] UPDATED ] ] CLASS ] ] DATA BASE ] ]___________] ] ]>>>>>>>>>>>>>>>>>>>>>>>] ] __________]____________ ] ] ] ] ______]______ ______]______ ] ]__SCH010___] ]__SCH020___] ] ]ADD,UPDATE,] ] CLASS ]....... SCHEDULE ] ]DEL CLASSES] ] REMARKS ] MAINTENANCE ] ]___________] ]___________] ] ] ] ] ]_____________________] ] ] ] ] ] ______]_______ ] ] UPDATED ] ]<<<<<<<<<<<<<<<<<<] CLASS ] ] DATA BASE ] ]____________] * ..... AVAILABLE SCHEDULE PRINT PROGRAMS __________________________]_________________________________ ] ] ] ] ] ] ] ] ] ] ______]______ ______]______ __]__________ ______]______ ______]______ ]__SCH500___] ]__SCH501___] ]__SCH591___] ]__SCH620___] ]__SCH700___] ] SCHEDULE ] ] NEWSPAPER ] ] SCHED. OF ] ] SCHED. OF ] ] SCHED. OF ] ] OF CLASSES] ] SCHEDULE ] ] CLASS-BRCC] ] CLASS- TCC] ] CLASS -DIV] ]___________] ]___________] ]___________] ]___________] ]___________] ] ] ..... CONTINUED SCHEDULE GENERATION ______]______ ]__SCH520___] ] ROOM AVAIL]>> * FOR SCHEDULE UPDATES, RETURN ]& CONFLICT ] TO SCHEDULE MAINTENANCE ]___________] AREA SCH010 AND SCH020 ] ]...REPORTS TO ASSIST PERSONNEL ] DURING TERM REGISTRATION ___________]_____________ ] ] ] ] ] ] ______]______ ] ______]______ ]__SCH551___] ] ]__SCH630___] ]CLASS LIST ] ] ] CENSUS ] ...CENSUS DATES ] W/CENSUS ] ] ] DATES RPT.] REPORTS ]___________] ] ]___________] ] ] ] ............ CLASS STATUS REPORTS _________________________]_________________________ ] ] ] ] ] ] ] ] ______]______ ______]______ ______]______ ______]______ ]__SCH600___] ]__SCH730___] ]__SCH740___] ]__SCH760___] ] CLASS ] ] CANCELLED ] ] CLASSES ] ] FILLED & ] ] STATUS ] ] CLASSES ] ] W/ZERO ENR] ] CANCEL CLS] ]___________] ]___________] ]___________] ]___________] * ...RELEASE TIME DATA ENTRY ] ______]______ ] CLASS ] ] DATA ] ] BASE ] ]___________] ] ]>>>>>>>>>>>>>>>>>>>>>>>>] ] ______]______ ] ]__SCH110___] ] ] RELEASE ]....... ADD AND MAINTAIN ] ] TIME UPDT.] RELEASE TIME DATA ] ]___________] ] ] ] ] ] ______]_______ ] ] UPDATED ] ]<<<<<<<<<<<<<<<<<<] CLASS DATA ] ] BASE ] ]____________] ] ] ______]______ ]__SCH710___] ] RELEASE ] ] TIME SUMM.] ]___________] * ]... TO GET DATA TO HOST FOR PAS ] SYSTEM UNTIL PAS IS MODIFIED ] TO EXTRACT DATA FROM SIS. ______]______ ]__SIP008___] ]SEND CLASS ]__________ ]& REF. DATA] / ______________ ] TO HOST ] / ]CLASS & REF.] ]___________] / ]FILES BUILT ] ] /_________] AT HOST ] ] ]____________] ______]_______ ]CREATE TSO ] ]MEMBER FOR ] ...TO GET RELEASE TIME ]RELEASE DATA] DATA TO HOST FOR PAS ]____________] ] ] ______]______ ] KEY IN ] ] VCPAS34 ] ] JCL ] ]___________] ] ] ______]______ ] KEY IN ] ] RELEASE ] ] TIME DATA ] ]___________] ] ]....SENDS RELEASE DATA TO APPROPRIATE ] FILES AT THE HOST. ______]______ ] SUBMIT ] ]TSO MEMBER ]---------- ] FOR ] / ______________ ] EXECUTION ] / ] UPDATE ] ]___________] / ]RELEASE TIME] ] /_________]FILES @ HOST] ] ]____________] ______]_______ ] SUBMIT ] ]PAS REPORTS ] ]EXEC. @ HOST] ]____________] ...PREPARING CLASS DATA FOR CENSUS ] REPORTING ] ______]______ ]__SCH670___] ] MISSING ] ]COURSE INFO] ]___________] ] ] ______]______ ] CLASS ] ] DATA ] ] BASE ] ]___________] ] ]>>>>>>>>>>>>>>>>>>>>>>>>] ] ______]______ ] ]__SCH010___] ] ]ADD,UPDATE,]....... UPDATE CLASS DATA ] ]DEL CLASSES] ] ]___________] ] ] ] ] ] ______]_______ ] ] UPDATED ] ]<<<<<<<<<<<<<<<<<<] CLASS DATA ] ] BASE ] ]____________] ] ] ______]______ ] EXECUTE ] ] CENSUS ] ...SUPPORTING CENSUS REPORTING ] SUBSYSTEM ] ]___________] ] ] /] ] / ] ]/ ] ______]_______ ]REPORT CLASS] ]CENSUS DATA ] ] TO VCCS ] ]____________] ............OTHER MANAGEMENT REPORTS _________________________]_________________________ ] ] ] ] ] ] ] ] ] ] ______]______ ______]______ ] ______]______ ______]______ ]__SCH610___] ]__SCH640___] ] ]__SCH650___] ]__SCH660___] ] ROOM ] ]BLD. ENROLL] ] ] DEPARTMENT] ] HOURLY ] ]UTILIZATION] ]SUMM WORKFL] ] ] WORKLOAD ] ] ENROLLMENT] ]___________] ]___________] ] ]___________] ]___________] ] ] ..LOADING CLASS SCHEDULE DATA ONTO ] A PERSONAL COMPUTER ] ______]______ ]__SCH770___] ] BLD SEQ ] ]SCHED. FILE] ]___________] ] ] ______]______ ]__SCH780___] ]LOAD SCHED ]__________ ]FILE TO PC ] / ______________ ]___________] / ] PERSONAL ] ] /_________] COMPUTER ] ] ]____________] ] ]..... DELETING CLASS DATA ______]______ ]__SCH300___] ]DELETE CLS ] ] REMARKS ] ]___________] * 3.0 DATA BASE DESIGN ---------------- THE SCHEDULING SUBSYSTEM WILL ACCESS THE FOLLOWING DATA BASES: 1. CLASS DATA BASE 2. CONTROL DATA BASE 3. COURSE DATA BASE 4. INSTRUCTOR DATA BASE 5. BUILDING DATA BASE 6. STUDENT DATA BASE THE FOLLOWING SECTION WILL DISPLAY THE SEGMENT LAYOUTS BEING UTILIZED BY THE SCHEDULE SUBSYSTEM AND THEIR PURPOSE. * 3.1 FILE LAYOUTS ------------ 1. BUILDING DATA BASE A. BUILDING MASTER SEGMENT PURPOSE: RECORDS DESCRIPTION, SQUARE FOOTAGE, AND FACILITIES AVAILABLE WITHIN THE BUILDING. ***************************************************************** * * * REVISED 01/13/83 * * ONE ENTRY PER BUILDING * * INCLUDE THIS MEMBER(BLDGMSTR) AFTER YOUR 01 DATA NAME * * REVISED 11/7/83 * * CHANGED SUITABILITY AND LAND-ID TO FILLER * * REVISED 12/13/83 * * ADDED SUITABILITY BACK * ******* SEGMENT KEY: BUILDING-ID ******* ***************************************************************** * 05 BUILDING PIC XXX. 05 ACCESSABILITY PIC X. 05 ACTIVE-INACTIVE PIC X. 05 AIR-CONDITIONED PIC X. 05 AREA-METERS PIC S9(5)V9 COMP-3. 05 BUILDING-NAME PIC X(36). 05 BUILDING-USE-CODE PIC X. 05 CAMPUS PIC X. 05 CAPACITY PIC S9(4) COMP-3. 05 CONDITION PIC X. 05 DATE-INVENTORY. 10 DATE-INV-YR PIC XX. 10 DATE-INV-MO PIC XX. 05 EST-REPLACE-COST PIC S9(4) COMP-3. 05 GROSS-AREA-FEET PIC S9(6) COMP-3. 05 FILLER PIC XX. 05 LOCATION PIC X(4). 05 NUMBER-OCCUPANTS PIC S9(4) COMP-3. 05 OWNERSHIP PIC X. 05 RENOVATION-COST PIC S9(4) COMP-3. 05 RENOVATION-YEAR PIC X(2). 05 RENT-LEASE-COST PIC S9(6) COMP-3. 05 SCHEV-BUILDING-CODE PIC X(4). 05 SUITABILITY PIC X. 05 YEAR-COMPLETED PIC X(4). 05 YEAR-R-T-D PIC X(2). 05 FILLER PIC X(20). * B. BUILDING ROOM SEGMENT PURPOSE: RECORDS DESCRIPTION OF EACH ROOM WITHIN A BUILDING. ***************************************************************** * * * REVISED 01/13/83 * * ONE ENTRY PER ROOM * * INCLUDE THIS MEMBER(BLDGROOM) AFTER YOUR 01 DATA NAME * * * * REVISED 11/7/83 * * CHANGED SUITABILITY TO FILLER * * * * REVISED 12/12/83 * * ADDED SUITABILITY BACK * * * ******* SEGMENT KEY: ROOM-NUMBER ******* ***************************************************************** * 05 ROOM-NUMBER PIC X(4). 05 ACCESSABILITY PIC X. 05 ACTIVE-INACTIVE PIC X. 05 AIR-CONDITIONED PIC X. 05 AREA-METERS PIC S9(5)V9 COMP-3. 05 DATE-INVENTORY. 10 DATE-INV-YR PIC XX. 10 DATE-INV-MO PIC XX. 05 DIVISION-CODE. 10 CAMPUS PIC X. 10 DIV-CODE PIC X. 05 FILLER PIC X(4). 05 ROOM-DESCRIPTION PIC X(20). 05 ROOM-DISCIPLINE PIC X(4). 05 ROOM-FUNCTION PIC X. 05 ROOM-PROGRAM PIC X(2). 05 ROOM-SCHEDULE-CODE PIC X. 05 ROOM-SIZE PIC S9(4) COMP-3. 05 ROOM-USE PIC X(3). 05 SQUARE-FEET PIC S9(6) COMP-3. 05 SUITABILITY PIC X. 05 FILLER PIC X(20). * C. BUILDING CLASS SEGMENT PURPOSE: RECORDS THE LOGICAL RELATIONSHIP BETWEEN THE BUILDING AND CLASS DATA BASES. ***************************************************************** * * * REVISED 10/05/82 * * ONE ENTRY PER BUILDING PER CLASS * * THIS IS TO ESTABLISH A LOGICAL RELATIONSHIP BETWEEN * * THE BUILDING AND CLASS DATA BASE * * INCLUDE THIS MEMBER(BLDGCLAS) AFTER YOUR 01 DATA NAME * * * ******* SEGMENT KEY:CLS-KEY ******* ***************************************************************** * 05 CLS-KEY PIC X(14). * 2. CLASS DATA BASE A. CLASS MASTER SEGMENT PURPOSE: RECORDS KEY INFORMATION FOR EACH CLASS MODIFICATION: THIS SEGMENT WILL NEED TO BE INCREASED TO SUPPORT THE ADDITIONAL ELEMENT CLASS-SEQUENCE-KEY FIELD NEEDED BY SCH620 TO PROVIDE THE USER WITH THE ABILITY OF CONTROLLING WHERE CLASSES WILL PRINT ON THEIR CLASS SCHEDULE. THE NECCESSARY ADDITIONS ARE NOTED AT THE BOTTOM OF THE LAYOUT. ***************************************************************** * * * REVISED 01/13/83 * * ONE ENTRY PER CLASS SECTION * * INCLUDE THIS MEMBER(CLSMASTR) AFTER YOUR 01 DATA NAME * * * * REVISED 9/5/85 BY RICHARD GILLETTE, ASC (V2.1) * * ADDED LAB-FEE AND REVENUE-CODE FOR LAB FEE. * * * * ************ THERE IS NO FILLER LEFT IN THE DATABASE * * ** NOTE ** FOR THIS SEGMENT. ANY FUTURE ADDITIONS * * ************ WILL REQUIRE DATA BASE CHANGE. * * * ******* SEGMENT KEY: CLASS-ID ******* ***************************************************************** * 05 CLASS-ID. 10 QUARTER-ID. 15 QTR-YR PIC XX. 15 QTR-CODE PIC X. 10 CAMPUS PIC X. 10 DEPARTMENT PIC XXXX. 10 COURSE-NUM PIC XXX. 10 SECTION-NO PIC XX. 10 LEC-LAB PIC X. 05 DIVISION-CODE. 10 CAMPUS PIC X. 10 DIV-CODE PIC X. 05 CLASS-END-DATE. 10 CLASS-END-YR PIC XX. 10 CLASS-END-MO PIC XX. 10 CLASS-END-DAY PIC XX. 05 CLASS-START-DATE. 10 CLASS-START-YR PIC XX. 10 CLASS-START-MO PIC XX. 10 CLASS-START-DAY PIC XX. 05 CLASS-STATUS PIC X. 05 COLLAPSE-CODE PIC X. 05 CREDITS PIC S99V9 COMP-3. 05 DATE-CENSUS. 10 CENSUS-YR PIC XX. 10 CENSUS-MO PIC XX. 10 CENSUS-DAY PIC XX. 05 DATE-LAST-DROP. 10 LAST-DROP-YR PIC XX. 10 LAST-DROP-MO PIC XX. 10 LAST-DROP-DAY PIC XX. 05 ENROLL-ACTUAL PIC S9(4) COMP-3. 05 ENROLL-MAX PIC S9(4) COMP-3. 05 HELD-SEATS PIC S9(4) COMP-3. 05 REQUIRED-TEST-CODE PIC S9(3) COMP-3. 05 SESSION PIC X. 05 SPECIAL-LOAD-HANDLING PIC X. 05 RESTRICT-CODE PIC X. 05 LAB-FEE PIC S9(3)V99 COMP-3. 05 REVENUE-CODE PIC 9(3) COMP-3. ***************************************************************** * ADDITIONS TO SUPPORT USER CLASS SEQUENCE CONTROL * ***************************************************************** 05 CLASS-SEQUENCE-KEY OCCURS 5 TIMES INDEXED BY CLASS-SEQ-SUB. 10 CAMPUS PIC X. 10 SEQUENCE-NO PIC XXXX. 05 FILLER PIC X(19). * B. CLASS DETAIL SEGMENT PURPOSE: RECORDS DETAIL CLASS DATA PERTAINING TO ROOMS, INSTRUCTORS, TIMES, AND DAYS. ***************************************************************** * * * REVISED 01/13/83 * * ONE ENTRY PER ROOM/INSTRUCTOR/TIME/DAYS PER CLASS SECTION * * INCLUDE THIS MEMBER(CLSDETAL) AFTER YOUR 01 DATA NAME * * * * REVISED 8/31/83 AT TNCC PER JSRCC * * CHANGED AVERAGE-WEEKLY-CONTACT, PERCENT-ALLOCATION TO * * FILLER AND ADDED INSTRUCTOR-CONTACT-HOURS AND DECREASED * * FILLER AT END OF SEGMENT. * * CHANGED INSTRUCT-WEEKS TO INSTRUCTOR-CREDIT-HOURS. * * * * REVISED 10/10/83 * * CHANGED INSTRUCTOR-CREDIT-HOURS FROM S99V99 COMP TO 99V99. * * ADDED REDEFINES ON INSTRUCTOR-CREDIT-HOURS AND INSTRUCTOR- * * CONTACT-HOURS OF PIC XXXX. * * * * REVISED 10/18/83 * * ADDED INSTRUCT-WEEKS AS A TEMPORARY FIELD DURING SIS * * CONVERSION, PIC X. DECREASED FILLER BY ONE. * * * ******* SEGMENT KEY: CLASS-REC-NO ******* ***************************************************************** * 05 CLASS-REC-NO PIC 9(2). 05 ADJUSTED-CONTACT PIC S99V999 COMP-3. 05 ADJUSTED-CREDITS PIC S99V999 COMP-3. 05 CAMP-BLDG-ROOM. 10 CAMPUS PIC X. 10 BUILDING PIC XXX. 10 ROOM-NUMBER PIC X(4). 05 CLASS-TIME. 10 CLASS-START-TIME. 15 CLASS-START-HR PIC XX. 15 CLASS-START-MIN PIC XX. 10 CLASS-END-TIME. 15 CLASS-END-HR PIC XX. 15 CLASS-END-MIN PIC XX. 05 DAYS-TAUGHT. 10 DAY1 PIC X. 10 DAY2 PIC X. 10 DAY3 PIC X. 10 DAY4 PIC X. 10 DAY5 PIC X. 10 DAY6 PIC X. 10 DAY7 PIC X. 05 INSTRUCTOR-CREDIT-HOURS PIC 99V99. 05 INS-CR-HOURS REDEFINES INSTRUCTOR-CREDIT-HOURS PIC XXXX. 05 SOCIAL-SECURITY PIC 9(9). 05 TEACHING-LOAD PIC X. 05 INSTRUCTOR-CONTACT-HOURS PIC 99V99. 05 INS-CONT-HOURS REDEFINES INSTRUCTOR-CONTACT-HOURS PIC XXXX. 05 INSTRUCT-WEEKS PIC X. 05 FILLER PIC X(18). * C. CLASS REMARKS SEGMENT PURPOSE: RECORDS SPECIAL REMARKS TO PROVIDE ADDITIONAL INFORMATION PERTAINING TO A CLASS, FOR SCHEDULING PURPOSES. MODIFICATION: THIS SEGMENT WILL NEED TO BE INCREASED TO ACCOMODATE THE REMARK-PRINT-CODE FIELD NEEDED TO CONTROL WHETHER A CLASS REMARK SHOULD PRINT BEFORE OR AFTER A CLASS FOR SCHEDULE PRINTING PURPOSES. ***************************************************************** * * * REVISED 01/13/83 * * ONE ENTRY PER REMARK NUMBER * * INCLUDE THIS MEMBER(CLSREMRK) AFTER YOUR 01 DATA NAME * * * ******* SEGMENT KEY: REMARK-RECORD-NO ******* ***************************************************************** * 05 REMARK-RECORD-NO PIC 9(2). 05 CLASS-REMARKS PIC X(64). ***************************************************************** * ADDITIONAL DATA ELEMENT NEEDED TO CONTROL WHERE REMARKS * * PRINT IN RELATION TO ITS CLASS DATA. * ***************************************************************** 05 REMARK-PRINT-CODE PIC X. * D. COMBINE CLASS SEGMENT PURPOSE: USED TO COMBINE TWO OR MORE CLASSES TOGETHER TO BE USED BY THE PAS SYSTEM. ***************************************************************** * * * REVISED 10/05/82 * * CODED DATA USED TO COMBINE >= 2 SECTIONS FOR PAS ANALYSIS * * INCLUDE THIS MEMBER(CLSCOMBW) AFTER YOUR 01 DATA NAME * * * ******* SEGMENT KEY: COMBINE-WITH-CLASS-ID ******* ***************************************************************** * 05 COMBINE-WITH-CLASS-ID. 10 QUARTER-ID. 15 QTR-YR PIC XX. 15 QTR-CODE PIC X. 10 CAMPUS PIC X. 10 DEPARTMENT PIC X(4). 10 COURSE-NUM PIC X(3). 10 SECTION-NO PIC XX. 10 LEC-LAB PIC X. * E. CLASS SUBSTITUTE TITLE SEGMENT PURPOSE: USED TO HAVE ALTERNATE TITLES PRINTED FOR CLASSES. ***************************************************************** * * * REVISED 10/05/82 * * ONE ENTRY PER CLASS * * INCLUDE THIS MEMBER(CLSSECST) AFTER YOUR 01 DATA NAME * * * ******* SEGMENT KEY: (NO KEY) ******* ***************************************************************** * 05 COURSE-TITLE-14 PIC X(14). 05 COURSE-TITLE-40 PIC X(40). F. CLASS STUDENT SEGMENT PURPOSE: THIS SEGMENT IS LOGICALLY CONNECTED TO THE STUDENT DATA BASE. ONE ENTRY WILL BE HERE FOR EACH STUDENT REGISTERED FOR A CLASS. ***************************************************************** * * * REVISED 01/13/83 * * ONE ENTRY PER CLASS PER STUDENT * * THIS IS TO ESTABLISH A LOGICAL RELATIONSHIP BETWEEN THE * * THE CLASS AND STUDENT DATA BASE * * INCLUDE THIS MEMBER(CLASSTUD) AFTER YOUR 01 DATA NAME * * * ******* SEGMENT KEY: STU-KEY ******* ***************************************************************** * 05 STU-KEY PIC 9(9). * 3. CONTROL DATA BASE A. CONTROL CAMPUS PURPOSE: RECORDS CAMPUS AND COLLEGE NAME AND ADDRESS ***************************************************************** * * * REVISED 1/21/83 * * ONE ENTRY PER CAMPUS * * INCLUDE THIS MEMBER(CTLCAMPM) AFTER YOUR 01 DATA NAME * * * ******* SEGMENT KEY: SEGMENT-TYPE/CAMPUS ******* ***************************************************************** * 05 LL-SEGMENT-INDICATOR PIC S9(4) COMP VALUE +210. 05 CAMPUS-SEGMENT-KEY. 10 SEGMENT-TYPE PIC XX. 10 CAMPUS PIC X. 10 FILLER PIC X(7). 05 CAMPUS-NAME PIC X(16). 05 CITY PIC X(16). 05 COLLEGE-CODE PIC X(3). 05 COLLEGE-LET PIC X. 05 COLLEGE-NAME PIC X(38). 05 COLLEGE-NAME-HDING PIC X(70). 05 NUMBER-CAMPUS PIC 9(2). 05 STATE PIC X(2). 05 STREET-ADDRESS PIC X(22). 05 ZIPCODE PIC X(9). 05 FILLER PIC X(19). * B. CONTROL DIVISION PURPOSE: RECORDS DIVISION NAME, CODE, CHAIRPERSON AND STATUS ***************************************************************** * * * REVISED 11/07/82 * * ONE ENTRY PER DIVISION * * INCLUDE THIS MEMBER(CTLDIVM ) AFTER YOUR 01 DATA NAME * * * ******* SEGMENT KEY: SEGMENT-TYPE/DIVISION-CODE ******* ***************************************************************** * 05 LL-SEGMENT-INDICATOR PIC S9(4) COMP VALUE +92. 05 DIV-SEGMENT-KEY. 10 SEGMENT-TYPE PIC XX. 10 DIVISION-CODE. 15 CAMPUS PIC X. 15 DIV-CODE PIC X. 10 FILLER PIC X(6). 05 ACTIVE-INACTIVE PIC X. 05 DIVISION-NAME PIC X(32). 05 NAME-FIRST PIC X(10). 05 NAME-INITIAL PIC X. 05 NAME-LAST PIC X(16). 05 FILLER PIC X(20). * C. CONTROL MESSAGE PURPOSE: RECORDS MESSAGE DATA DISPLAYED BY VARIOUS PROGRAMS ***************************************************************** * * * REVISED 1/21/83 * * ONE ENTRY PER MESSAGE CODE * * INCLUDE THIS MEMBER(CTLMESSG) AFTER YOUR 01 DATA NAME * * * ******* SEGMENT KEY: SEGMENT-TYPE/MESSAGE-CODE ******* ***************************************************************** * 05 LL-SEGMENT-INDICATOR PIC S9(4) COMP VALUE +315. 05 MESSAGE-SEGMENT-KEY. 10 SEGMENT-TYPE PIC XX. 10 MESSAGE-CODE PIC X(6). 10 FILLER PIC X(2). 05 MESSAGE-LINE-COUNT PIC S9(4) COMP-3. 05 MESSGE PIC X(70) OCCURS 1 TO 4 TIMES DEPENDING ON MESSAGE-LINE-COUNT. 05 FILLER PIC X(20). * D. CONTROL PROGRAM OPTION PURPOSE: RECORDS PROGRAM OPTION DATA USED TO CONTROL HOW A PROGRAM IS TO OPERATE FOR A COLLEGE'S SPECIFIC NEEDS. ***************************************************************** * * * CREATED 8/29/83 AT TNCC * * ONE ENTRY PER PROGRAM FOR PROGRAM OPTIONS * * INCLUDE THIS MEMBER(CTLPROPT) AFTER YOUR 01 DATA NAME * * * * REVISED 9/29/83 AT TNCC * * ADDED OPTION-NUM TO PROGRAM-SEGEMENT-KEY. * * * ******* SEGMENT KEY: SEGMENT-TYPE/PROGRAM-ID/OPTION-NUM ******* ***************************************************************** * 05 LL-SEGMENT-INDICATOR PIC S9(4) COMP VALUE +122. 05 PROGRAM-SEGMENT-KEY. 10 SEGMENT-TYPE PIC XX. 10 PROGRM-ID PIC X(6). 10 OPTION-NUM PIC XX. 05 PROGRAM-DEFINED-DATA PIC X(90). 05 FILLER PIC X(20). * E. CONTROL TERM PURPOSE: RECORDS TERM NAME AND YEAR, BEGINNING AND ENDING DATES, CENSUS AND WITHDRAWAL DATES, TUITION DATA, CONTROL FLAGS AND OTHER PERTINENT INFORMATION TO UNIQUE TO A PARTICULAR TERM. ***************************************************************** * * * REVISED 01/21/83 * * ONE ENTRY PER TERM PER YEAR * * INCLUDE THIS MEMBER(CTLQUART) AFTER YOUR 01 DATA NAME * * * * REVISED 9/12/85 (V2.2) * * CHANGED 4 BYTE FILLER TO FIN-AID-ACAD-YEAR PIC X(4). * * ADDED ACT-FEE-OPT, ACT-FEE-AMT, MAX-ACT-FEE, * * MAX-ACT-CREDITS, EXCL-OFF-CAMPUS. * * * * REVISED 4/17/86 (V2.2) * * CHANGED 4 BYTE FILLER TO FIN-AID-ACAD-YEAR PIC X(4). * * ADDED ACT-FEE-OPT, ACT-FEE-AMT, MAX-ACT-FEE, * * MAX-ACT-CREDITS, EXCL-OFF-CAMPUS. * * * * REVISED 5/29/86 (V2.9) * * CHANGED FILLER AT END FROM 12 TO 10 * * ADDED AKT-FLAG MERGE-LEC-LAB-FLAG * * * ******* SEGMENT KEY: SEGMENT-TYPE/QUARTER-ID ******* ***************************************************************** * 05 LL-SEGMENT-INDICATOR PIC S9(4) COMP VALUE +83. 05 QUARTER-SEGMENT-KEY. 10 SEGMENT-TYPE PIC XX. 10 QUARTER-ID PIC X(3). 10 FILLER PIC X(5). 05 CLASS-END-DATE. 10 CLASS-END-YR PIC XX. 10 CLASS-END-MO PIC XX. 10 CLASS-END-DAY PIC XX. 05 CLASS-START-DATE. 10 CLASS-START-YR PIC XX. 10 CLASS-START-MO PIC XX. 10 CLASS-START-DAY PIC XX. 05 CONTRACT-TUITION-RATE PIC S999V99 COMP-3. 05 CUMM-INFO-FLAG PIC X. 05 FIN-AID-QTR-NO PIC 9. 05 FILLER PIC X. 05 QUARTER-NAME. 10 QTR-NAME PIC X(6). 10 QTR-YEAR PIC XX. 05 TUITION-RATE-IN PIC S999V99 COMP-3. 05 FIN-AID-ACAD-YEAR. 10 FIN-AID-ACAD-BEG-YR PIC XX. 10 FIN-AID-ACAD-END-YR PIC XX. 05 TUITION-RATE-OUT PIC S999V99 COMP-3. 05 DATE-CENSUS. 10 CENSUS-YR PIC XX. 10 CENSUS-MO PIC XX. 10 CENSUS-DAY PIC XX. 05 DATE-LAST-DROP. 10 LAST-DROP-YR PIC XX. 10 LAST-DROP-MO PIC XX. 10 LAST-DROP-DAY PIC XX. 05 ACT-FEE-OPT PIC X(2). 05 ACT-FEE-AMT PIC S9(3)V99 COMP-3. 05 MAX-ACT-FEE PIC S9(3)V99 COMP-3. 05 MAX-ACT-CREDITS PIC 9(2). 05 EXCL-OFF-CAMPUS PIC X(1). 05 AKT-FLAG PIC X(1). 05 MERGE-LEC-LAB-FLAG PIC X(1). 05 FILLER PIC X(10). * 4. COURSE DATA BASE A. COURSE DEPARTMENT SEGMENT PURPOSE: RECORDS DEPARTMENT DESCRIPTION AND STATUS. ***************************************************************** * * * REVISED 01/13/83 * * ONE ENTRY PER DEPARTMENT * * INCLUDE THIS MEMBER(CRSDEPT ) AFTER YOUR 01 DATA NAME * * * ******* SEGMENT KEY: DEPARTMENT ******* ***************************************************************** * 05 DEPARTMENT PIC X(4). 05 ACTIVE-INACTIVE PIC X. 05 DEPARTMENT-BUDGET-CODE PIC S9(3) COMP-3. 05 DEPARTMENT-FUND-RATIO PIC S9(3) COMP-3. 05 DEPARTMENT-NAME PIC X(30). 05 FILLER PIC X(20). * B. COURSE SEGMENT PURPOSE: RECORDS COURSE TITLE, CREDITS, CONTACT HOURS, FIRST AND LAST TERM AND YEAR COURSE WAS VALID. ***************************************************************** * * * REVISED 01/13/83 * * ONE ENTRY PER COURSE * * INCLUDE THIS MEMBER(CRSSEGM ) AFTER YOUR 01 DATA NAME * * WHOLE RECORD CAN BE REPEATED. MOST CURRENT RECORD IS FOR * * CURRENT USE. OLDER RECORDS ARE RETAINED TO PROVIDE ACCESS * * TO EARLIER VERSIONS OF TITLES, CREDIT HOURS, LAB REQ. ETC. * * * * REVISED 04/6/84 AT TNCC (V1.5) * * CHANGED CREDITS AND CONTACT-HOURS TO REFLECT ACTUAL NAME, * * CREDITS-LEC, AND CONTACT-HR-TOT. * * * ******* SEGMENT KEY: COURSE-NUM (NON-UNIQUE) ******* ***************************************************************** * 05 COURSE-NUM PIC X(3). 05 ACTIVE-INACTIVE PIC X. 05 CONTACT-HR-TOT PIC 9(2). 05 CONTACT-HR-LAB PIC 9(2). 05 CONTACT-HR-LEC PIC 9(2). 05 COURSE-TITLE-14 PIC X(14). 05 COURSE-TITLE-40 PIC X(40). 05 CREDITS-LEC PIC S9(2)V9 COMP-3. 05 CREDITS-LAB PIC S9(2)V9 COMP-3. 05 GRADE-OPTION PIC X. 05 MAX-VAR-CR PIC S99V9 COMP-3. 05 MIN-VAR-CR PIC S99V9 COMP-3. 05 PASS-FAIL-CODE PIC X. 05 QTR-FIRST-VALID. 10 FIRST-VALID-YR PIC XX. 10 FIRST-VALID-QTR PIC X. 05 QTR-LAST-VALID. 10 LAST-VALID-YEAR PIC XX. 10 LAST-VALID-QTR PIC X. 05 FILLER PIC X(20). 05 DIVISION-AUTHORIZED-COUNT PIC S9(4) COMP-3. 05 DIVISION-AUTHORIZED PIC XX OCCURS 1 TO 25 TIMES DEPENDING ON DIVISION-AUTHORIZED-COUNT. * C. COURSE REQUISITE PURPOSE: RECORDS ANY 'PRE' OR 'CO' REQUISITE DATA PERTAINING TO A COURSE. ***************************************************************** * * * REVISED 01/13/83 * * ONE ENTRY PER REQUISITE PER COURSE * * INCLUDE THIS MEMBER(CRSREQ) AFTER YOUR 01 DATA NAME * * * ******* SEGMENT KEY: (NO KEY FOR THIS SEGMENT) ******* ***************************************************************** * 05 REQUISITE-CODE PIC X. 05 COURSE-ID. 10 DEPARTMENT PIC XXXX. 10 COURSE-NUM PIC XXX. 05 FILLER PIC X(20). * 5. INSTRUCTOR DATA BASE A. INSTRUCTOR SEGMENT PURPOSE: RECORDS INSTRUCTOR NAME, DEPARTMENT ASSIGNED, ADVISOR CODE, TERM AND YEAR LAST TAUGHT, OFFICE LOCATION, AND STATUS. ***************************************************************** * * * REVISED 01/13/83 * * ONE ENTRY PER INSTRUCTOR OR OTHER STAFF MEMBER * * INCLUDE THIS MEMBER(INSTRUCR) AFTER YOUR 01 DATA NAME * * * ******* SEGMENT KEY: SOCIAL-SECURITY ******* ***************************************************************** * 05 SOCIAL-SECURITY PIC 9(9). 05 ACTIVE-INACTIVE PIC X. 05 ADVISOR. 15 CAMPUS PIC X. 15 DIV-CODE PIC X. 15 ADV-CODE PIC XX. 05 CAMP-BLDG-ROOM. 10 CAMPUS PIC X. 10 BUILDING PIC XXX. 10 ROOM-NUMBER PIC X(4). 05 COUNSELOR PIC X(2). 05 NAME-FIRST PIC X(10). 05 NAME-INITIAL PIC X. 05 NAME-LAST PIC X(16). 05 NAME-SUFFIX PIC XX. 05 QTR-LAST-TAUGHT. 10 QTR-YR PIC XX. 10 QTR-CODE PIC X. 05 TEACHING-LOAD PIC X. 05 FILLER PIC X(20). * B. INSTRUCTOR RELEASE SEGMENT PURPOSE: RECORDS RELEASE TIME ASSIGNMENTS. ***************************************************************** * * * REVISED 01/13/83 * * ONE ENTRY PER RELEASE TIME ASSIGNMENT PER FACULTY MEMBER * * INCLUDE THIS MEMBER(INSRTIME) AFTER YOUR 01 DATA NAME * * * ******* SEGMENT KEY: QUARTER-ID (NON UNIQUE) ******* ***************************************************************** * 05 QUARTER-ID. 10 QUARTER-YR PIC XX. 10 QUARTER-CODE PIC X. 05 RELEASE-TIME-CREDITS PIC S99V99 COMP-3. 05 DEPARTMENT PIC X(4). 05 DEVELOPMENTAL PIC X. 05 DIVISION-CODE. 10 CAMPUS PIC X. 10 DIV-CODE PIC X. 05 INSTRUCTION-CODE PIC X. 05 RELEASE-TYPE PIC X(4). 05 FILLER PIC X(19). C. INSTRUCTOR CLASS SEGMENT PURPOSE: RECORDS THE LOGICAL RELATIONSHIP BETWEEN THE INSTRUCTOR AND CLASS DATA BASES. ***************************************************************** * * * CREATED 3/25/83 AT TNCC * * ONE ENTRY PER INSTRUCTOR PER CLASS * * THIS IS TO ESTABLISH A LOGICAL RELATIONSHIP BETWEEN THE * * THE INSTRUCTOR AND CLASS DATA BASE * * INCLUDE THIS MEMBER(INSTCLAS) AFTER YOUR 01 DATA NAME * * * ******* SEGMENT KEY: CLS-KEY ******* ***************************************************************** * 05 CLS-KEY PIC X(14). * 6. STUDENT DATA BASE A. STUDENT MASTER SEGMENT PURPOSE: RECORDS DEMOGRAPHIC AND DESCRIPTIVE DATA PERTAINING TO A STUDENT. ****************************************************************** * * * REVISED 01/13/83 * * ONE ENTRY PER STUDENT. CONTAINS DEMOGRAPHIC AND * * DESCRIPTIVE DATA. * * INCLUDE THIS MEMBER(STUDENTM) AFTER YOUR 01 DATA NAME. * * * * REVISED 2/14/85 (V2.0) * * ADDED TRANSCRIPT-AUDIT-CNTL PIC XX, CURRICULUM-ADV-STD-EVAL * * PIC XXX, REDUCED FILLER TO 62. * * * * REVISED 4/02/85 (V2.0) * * ADDED QTR-LAST-FIN-AID PIC XXX AND CHANGED TWO-TWO-CURR * * PIC X TO FIN-AID-INFO PIC X, ADDED TWO-TWO-CURR PIC X(6), * * BACKOUT-FLAG PIC X, PREV-DEGREE-TYPE PIC XX. * * * * REVISED 7/19/85 (V2.1) * * CHANGED CURRICULUM-ADV-STD-EVAL PIC XXX TO FILLER. * * * ******* SSA KEY NAME: SOCSECNO ******* ******* SEGMENT KEY: SOCIAL-SECURITY ******* ****************************************************************** * 05 SOCIAL-SECURITY PIC 9(9). 05 ADM-FILE-COMP PIC X(1). 05 ADVISOR. 10 ADV-CAMPUS PIC X(1). 10 ADV-DIV-CODE PIC X(1). 10 ADV-CODE PIC X(2). 05 APPLICATION-LABEL PIC X(1). 05 BAD-CHECK PIC X(1). 05 CATALOG-YEAR. 10 CATALOG-BEG-YR PIC X(2). 10 CATALOG-END-YR PIC X(2). 05 CITIZENSHIP PIC X(1). 05 CITY PIC X(16). 05 COLLEGE-LAST PIC X(4). 05 CONTRACT-CLASS-ELIG-QTR. 10 ELIG-QTR-YEAR PIC X(2). 10 ELIG-QTR-CODE PIC X(1). 05 COUNSELOR PIC X(2). 05 CURR-LEVEL PIC X(1). 05 CURRICULUM PIC X(3). 05 DATE-APPLICATION. 10 APPLICATION-YR PIC X(2). 10 APPLICATION-MO PIC X(2). 10 APPLICATION-DAY PIC X(2). 05 DATE-BIRTH. 10 BIRTH-YR PIC X(2). 10 BIRTH-MO PIC X(2). 10 BIRTH-DAY PIC X(2). 05 DECEASED-CODE PIC X(1). 05 DISMISSAL-CODE PIC X(1). 05 ELIGIBLE-SPECIAL-AGY-RATE PIC X(1). 05 SENIOR-CITIZEN PIC X(1). 05 FOLDER-LOCATION. 10 CAMPUS PIC X(1). 10 DIV-CODE PIC X(1). 05 FORMER-NAME PIC X(16). 05 GRADE-AVG-CUMM PIC S9V9(3) COMP-3. 05 GRADE-AVG-QTR PIC S9V9(3) COMP-3. 05 GRADE-POINT-CUMM PIC S9(3) COMP-3. 05 GRADE-POINT-QTR PIC S9(3) COMP-3. 05 HIGH-SCHOOL-CODE PIC 9(6). 05 HOURS-ATT-CUMM PIC S9(3) COMP-3. 05 HOURS-ATT-QTR PIC S9(3) COMP-3. 05 HOURS-COMP-CUMM PIC S9(3) COMP-3. 05 HOURS-COMP-QTR PIC S9(3) COMP-3. 05 HOW-REGISTERED-CODE PIC X(1). 05 JURISDICTION PIC X(3). 05 LIBRARY-CAMPUS PIC X(1). 05 LIBRARY-CARD-NUM PIC X(5). 05 LIBRARY-CARD-QTR. 10 LIBRARY-CARD-YR PIC X(2). 10 LIBRARY-CARD-CODE PIC X(1). 05 MILITARY-DISCH. 10 MIL-DISCH-YR PIC X(2). 10 MIL-DISCH-MO PIC X(2). 05 TWO-TWO-CURR PIC X(6). 05 NAME-LAST PIC X(16). 05 NAME-FIRST PIC X(10). 05 NAME-INITIAL PIC X(1). 05 NAME-SUFFIX PIC X(2). 05 PHONE-BUSINESS. 10 PHONE-BUS-AREA PIC X(3). 10 PHONE-BUS-EXCH PIC X(3). 10 PHONE-BUS-EXTEN PIC X(4). 05 PHONE-HOME. 10 PHONE-HOME-AREA PIC X(3). 10 PHONE-HOME-EXCH PIC X(3). 10 PHONE-HOME-EXTEN PIC X(4). 05 QTR-ADMISSION. 10 ADM-QTR-YR PIC X(2). 10 ADM-QTR-CODE PIC X(1). 05 QTR-FIRST-ENROL. 10 QTR-FIRST-YR PIC X(2). 10 QTR-FIRST-CODE PIC X(1). 05 QTR-GRADUATED. 10 QTR-GRAD-YR PIC X(2). 10 QTR-GRAD-CODE PIC X(1). 05 QTR-LAST-ENROL. 10 QTR-LAST-YR PIC X(2). 10 QTR-LAST-CODE PIC X(1). 05 QTR-PREV-ENROL. 10 QTR-PREV-YR PIC X(2). 10 QTR-PREV-CODE PIC X(1). 05 QTR-REAPPLY. 10 QTR-REAPPLY-YR PIC X(2). 10 QTR-REAPPLY-CODE PIC X(1). 05 RACE PIC X(1). 05 REACTIVATE-FLAG PIC X(1). 05 RI-PRINT-FLAG PIC X(1). 05 SELF-ADVISE PIC X(1). 05 SEX PIC X(1). 05 SPECIAL-SERVICES PIC X(1). 05 STATE PIC X(2). 05 STATUS-CURR PIC X(1). 05 STATUS-PRIOR PIC X(1). 05 STREET-ADDRESS PIC X(22). 05 STUDENT-SIP-CODE PIC X(1). 05 STUDENT-TYPE PIC X(1). 05 SUSPENDED-CODE PIC X(1). 05 TRANSFER-HOURS PIC S9(3) COMP-3. 05 TUITION-STMT-MAILED PIC X(1). 05 FIN-AID-INFO PIC X(1). 05 VETERAN-BENEFIT-STATUS PIC X(1). 05 VETERAN-CERT PIC X(2). 05 VETERAN-CLOCK-HR PIC 9(2). 05 VETERAN-CR-HRS PIC 9(2). 05 VETERAN-DEV-CLHR PIC 9(2). 05 VETERAN-DEV-CRHR PIC 9(2). 05 VETERAN-ENTITLE-CODE PIC X(1). 05 VETERAN-FILE PIC X(10). 05 VETERAN-NCD-CLHR PIC 9(2). 05 VETERAN-NCD-CRHR PIC 9(2). 05 VISA-NUMBER PIC X(6). 05 VISA-TYPE PIC X(6). 05 YEAR-H-S-GRAD-GED PIC X(2). 05 YEAR-LAST-COLL PIC X(2). 05 ZIPCODE PIC X(9). 05 VA-ACTIVITY-FLAG PIC X(1). 05 TUITION-TYPE PIC X(4). 05 TRANSCRIPT-AUDIT-CNTL PIC XX. 05 FILLER PIC X(3). 05 QTR-LAST-FIN-AID. 10 QTR-LAST-FIN-YR PIC XX. 10 QTR-LAST-FIN-CODE PIC X. 05 BACKOUT-FLAG PIC X. 05 PREV-DEGREE-TYPE PIC XX. 05 FILLER PIC X(56). * B. STUDENT REGISTRATION SEGMENT PURPOSE: RECORDS AN ENTRY FOR EACH COURSE A STUDENT IS ENROLLED. ****************************************************************** * * * REVISED 10/05/82 * * ONE ENTRY PER COURSE FOR WHICH STUDENT IS REGISTERED * * INCLUDE THIS MEMBER(STUREGIS) AFTER YOUR 01 DATA NAME * * * * REVISED 1/6/84 AT TNCC * * ADDED SR-CIT-LATE-ADD AND DECREASED FILLER BY 1 * * * * REVISED 04/03/84 AT JSRCC (V1.5) * * ADDED ACCOUNT-CODE AND DECREASED FILLER BY 4 * * * * REVISED 11/29/84 AT JSRCC (V2.0) * * ADDED REPEATED-CLASS-FLAG AND DECREASED FILLER BY 1 * * * ******* SEGMENT KEY: CLASS-ID ******* ****************************************************************** * 05 CLASS-ID. 10 QUARTER-ID. 15 QTR-YR PIC XX. 15 QTR-CODE PIC X. 10 CAMPUS PIC X. 10 DEPARTMENT PIC X(4). 10 COURSE-NUM PIC X(3). 10 SECTION-NO PIC XX. 10 LEC-LAB PIC X. 05 AID-AUTHORIZED-CODE PIC X. 05 CREDITS PIC S9(2)V9 COMP-3. 05 DATE-LAST-ATTEND. 10 DATE-LAST-MO PIC XX. 10 DATE-LAST-DAY PIC XX. 05 DATE-WITHDREW. 10 WITHDREW-MO PIC XX. 10 WITHDREW-DAY PIC XX. 05 GRADE PIC X. 05 SESSION PIC X. 05 WITHDRAW-TYPE PIC X. 05 WITHDRAW-NOTIFY-FLAG PIC X. 05 SR-CIT-LATE-ADD PIC X. 05 ACCOUNT-CODE PIC X(4). 05 REPEATED-CLASS-FLAG PIC X. 05 FILLER PIC X(34). 4.0 PROGRAM DOCUMENTATION --------------------- THE FOLLOWING TABLE SUMMARIZES THE PROGRAMS WHICH COMPRISE THE SCHEDULING SUBSYSTEM: ------------------------------------------------------------------- PROGRAM ] DESCRIPTION -----------+------------------------------------------------------- SCH010 ] ADD, UPDATE, DELETE CLASSES -----------+------------------------------------------------------- SCH020 ] CLASS REMARKS DATA ENTRY -----------+------------------------------------------------------- SCH060 ] CLASS BY ROOM INQUIRY -----------+------------------------------------------------------- SCH110 ] RELEASE TIME UPDATE -----------+------------------------------------------------------- SCH130 ] ONLINE CLASS ENROLLMENT -----------+------------------------------------------------------- SCH300 ] DELETE REMARKS-DTL BY TERM -----------+------------------------------------------------------- SCH310 ] CREATE FUTURE TERM SCHEDULE -----------+------------------------------------------------------- SCH330 ] STUDENT ENROLLMENT STATUS REPORT -----------+------------------------------------------------------- SCH335 ] CLASS CHANGE REPORT -----------+------------------------------------------------------- SCH500 ] SCHEDULE OF CLASSES -----------+------------------------------------------------------- SCH501 ] NEWSPAPER SCHEDULE - TCC -----------+------------------------------------------------------- SCH520 ] ROOM AVAILABLE AND CONFLICT REPORT -----------+------------------------------------------------------- SCH550 ] CLASS DETAIL LISTING -----------+------------------------------------------------------- SCH551 ] CLASS LISTING WITH CENSUS DATES -----------+------------------------------------------------------- SCH560 ] SCHEDULE OF EVENING CLASSES -----------+------------------------------------------------------- SCH570 ] SCHEDULE OF OFF-CAMPUS CLASSES -----------+------------------------------------------------------- SCH575 ] OFF-CAMPUS CREDIT CLASSES -----------+------------------------------------------------------- SCH580 ] SCHEDULE OF CLASSES - FINAL -----------+------------------------------------------------------- SCH590 ] TERM SCHEDULE -----------+------------------------------------------------------- SCH591 ] SCHEDULE OF CLASSES - BRCC -----------+------------------------------------------------------- SCH600 ] CLASS STATUS REPORT -----------+------------------------------------------------------- SCH610 ] ROOM UTILIZATION REPORT -----------+------------------------------------------------------- SCH620 ] TERM CLASS SCHEDULE - TCC -----------+------------------------------------------------------- SCH621 ] NEWSPAPER CLASS SCHEDULE -----------+------------------------------------------------------- SCH630 ] CENSUS DATES REPORT * PROGRAM ] DESCRIPTION ------------------------------------------------------------------- SCH640 ] BUILD ENROLLMENT SUMMARY WORKFILE -----------+------------------------------------------------------- SCH650 ] DEPARTMENT WORKLOAD -----------+------------------------------------------------------- SCH660 ] HOURLY ENROLLMENT SUMMARY -- NRCC HASN'T DEVELOPED YET -----------+------------------------------------------------------- SCH670 ] MISSING COURSE INFORMATION -----------+------------------------------------------------------- SCH680 ] EDIT EXPANDED CLASS TITLE FILE -----------+------------------------------------------------------- SCH690 ] OFF-CAMPUS CONSORTIUM REPORT -----------+------------------------------------------------------- SCH700 ] CLASS SCHEDULE BY DIVISION -----------+------------------------------------------------------- SCH710 ] RELEASE TIME REPORT -----------+------------------------------------------------------- SCH730 ] CANCELLED CLASS LIST -----------+------------------------------------------------------- SCH740 ] LIST OF CLASSES WITH ZERO ENROLLMENT -----------+------------------------------------------------------- SCH760 ] LIST OF CLASSES FILLED AND CANCELLED -----------+------------------------------------------------------- SCH770 ] BUILDS SEQUENTIAL SELECTED SCHEDULE FILES -----------+------------------------------------------------------- SCH780 ] DOWN LOAD SELECTED SCHEDULE FILES TO PC -----------+------------------------------------------------------- SCH790 ] PRINT CLASS SCHEDULE -----------+------------------------------------------------------- SCH800 ] OFF CAMPUS SCHEDULE BY MILITARY STATUS -----------+------------------------------------------------------- 4.1 PROGRAM SUMMARIES ----------------- SCH010 - ADD, UPDATE, DELETE CLASSES THIS SCREEN PROVIDES THE ABILITY TO ADD NEW CLASSES, CHANGE EXISTING CLASS DATA OR DELETE CLASSES FROM AN EXISTING SCHEDULE. IF A FUTURE TERM SCHEDULE WAS NOT BUILT, THEN SCH010 WILL BE USED TO CREATE A NEW CLASS SCHEDULE BY ADDING ALL CLASSES TO BE OFFERED. SCH020 - CLASS REMARKS DATA ENTRY THIS SCREEN IS USED TO ADD UNIQUE REMARKS ABOUT A PARTICULAR CLASS. THE ADDITIONAL DATA ELEMENT, REMARK-PRINT-CODE, OFFERS THE ABILITY TO CONTROL WHETHER REMARKS PRINT BEFORE OR AFTER A CLASS. SCH060 - CLASS BY ROOM INQUIRY THIS SCREEN IS USED TO DISPLAY ALL CLASSES FOR A SPECIFIC BUILDING AND ROOM ENTERED BY THE USER. IT LISTS ALL CLASSES FOR A SPECIFIC TERM. IT SHOWS KEY SCHEDULING DATA RELATED TO WHEN EACH CLASS IS TAUGHT, (CLASS DATES, DAYS, AND TIMES). THE ACTUAL AND MAXIMUM ENROLLMENT FOR EACH CLASS ARE SHOWN, ALONG WITH THE CLASS SESSION AND STATUS CODES. THE USER CAN ALSO OBTAIN THE INSTRUCTOR'S NAME OR THE CLASS TITLE BASED ON A FIELD CALLED "VIEW" ON THE SCREEN. THIS SCREEN SUPPORTS LOGICAL PAGING OF MULTIPLE OUTPUT SCREENS. SCH110 - RELEASE TIME UPDATE THIS SCREEN IS USED TO UPDATE THE RELEASE TIME SEGMENT OF THE INSTRUCTOR DATA BASE. ADDITIONS, CHANGES AND/OR DELETIONS CAN ALL BE MADE WITH THIS ONLINE PROGRAM. THIS PROGRAM HAS NOT BEEN RELEASED FOR PRODUCTION AT THIS TIME. SCH130 - ONLINE CLASS ENROLLMENT THIS ONLINE PROGRAM WILL DISPLAY CLASS INFORMATION FOR A RANGE OF CLASSES BASED ON CRITERIA ENTERED ON THE SCREEN. THE INFORMATION DISPLAYED INCLUDES CAMPUS, DEPARTMENT, COURSE NUMBER, SECTION, SESSION, LECTURE-LAB INDICATOR, CLASS TITLE (THE PROGRAM WILL DISPLAY SUBSTITUTE TITLE IF IT EXISTS, IF NOT THE COURSE TITLE WILL BE DISPLAYED), DAYS AND TIMES (IF THERE ARE MORE THAN ONE DETAIL RECORDS AN '*' IS DISPLAYED BESIDE THE DAYS), CLASS STATUS, MAXIMUM AND ACTUAL ENROLLMENT. THE NUMBER CLASSES DISPLAYED APPEARS IN THE LOWER RIGHT CORNER AS THE USER SCROLLS THROUGH THE OUTPUT WITH THE TOTAL NUMBER OF CLASSES THAT MEET THE SELECTION CRITERIA APPEARING AT THE END OF THE OUTPUT. SCH300 - DELETE REMARKS-DTL BY TERM THIS PROGRAM IS USED TO CLEAR OLD REMARKS FROM A PREVIOUS TERM(S) SCHEDULE. THIS PROGRAM HAS NOT BEEN RELEASED FOR PRODUCTION AT THIS TIME AND NO DOCUMENTATION IS CURRENTLY AVAILABLE. SCH310 - CREATE FUTURE TERM SCHEDULE THIS PROGRAM IS USED TO BEGIN CREATING AN INITIAL FUTURE TERM SCHEDULE FROM A PREVIOUS TERM SCHEDULE. THE PURPOSE IS TO SAVE DIVISION CHAIRPERSONS FROM HAVING TO CREATE A COMPLETE NEW SCHEDULE. THIS PROGRAM WILL NORMALLY RUN TERM WHEN SCHEDULE PREPARATION BEGINS FOR A NEW TERM. THE SEGMENTS CREATED BY THIS PROGRAM ARE; CLASS-MASTER, CLASS-DETAIL, CLASS-SUBSTITUTE AND CLASS-REMARKS. A REPORT IS ALSO GENERATED FOR CLASSES CREATED. ALSO INCLUDED IS THE OPTION TO CREATE CLASS SCHEDULE DATA FROM ONE TO NINE SELECTIVE DIVISIONS WITHIN THE PREVIOUS TERM'S SCHEDULE. SCH330 - STUDENT ENROLLMENT STATUS REPORT THE PURPOSE OF THIS BATCH PROGRAM IS TO PRODUCE A LIST OF CLASSES AND THE ENROLLMENT IN EACH OF THOSE CLASSES AT FOUR DIFFERENT TIMES DURING A TERM. THE FOUR TIMES THAT THE PROGRAM SHOULD BE SCHEDULED TO RUN ARE THE START OF THE TERM, CENSUS DATE, THE LAST DAY TO DROP WITHOUT PENALTY, AND THE END OF THE TERM. THE PROGRAM READS THE CLSMASTR SEGMENT AND THEN READS THE STUREGIS SEGMENT AND TOTALS ALL STUDENTS WHO HAVE NOT DROPPED OR WITHDRAWN THAT CLASS. THE CLASS-ID AND THE ENROLLMENT TOTAL FOR THE SPECIFIC RUN IN THE TERM ARE THEN WRITTEN TO SCH330V, A VSAM FILE. THE CLSDETAL SEGMENT IS THEN READ TO FIND THE INSTRUCTOR'S SOCIAL-SECURITY NUMBER, ROOM-NUMBER AND CLASS-STATUS. THE INFORMATION IS THEN SORTED BY CLASS WITHIN DIVISION WITHIN CAMPUS OR BY INSTRUCTOR WITHIN DIVISION WITHIN CAMPUS. THE PROGRAM READS THE CLSSECST SEGMENT AND SHOWS THE SUBSTITUTE TITLE FOR THE CLASS IF THERE IS ONE. SCH335 - CLASS CHANGE REPORT THIS PROGRAM REPORTS ON ALL CLASSES CHANGED BY SCH010. SCH010 LOGS CHANGES TO THE WORK DATABASE AND SCH335 READS THESE RECORDS, REPORTS ON CHANGES TO THE CLASSES, AND DELETES THE RECORDS FROM THE WORK DATABASE. SCH500 - SCHEDULE OF CLASSES THIS PROGRAM PRINTS ONE OF THE SCHEDULE OF CLASSES REPORTS IN CLASS SEQUENCE. THIS REPORT MAY BE RUN ANY TIME AND FOR ANY TERM IN WHICH THERE IS CLASS DATA AVAILABLE. IN ADDITION TO THE DETAIL CLASS LISTING PROVIDED, A ONE PAGE SUMMARY REPORT IS INCLUDED AT THE END OF THE REPORT. SCH501 - NEWSPAPER SCHEDULE - TCC THIS PROGRAM IS USED AT TIDEWATER TO PRINT THEIR COLLEGE NEWSPAPER ADVERTISEMENT. THE SCHEDULE IS PRINTED IN A VERY SIMPLE EASY TO READ, BUT INFORMATIVE LAYOUT. INCLUDED ON THIS SCHEDULE FOR EACH UNIQUE OCCURANCE OF A PARTICULAR CLASS DEPARTMENT AND COURSE NUMBER, ONLY ONE LISTING WILL APPEAR ON THE NEWSPAPER SCHEDULE, ALONG WITH THE TITLE AND WHETHER THE CLASS(ES) ARE OFFERED DURING THE DAY, EVENING, OR SATURDAY. THIS IS DONE TO INFORM THE PUBLIC OF THE TYPES OF CLASSES BEING OFFERED AND AT THE SAME TIME BEING COST EFFECTIVE. THE STUDENT IS DIRECTED TO THE REGULAR TERM SCHEDULE FOR FURTHER DETAILS, IF INTERESTED. SCH520 - ROOM AVAILABLE AND CONFLICT REPORT THIS PROGRAM IS DESIGNED TO DETECT CONFLICTS WHICH MAY ARISE WHEN SCHEDULING CLASSES INTO A PARTICULAR ROOM FOR A GIVEN TIME SPAN. A CONFLICT IS DEFINED AS SCHEDULING TWO OR MORE CLASSES INTO THE SAME ROOM DURING THE SAME TIME SPAN OR A PORTION OF THE SAME TIME SPAN WHETHER IT BE 1 MINUTE OR 16 HOURS. THE REPORT IS PRESENTED IN A MATRIX FORMAT WITH CLASS HOURS ON THE LEFT SIDE OF THE MATRIX AND DAYS OF THE WEEK ACROSS THE TOP OF THE MATRIX. SCH550 - CLASS DETAIL LISTING THIS PROGRAM PRINTS A COMPREHENSIVE CLASS LIST FOR A SELECTED TERM. THERE ARE THREE OPTIONS AVAILABLE; DIVISION, CAMPUS AND SCHOOL. TOTALS ARE PROVIDED AT THE END OF THE REPORT. SCH551 - CLASS LISTING WITH CENSUS DATES THIS BATCH PROGRAM PRINTS A COMPREHENSIVE CLASS DETAIL LIST FOR ANY GIVEN TERM. THE PROGRAM ACCEPTS A TERM/YEAR; SORT OPTION; AND SELECT OPTIONS FROM AN INPUT PARAMETER CARD. THE AVAILABLE SORT OPTIONS ARE DIVISION, CAMPUS AND SCHOOL. THE SELECT OPTIONS ALLOW SPECIFICATION FO CLASS STATUS AND/OR LAB DESIGNATION. FIELDS SHOWN ON THIS REPORT FOR EACH CLASS DETAIL RECORD ARE: COURSE ID, RECORD NUMBER, SESSION, INSTRUCTOR SSN, INSTRUCTOR INITIALS AND LAST NAME, CREDITS, CLASS START AND END DATES, CENSUS DATE, ADD/DROP DATE, DAYS TAUGHT, CLASS HOURS, ACTUAL ENROLLMENT, AND CLASS STATUS. TOTALS ARE PRINTED AT SORT BREAKS AND AT THE END OF THE REPORT. SCH560 - SCHEDULE OF EVENING CLASSES THIS PROGRAM PRINTS A SCHEDULE OF EVENING CLASSES ONLY. AN EVENING CLASS IS ANY CLASS THAT STARTS AT 5:00 PM OR LATER. THE CLASS DATA BASE IS READ SERIALLY AND ALL CLASSES ARE SELECTED WITHIN THE TERM/YEAR AND CAMPUS FROM THE INPUT CARD. CLASSES WITH CO- OR PRE-REQUISITES MAY BE INDICATED DEPENDING ON AN INPUT CARD PARAMETER. SCH570 - SCHEDULE OF OFF-CAMPUS CLASSES THIS PROGRAM PRINTS A SCHEDULE OF OFF-CAMPUS CLASSES ONLY. CLASSES ARE CONSIDERED OFF CAMPUS IF THE BUILDING NUMBER BEGINS WITH A 'Z' OR 'R' OR THE CAMPUS IS NUMERIC OR THE CLASS IS TAUGHT ON SATURDAY OR SUNDAY. THE REPORT PRINTS TOTALS FOR EACH BUILDING, CAMPUS, AND FINAL TOTALS ARE PRINTED FOR THE SCHOOL. THE CLASSES ARE SORTED BY CAMPUS, BUILDING AND CLASS. THE CAMPUS USED FOR THE SORT IS THE CAMPUS OF CLASS-ID. CLASSES WITH REQUISITES MAY BE INDICATED DEPENDING ON AN INPUT CARD PARAMETER. SCH575 - OFF-CAMPUS CREDIT CLASSES THIS PROGRAM PRINTS A REPORT OF OFF-CAMPUS CREDIT CLASSES. SCH590 - TERM SCHEDULE THIS PROGRAM READS THE CLASS MASTER, CLASS DETAIL, CLASS SUBTITLE AND REMARKS SEGMENTS OF THE CLASS DATA BASE AND THE COURSE AND REQUISITES SEGMENTS OF THE COURSE DATA BASE TO PREPARE THE TERM CLASS SCHEDULE. RECORDS ARE SELECTED DEPENDING ON THE TERM INDICATED IN THE INPUT PARAMETERS. THESE RECORDS ARE SORTED BY DEPARTMENT, COURSE, SESSION, SECTION, LAB, RECORD TYPE AND RECORD NUMBER. THE SORTED FILE IS READ TO PREPARE A PRINTOUT OF THE CLASS SCHEDULE. SCH591 - SCHEDULE OF CLASSES - BRCC THIS SCHEDULE OF CLASSES REPORT WILL ALLOW SELECTION FOR A SPECIFIC TERM AND CAMPUS. THERE ARE THREE TYPES OF SCHEDULES FROM WHICH TO CHOOSE: . COMPLETE SCHEDULE OF CLASSES . DAY SCHEDULE OF CLASSES . EVENING SCHEDULE OF CLASSES A COMPLETE SCHEDULE WILL CONSIST OF ALL CLASS OFFERINGS WHEREAS A DAY OR EVENING SCHEDULE IS USER CONTROLLED BY INPUT PARAMETERS STATING BEGINNING TIMES FOR DAY AND EVENING CLASSES OR RANGES OF SECTION CODES THAT CONSTITUTE DAY OR EVENING CLASSES. SCH600 - CLASS STATUS REPORT THIS PROGRAM PRINTS A CLASS STATUS REPORT FOR A SELECTED TERM. THE REPORT HAS TWO SORT OPTIONS: 1- SORT BY CAMPUS, DEPARTMENT, COURSE AND SECTION 2- SORT BY DEPARTMENT, COURSE AND SECTION THIS REPORT IS NORMALLY USED TO DETERMINE WHETHER A CLASS IS OPEN FOR ENROLLMENT OR BASED ON ENROLLMENT IF IT SHOULD BE CANCELLED. SCH610 - ROOM UTILIZATION REPORT THIS PROGRAM PREPARES A ROOM UTILIZATION REPORT FOR A SELECTED TERM AND YEAR CHOSEN. THE REPORT CAN BE RUN FOR ONE OR UP TO FIVE SELECTED CAMPUSES. THE OUTPUT IS SORTED BY CAMPUS, ROOM, BEGINNING TIME, INSTRUCTOR LAST AND FIRST NAME. SCH620 - CLASS SCHEDULE - TCC THIS CLASS SCHEDULE PROGRAM CAN BE RUN ANY TIME THE USER IS READY TO BEGIN PRINTING PRELIMINARY COPIES OF THEIR SCHEDULE. SCH620 OFFERS A WIDE VARIETY OF SELECTION CRITERIA SUCH AS: . A COLLEGE SCHEDULE . A SELECTED CAMPUS(ES) SCHEDULE . SELECTION BY A DIVISION(S) . SELECTION BY A DEPARTMENT(S) . OFF-CAMPUS SCHEDULE . DAY SCHEDULE . EVENING SCHEDULE . IRREGULAR SESSION SCHEDULE . SATURDAY SCHEDULE . BY A UNIQUE GROUP OF SECTION NUMBERS EG. 71 AT TCC FOR TELECOURSES IN ADDITION TO THE SELECTION OFFERED, THE SCHEDULE CAN BE PRINTED IN THE DEFAULT SEQUENCE OF DEPARTMENT, COURSE, SECTION, LECTURE/LAB WITHIN CAMPUS OR BY THE OPTIONAL SEQUENCE OF CLASS-SEQUENCE-KEY WITHIN DEPARTMENT. WHERE THE USER IS IN CONTROL OF THE ORDER IN WHICH CLASSES WILL PRINT WITHIN EACH DEPARTMENT. SCH621 - NEWSPAPER CLASS SCHEDULE THIS PROGRAM PROVIDES A CLASS SCHEDULE REPORT TO BE USED FOR NEWSPAPERS. SCH630 - CENSUS DATES REPORT THIS PROGRAM PROVIDES A REPORT OF ALL CLASSES FOR A SPECIFIED TERM LISTING EACH CLASS' 15 AND 60 PERCENT DATES. THE PURPOSE OF THIS REPORT IS TO PROVIDE A QUICK REFERENCE FOR WHEN THE LAST DAY TO DROP/ADD A CLASS (15%) AND THE LAST DAY TO WITHDRAW FROM A CLASS (60%) WITHOUT ACADEMIC PENALTY. THE REPORT CAN OPTIONALLY BE SELECTED BY CAMPUS(ES). SCH640 - BUILD ENROLLMENT SUMMARY WORKFILE THIS PROGRAM EXTRACTS VARIOUS SCHEDULE DATA ON A TERM BASIS AND BUILDS A TEMPORARY FILE THAT IS FED TO THE FOLLOWING PROGRAMS: . SCH650 - DEPARTMENT WORKLOAD . SCH660 - HOURLY ENROLLMENT SUMMARY . REG570 - ANNUAL INSTRUCTOR WORKLOAD REPORT SCH650 - DEPARTMENT WORKLOAD THIS PROGRAM USES THE TEMPORARY FILE CREATED FROM SCH640 AS INPUT. THE PURPOSE OF THIS REPORT IS TO CREATE A DEPARTMENT UTILIZATION REPORT FOR A SELECTED TERM. THE REPORT IS SORTED BY CAMPUS, DIVISION, DEPARTMENT, TERM, YEAR, COURSE NUMBER, AND SECTION. TOTALS ARE GENERATED FOR NUMBER OF CLASSES AND INSTRUC- TORS USED. TOTAL BREAKS OCCUR FOR EACH DEPARTMENT, DIVISION AND REPORT. SCH660 - HOURLY ENROLLMENT SUMMARY THIS PROGRAM USES THE TEMPORARY FILE CREATED FROM SCH640 AS INPUT. THE REPORT CAN BE BASED ON ONE TERM OR TWO TERMS AND YEARS CAN BE SELECTED TO COMPARE AGAINST THE OTHER EG. SPRING 1985 AND SPRING 1986. THE REPORT IS LISTED BY THE CLASS BEGINNING HOUR. TOTALS ARE GENERATED FOR EACH DIVISION, CAMPUS AND COLLEGE BY HOUR AT THE END OF THE REPORT. THIS PROGRAM IS ASSIGNED TO NRCC FOR DEVELOPMENT. SCH670 - MISSING COURSE INFORMATION THIS PROGRAM PRINTS A MISSING COURSE INFORMATION REPORT BY DIVISION WITHIN CAMPUS FOR A SELECTED TERM. ALL CLASSES THAT HAVE NOT BEEN CANCELLED ARE CHECKED FOR THE FOLLOWING CRITERIA: . ACTUAL ENROLLMENT EQUAL TO ZERO . INSTRUCTOR SOCIAL SECURITY NUMBER GREATER THAN 899-99-9999, A DUMMY INSTRUCTOR. . DAYS TAUGHT BLANK . MEETING TIME EQUAL '00010002' OR BLANK . BUILDING EQUAL 'TBA' OR 'XXX' . ROOM NUMBER EQUAL 'TBA' OR 'XXX' . DUPLICATE CLASS DETAIL ENTRIES ANY MISSING INFORMATION IS PRINTED WITH UNDERSCORES. THIS REPORT IS USUALLY USED TO PREPARE A COLLEGE FOR THEIR CENSUS REPORTING. SCH680 - EDIT EXPANDED CLASS TITLE FILE THIS PROGRAM READS THE CLASS MASTER AND CLASS DETAIL SEGMENTS OF THE CLASS DATA BASE AND THE COURSE SEGMENT OF THE COURSE DATABASE TO DEVELOP A CLASS TITLE EXCEPTION REPORT RECORDS ARE SELECTED DEPENDING ON THE TERM INDICATED IN THE PARAMETERS. CLASS DEPARTMENT AND COURSE ARE MATCHED TO DEPARTMENT AND COURSE OF A FILE CONTAINING EXTENDED COURSE TITLES. A SORT FILE IS CREATED FROM TITLE EXCEPTIONS AND SORTED ON DEPARTMENT AND COURSE. THE FILE IS PRINTED AT THE END OF THE JOB. DATA ELEMENTS ON THE PRINTOUT ARE DEPARTMENT, COURSE AND ABBREVIATED COURSE TITLE. THE EXPANDED CLASS TITLE FILE IS AN EDITOR FILE CONTAINING LONG TITLES FOR COURSES AS THEY WOULD APPEAR ON THE CLASS SCHEDULE PREPARED BY SCH590. SCH690 - OFF-CAMPUS CONSORTIUM REPORT THE PURPOSE OF THIS PROGRAM IS TO PRINT AN OFF- CAMPUS CONSORTIUM REPORT FOR THE TIDEWATER CONSORTIUM. THIS REPORT CONSISTS OF A CLASS DETAIL LISTING OF ALL OFF-CAMPUS CLASSES. THE BUILDING NUMBERS USED TO DETERMINE OFF-CAMPUS ARE LOCATED IN A MESSAGE SEGMENT (SIS00101-08). THE REPORT IS SCHEDULED TO RUN APPROXIMATELY SIX WEEKS PRIOR TO THE BEGINNING OF CLASSES FOR EACH TERM AND SIX WEEKS AFTER CLASSES HAVE BEGUN FOR THAT TERM. A INPUT RECORD IS USED TO SELECT ON TERM, YEAR, AND ONE OF THE THREE AVAILABLE SORT OPTIONS (DIVISION, CAMPUS, OR SCHOOL) AND CAMPUS. THE CAMPUS OF THE CLASS-ID IS USED FOR CAMPUS SELECT AND SORT. SCH700 - CLASS SCHEDULE BY DIVISION THIS PROGRAM WILL PRINT A SCHEDULE OF CLASSES BY CAMPUS AND DIVISION FOR ANY GIVEN TERM. ALSO INCLUDED IS AN OPTION TO INCLUDE OR EXCLUDE AUDIT AND SENIOR CITIZEN COUNTS BY CLASS. TOTALS ARE PROVIDED FOR EACH DIVISION AND CAMPUS. FINAL TOTALS ARE ALSO PRINTED FOR THE COLLEGE. SCH710 - RELEASE TIME REPORT THIS PROGRAM SELECTS INSTRUCTORS WITH RELEASE TIME SEGMENTS FOR A GIVEN TERM OR RANGE OF TERMS AND PRINTS A REPORT. THE REPORT MAY BE SORTED BY SCHOOL, CAMPUS OR DIVISION WITH THE INSTRUCTORS IN ALPHABETICAL ORDER BY LAST NAME. TOTALS ARE TAKEN FOR CREDITS AND FULL TIME EQUIVALENT FACULTY UTILIZATION (FTEFU'S) FOR EACH INSTRUCTOR AND LEVEL OF SORT SELECTED. SCH730 - CANCELLED CLASS LIST THIS PROGRAM PRODUCES A LISTING OF ALL CANCELLED CLASSES. THE REPORT HAS THE OPTION OF BEING SORTED BY CAMPUS OR DIVISION. TOTALS ARE TAKEN FOR THE NUMBER OF CLASSES CANCELLED AND STUDENT CREDIT HOURS BY DEPARTMENT, DIVISION (IF SORTED BY DIVISION), CAMPUS AND SCHOOL. SCH740 - LIST OF CLASSES WITH ZERO ENROLLMENT THIS PROGRAM PRODUCES A LISTING OF ALL ZERO ENROLLMENT CLASSES. THE REPORT HAS THE OPTION OF BEING SORTED BY CAMPUS OR DIVISION. TOTALS ARE TAKEN FOR THE NUMBER OF CLASSES WITH ZERO ENROLLMENT BY DEPARTMENT, DIVISION (IF SORTED BY DIVISION), CAMPUS AND SCHOOL. SCH760 - LIST OF CLASSES FILLED AND CANCELLED THIS PROGRAM PRODUCES A LISTING OF ALL FILLED AND CANCELLED CLASSES. THE REPORT HAS THE OPTION OF BEING SORTED BY CAMPUS OR DIVISION. THE REPORT CAN BE SEPERATED BY LISTING CANCELLED CLASSES ONLY FOLLOWED BY FILLED ONLY. TOTALS ARE TAKEN FOR THE NUMBER OF CANCELLED AND FILLED CLASSES BY DEPARTMENT, DIVISION (IF SORTED BY DIVISION), CAMPUS AND SCHOOL. SCH770 - BUILD SEQUENTIAL SCHEDULE FILE(S) THIS PROGRAM PRODUCES ONE OR MORE SEQUENTIAL DATA FILES CONSISTING OF DETAIL SCHEDULE INFORMATION. THE PC USER CAN THEN READ THE SELECTED SEQUENTIAL FILE AND LOAD THIS INFORMATION ONTO THEIR PC WHERE THEY CAN MASSAGE THE DATA TO FIT THEIR UNIQUE NEEDS. THERE ARE MANY WAYS OF SELECTING SCHEDULE FILES, THEY ARE: . COLLEGE . CAMPUS(ES) . DIVISIONS(S) . DEPARTMENT(S) . OFF-CAMPUS(ES) . DAY . EVENING . SATURDAY . SESSIONS . UNIQUE SECTION NUMBER GROUPS EG. 71 WHICH ARE FOR TELECOURSES AT TCC OPTIONS ARE AVAILABLE TO ALLOW THE USER TO DEFINE WHAT CAMPUS CODES CONSTITUTE OFF-CAMPUSES, THE BEGINNING CLASS TIME WHICH IS CONSIDERED AN EVENING CLASS, ANY TIME LESS THAN THE EVENING TIME WOULD BE USED FOR DAY CLASS DETERMINATION. IF TIMES AREN'T AVAILABLE THEN SECTION CODES CAN BE ESTABLISHED TO DESIGNATED A CLASS AS DAY OR EVENING. SCH780 - LOAD SCHEDULE FILE TO PC THIS PROGRAM WILL READ THE EXTRACTED FILE(S) CREATED BY SCH770 AND LOAD ONTO A USERS PERSONAL COMPUTER. SCH790 - PRINT CLASS SCHEDULE THIS PROGRAM PRODUCES ONE OR MORE CLASS SCHEDULES FOR A SELECTED TERM IN A CHOICE OF 6 DIFFERENT FORMATS. A SCHEDULE MAY BE SORTED BY COURSE, BY COURSE WITHIN CAMPUS, OR BY COURSE WITHIN DIVISION. IT MAY INCLUDE ALL CLASSES FOR THE TERM, ONLY EVENING AND SATURDAY CLASSES TAUGHT BY SPECIFIED DIVISIONS. ONE FORMAT PRINTS THE COST OF EACH CLASS. SCH800 - OFF CAMPUS SCHEDULE BY MILITARY STATUS THIS PROGRAM PRINTS A SCHEDULE OF OFF-CAMPUS CLASSES ONLY BY MILITARY STATUS (VETERAN BENEFIT STATUS). CLASSES ARE CONSIDERED OFF CAMPUS IF THE BUILDING NUMBER BEGINS WITH A 'Z' OR 'R' OR THE CAMPUS IS NUMERIC OR THE CLASS IS TAUGHT IS TAUGHT ON SATURDAY OR SUNDAY. THE REPORT PRINTS TOTALS FOR EACH BUILDING, CAMPUS, AND FINAL TOTALS ARE PRINTED FOR THE SCHOOL. THE CLASSES ARE SORTED BY CAMPUS, BUILDING AND CLASS. THE CAMPUS USED FOR TEH SORT IS THE CAMPUS OF THE CLASS-ID. THE N UMBER OF STUDENTS PAID IS DETERMINED BY AN ACCOUNT CODE BEING PRESENT IN THE STUDENT'S REGISTRATION DETAIL RECORD. IF THE STUDENT IS RECEIVING FINANCIAL AID; THE FINANCIAL AID DATA BASE IS CHECKED TO DETERMINE IF THE STUDENT IS ON SUSPENSION; IF NOT, HE IS COUNTED AS PAID.THE PROGRAM ACCEPTS AN INPUT CARD THAT CONTAINS TERM/YEAR, CAMPUS AND WHERE WEEKEND CLASSES SHOULD PRINT. 5.0 IMPLEMENTATION PROCEDURE ------------------------ THE SCHEDULING SUBSYSTEM REQUIRES THE FOLLOWING ACTION BEFORE THIS SYSTEM COULD BE FULLY IMPLEMENTED. PREPARATION: ------------ . THE CLASS MASTER SEGMENT OF THE CLASS DATA BASE NEEDS TO BE EXPANDED BY AT LEAST 25 BYTES, CURRENTLY THE CLASS MASTER HAS NO ADDITIONAL FREE SPACE AVAILABLE FOR GROWTH. AN ADDITIONAL 25 BYTES ARE NEEDED TO SUPPORT THE DATA ELEMENT, CLASS-SEQUENCE-KEY, WHICH WILL NEED TO OCCUR 5 TIMES. IT MAY PROVE TO BE WISE TO ADD SOME ADDITIONAL FREE SPACE FOR FUTURE GROWTH. . THE CLASS REMARKS SEGMENT OF THE CLASS DATA BASE NEEDS TO BE EXPANDED BY 1 BYTE. THIS WILL ALLOW A REMARK- PRINT-CODE TO BE INSERTED BY EACH REMARK. THIS SEGMENT ALSO HAS NO FREE SPACE AVAILABLE; THEREFORE, IT MIGHT BE A GOOD IDEA TO ADD SOME ADDITIONAL SPACE FOR FUTURE GROWTH. . ONCE THE CLASS MASTER AND CLASS REMARKS SEGMENTS ARE EXPANDED THE FOLLOWING STEPS WILL NEED TO OCCUR: - DBD GEN - DATA BASE UNLOAD - DATA BASE RE-UNLOAD . DEVELOP A PROGRAM TO MOVE SPACES TO THE NEWLY ADDED DATA ELEMENTS, CLASS-SEQUENCE-KEY AND REMARK-PRINT-CODE. AFTER THE DATA BASE RE-LOAD EXECUTE THIS PROGRAM TO INITIALIZE THESE DATA ELEMENTS TO SPACES. . THE DATA DICTIONARY WILL NEED TO BE UPDATED TO REFLECT THE DEFINITION OF: - CLASS-SEQUENCE-KEY DESCRIPTION A SEQUENCE KEY ASSOCIATED WITH A CLASS TO CONTROL IT'S ORDER OF PRINTING WITHIN EACH DEPARTMENT. SIZE/TYPE 005 ALPHANUMERIC CODES CXXXX WHERE C = VALID CAMPUS CODE XXXX = SEQUENCE NUMBER DATA SET CLASS MASTER - REMARK-PRINT-CODE DESCRIPTION PRINT CODE ORDER FOR PRINTING CLASS REMARKS SIZE/TYPE 001 ALPHANUMERIC CODES A = REMARK PRINTS AFTER THE CLASS B = REMARK PRINTS BEFORE THE CLASS DATA SET CLASS MASTER . THE COPYLIB WILL NEED TO BE MODIFIED TO REFLECT THE ADDITION OF THE CLASS-SEQUENCE-KEY OCCURING 5 TIMES IN THE CLASS MASTER SEGMENT. 05 CLASS-SEQUENCE-KEY OCCURS 5 TIMES INDEXED BY CLASS-SEQ-SUB. 10 CAMPUS PIC X. 10 SEQUENCE-NO PIC XXXX. THE CLASS-REMARKS COPYLIB MEMBER WILL ALSO NEED TO BE MODIFIED TO REFLECT THE ADDITION OF A REMARK-PRINT-CODE. 05 REMARK-PRINT-CODE PIC X. . AFTER THE CLASS DATA BASE CHANGES HAVE OCCURED THE NECCESSARY PROGRAMMING CAN BEGIN. THE FOLLOWING INCLUDES, BUT IS NOT LIMITED TO, ANY SOFTWARE WHICH WILL NEED TO BE DEVELOPED AND/OR MODIFIED, OR RELEASED TO PRODUCTION. - SCH010 - ADD, UPDATE, DELETE CLASSES . ADD THE ABILITY TO ENTER THE CLASS-SEQUENCE-KEY FROM 1 TO 5 TIMES FOR EACH CLASS. - SCH020 - CLASS REMARKS . MODIFY TO ALLOW PAGING SO THAT A USER IS NOT LIMITED TO ONLY 9 CLASS REMARKS. . ADD THE ABILITY TO INPUT A REMARK-PRINT-CODE FOR EACH CLASS REMARK, THE DEFAULT BEING 'A' TO PRINT REMARK AFTER THE CLASS. . ADD THE DISPLAY OF THE REMARK-RECORD-NO BESIDE EACH REMARK ENTRY. - SCH110 - RELEASE TIME UPDATE . THIS PROGRAM HAS BEEN WRITTEN AND DOCUMENTED, BUT REMAINS TO BE TESTED AND RELEASED INTO PRODUCTION. - SCH300 - DELETE REMARKS-DTL BY TERM . THIS PROGRAM HAS BEEN ASSIGNED TO NRCC TO DEVELOP. THE PROGRAM REMAINS TO BE DEVELOPED, DOCUMENTED, TESTED AND RELEASED INTO PRODUCTION. - SCH310 - CREATE FUTURE TERM SCHEDULE . ADD AN OPTION TO CONTROL ASSIGNMENT OF SEQUENCE NUMBERS BY DEPARTMENT WITHIN CAMPUS. SEQUENCE NUMBERS ARE TO BE INITIALLY INCREMENTED IN GROUPS OF TEN. THIS WILL OPTIONALLY PROVIDE SEQUENCE NUMBERS FOR A FUTURE SCHEDULE WHEN THE PREVIOUS SCHEDULE HAD NONE. . CREATE THE SUBSTITUTE TITLE SEGMENT IF ONE PREVIOUSLY EXISTED. . TEST AND RELEASE. - SCH501 - NEWSPAPER SCHEDULE - TCC . TCC WILL DEVELOP A CLASS SCHEDULE TO BE PUBLISHED IN LOCAL NEWSPAPERS. THE OBJECT OF THIS SCHEDULE IS NOT TO PROVIDE DETAIL INFORMATION PERTAINING TO A CLASS SCHEDULE, BUT TO SIMPLY MAKE THE GENERAL PUBLIC AWARE OF THE KINDS OF CLASSES BEING OFFERED IN A COST EFFECTIVE MANNER. THIS REPORT WILL INCLUDE: - DEPARTMENT PREFIX - COURSE NUMBER * ONLY ONE LISTING WILL BE PRINTED FOR MULTIPLE SECTION OCCURANCES WITHIN A UNIQUE DEPARTMENT/COURSE. - TITLE: * SUBSTITUTE TITLES SHOULD ALWAYS BE PRINTED IN PLACE OF THE MASTER COURSE TITLE, IF ONE IS AVAILABLE. - TIME: * TIME WILL BE NOTED AS FOLLOWS: D - CLASS OFFERING(S) AVAILABLE DURING THE DAY E - CLASS OFFERING(S) AVAILABLE DURING THE EVENING S - CLASS OFFERING(S) AVAILABLE ON SATURDAYS T - CLASS OFFERING(S) TO BE ANNOUNCED DAY AND EVENING CLASSES WILL BE USER DEFINED. THE REPORT WILL BE LISTED BY ON-CAMPUS OFFERINGS FOLLOWED BY OFF-CAMPUS CLASS OFFERINGS. - SCH620 - TCC CLASS SCHEDULE . TCC WILL DEVELOP A CLASS SCHEDULE PROGRAM WITH THE FLEXIBILITY TO BE PRINTED BY DEFAULT SEQUENCE; DEPARTMENT, COURSE NUMBER, SECTION NUMBER, LECTURE/LAB WITHIN CAMPUS. OPTIONAL SEQUENCE IS BY; DEPARTMENT AND CLASS-SEQUENCE-KEY WITHIN CAMPUS. THE OPTIONAL SEQUENCE IS CONTROLLED BY THE USER WHERE HE/SHE ASSIGNS THE CAMPUS AND SEQUENCE NUMBERS TO THE CLASS-SEQUENCE-KEY. THE SCHEDULE PROGRAM SHOULD INCLUDE THE FOLLOWING SELECTION ABLILTY: - COLLEGE - CAMPUS(ES) - DIVISION(S) - DEPARTMENT(S) - OFF-CAMPUS: OFF-CAMPUS CODES SELECTED NEED TO BE USER DEFINED IN THE PROGRAM OPTION SEGMENT. - DAY: DAY CLASSES SHOULD BE USER DEFINED, WHERE ANY TIME LESS THAN THE BEGINNING TIME OF AN EVENING CLASS WOULD CONSTITUTE A DAY CLASS OR SECTION CODES PROVIDED WILL INDICATE DAY CLASSES WHERE TIMES ARE NOT AVAILABLE. - EVENING: EVENING CLASSES SHOULD BE USER DEFINED, A BEGINNING TIME IS SUPPLIED BY THE USER IN THE PROGRAM OPTION AREA TO INDICATE THAT TIME IN WHICH EVENING CLASSES BEGIN. SHOULD TIMES NOT BE AVAILABLE A RANGE OF USER SUPPLIED SECTION CODES SHOULD BE USED TO INDICATE EVENING CLASSES. - SATURDAY - IRREGULAR SESSION - SPECIAL SECTION GROUPS EG. 71 WHERE 71 SECTION NUMBERS ARE RESERVED FOR TELECOURSE AT TCC. THE DATA ELEMENTS AND THE ORDER IN WHICH THEY SHOULD PRINT ARE LISTED BELOW: - DEPARTMENT PREFIX - COURSE NUMBER - SECTION NUMBER - LAB CODE 'L' - CREDITS - DAY CODES - TIME: BEGINNING ENDING WITH THE OPTION OF PRINTING TIMES IN TERMS OF MILITARY TIME OR STANDARD TIME FOLLOWED BY 'AM' OR 'PM' ACCORDINGLY. - ROOM CODE - COURSE TITLE * SUBSITIUTE TITLES SHOULD ALWAYS BE PRINTED IN PLACE OF THE MASTER COURSE TITLE, IF ONE IS AVAILABLE. - FACULTY NAME * INCLUDE INSTRUCTORS' FIRST INITIAL - PRE AND/OR CO-REQUISITES - CLASS REMARKS SHOULD BE CENTERED ON THE LINE(S) AFTER AND/OR BEFORE EACH CLASS. WHETHER THE REMARK SHOULD PRINT BEFORE AND/OR AFTER THE CLASS WILL BE CONTROLLED BY THE REMARK-PRINT-CODE. WHERE: A = PRINT REMARK AFTER THE CLASS B = PRINT REMARK BEFORE THE CLASS ALL REMARKS SHOULD PRINT BY REMARK-RECORD- NO WITHIN REMARK-PRINT-CODE. SHOULD YOU ENCOUNTER A CLASS REMARK BEGINNING WITH '/V' WHERE 'V' MAY BE ANY LITERAL VALUE, THE LITERAL SHOULD BE USED TO PRINT AN ENTIRE LINE OF THAT LITERAL VALUE. AN EXCEPTION TO THIS WOULD BE IS THE CLASS REMARK BEGAN WITH '/S'. IF THIS SENERIO SHOULD OCCUR, THE USER IS REQUESTING THE SUPPRESSION OF A DIVIDER LINE WHICH WOULD NORMALLY FOLLOW THE CLASS. ALSO PROVIDE THE ABILITY TO OPTIONALLY PRINT THE CLASS-SEQUENCE-KEY. - SCH660 - HOURLY ENROLLMENT SUMMARY . NRCC WILL DEVELOP THIS PROGRAM. THIS REPORT WILL HAVE THE OPTION OF BEING BASED ON ONE OR TWO TERMS AND YEARS OF DATA. THE REPORT WILL BE LISTED BY THE CLASS BEGINNING HOUR. INCLUDED ON THE REPORT WILL BE: - STARTING TIME - CLASS-ID . DEPARTMENT PREFIX . COURSE NUMBER . SECTION NUMBER . LECTURE/LAB CODE - COURSE TITLE * SUBSTITUTE TITLES SHOULD BE USED, IF ONE IS AVAILABLE. - ROOM - INSTRUCTOR . INITIALS . LAST NAME - ACTUAL ENROLLMENT IF TWO TERMS AND YEARS ARE BEING COMPARED WITH ONE ANOTHER, THE ROOM, INSTRUCTOR AND ENROLLMENT ELEMENTS WILL BE REPEATED BESIDE THE FIRST TERM FOR THE SECOND TERM/YEAR OCCURANCE FOR THE SAME CLASS. - SCH710 - RELEASE TIME REPORT . THIS PROGRAM AND DOCUMENTATION WAS DEVELOPED BY JSRCC. THE PROGRAM NEEDS TO BE TESTED AND RELEASED INTO PRODUCTION. - SCH770 - BUILD SEQUENTIAL SELECTED SCHEDULE FILES . TCC WILL DEVELOP THIS PROGRAM. PROVIDED WILL BE THE ABILITY TO SELECTIVELY EXTRACT AND BUILD DETAIL SCHEDULE FILES BY: - COLLEGE - CAMPUS(ES) - DIVISION(S) - OFF-CAMPUS(ES) - DAY: WHERE THE USER WILL DEFINE THE BEGINNING TIME OF AN EVENING CLASS, A DAY CLASS WILL BE ANY TIME LESS THAN THE BEGINNING EVENING TIME OR A RANGE OF SECTION CODES CAN BE USER DEFINED TO DETERMINE DAY CLASSES WITH NO TIMES AVAILABLE. - EVENING: WHERE THE USER WILL DEFINE THE BEGINNING TIME WHICH CONSTITUTES AN EVENING CLASS OR THE RANGE OF SECTION CODES DEFINING EVENING CLASSES WHEN NO TIMES ARE AVAILABLE. - SATURDAY - SESSION - UNIQUE SECTION NUMBERS OR RANGES THEREOF THE DATA TO BE INCLUDED IN THE FILE(S) WILL BE THE CLASS MASTER DATA CONCATENATED TO THE CLASS DETAIL. CONCATENATED TO THE CLASS DETAIL WILL BE ANY 'PRE' OR 'CO' REQUISITES FOR A CLASS. IF SUBSTITUTE TITLES EXIST FOR A CLASS, THE TITLE IN THE CLASS MASTER WILL BE REPLACED BY THE TITLE IN THE SUBSITITUTE SEGMENT. THESE FILES ARE TO BE CREATED AND STORED SEQUENTIALLY INTO A TSO DEFINED DATA SET. THIS PROGRAM WILL NEED TO BE DEVELOPED, DOCUMENTED, TESTED AND RELEASED INTO PRODUCTION. - SCH780 - LOAD SCHEDULE FILE TO PERSONAL COMPUTER . THIS PROGRAM, TO BE DEVELOPED BY TCC, WILL READ THE USER DEFINED SCHEDULE FILE CREATED BY THE EXECUTION OF SCH770 AND DOWNLOAD THE SELECTED FILE ONTO A USERS PERSONAL COMPUTER. THIS PROGRAM NEEDS TO BE DEVELOPED, DOCUMENTED, TESTED AND RELEASED INTO PRODUCTION. * TRAINING: --------- FOR HP COLLEGES COMING ON TO SIS, THE SCHEDULING SUBSYSTEM SHOULD BE INCLUDED IN THEIR TRAINING SESSION. EMPHASIS NEEDS TO BE PLACED ON THE DIFFERENCES AND ENHANCEMENTS BETWEEN THE HP SCHEDULE SUBSYSTEM AND THE CONVERTED SIS SCHEDULE SUBSYSTEM. THE NEW DATA ELEMENTS IN REGARDS TO THE SCHEDULING SUBSYSTEM AND HOW THEY ARE UTILIZED SHOULD ALSO BE INCLUDED. FOR THOSE COLLEGES ALREADY ON SIS, A TRAINING SESSION MAY BE DESIRED TO REVIEW THE NEWER FEATURES AND ADDITIONS TO THE SCHEDULE SUBSYSTEM. TESTING: -------- MANY PROGRAMS OF THE SCHEDULE SUBSYSTEM HAVE ALREADY GONE THROUGH EXTENSIVE TESTING ESPECIALLY, SINCE THE SYSTEM HAS BEEN IN PRODUCTION FOR TWO YEARS AND BY THE TIME SOME OF THE HP COLLEGES CONVERT, THREE YEARS WILL HAVE TRANSPIRED. HOWEVER, DURING TIDEWATER'S CONVERSION EFFORT, TCC WILL BE TESTING THE SCHEDULE SUBSYSTEM AND PARTICULARLY THOSE ADDITIONAL PROGRAMS ADDED BY TIDEWATER TO SUPPORT THEIR UNIQUE SCHEDULE NEEDS. THOSE PROGRAMS INCLUDE, BUT ARE NOT LIMITED TO: . SCH501 - NEWSPAPER SCHEDULE . SCH620 - TCC CLASS SCHEDULE . SCH770 - BUILD SEQUENTIAL TSO SCHEDULE FILES . SCH780 - LOAD SCHEDULE FILE(S) TO PERSONAL COMPUTER IT IS DURING THE TESTING PERIOD USERS NEED TO FAMILIARIZE THEMSELVES WITH THE PROGRAMS AVAILABLE AND WHEN AND HOW THEY WILL NEED TO USE THEM. ADMINISTRATORS WILL NEED TO REACH AN AGREEMENT WITHIN THE COLLEGE AS A WHOLE AS TO: . WHAT PROGRAMS WILL BE NEEDED? . WHEN THESE PROGRAMS WILL BE NEEDED WITH RESPECT TO THE TERM? . WHAT OPTIONS WILL BE AGREED UPON BY ALL USERS FOR EACH PROGRAM? . ON WHAT FORMS SHOULD THE REPORT(S) BE PRINTED? . HOW MANY COPIES WILL BE NEEDED? . WHO SHOULD RECEIVE A COPY OF EACH REPORT? THIS IS A GREAT RESPONSIBILITY PLACED ON THE USER AND IT IS CRUCIAL TO THE SUCCESS OF THE OVERALL SYSTEM THAT USERS AGREE ON THE REPORTS AND OPTIONS ETC. NEEDED AND THAT THEY ARE NOT ABUSED. FOLLOW UP: --------- FOR TIDEWATER THERE WILL BE ABOUT A SIX MONTH PERIOD ALLOTTED FOR USERS TO UNCOVER ANY ADDITIONAL PROBLEMS NOT ORGINALLY APPARENT DURING THE INITIAL CONVERSION TESTING PERIOD. DURING THIS TIME SPECIAL ATTENTION AND CONSIDERATION WILL BE DIRECTED TOWARDS ANY CHANGE REQUESTS SUBMITTED. 6.0 SPECIAL CONSIDERATIONS AND PROBLEMS ----------------------------------- Q. SHOULD THE SEQUENCE NUMBERS BE A SECONDARY KEY? A. NO, SEQUENCE NUMBERS WILL ONLY BE UNIQUE WITHIN A DEPARTMENT AND CAMPUS. Q. HOW SHOULD SEQUENCE NUMBERS BE UNIQUE? A. SEQUENCE NUMBERS WILL BE UNIQUE WITHIN A DEPARTMENT AND CAMPUS THE FORMAT OF THE SEQUENCE NUMBER WILL BE: CNNNNN WHERE: C = THE CAMPUS CODE ASSIGNED TO THE SEQUENCE NUMBER FOR PRINTING PURPOSES NNNN = A NUMERIC DATA FIELD CONTAINING A UNIQUE NUMBER BY DEPARTMENT WITHIN A CAMPUS CODE Q. WHEN PRINTING CLASSES ACROSS CAMPUS SCHEDULES, HOW WILL THIS AFFECT THE SEQUENCE NUMBER? A. FOR EACH CLASS THAT IS TO BE PRINTED ON MORE THAN ONE CAMPUS SCHEDULE, A CLASS-SEQUENCE-KEY WILL NEED TO BE ASSIGNED TO THE CLASS BY THE USER. THE CLASS-SEQUENCE-KEY IS IN THE FORMAT OF (CNNNN) WHERE 'C' REPRESENTS THE CAMPUS AND 'NNNN' IS THE SEQUENCE NUMBER ORDER WITHIN THAT CAMPUS DEPARTMENT UPON WHICH THE CLASS WILL PRINT. ADDITIONALLY, TO ACHIEVE THIS EFFECT THE SCHEDULE WILL HAVE TO BE PRINTED BY THE OPTIONAL SCHEDULE SEQUENCE OF DEPARTMENT AND CLASS-SEQUENCE-KEY WITHIN CAMPUS. Q. WHAT IS THE ACTUAL AMOUNT OF FILLER SPACE AVAILABLE IN THE CLASS MASTER AND CLASS REMARK SEGMENTS OF THE CLASS DATA BASE? A. CLSMASTER: 63 BYTES DATA 0 BYTES FILLER --- 63 BYTES TOTAL * NEED 25 BYTES OF FILLER ARE NEEDED TO ACCOMODATE A AN ALPHA-NUMERIC CLASS-SEQUENCE-KEY FIELD OF CNNNN OCCURING 5 TIMES. CLSREMRK: 66 BYTES DATA 0 FILLER --- 66 BYTES TOTAL * NEED 1 BYTE OF FILLER TO ACCOMODATE A PRINT-CODE WHERE: B = PRINT REMARK BEFORE THE CLASS A = PRINT REMARK AFTER THE CLASS (DEFAULT) *** TO INCREASE THE SIZE OF THE DATA BASE SEGMENTS WOULD REQUIRE: - DBD GEN - UNLOAD - RELOAD Q. CAN SECURITY BE RESTRICTED WITHIN THE CLASS DATA BASE TO THE DIVISION LEVEL OF THE CLASS? A. - DIVISION CODE ADDED TO THE MST000 SCREEN TO BE UTILIZED AS CONTROL VIA SCH010... MARGARET SAID ANY CHANGE TO MST000 WOULD EFFECT ALL SIS COLLEGES AND SHE DIDN'T THINK THIS WOULD GET APPROVAL AT THE SYSTEM'S OFFICE. - SECURITY BEYOND THE DATASET OR PASSWORD LEVEL... THERE'S NOT MUCH YOU CAN DO. - TO CHANGE THE SCHEDULE PROGRAM(S) (SCH010) AND (SCH020) TO RESTRICT ACCESS TO ONLY APPROVED TERMINAL ID'S: . TOO MUCH ADDED OVERHEAD TO THE PROGRAM . TOO LOCKED IN . TOO TEDIOUS . WHEN EVER TERMINALS ARE ADDED OR DELETED THEN IT WOULD REQUIRE A PROGRAM CHANGE. Q. HOW CAN LECTURES AND LABS BE GROUPED TOGETHER? A. BY THE USER CONTROLLING THE ASSIGNMENT OF THE CLASS-SEQUENCE-KEY HE/SHE CAN ASSIGN SEQUENCE NUMBERS THAT ARE INCREMENTED ONE AFTER ANOTHER TO FORCE LECTURES AND LABS TO BE PRINTED TOGETHER. FOR EXAMPLE YOU HAVE THE FOLLOWING CLASSES: DEPT CRSE SECT CAMP LAB ---- ---- ---- ---- --- BIOL 101 01 A BIOL 101 02 A BIOL 101 31 A LAB BIOL 101 32 A LAB BIOL 101 33 A LAB BIOL 101 91 A WITH THE DEFAULT SORT SEQUENCE THE ABOVE IS THE ORDER IN WHICH THESE CLASSES WOULD PRINT. WITH THE OPTIONAL SORT SEQUENCE THE USER CAN CONTROL THE ORDER IN WHICH THE CLASSES PRINT BY USING THE CLASS-SEQUENCE-KEY, THUS YOU COULD GROUP YOUR LECTURES AND LABS TOGETHER: DEPT CRSE SECT CAMP LAB CLASS-SEQ-KEY ---- ---- ---- ---- --- ------------- BIOL 101 01 A A0010 BIOL 101 31 A LAB A0020 BIOL 101 02 A A0030 BIOL 101 32 A LAB A0040 BIOL 101 91 A A0050 BIOL 101 33 A LAB A0060 Q. NEED TO MOVE "LAB" TO THE COURSE TITLE OR SECOND CLASS MEETING...WHICH HAS A DIFFERENT SECTION NUMBER. A. SUBSTITUTE TITLE WILL REPLACE THE REGULAR TITLE WITH "LAB", IF UTILIZED. *NOTE: ALL SECOND CLASS MEETINGS FOUND ON TCC SCHEDULE HAD UNIQUE DEPT,CRSE,SECT NUMBERS...THE SUBSTITUTE TITLE WILL SATISFIY THIS NEED. Q. SEPERATING MUSIC CLASSES FOR MUSIC MAJORS FROM MUSIC CLASSES FOR NON-MUSIC MAJORS. A. THIS CAN BE DONE BY UTILIZING SEQUENCE NUMBERING AGAIN. Q. MOVING THE WORD "HOSPITAL" TO THE COURSE TITLE FOR NURSING CLASSES. A. THE SUBSTITUTE TITLES WILL NOT WORK HERE, BECAUSE THE NURSING DEPARTMENT ONLY WANTS "HOSPITAL" TO APPEAR ON THE SECOND DETAIL LINE...NOT TO REPLACE THE ORGINAL TITLE ON THE FIRST LINE. THERE ARE TWO ALTERNATIVES 1. THE REMARKS AREA COULD BE USED TO INDICATE WHEN THE CLASS WILL MEET AT THE HOSPITAL. 2. IF THE STANDARD ON ALL NURSING CLASSES WAS TO PRINT "HOSPITAL" IN THE TITLE FIELD FOR THE SECOND RECORD, THEN AN OPTION COULD BE ADDED TO THE SCHEDULE PRINT PROGRAM. Q. FORCING A LINE TO PRINT BETWEEN CLASSES? A. THE SCHEDULE CURRENTLY PRINTS A DIVIDER LINE OF "-" WHEN: - THERE IS A CHANGE IN DEPARTMENT - A CLASS HAS MORE THAN ONE DETAIL RECORD - A CLASS HAS A REMARK THE SCHEDULE PROGRAM COULD BE WRITTEN SUCH THAT WHEN A REMARK IS READ IN AND THE VALUE OF THE REMARK IS "/-", OR ANY OTHER CHARACTER, THE PROGRAM WILL MOVE "-" TO THE PRINT LINE AND PRINT A LINE OF "-"S, OR WHAT EVER THE SPECIAL CHARACTER IS. Q. KEEPING A LINE FROM PRINTING BETWEEN CLASSES? A. '/S' WILL CAUSE A NORMALLY DIVIDER LINE FOLLOWING A CLASS TO BE SUPPRESSED. Q. MANAGING THE MODIFICATION TO MESSAGE FILES AND REFORMATTING THEM? A. UNDER THE SIS SYSTEM A MESSAGE FILE WILL NO LONGER EXIST, ADDING A PRINT-CODE TO THE REMARKS AREA WILL ALLOW THE USER TO CONTROL WHETHER REMARKS WILL PRINT BEFORE OR AFTER A CLASS. Q. HOW CAN TELE-CLASSES PRINT ON ALL CAMPUS SCHEDULES? A. BY ADDING A CLASS-SEQUENCE-KEY TO THE CLASS MASTER SEGMENT, OF WHICH THE CLASS-SEQUENCE-KEY WILL INCLUDE THE CAMPUS AND THE SEQUENCE NUMBER WHERE THE CLASS SHOULD APPEAR WITHIN EACH DEPARTMENT OF A CAMPUSES SCHEDULE. ALSO, THE SEQUENCE KEYS WILL OCCUR UP TO 5 TIMES FOR EACH CLASS, THIS WILL ALLOW EACH CAMPUS TO CONTROL WHERE ON THEIR SCHEDULE THE CLASS SHOULD PRINT, IF AT ALL. Q. ENSURE THAT CO-OP CLASSES AND THEIR MESSAGES PRINT IN THE PROPER ORDER. A. WITH THE NEW DATA BASE DESIGN THE REMARKS SEGMENT IS IS A CHILD OF THE CLASS IN WHICH IT COINSIDES, THIS WILL ENSURE THAT ALL REMARKS ARE TIED IN WITH THE PROPER CLASS. THE REMARK-PRINT-CODE WILL DETERMINE WHETHER THE REMARK(S) PRINT BEFORE OR AFTER THE CLASS. Q. HAVE THE DATA BASES BEEN CHANGED SINCE ORGINALLY CREATED? A. YES, MANY DATA BASES WERE REDUCED IN SIZE BY REMOVING EXTRA FILLER SPACE IN MAY AND JUNE OF 1985. Q. IS THERE CURRENTLY ANY SCHEDULE SUBSYSTEM DOCUMENTATION AVAILABLE? A. NO, I CHECKED WITH JOYCE HENLY, SHE WAS GOING TO WRITE SOME UP, BUT NEVER GOT AROUND TO IT. Q. ON A DEFAULT PRINTED SCHEDULE CAN TELE-CLASSES PRINT ON ALL CAMPUSES? A. YES, ADD AN OPTION TO SPAN CLASSES ACROSS CAMPUS SCHEDULES BY SECTION NUMBER. Q. HOW WILL SEQUENCE NUMBERS BE ASSIGNED INITIALLY FOR TELE-CLASSES? A. IF CLASS-SEQUENCE-KEY WERE NOT AVAILABLE IN PREVIOUS TERMS CLASS SCHEDULE FOR WHICH A FUTURE TERM SCHEDULE IS BEING GENERATED, LET SCH310 ASSIGN A CLASS-SEQUENCE-KEY FOR THE TELE-CLASS JUST LIKE IT WOULD FOR ANY OTHER CLASS. THAT IS IN INCREMENTS OF TEN IN DEPARTMENT, COURSE, SECTION ORDER WITHIN EACH DEPARTMENT AND CAMPUS. ANY CAMPUS THAT WANTS ANOTHER CAMPUS CLASS PRINTED ON THEIR SCHEDULE CAN ADD A UNIQUE SEQUENCE NUMBER FOR THERE OWN CAMPUS AS DESIRED. - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - REVISIONS TO DOCUMENTATION: 6.1 VERSION NO: V3.8 CHANGE DATE: 03/05/88 PROGRAMMER NAME: TONY SANTOS PROGRAM CHANGE REQUEST NO: SCP-SO-150 DESCRIPTION OF CHANGE: CHANGED ALL REFERENCES OF QUARTER'S TO TERM. - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 6.2 VERSION NO: V4.08 CHANGE DATE: 11/01/89 PROGRAMMER NAME: DANA BRYANT PROGRAM CHANGE REQUEST NO: 3831 DESCRIPTION OF CHANGE: ADDED DOCUMENTATION FOR NEW PROGRAM SCH335 CLASS CHANGE REPORT. - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 6.3 VERSION NO: V4.10 CHANGE DATE: 01/08/90 PROGRAMMER NAME: S. EDMONDS PROGRAM CHANGE REQUEST NO: 4497 DESCRIPTION OF CHANGE: REVISED DOCUMENTATION BY PROVIDING PROGRAM DESCRIPTIONS FOR SOME OF THE PROGRAMS IN THE 4.0 PROGRAM DOCUMENTATION SECTION. - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 6.4 VERSION: V4.41 CHANGE-DATE: 11/15/1992 PROGRAMMER: HARRY L. WALDRON, VWCC INFO-REQUEST: 9964 SCHOOL/DEPT: GCC DESCRIPTION: ADDED DOCUMENTATION FOR SCH060 (NEW ON-LINE INQUIRY PROGRAM) - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -