0.012/15/92 GEORGIA THISTLE 1.0 INTRODUCTION: ------------ THE CONTINUING EDUCATION SYSTEM IS DESIGNED TO PROCESS THE INFORMATION NEEDED TO IMPLEMENT THE VARIOUS FUNCTIONS OF THE VCCS CONTINUING EDUCATION SYSTEM. THIS SYSTEM WILL ALLOW THE USER TO REGISTER STUDENTS IN CONTINUING EDUCATION CLASSES, PRINT R&I FORMS AND OBTAIN CLASS ROLLS. THE USER WILL ALSO HAVE ACCESS TO FINANCIAL AND SUMMARY INFORMATION CONTAINED IN THE CEU AND SIS DATA BASES. THE PROJECT WAS ENVISIONED IN THREE PHASES, EACH PHASE CONSISTING OF ONLINE AND BATCH PROGRAMS. IN PHASE I, THREE SEPARATE DATA BASES WERE ESTABLISHED FOR THE CEU SYSTEM, THE CEU STUDENT DATA BASE, THE CEU COURSE DATA BASE AND THE CEU CLASS DATA BASE. SUBSEQUENTLY, PSEUDO-LOGICAL SEGMENTS WERE ADDED TO THE SIS DATA BASES FOR SIS-BUILDING/CEU-CLASS AND SIS-INSTRUCTOR/ CEU-CLASS RELATIONSHIPS. THE HEGIS CODE REFERENCE FILE WAS CREATED ON THE SIS CONTROL DATA BASE FOR SHARED USE BY THE CONTINUING EDUCATION AND PERSONNEL SUBSYSTEMS. PHASE II ADDED MORE INQUIRY CAPABILITY AND A MASS ADD/DROP SCREEN. PHASE III WILL BRING THE CEU SUBSYSTEM INTO THE STUDENT ACCOUNTS RECIEVABLE SUBSYSTEM. ON-LINE SCREENS IN PHASE I: (CEU010) CEU STUDENT APPLICATION ENTRY (CEU020) STUDENT REGISTRATION (CEU025) STUDENT WITHDRAWAL (CEU030) CLASS ROSTER- SCREEN/IMS PRINT/HARDCOPY/LABELS (CEU040) GRADE ASSIGNMENT BY CLASS (CEU055) CHANGE/DELETE SOCIAL SECURITY NUMBER (CEU100) ADD/UPDATE/DELETE COURSES (CEU100S) TUITION CALCULATION SUBPROGRAM (CEU110) CLASS MASTER/DETAIL UPDATE (CEU116) CLASS NOTES/REMARKS UPDATE (CEU117) CLASS EQUIPMENT UPDATE (REF135) UPDATE HEGIS CODES (CEU170) R/I FORMS (CEU200S) TERMS OF ENROLLMENT SUBPROGRAM BATCH PROGRAMS IN PHASE I: (CEU351) CLASS ROSTER/GRADE ROLLS WITH COMMENTS TO INSTRUCTOR (CLASS ENTERED FROM CEU030) (CEU358) CEU GRADE LABELS (CEU500) SCHEDULE OF CLASSES (OPTION TUITION AMOUNTS) (CEU501) NEWSPAPER SCHEDULE (CEU515) UNPAID STUDENTS LIST (REF635) HEGIS CODES REFERENCE LIST (CEU525) COURSE MASTER REFERENCE LIST (CEU530) CEU MAILING LABELS AND/OR LISTING OPTIONS - ALL STUDENTS ACTIVE STUDENTS INACTIVE STUDENTS SENIOR CITIZENS SORT BY NAME - SORT BY ZIP (CEU540) CEU ENROLLMENT RECAP OF CREDIT AND NON-CREDIT CLASSES, DAY AND NIGHT CLASSES, AND STUDENTS BY RACE CODE AND PAID, NOT-PAID. (CEU550) SHEV Q1 REPORT (CEU572) FINANCIAL REPORT BY DEPARTMENT BY CLASS SHOWING ENROLLMENT, TOTAL TUITION, TOTAL EXPENSES, FACULTY SALARIES, AND DIFFERENTIAL AMOUNT (CEU740) CONFLICT LIST - SCHEDULE AND ROOM (OPTION - EITHER SIS OR CEU OR BOTH) ON-LINE SCREENS IN PHASE II: (CEU060) MASS REGISTRATION (ADD/DROP) (CEU072) FINANCIAL SUMMARY BY CLASS (CEU080) STUDENT INQUIRY (CEU082) COURSE INQUIRY (CEU083) INSTRUCTOR INQUIRY (CEU084) ENROLLMENT INQUIRY (CEU090) ONLINE TRANSCRIPTS BATCH PROGRAMS IN PHASE II: (CEU310) CREATE NEW TERM FROM PREVIOUS TERM DATA (CEU610) GRADE MAILERS (CEU620) CLASS ROSTERS (CEU630) LETTER TO STUDENT IN CANCELLED CLASSES (CEU640) NAME TAGS FOR CLASSES (CEU680) FACULTY SCHEDULE BY DATE AND TERM SHOWING AMOUNT OF CLASS INSTRUCTION (OPTION SHOWING TUITION COLLECTED, CLASS EXPENSES AND DIFFERENTIAL AMOUNT) (CEU700) PRINT CERTIFICATE OF COMPLETION (CEU760) LIST OF EQUIPMENT NEEDED FOR CLASSES BY DATE/ TERM (WEEKLY) (CEU777) LIST AND MAILING LABELS OF COMPANIES BY ACCOUNT CODES ------------------------------------------------------ PHASE III WILL INCORPORATE THE CEU SUBSYSTEM INTO THE STUDENT ACCOUNTS RECEIVABLE SUBSYSTEM AND WILL INCLUDE ADDITIONAL SCREENS AND REPORTS. IT WILL ALSO PROBABLY INCLUDE CEU DATA BASE CHANGES. ON-LINE SCREENS IN PHASE III: TO BE DEFINED BATCH PROGRAMS IN PHASE III: (CEU780) LIST OF CEU STUDENT OBLIGATIONS * 2.0 NARRATIVE: --------- WHEN A STUDENT APPLIES FOR ADMISSION TO THE CONTINUING EDU- CATION PROGRAM, THE DATA FROM THE REGISTRATION FORM IS ENTERED INTO THE CEU STUDENT DATABASE. LATER, INFORMATION CAN BE ENTERED TO UPDATE DATA FOR A STUDENT ALREADY ON FILE. REGISTRATION AND DROP/ADD FUNCTIONS ARE PERFORMED BY THE SYSTEM. R/I REGISTRATION IDENTIFICATION FORMS CAN BE PRINTED FOR FOR STUDENTS WHO OWE TUITION. HOWEVER, IN THE SYSTEM A STUDENT MAY NOT HAVE TO PAY TUITION OR THE TUITION AMOUNT FOR A CLASS MAY BE VARIABLE BY STUDENT. THE SYSTEM ALLOWS FOR OUTSIDE, BILLABLE SPONSORS OF CLASSES. THE SYSTEM PROVIDES VARIOUS REPORTS SIMILAR TO THE SIS CLASS SCHEDULES, CLASS ROLLS, ENROLLMENT SUMMARY, ETC. THE ROOM CONFLICT LISTING IS SENSITIVE TO THE SIS DATA BASES SO THAT A REPORT COMBINING THE SIS AND CEU CLASSROOM CONFLICTS IS POSIBLE. PHASE I ALLOWS FOR THE BASIC FUNCTION OF PROCESSING STUDENTS THROUGH CEU CLASSES. IT ALSO PROVIDES A MEANS OF KEEPING TRACK OF THE FINANCIAL FLOW AND STUDENT ENROLLMENT. PROGRAMS IN PHASE II OF THE SYSTEM PROVIDE FURTHER CAPABILITY FOR ACQUIRING INFORMATION ABOUT STUDENTS AND CLASSES. ALSO FOR MASS REGISTRATION, MASS DROP, CLASS INQUIRY, INSTRUCTOR INQUIRY AND ENROLLMENT INQUIRY. BATCH PROGRAMS INCLUDE FACULTY SCHEDULE, PRINTING OF SPECIAL CERTIFICATES, LIST OF EQUIPMENT, AND LIST AND LABELS FOR ALL ACCOUNTS. 3.0 DATA BASE DESIGN: ---------------- CONTINUING EDUCATION (NON-CREDIT) SUBSYSTEM GENERAL LAYOUT OF DATA BASES STUDENT COURSE CONTROL DATA BASE DATA BASE DATA BASE ------------- CEU ------------- CEU ------------- SIS ] STUDENT ] ] COURSE ] ] TERM ] ] MASTER ] ] MASTER ] ] SEGMENT ] ------------- ------------- ------------- ] CLASS DATA BASE ] ------------- CEU ------------- SIS ] ] CLASS ] ] CAMPUS ] ] ] MASTER ] ] SEGMENT ] ] ------------- ------------- ] ] ------------- CEU ------------- CEU ------------- SIS ] REG. ]_________] CLASS ] ] DIV. ] ] DETAIL ] ] DETAIL ] ] SEGMENT ] ------------- ------------- ------------- ------------- SIS ] OBLIG. ] ] SEGMENT ] ------------- ------------- SIS ] PROG OPT ] ] SEGMENT ] ------------- ------------- SIS ] MESSG ] ] SEGMENT ] ------------- ACCOUNTING DATA BASE ------------- SIS ] ACCT. ] ] MASTER ] ------------- * DATA BASE DESIGN (CONTINUED): ---------------------------- CONTINUING EDUCATION (NON-CREDIT) SUBSYSTEM GENERAL LAYOUT OF DATA BASES BUILDING DATA BASE ------------- SIS ] BUILD ] ] MASTER ] ------------- ------------- SIS ] ROOM ] ] DETAIL ] ------------- COURSE DATA BASE ------------- SIS ] DEPT. ] ] MASTER ] ------------- INSTRUCTOR DATA BASE ------------- SIS ] INSTR. ] ] MASTER ] ------------- * CONTINUING EDUCATION (NON-CREDIT) SUBSYSTEM DATA BASE DIAGRAM CEU STUDENT DATA BASE ------------- ] STUDENT ] ] MASTER ] ------------- ] ------------------------------------------------------------- ] ] ] ] ] ------------ ------------ ------------ ------------ ----------- ] REGIS ] ] STU/ACCT.] ] OBLIG. ] ] DRPRG ] ] OBAUD ] ] DETAIL ]] ] DETAIL ]] ] DETAIL ]] ] DETAIL ]] ] DETAIL ] ------------] ------------] ------------] ------------] ----------- ------------ ----------- ------------ ------------ ---------- CEU COURSE DATA BASE ------------- ] COURSE ] ] MASTER ] ------------- CEU CLASS DATA BASE ------------- ] CLASS ] ] MASTER ] ------------- ] -------------------------------------------------------- ] ] ] ] ------------- ------------- ------------- ------------- ] CLASS ] ] REMARKS ] ] NOTES ] ] EQUIP. ] ] DETAIL ]] ] DETAIL ]] ] DETAIL ]] ] DETAIL ]] -------------] -------------] -------------] -------------] ------------- ------------- ------------- ------------- * UNIDIRECTIONAL LOGICAL RELATIONSHIP CEU ---------- ] CLASS ] ] MASTER ] (CONT) ---------- <......_______]________ ] ] ---------- :::::::::: ] EQUIP ] ] CLASS/ ] ] DETAIL ] ] STUDENT] ---------- :::::::::: . . .> ---------- ] STUDENT] ] MASTER ] ---------- PSEUDO-LOGICAL SEGMENTS SIS/CEU ---------- ---------- ] INSTR. ] ] BLDG ] ] MASTER ] ] MASTER ] (CONT) ---------- (CONT) ---------- <......_______]________ <......._______]_________ ] ] ---------- ---------- ] CEU INS] ] CEU BLD] ] /CLASS ] ] /CLASS ] ---------- ---------- * 3.1 SEGMENT LAYOUTS: ---------------- STUDENT DATA BASE STUDENT MASTER SEGMENT ------- ------ ------- SOCIAL-SECURITY PIC 9(9) SOCIAL SECURITY NUMBER (MUST BE NUMERIC) DMV PIC X(1) COURT ASSIGNED ' ' = NOT COURT ASSIGNED 'W' = COURT ASSGN W/PTS 'O' = COURT ASSGN WO/PTS FILLER PIC X(3) CAMPUS PIC X CAMPUS WHERE APPLICATION PROCESSED CITY PIC X(16) CITY EMPLOYER-NAME PIC X(28) DATE-APPLICATION DATE APPLICATION PROCESSED APPLICATION-YR PIC XX APPLICATION-MO PIC XX APPLICATION-DAY PIC XX DATE-BIRTH DATE OF BIRTH BIRTH-YR PIC XX (NUMERIC, USE '99' FOR UNKNOWN) BIRTH-MO PIC XX (01 - 12) BIRTH-DAY PIC XX (01 - 31) DECEASED-CODE PIC X INDICATES STUDENT IS DECEASED BLANK - ALIVE 1 - DECEASED 2 - ADDRESS NOT AVAILABLE 3 - NO MAIL FOLDER-LOCATION LOCATION OF STUDENTS PHYSICAL CAMP PIC X FOLDER DIV-CODE PIC X FORMER-NAME PIC X(16) MAIDEN OR OTHER FORMER NAME NAME-LAST PIC X(16) LAST NAME (MUST BE ALPHA, EXCEPT ONE HYPHEN ALLOWED) NAME-FIRST PIC X(10) FIRST NAME NAME-INITIAL PIC X FIRST CHARACTER OF STUDENT'S MIDDLE NAME NAME-SUFFIX PIC XX SUFFIX OF STUDENT NAME (JR, SR, DR, 3) PHONE-BUSINESS STUDENT BUSINESS PHONE NUMBER PHONE-BUS-AREA PIC X(3) BUSINESS PHONE AREA CODE PHONE-BUS-EXCH PIC X(3) BUSINESS PHONE EXCHANGE PHONE-BUS-EXTEN PIC X(4) BUSINESS PHONE EXTENSION PHONE-HOME STUDENT HOME PHONE NUMBER PHONE-HOME-AREA PIC X(3) HOME PHONE AREA CODE PHONE-HOME EXCH PIC X(3) HOME PHONE EXCHANGE PHONE-HOME-EXTEN PIC X(4) HOME PHONE EXTENSION TERM-ADMISSION TERM STUDENT PLANS TO ENROLL ADM-TERM-YR PIC XX ADM-TERM-CODE PIC X TERM-FIRST-ENROL TERM STUDENT FIRST ENROLLED TERM-FIRST-YR PIC XX TERM-FIRST-CODE PIC X TERM-LAST-ENROL TERM STUDENT LAST ENROLLED TERM-LAST-YR PIC XX TERM-LAST-CODE PIC X RACE PIC X INDICATES STUDENT'S RACE 1 - CAUCASIAN 2 - BLACK 3 - AMERICAN INDIAN 4 - ORIENTIAL 5 - SPANISH SURNAMED AMERI- CAN 6 - OTHER 9 - UNKNOWN SENIOR-CITIZEN PIC X INDICATES IF SENIOR CITIZEN BLANK - NO 1 - YES SEX PIC X INDICATES STUDENT'S SEX 1 - MALE 2 - FEMALE 9 - UNKNOWN STATE PIC XX STATE ABBREVIATION STREET-ADDRESS PIC X(22) STREET ADDRESS TUITION-STMT-MAILED PIC X INDICATES IF TUITION STATEMENT HAS BEEN MAILED 1 - NOT PRINTED 2 - PRINTED ZIPCODE PIC X(9) CURRENT ZIPCODE STUDENT-CROSSOVER-FLAG PIC X STUDENT ON SIS DATA BASE Y - STUDENT IS ON STUDENTM OR STUDENTH BLANK - STUDENT NOT ON THE ABOVE EMPLOYER-ATTENTION PIC X(28) SECOND LINE OF EMPLOYER NAME-ADDRESS INFORMATION EMPLOYER-STREET-ADDRESS PIC X(22) EMPLOYER ADDRESS EMPLOYER-CITY PIC X(16) EMPLOYER CITY EMPLOYER-STATE PIC XX EMPLOYER STATE EMPLOYER-ZIPCODE PIC X(9) EMPLOYER ZIPCODE JURISDICTION PIC X(3) CODE FROM JURISDICTION MASTER USE 'ZZZ' FOR UNKNOWN FILLER PIC X(47) STUDENT REGISTRATION SEGMENT ------- ------------ ------- CLASS-ID INDENTIFY EACH SECTION OF A CLASS TERM-ID TERM-YR PIC XX YEAR TERM-CODE PIC X TERM CODE CAMPUS PIC X CAMPUS DEPARTMENT PIC X(4) DEPARTMENT COURSE-NUM PIC X(3) COURSE NUMBER SECTION-NO PIC XX SECTION NUMBER LEC-LAB PIC X LECTURE-LAB BLANK - LECTURE L - LAB COURSE ACCOUNT-CODE PIC X(4) ACCOUNT-CODE AID-AUTHORIZED-CODE PIC X INDICATES CONTRACT CLASSES OR SENIOR CITIZEN NOT PAYING CEU-CREDITS PIC S999V99 CREDIT HOURS PER COURSE DATE-LAST-ATTENDED DATE STUDENT LAST ATTENDED CLASS DATE-LAST-MO PIC XX DATE-LAST-DAY PIC XX DATE-PAID DATE ACCOUNT WAS PAID DATE-PAID-YR PIC XX DATE-PAID-MO PIC XX DATE-PAID-DAY PIC XX DATE-WITHDREW DATE STUDENT WITHDREW FROM CLASS DATE-LAST-MO PIC XX DATE-LAST-DAY PIC XX GRADE-LETTER PIC X LETTER GRADE (SAME AS SIS) GRADE-PERCENT PIC S9(3) PERCENT GRADE RI-PRINT-FLAG PIC X IDENTIFIES STATUS OF PRINTING OF RI FORMS 0 - REGISTERED BUT NO RI FORM PRINTED 1 - RI FORM PRINTED B - REGISTERED, BILLED TO SPONSOR WITHDRAW-TYPE PIC X INDICATES TYPE OF WITHDRAWAL S - STUDENT A - ADMINISTRATIVE C - COLLEGE WITHDRAW-NOTIFY-FLAG PIC X INDICATES IF CARD WRITTEN BLANK - IF GRADE IS 'W' PRINT CARD Y - CARD PRINTED SESSION PIC X INDICATES TYPE OF SESSION SPONSOR-CODE PIC X(4) INDICATES ACCT THAT SPONSORED STUDENT FOR CLASS STUDENT-MISC-FEE PIC S9(3)V99 MISCELLANEOUS FEE LAB-FEE PIC S9(3)V99 LABORATORY FEE CREATION-DATE PIC 9(5) JULIAN DATE SEGMENT WAS CREATED REAPPLY-FLAG PIC X INDICATES IF TUITION WAS REAPPLIED ' ' NO REAPPLICATION '1' PAID IN FULL BY REAPPLY '2' PARTIALLY PAID BY REAPPLY REAPPLY-PART-AMT PIC S9(5)V99 PART OF TUITION THAT IS PAID (ONLY WHEN FLAG= '2') DROP-FLAG PIC X RESERVED FOR FUTURE USE DROP-PART-AMT PIC S9(5)V99 RESERVED FOR FUTURE USE TUITION-RATE PIC S9(5)V99 IF STUDENT PAYS DIFFERENT TUITION THAN CLASS MASTER FILLER PIC(10) STUDENT ACCOUNT SEGMENT ------- ------- ------- IDENTICAL TO SIS STUDENT ACCOUNT DETAIL (STUACCTD) STUDENT OBLIGATION SEGMENT ------- ---------- ------- IDENTICAL TO SIS STUDENT OBLIGATION SEGMENT (STUOBLIG) STUDENT DROP REGISTRATION SEGMENT ------- ---- ------------ ------- CLASS-ID INDENTIFY EACH SECTION OF A CLASS TERM-ID TERM-YR PIC XX YEAR TERM-CODE PIC X TERM CODE CAMPUS PIC X CAMPUS DEPARTMENT PIC X(4) DEPARTMENT COURSE-NUM PIC X(3) COURSE NUMBER SECTION-NO PIC XX SECTION NUMBER LEC-LAB PIC X LECTURE-LAB BLANK - LECTURE L - LAB COURSE ACCOUNT-CODE PIC X(4) ACCOUNT-CODE AID-AUTHORIZED-CODE PIC X INDICATES CONTRACT CLASSES OR SENIOR CITIZEN NOT PAYING CEU-CREDITS PIC S999V99 CREDIT HOURS PER COURSE DATE-LAST-ATTENDED DATE STUDENT LAST ATTENDED CLASS DATE-LAST-MO PIC XX DATE-LAST-DAY PIC XX DATE-PAID DATE ACCOUNT WAS PAID DATE-PAID-YR PIC XX DATE-PAID-MO PIC XX DATE-PAID-DAY PIC XX DATE-WITHDREW DATE STUDENT WITHDREW FROM CLASS DATE-LAST-MO PIC XX DATE-LAST-DAY PIC XX GRADE-LETTER PIC X LETTER GRADE (SAME AS SIS) GRADE-PERCENT PIC S9(3) PERCENT GRADE (000 - 100) RI-PRINT-FLAG PIC X IDENTIFIES STATUS OF PRINTING OF RI FORMS 0 - REGISTERED BUT NO RI FORM PRINTED 1 - RI FORM PRINTED B - REGISTERED, BILLED TO SPONSOR WITHDRAW-TYPE PIC X INDICATES TYPE OF WITHDRAWAL S - STUDENT A - ADMINISTRATIVE C - COLLEGE WITHDRAW-NOTIFY-FLAG PIC X INDICATES IF CARD WRITTEN BLANK - IF GRADE IS 'W' PRINT CARD Y - CARD PRINTED SESSION PIC X INDICATES TYPE OF SESSION SPONSOR-CODE PIC X(4) INDICATES ACCT THAT SPONSORED STUDENT FOR CLASS STUDENT-MISC-FEE PIC S9(3)V99 MISCELLANEOUS FEE LAB-FEE PIC S9(3)V99 LABORATORY FEE CREATION-DATE PIC 9(5) JULIAN DATE SEGMENT WAS CREATED REAPPLY-FLAG PIC X INDICATES IF MONEY WAS REAPPLIED ' ' NO REAPPLICATION '1' PAID IN FULL BY REAPPLY '2' PARTIALLY PAID BY REAPPLY REAPPLY-PART-AMT PIC S9(5)V99 PART OF TUITION THAT IS PAID (ONLY WHEN FLAG= '2') DROP-FLAG PIC X RESERVED FOR FUTURE USE DROP-PART-AMT PIC S9(5)V99 RESERVED FOR FUTURE USE TUITION-RATE PIC S9(5)V99 IF STUDENT PAYS DIFFERENT TUITION THAN CLASS MASTER REGIS-SEGMENT-FILLER PIC X(10) TIME-STAMP PIC 9(6) ] LTERM-ID PIC X(8) ] USED BY ACCTS REC. DATE-CHANGED PIC 9(5) ] PROGRAM-CODE PIC X(8) ] TO BE DEFINED PROCESS-CODE PIC X ] FILLER PIC X(5) STUDENT OBLIGATION AUDIT SEGMENT ------- ---------- ----- ------- IDENTICAL TO SIS STUDENT OBLIGATION AUDIT SEGMENT (STUOBAUD) COURSE DATA BASE COURSE MASTER SEGMENT ------ ------ ------- COURSE-ID CODE TO IDENTIFY EACH COURSE COURSE-DEPARTMENT PIC XXXX DEPARTMENT (MUST BE IDENTICAL TO SCHEV APPROVED PREFIX) COURSE-NUMBER PIC XXX COURSE NUMBER ACTIVE-INACTIVE PIC X A - ACTIVE, I - INACTIVE COURSE-TITLE-14 PIC X(14) SHORT COURSE TITLE COURSE-TITLE-40 PIC X(40) LONG COURSE TITLE TERM-FIRST-VALID PIC XXX FIRST TERM A COURSE MAY BE OFFERED TERM-LAST-VALID PIC XXX LAST TERM A COURSE MAY BE OFFERED DIVISIONS-AUTHORIZED-COUNT PIC S9(4) COUNT OF DIVISIONS AUTHORIZED TO OFFER THAT COURSE DIVISIONS-AUTHORIZED OCCURS 1 TO 25 TIMES DEPENDING ON DIVISION-AUTHORIZED-COUNT PIC XX. WHICH DIVISION IS AUTHORIZED TO OFFER A COURSE. * CLASS DATA BASE CLASS MASTER SEGMENT ----- ------ ------- CLASS-ID CODE TO IDENTIFY EACH CLASS TERM-ID TERM-YR PIC XX YEAR TERM-CODE PIC X CODE TO IDENTIFY TERM CAMPUS PIC X CAMPUS CODE DEPARTMENT PIC X(4) DEPARTMENT CODE (MUST BE IDENTICAL TO SCHEV APPROVED PREFIX) COURSE-NUM PIC X(3) COURSE NUMBER SECTION-NO PIC XX SECTION NUMBER LEC-LAB PIC X LECTURE-LAB INDICATOR BLANK - LECTURE L - LAB DIVISION-CODE CODE TO IDENTIFY THE DIVISION CAMPUS PIC X CAMPUS CODE DIV-CODE PIC X DIVISION CODE CLASS-END-DATE DATE CLASS ENDS OR LAST DATE OF TERM CLASS-END-YR PIC XX CLASS-END-MO PIC XX CLASS-END-DAY PIC XX CLASS-START-DATE DATE CLASS STARTS OR FIRST DATE OF TERM CLASS-START-YR PIC XX CLASS-START-MO PIC XX CLASS-START-DAY PIC XX CLASS-WITHDRAW-DATE DATE CAN WITHDRAW WITH REFUND CLASS-WITHDRAW-YR PIC XX CLASS-WITHDRAW-MO PIC XX CLASS-WITHDRAW-DAY PIC XX CLASS-STATUS PIC X CODE TO IDENTIFY CLASS STATUS C - CLASS CANCELLED P - OPENING PENDING F - FILLED O - OPEN COLLAPSE-CODE PIC X COURSE COLLAPSED INTO ANOTHER 0 - NOT COLLASPED 1 - COMBINED FOR REPORTING 2 - COMBINED FOR ROOM OVERLAP CEU-CREDITS PIC S999V99 CREDIT HOURS FOR COURSE (ZEROS IF NO CEU'S AWARDED) ENROLL-ACTUAL PIC S9(4) NUMBER CURRENTLY ENROLLED ENROLL-MAX PIC S9(4) NUMBER SEATS AVAILABLE IN ROOM WHERE CLASS TO BE TAUGHT TO SELECT STUDENTS HELD-SEATS PIC S9(4) NUMBER OF SEATS RESTRICTED TO SELECT STUDENTS RESTRICT-CODE PIC X INDICATES IF CLASS IS RE- STRICTED BLANK - NOT RESTRICTED R - ENROLLMENT RE- STRICTED LAB-FEE PIC S9(3)V99 LAB FEE APPLICABLE TO CLASS REVENUE-CODE PIC 9(3) REVENUE CODE OF LAB FEE CLASS-EXPENSES-NB PIC S9(5)V99 NON-BILLABLE CLASS EXPENSES HEGIS-CODE PIC X(6) HEGIS CODE DEPT-ACCOUNT-CODE PIC S9(3) DEPARTMENT ACCOUNT CODE CE-OFFICE-PERCENT PIC 9(3) PERCENT CHARGED BY CE OFFICE SESSION PIC X INDICATES TYPE OF SESSION SPONSOR-CODE PIC X(4) ACCOUNT CODE OF COMPANY SPONSORING CLASS HOST-CODE PIC X(4) ACCOUNT CODE OF COMPANY HOSTING CLASS CONTACT-HR-TOT PIC 9(3)V99 TOTAL CONTACT HOURS FOR CLASS COMPANY-ENROL PIC X(4) TOTAL ENROLLED FOR CLASS WHEN STUDENT NAMES ARE NOT AVAILABLE COMPANY-TUITION PIC 9(5)V99 THE AMOUNT OF TUITION THE COMP-3 SPONSOR COMPANY IS LIABLE FOR WHEN THE SPONSOR-CODE IS A BILLABLE ACCOUNT. CE-OFFICE-FEE PIC S9(5)V99 (BILLABLE EXPENSES + COMP-3 TOTAL TUITION) TIMES THE C.E. OFFICE PERCENT COMPANY-EXPENSES-B PIC S9(5)V99 BILLABLE COMPANY EXPENSES STUDENT-MISC-FEE PIC S9(3)V99 MISCELLANEOUS FEES TUITION-RATE PIC S9(5)V99 TUITION RATE FOR CLASS MISC-FEE-FLAG PIC X IS COMPANY SPONSORED STUDENT RESPONSIBLE FOR MISC FEE? BLANK = NO Y = YES LAB-FEE-FLAG PIC X IS COMPANY SPONSORED STUDENT RESPONSIBLE FOR LAB FEE? BLANK = NO Y = YES TUITION-FLAG PIC X IS COMPANY SPONSORED STUDENT RESPONSIBLE FOR TUITION? BLANK = NO Y = YES INVOICE-PRINTED-DATE PIC X(6) DATE INVOICE WAS PRINTED JURISDICTION PIC X(3) VALID CODE FROM JURISDICTION MASTER - USE 'ZZZ' FOR UNKNOWN CONSORTIUM-CODE PIC X(2) CONSORTIUM CODE VALID CONSORTIUM CODES (USED IN SCHEV Q1 REPORT) 01 - NORTHERN 02 - CAPITAL 03 - VALLEY 04 - CENTRAL 05 - TIDEWATER 06 - WESTERN BILLABLE-AMOUNT PIC S9(7)V99 BILLABLE COMPANY EXPENSES + COMP-3 TOTAL TUITION (FOR SPONSOR) + LAB FEE (FOR SPONSOR) + MISC FEE (FOR SPONSOR) + C.E. OFFICE FEE FILLER PIC X(35) CLASS DETAIL SEGMENT ----- ------ ------- CLASS-REC-NO PIC 9(2) SEQUENCE OF CLASS RECORD DETAIL ADJUSTED-CONTACT PIC S99V999 CONTACT HOURS USED IF IN- STRUCTOR CONTACT HOURS NOT USED ADJUSTED-CREDITS PIC S999V999 CREDIT HOURS USED IF INSTRUC- TOR CREDIT HOURS NOT USED CAMP-BLDG-ROOM CAMPUS PIC X CAMPUS CODE BUILDING PIC X(3) BUILDING CODE ROOM-NUMBER PIC X(4) ROOM NUMBER CLASS-TIME TIME OF DAY (MILITARY TIME) CLASS-START-TIME CLASS IS TAUGHT CLASS-START-HR PIC XX CLASS-START-MIN PIC XX CLASS-END-TIME CLASS-END-HR PIC XX CLASS-END-MIN PIC XX DAYS-TAUGHT DAYS OF WEEK CLASS TAUGHT DAY1 PIC X M - MONDAY DAY2 PIC X T - TUESDAY DAY3 PIC X W - WEDNESDAY DAY4 PIC X R - THURSDAY DAY5 PIC X F - FRIDAY DAY6 PIC X S - SATURDAY DAY7 PIC X U - SUNDAY INSTRUCTOR-CREDIT-HOURS CREDIT HOURS AWARDED FOR PIC 99V99 INSTUCTOR WORKLOAD INS-CR-HOURS REDEFINES INSTRUCTOR-CREDIT-HOURS PIC XXXX SOCIAL-SECURITY PIC 9(9) SOCIAL SECUITY NUMBER OF CLASS INSTRUCTOR TEACHING-LOAD PIC X INDICATES FACULTY CONTRACT 1 - FULL-TIME (9 MONTHS) 2 - STAFF 3 - PART-TIME FACULTY 4 - FULL-TIME OVERLOAD WITH PAY 5 - STAFF OVERLOAD WITH PAY 6 - FULL-TIME (12 MONTHS) 7 - CCIA (CONSIDERED PART-TIME FACULTY) INSTRUCTOR-CONTACT-HOURS PIC S9(3)V99 CONTACT HOURS AWARDED IN- STRUCTOR WORKLOAD INSTRUCT-WEEKS PIC X PROVIDES ACCURATE CONTACT HOUR CALCULATION FOR IN- STRUCTOR AND WORKLOAD AL- LOCATION AMONG INSTRUCTORS BLANK - NOT MULTI-TAUGHT CL 1 - 1 WEEK 2 - 2 WEEKS 3 - 3 WEEKS 4 - 4 WEEKS 5 - 5 WEEKS 6 - 6 WEEKS 7 - 7 WEEKS 8 - 8 WEEKS 9 - 9 WEEKS A - 10 WEEKS B - 11 WEEKS C - 12 WEEKS D - 13 WEEKS E - 14 WEEKS F - 15 WEEKS R - 2 1/2 WEEKS W - 3 1/3 WEEKS S - 3 3/4 WEEKS U - 7 1/2 WEEKS 0 - COLLAPSED CLASS - NOT COUNTED INSTRUCTOR-FEE PIC S9(4)V99 FEE INSTRUCTOR PAID FOR CLASS INSTRUCTOR-PERCENT PIC S9(3) PERCENTAGE INSTRUCTOR PAID FOR CLASS FILLER PIC X(20) CLASS REMARKS SEGMENT ----- ------- ------- REMARK-RECORD-NO PIC 99 SEQUENCE NUMBER TO IDENTIFY CLASS-REMARKS PIC X(64) EXPLANATORY CLASS REMARKS CLASS NOTES SEGMENT ----- ----- ------- NOTES-RECORD-NO PIC 99 SEQUENCE NUMBER TO IDENTIFY CLASS-NOTES PIC X(64) EXPLANATORY CLASS NOTES CLASS EQUIPMENT SEGMENT ----- --------- ------- EQUIP-RECORD-NO PIC 99 SEQUENCE NUMBER BEGINNING-DATE PIC X(6) BEGINNING DATE (YYMMDD) ENDING-DATE PIC X(6) ENDING DATE (YYMMDD) CLASS-EQUIP PIC X(52) EQUIPMENT NEEDED FOR CLASS * 4.0 PROGRAM DOCUMENTATION: --------------------- PROGRAM SUMMARIES ------- --------- CEU010 - CEU STUDENT UPDATE ------ THIS PROGRAM IS USED TO UPDATE THE STUDENT MASTER SEGMENT. A STUDENT MASTER SEGMENT IS CREATED FOR EACH CEU STUDENT. SEGMENTS MAY BE UPDATED BUT CANNOT BE DELETED FROM THIS SCREEN. CEU020 - STUDENT REGISTRATION ------ THIS PROGRAM IS USED TO REGISTER A CEU STUDENT. WHEN THE SOCIAL SECURITY NUMBER IS ENTERED ALL INFORMATION ABOUT THE STUDENT IS DISPLAYED ON THE SCREEN AND ANY CLASSES FOR WHICH THE STUDENT IS CURRENTLY ENROLLED. THE STUDENT MAY THEN BE ENROLLED IN CLASSES. A STUDENT DETAIL SEGMENT IS CREATED FOR EACH CLASS IN WHICH THE STUDENT IS ENROLLED. CEU025 - STUDENT WITHDRAWAL ------ THIS PROGRAM ALLOWS A STUDENT TO BE WITHDRAWN FROM A CLASS AFTER THE ADD/DROP DATE. CEU030 - CLASS ROSTER TERMINAL/IMS PRINT/HARDCOPY/LABELS ------ THIS PROGRAM PRODUCES THE CLASS ROSTER SHOWING DATA FOR THE CLASS AND THE CLASS ROLL. THE CLASS ROSTER MAY BE DISPLAYED ON THE SCREEN, PRINTED, AND/OR LABELS PRODUCED AS THE USER CHOOSES. CEU040 - GRADE ASSIGNMENT BY CLASS ------ THIS PROGRAM ALLOWS GRADES FOR A CLASS TO BE ENTERED THROUGH THE SCREEN. CEU055 - CHANGE/DELETE SOCIAL SECURITY NUMBER ------ THIS PROGRAM ALLOWS THE SOCIAL SECURITY NUMBER TO BE CHANGED OR DELETED. CEU060 - MASS REGISTRATION/DROP ------ THIS PROGRAM ALLOWS ALL STUDENTS TO BE REGISTERED FOR ONE CLASS AT ONE TIME OR DROPPED FROM A CLASS AT ONE TIME. * CEU072 - FINANCIAL INQUIRY ------ THIS PROGRAM ALLOWS THE USER TO HAVE ONLINE INFORMATION AS TO CLASS EXPENSES, INSTRUCTOR SALARY, TOTAL TUITION PAID AND DIFFERENTIAL AMOUNT FOR A SPECIFIC CLASS. * - PROGRAM HAS NOT BEEN WRITTEN. CEU080 - STUDENT INQUIRY ------ THIS PROGRAM ALLOWS THE ENTRY OF A STUDENT SOCIAL SECURITY NUMBER AND THE STUDENT DATA IS SHOWN INCLUDING ALL CLASSES FOR WHICH THE STUDENT IS REGISTERED. ** CEU082 - COURSE INQUIRY ------ THIS PROGRAM ALLOWS THE ENTRY OF THE DEPARTMENT AND COURSE NUMBER AND DISPLAYS ALL SECTIONS OF THAT COURSE. ** - PROGRAM IS IN BETA TEST. ** CEU083 - INSTRUCTOR INQUIRY ------ THIS PROGRAM ALLOWS THE ENTRY OF AN INSTRUCTOR'S SOCIAL SECURITY NUMBER AND DISPLAYS ALL CLASSES ASSIGNED TO THAT INSTRUCTOR. ** - PROGRAM IS IN BETA TEST. ** CEU084 - ENROLLMENT INQUIRY ------ THIS PROGRAM ALLOWS THE ENTRY OF A DEPARTMENT AND SHOWS THE ENROLLMENT IN ALL SECTIONS. ** - PROGRAM IS IN BETA TEST. CEU100 - UPDATE CEU COURSE MASTER ------ THIS PROGRAM UPDATES THE CEU COURSE MASTER. CEU110 - CLASS MASTER/DETAIL UPDATE ------ THIS PROGRAM UPDATES THE CLASS MASTER SEGMENT OF THE DATA BASE. BEGINNING AND ENDING DATES, DAYS, BUILDING AND ROOM ARE SOME OF THE DATA INCLUDED IN THIS SEGMENT. IT ALSO UPDATES THE CLASS DETAIL SEGMENT. THERE IS A SEGMENT PER ROOM/INSTRUCTOR/TIME/DAYS PER CLASS SECTION. DATA IN THIS SEGMENT INCLUDES INSTRUCTOR'S SOCIAL SECURITY NUMBER AND THE TIME, PLACE AND DAYS THE CLASS MEETS. CEU116 - CLASS NOTES/REMARKS UPDATE ------ THIS PROGRAM UPDATES THE CLASS NOTES SEGMENT OR THE REMARKS SEGMENT. THE DATA CONTAINED IN THE IN THE NOTES AND REMARKS SEGMENTS ARE RECORD NUMBER (GENERATED BY THE PROGRAM) AND INFORMATION. CEU117 - CLASS EQUIPMENT UPDATE ------ THIS PROGRAM UPDATES THE CLASS EQUIPMENT SEGMENT. EQUIPMENT REQUIRED IS ENTERED ALONG WITH A BEGINNING AND ENDING DATE. CEU170 - REGISTRATION IDENTIFICATION SCREEN FOR NON-ACCOUNTING ------ THIS PROGRAM IS USED TO PRINT R/I FORMS. A REGISTRATION IDENTIFICATION FORM WILL BE PRINTED FOR EACH SSN ENTERED. CEU310 - CREATE NEW TERM FROM PREVIOUS TERM DATA. ------ THIS BATCH UPDATE PROGRAM TAKES THE DATA FROM A PREVIOUS TERM AND INSERTS IT INTO THE DATA BASE WITH THE NEW TERM YEAR. CEU351 - CLASS ROSTER/GRADE ROLLS WITH COMMENTS TO THE INSTRUCTOR ------ THIS BATCH PROGRAM PRODUCES THE CLASS ROSTER OR GRADE ROLL WITH ANY COMMENTS TO THE INSTRUCTOR FOR ANY OR ALL CLASSES. CLASS ID IS ENTERED THROUGH CEU030 SCREEN. CEU500 - SCHEDULE OF CLASSES ------ THIS BATCH PROGRAM PRODUCES A LISTING OF THE SCHEDULE SHOWING DATA CONCERNING THE CLASSES INCLUDING THE SEATS HELD, AND SEATS AVAILABLE. TUITION INFORMATION IS OPTIONAL. CEU501 - NEWPAPER SCHEDULE OF CLASSES ------ THIS BATCH PROGRAM PRODUCES A LISTING OF THE SCHEDULE FOR PRINTING BY THE NEWSPAPER. CEU515 - UNPAID STUDENTS LIST ------ THIS REPORT IS TO BE USED IN PHASE I TO FLAG THE STUDENTS STUDENTS WHO HAVE NOT PAID TUITION. CEU525 - COURSE MASTER REFERENCE LIST ------ THIS BATCH PROGRAM PRINTS THE CEU COURSE MASTER. CEU530 - CEU MAILING LABELS AND/OR LISTING ------ THIS BATCH PROGRAM PRODUCES LABELS OR LISTING DEPENDING ON OPTIONS SELECTED. OPTIONS INCLUDE ALL STUDENTS, ACTIVE OR INACTIVE STUDENTS, OR SENIOR CITIZENS. THE LABELS CAN BE SORTED BY NAME OR ZIP CODE. CEU540 - CEU ENROLLMENT RECAP ------ THIS BATCH PROGRAM PRINTS AN ENROLLMENT RECAP SHOWING ENROLLMENT BY SEX AND RACE, NUMBER OF CLASSES, CREDITS, AND STUDENTS IN CREDIT AND NON-CREDIT CLASSES AND DAY AND EVENING CLASSES. CEU550 - SHEV Q1 REPORT ------ THIS BATCH PROGRAM PRODUCES A REPORT SHOWING ACTIVITY, NUMBER OF OFFERINGS BY FORMAT, NUMBER OF REGISTRANTS, NUMBER OF CONTACT HOURS, AND TOTAL CREDITS AWARDED. CEU572 - FINANCIAL REPORT BY CLASS ------ THIS BATCH PROGRAM PRODUCES A REPORT SHOWING COURSE ID, TITLE, DATES, INSTRUCTOR, CEU CREDITS, ACTUAL CLASS EN- ROLLMENT, TOTAL TUITION PAID, EXPENSES, SALARY, AND DIFFERENTIAL AMOUNT. CEU580 - CEU LABELS ------ THIS BATCH PROGRAM PRODUCES LABELS SHOWING THE NAME, SOCIAL SECURITY NUMBER, CLASS, CEU CREDITS, AND GRADES. * CEU610 - GRADE MAILERS ------ THIS PROGRAM PRODUCES GRADE MAILERS FOR THE TERM. * - PROGRAM HAS NOT BEEN WRITTEN. CEU620 - CLASS ROSTERS ------ THIS PROGRAM PRODUCES A LISTING OF CLASSES DEPENDING ON THE OPTIONS SELECTED. OPTIONS ARE SIMILAR TO REG531 BATCH ROLLS. * CEU630 - LETTERS TO STUDENTS IN CANCELLED CLASSES ------ THIS PROGRAM PRODUCES A LETTER FOR ALL STUDENTS IN CANCELLED CLASSES. * - PROGRAM HAS NOT BEEN WRITTEN. * CEU640 - NAME TAGS FOR CLASSES ------ THIS PROGRAM PRODUCES NAME TAGS FOR A GIVEN CLASS SHOWING STUDENT NAME, COMPANY NAME, AND CLASS. * - PROGRAM HAS NOT BEEN WRITTEN. * CEU680 - FACULTY SCHEDULE BY DATE AND TERM ------ THIS PROGRAM PRODUCES A REPORT SHOWING THE FACULTY SCHEDULE BY TERM SHOWING THE AMOUNT OF CLASS INSTRUCTION WITH AN OPTION SHOWING THE TUITION COLLECTED, THE CLASS EXPENSES, AND DIFFERENTIAL AMOUNT. * - PROGRAM HAS NOT BEEN WRITTEN. * CEU700 - PRINT CERTIFICATES ------ THIS PROGRAM PRINTS THE PROPER CERTIFICATE SHOWING THE STUDENT'S NAME, DATE OF COMPLETION, AND CLASS TITLE, WITH APPROPRIATE LINES FOR AUTHORIZED SIGNATURES. * - PROGRAM HAS NOT BEEN WRITTEN. CEU740 - ROOM AVAILABILITY AND CONFLICT LIST ------ MODIFIED TO ACCESS BOTH SIS AND CEU DATA BASES. REPORT CAN BE RUN FOR EITHER SIS, CEU OR BOTH. * CEU760 - LIST OF EQUIPMENT NEEDED FOR CLASSES BY DATE/TERM - ------ WEEKLY THIS PROGRAM PRODUCES A LISTING OF EQUIPMENT NEEDED BY CLASSES. OPTIONS ARE BY TERM OR WEEK. * - PROGRAM HAS NOT BEEN WRITTEN. * CEU777 - LIST AND LABELS OF COMPANIES BY ACCOUNT CODES ------ THIS PROGRAM PRODUCES A LIST AND MAILING LABELS OF COMPANIES FROM THE ACCOUNT MASTER. * - PROGRAM HAS NOT BEEN WRITTEN. * CEU780 - CEU STUDENT OBLIGATIONS ------ THIS PROGRAM PRINTS A LIST OF CEU STUDENTS WITH UNPAID OBLIGATIONS AND THE OBLIGATIONS AND TOTALS DUE. * - PROGRAM HAS NOT BEEN WRITTEN. REF135 - UPDATE HEGIS CODES ------ THIS ONLINE PROGRAM UPDATES THE HEGIS CODES ON THE CONTROL DATA BASE. REF635 - HEGIS CODES REFERENCE LIST ------ THIS BATCH PROGRAM PRINTS THE HEGIS CODES. 5.0 IMPLEMENTATION PROCEDURE: ------------------------ THE FOLLOWING EQUIPMENT IS SUGGESTED FOR IMPLEMENTATION. 5.1 HARDWARE: -------- I. EQUIPMENT NEEDED: A. CONTINUING EDUCATION (NON-CREDIT) OFFICE: EQUIPMENT: 3270 COMPATIBLE TERMINAL EXAMPLE: TELEX 078, 079 OR 278 PURPOSE: ADD/UPDATE APPLICATION DATA ADD/UPDATE CLASS DATA REGISTRATION REQUEST REPORTS, ROSTERS AND ETC. B. BUSINESS OFFICE: EQUIPMENT: 3270 COMPATIBLE TERMINAL 3270 COMPATIBLE PRINTER EXAMPLE: TELEX 278 OR 387 PURPOSE: TERMINAL AND PRINTER WILL BE USED FOR R&I FORMS NOTE: THIS CAN BE THE EXISTING EQUIPMENT USED TO PRESENTLY PROCESS SIS R&I FORMS. C. COMPUTER CENTER: EQUIPMENT: 3270 COMPATIBLE PRODUCTION PRINTER EXAMPLE: IBM 3262 OF CONTROL DATA B-600 PURPOSE: PRINT ROSTERS, REPORTS AND NAME TAGS II. OPTIONAL: EQUIPMENT: A. MICRO COMPUTER PRINTER - EPSON LQ-1500, LQ-1050 OR LQ-1000 PURPOSE: PRINT SELECTED CLASS ROSTERS AND NAME TAGS B. HEWLETT PACKARE LASERJET 500, 500 PLUS OR SERIES II PURPOSE: PRINT SELECTED CLASS ROSTERS AND NAME TAGS AND CERTIFICATES THE REGIONAL COORDINATOR FOR EACH COLLEGE MUST ALLOCATE THE CEU DATA BASES. 5.2 SOFTWARE: -------- I. CEUSTUDENT DB. DB NAME CSTDBD DB VSAM NAME SODBV.SIS.CLUSPROD.XXXXX.CSTDBD A. SEGMENT NAME CEUSTUDENT MASTER RECORD IS SEQUENCED AND UNIQUE RECORD LENGTH IS 312 BYTES CAPACITY - 10,000 RECORDS B. SEGMENT NAME REGISTRATION DETAIL RECORD IS SEQUENCED AND UNIQUE RECORD LENGTH IS 83 BYTES CAPACITY - 100,000 RECORDS C. SEGMENT NAME ACCOUNT DETAIL RECORD IS SEQUENCED AND MULTIPLE RECORD LENGTH IS 72 BYTES CAPACITY - 35,000 RECORDS D. SEGMENT NAME OBLIGATION DETAIL RECORD IS SEQUENCED AND UNIQUE RECORD LENGTH IS 56 BYTES CAPACITY - 3,000 RECORDS E. SEGMENT NAME DROP REGISTRATION DETAIL RECORD IS SEQUENCED AND MULTIPLE RECORD LENGTH IS 112 BYTES CAPACITY - 3,000 F. SEGMENT NAME OBLIGATION AUDIT DETAIL RECORD IS SEQUENCED AND MULTIPLE RECORD LENGTH IS 73 BYTES CAPACITY - 3,000 II. CEUCOURSE DB. DB NAME CCRDBD DB VSAM NAME SODBV.SIS.CLUSPROD.XXXXX.CCRDBD A. SEGMENT NAME CEUCOURSE MASTER RECORD IS SEQUENCED AND MULTIPLE RECORD LENGTH IS 141 BYTES CAPACITY - 1,000 RECORDS III. CEUCLASS DB. DB NAME CCLDBD DB VSAM NAME SODBV.SIS.CLUSPROD.XXXXX.CCLDBD A. SEGMENT NAME CEUCLASS MASTER RECORD IS SEQUENCED AND UNIQUE RECORD LENGTH IS 160 BYTES CAPACITY - 5,000 RECORDS B. SEGMENT NAME CEUCLASS DETAIL RECORD IS SEQUENCED AND UNIQUE RECORD LENGTH IS 76 BYTES CAPACITY - 6,500 RECORDS C. SEGMENT NAME REMARKS DETAIL RECORD IS SEQUENCED AND UNIQUE RECORD LENGTH IS 66 BYTES CAPACITY - 2,000 RECORDS D. SEGMENT NAME CLSNOTES DETAIL RECORD IS SEQUENCED AND UNIQUE RECORD LENGTH IS 66 BYTES CAPACITY - 2,000 RECORDS E. SEGMENT NAME CLSEQUIP DETAIL RECORD IS SEQUENCED AND UNIQUE RECORD LENGTH IS 66 BYTES CAPACITY - 2,000 RECORDS F. SEGMENT NAME CLASS/STUDENT LOGICAL RECORD IS SEQUENCED AND UNIQUE RECORD LENGTH IS 9 BYTES CAPACITY - 100,000 RECORDS FOLLOWING THE ALLOCATION OF BATA BASES THE APPROPRIATE SIS DATA BASES SHOULD BE UPDATED WITH THE CEU INFORMATION. 1. ACCOUNT MASTER - THE SIS ACCOUNT MASTER (REC010) SHOULD BE UPDATED WITH CEU SPONSOR CODES. 2. DEPARTMENT SEGMENT - THE SIS DEPARTMENT SEGMENT (REF035) SHOULD BE UPDATED WITH CEU DEPARTMENT CODES. 3. INSTRUCTOR MASTER - THE SIS INSTRUCTOR SEGMENT (REF055) SHOULD BE UPDATED WITH CEU INSTRUCTOR ID'S. 4. ROOM SEGMENT - THE SIS ROOM DETAIL SEGMENT (REF015) SHOULD BE UPDATED WITH CEU CLASSROOM NUMBERS. BEFORE RUNNING ANY OF THE CEU PROGRAMS, ALL PROGRAM OPTIONS SHOULD BE CHOSEN. 1. PROG OPTION SEGMENT- THE SIS PROGRAM OPTION SEGMENT (REF070) SHOULD BE UPDATED WITH THE CHOSEN CEU PROGRAM OPTIONS. 6.1 VERSION NO: V4.05 CHANGE DATE: 08/01/89 PROGRAMMER NAME: CAROL WILLIS PROGRAM CHANGE REQUEST NO: 00003506 DESCRIPTION OF CHANGE: CORRECTED TYPOGRAPHICAL ERRORS, CLARIFIED SOME DEFINITIONS, ADDED REST OF DATA BASES USED BY CEU TO DATA BASE DESIGN SECTION. 6.2 VERSION NO: V4.09 CHANGE DATE: 12/13/89 PROGRAMMER NAME: S. EDMONDS PROGRAM CHANGE REQUEST NO: 00004497 DESCRIPTION OF CHANGE: REVISED DOCUMENTATION TO INCLUDE SUBPROGRAMS CEU100S AND CEU200S AND PROGRAM CEU501 TO THE DATA BASE DESIGN SECTION. 6.3 VERSION NO: V4.10 CHANGE DATE: 01/31/90 PROGRAMMER NAME: CAROL WILLIS PROGRAM CHANGE REQUEST NO: 00004890 DESCRIPTION OF CHANGE: ADDED CEU090 - ONLINE TRANSCRIPTS TO PHASE III. 6.4 VERSION NO: V4.16 CHANGE DATE: 08/28/90 PROGRAMMER NAME: CAROL WILLIS PROGRAM CHANGE REQUEST NO: 00006228 DESCRIPTION OF CHANGE: ADDED EDIT INFORMATION TO THE FOLLOWING FIELDS: INSTRUCTOR SSN, DEPARTMENT CODE, CEU CREDITS, CLASS JURISDICTION, STUDENT SSN, NAME, DATE OF BIRTH, AND STUDENT JURISDICTION. 6.5 VERSION NO: V4.26 CHANGE DATE: 08/09/91 PROGRAMMER NAME: CAROL WILLIS PROGRAM CHANGE REQUEST NO: 00008352 DESCRIPTION OF CHANGE: MODIFIED THE STUDENT REGISTRATION, DROP REGISTRATION AND CLASS MASTER LAYOUTS FOR THE TUITION INCREASE CONVERSION. 6.6 VERSION NO: V4.40 CHANGE DATE: 09/15/92 PROGRAMMER NAME: CAROL WILLIS PROGRAM CHANGE REQUEST NO: N/A DESCRIPTION OF CHANGE: UPDATE DOCUMENTATION. 6.7 VERSION NO: V4.41 CHANGE DATE: 11/30/92 PROGRAMMER NAME: CAROL WILLIS PROGRAM CHANGE REQUEST NO: N/A DESCRIPTION OF CHANGE: ADDED CEU310 TO DOCUMENTATION.