0.005/15/94 CAROL WILLIS 1.0 INTRODUCTION: ------------ THE REGISTRATION SUBSYSTEM SUPPORTS PREPARATION FOR THE REGISTRATION OF STUDENTS AND THE REGISTRATION PROCESS ITSELF. IT ALLOWS FOR THE ONLINE PROCESSING OF STUDENT APPLICATIONS, STUDENT REGISTRATION, DROP/ADD CLASSES AND THE WITHDRAWAL OF STUDENTS FROM ANY CLASS FOR WHICH THE STUDENT IS REGISTERED. INCLUDED IN THE ONLINE REGISTRATION SUBSYSTEM CAPABILITIES ARE CLASS STATUS INQUIRIES, STUDENT INQUIRIES AND SELECTED CLASS ROLLS. R & I FORMS ARE PREPARED AND PRINTED BY THE ONLINE PROCESS. OUTPUT OF THE SUBSYSTEM ENCOMPASSES STUDENT, CLASS, INSTRUCTOR AND SUMMARY REPORTS AND MANY LISTS. 2.0 SUBSYSTEM NARRATIVE: ------------------- WHEN A STUDENT APPLIES FOR ADMISSION TO THE COLLEGE, THE DATA FROM THE VCCS STUDENT APPLICATION FORM IS ENTERED INTO THE STUDENT, CURRICULUM AND ADVISOR DATA BASES. LATER, INFORMATION CAN BE ENTERED TO UPDATE DATA FOR A STUDENT ALREADY ON FILE. THE SOCIAL SECURITY NUMBER IS USED TO RETRIEVE THE FILE WHEN THE STUDENT IS TO BE UPDATED OR TO INITIATE A NEW FILE IN THE CASE OF A NEW STUDENT. IF THE STUDENT IS ALREADY ON THE DATABASE THE CURRENT DATA IS DISPLAYED ON THE SCREEN. OTHERWISE THE SCREEN CONTAINS BLANK FIELDS FOR DATA ENTRY. THE NEW DATA IS THEN ENTERED AND CHECKED FOR VALIDITY. ERRORS ARE HIGHLIGHTED. THE CORRECT DATA IS PROCESSED AND PLACED IN THE APPROPRIATE DATABASE SEGMENTS. AT THIS TIME A NEW SOCIAL SECURITY NUMBER MAY BE ENTERED TO CONTINUE WITH ANOTHER STUDENT OR THE PROCESS MAY BE TERMINATED. REGISTRATION AND DROP/ADD FUNCTIONS ARE PERFORMED INITIALLY BY ENTERING THE STUDENT'S ID. INFORMATION IS RETRIEVED FROM THE STUDENT MASTER SEGMENT AND IS DISPLAYED ON THE SCREEN ALONG WITH ANY CLASSES FOR WHICH HE IS ALREADY REGISTERED DURING THE PROCESSING TERM. CLASSES ARE ADDED OR DELETED FROM THE STUDENT REGISTRATION SEGMENT AND THE CLASS STUDENT LOGICAL RELATIONSHIP SEGMENT. IN ADDITION TO THESE SEGMENTS BEING UPDATED, SEVERAL OTHER DATABASE FIELDS MUST BE UPDATED DEPENDING ON THE TYPE OF PROCESSING BEING PERFORMED. FOR EXAMPLE THE RI-PRINT-FLAG FIELD IN THE STUDENT MASTER SEGEMENT (WHICH IS USED TO DETERMINE WHETHER AN R & I FORM HAS BEEN PRINTED) IS UPDATED TO A '0' FOR INITIAL REGISTRATION. THIS SIGNIFIES ONLY THAT TUITION IS DUE. LATER, DURING ANOTHER PROCESS THE FLAG WILL BE UPDATED TO A '1' WHEN TUITION IS PAID AND THE R & I FORM IS PRINTED. THE SUBSYSTEM IS ABLE TO PROCESS A STUDENTS WHO WISHES TO WITHDRAW FROM A CLASS OR CLASSES FOR WHICH HE IS REGISTERED. IN ORDER TO DO THIS THE TYPE OF WITHDRAWAL, THE DATE OF LAST ATTENDANCE, THE DATE OF WITHDRAWAL, AND THE GRADE RECEIVED MUST BE ENTERED. AFTER ALL INFORMATION IS RECEIVED THE SYSTEM CHECKS THE DATA FOR VALIDITY. WHEN NO ERRORS ARE DETECTED ALL RECORDS ARE PROCESSED AND UPDATED ON THE STUDENT REGISTRATION SEGMENT. THE REGISTRATION SUBSYSTEM SUPPORTS SEVERAL ONLINE INQUIRY PROCEDURES. ONE DISPLAYS INFORMATION ABOUT A STUDENT'S PERSONAL AND REGISTRATION FILES. THE STUDENT INQUIRY OPTION RETRIEVES THE STUDENT'S NAME, ADDRESS, ADVISOR, CURRICULUM AND EACH COURSE FOR WHICH HE IS REGISTERED. INCLUDED IN THE COURSE INFORMATION IS THE DEPARTMENT, SECTION, CAMPUS, LECTURE/LAB, SESSION, CREDITS, GRADE AND ANY WITHDRAWAL DATA. AFTER REVIEWING ALL INFORMATION A NEW STUDENT MAY BE CHOSEN OR THE PROCESS TERMINATED. ANOTHER OPTION IS THE CLASS STATUS INQUIRY. THIS IS USED TO BROWSE A SELECTED CLASS. THE INFORMATION DISPLAYED WHEN THE CLASS ID IS ENTERED INCLUDES ASSOCIATED INFORMATION SUCH AS MEETING TIME, CLASS DATES, CREDITS, SESSION, INSTRUCTOR NAME, BUILDING, ROOM NUMBER, ACTUAL ENROLLMENT, MAXIMUM ENROLLMENT AND COURSE TITLE. AN OPTION IS AVAILABLE TO INQUIRE ABOUT ANY COURSE TO DETERMINE WHO IS REGISTERED FOR THAT COURSE. THE DISPLAY INCLUDES THE STUDENT'S NAME, SOCIAL SECURITY NUMBER, PHONE NUMBER, CURRICULUM AND GRADES. THIS INFORMATION MAY BE CHOSEN IN THREE DIFFERENT FORMATS. DISPLAY CLASS ROLL ON THE SCREEN PRINT A HARD COPY OF THE SELECTED CLASS ROLL (OPTIONAL) PRINT 3-UP MAILING LABELS OF STUDENTS ON THE SELECTED CLASS ROLL (OPTIONAL) WHEN THE REGISTRATION IDENTIFICATION (R & I) FORM IS PRINTED THE STUDENT'S NAME, ADDRESS AND ADVISOR ARE TAKEN FROM THE STUDENT DATA BASE. TUITION IS CALCULATED, THE FORM IS PRINTED AND THE FILE IS UPDATED. THE R & I FORM PROVIDES THE STUDENT WITH A LIST OF CLASSES FOR WHICH HE IS REGISTERED. THE FORM SHOWS THE COURSE-ID, COURSE TITLE, NUMBER OF CREDITS, DAYS OF THE WEEK THE CLASS IS TAUGHT, TIME THE CLASS IS HELD, AND THE ROOM WHERE THE CLASS MEETS. OFFLINE PROCEDURES UPDATE THE DATA BASES ALSO. R & I FORMS CAN BE PRINTED FOR STUDENTS WHO WERE SUBSEQUENTLY DROPPED FROM A CLASS OR CLASSES DUE TO CLASS CANCELATION. THIS PROCEDURE CAUSES THE STUDENT TO BE DELETED FROM THE CANCELLED CLASS. AN OPTION MAY BE CHOSEN TO MERGE LECTURE AND LAB CLASSES. THE STUDENT REGISTRATION AND CLASS MASTER SEGMENTS ARE UPDATED AFTER CERTAIN OF THE LAB CLASSES' CREDITS HAVE BEEN MERGED WITH LECTURE CREDITS. FOR STUDENTS ENROLLED IN CERTAIN BIOLOGY, CHEMISTRY, GEOLOGY, NATURAL SCIENCE AND PHYSICS CLASSES, THE LAB CREDITS ARE UPDATED TO ZERO AND THE LECTURE CLASSES UPDATED TO THE COMBINED CREDITS. ALSO, ENROLLMENT TERMS MAY BE UPDATED ON THE STUDENT MASTER. INFORMATION IS CALCULATED AS TO THE ENROLLMENT TERMS AND STUDENT TYPE BASED ON THE ENTRIES IN THE STUDENT REGISTRATION SEGMENT THIS IS COMPARED TO THE INFORMATION IN THE STUDENT MASTER SEGMENT. AN UPDATE OF THE STUDENT MASTER IS PERFORMED IF NECESSARY. THE REGISTRATION SUBSYSTEM PROVIDES A WIDE RANGE OF REPORTING FEATURES. LISTS OF STUDENT CHOSEN BY VARIOUS CRITERIA CAN BE GENERATED, SUCH AS STUDENTS BY AGE OR STUDENTS BY CURRICULUM FOR A SPECIFIED TERM. USING INFORMATION FROM THE STUDENT AND CLASS DATA BASES, A REGISTRATION SUMMARY REPORT, SUMMARIZING TUITION AMOUNT, TOTAL CREDITS AND NUMBER OF STUDENTS ENROLLED IS PRINTED. INSTRUCTOR SCHEDULES AND WORKLOAD REPORTS ARE ALSO PRODUCED BY THE SUBSYSTEM. 3.0 DATA BASE DESIGN: ---------------- 3.1 DATA BASE DIAGRAM: ----------------- SEE APPENDIX A 3.2 DATA BASE DESCRIPTION: --------------------- 3.2.1 STUDENT DATA BASE SEGMENTS -------------------------- STUDENT MASTER CONTAINS DEMOGRAPHIC AND DESCRIPTIVE DATA KEY IS STUDENT SOCIAL SECURITY NUMBER STUDENT REGISTRATION ONE ENTRY FOR EACH COURSE FOR WHICH THE STUDENT IS REGISTERED. KEY IS CLASS-ID STUDENT ACCOUNT DETAIL ONE ENTRY FOR EACH FINANCIAL TRANSACTION PER STUDENT. KEY IS THE ACCOUNT KEY STUDENT TRANSFER ONE ENTRY FOR EACH COURSE TRANSFERRED INTO THE COLLEGE KEY IS TRANSFER-COURSE STUDENT SUBSTITUTION MSTR ONE ENTRY PER CURRICULUM ENROLLED PER STUDENT PER CATALOG YEAR. KEY IS CATALOG YEAR STUDENT SUBSTITUTION DTL ONE ENTRY PER COURSE SUBSTITUTED TOWARD DEGREE IN CURRICULUM YEAR KEY IS COURSE ID STUDENT GRADUATE DTL ONE ENTRY PER GRADUATING CURRICULUM PER STUDENT NO KEY STUDENT TEST DTL ONE ENTRY PER PLACEMENT TEST TAKEN PER STUDENT KEY IS TEST CODE STUDENT VEDS ONE ENTRY PER STUDENT ON VEDS NO KEY STUDENT FINANCIAL AID MSTR ONE ENTRY PER STUDENT ON FINANCIAL AID NO KEY STUDENT FINANCIAL AID DTL ONE ENTRY PER TYPE OF FINANCIAL AID PER STUDENT KEY IS FINANCIAL AID RECORD TYPE AND IS NON-UNIQUE STUDENT OBLIGATION ONE ENTRY PER OBLIGATION PLACED ON STUDENT KEY IS OBLIGATION OCDE STUDENT VEHICLE ONE ENTRY PER VEHICLE REGISTERED KEY IS VEHICLE PERMIT NO. STUDENT USER #1 ONE ENTRY IF NEEDED PER STUDENT NO KEY STUDENT USER #2 ONE ENTRY PER REQUIRED DEVELOPMENTAL COURSE NO KEY STUDENT DROP REGISTRATION ONE ENTRY PER COURSE FOR WHICH STUDENT IS REGISTERED KEY IS CLASS-ID STUDENT EXTEND ONE ENTRY PER COURSE PER TERM FOR WHICH THE STUDENT IS WAIT LISTED (TYPE 08) 3.2.2 CURRICULUM DATA BASE SEGMENTS. ----------------------------- CURRICULUM MASTER ONE ENTRY PER CURRICULUM PER CATALOG YEAR KEY IS CURRICULUM CODE CURRICULUM DETAIL ONE ENTRY PER COURSE PER CURRICULUM PER CATALOG YEAR KEY IS COURSE-ID CURRICULUM ELECTIVE ONE ENTRY PER ASSIGNED ELECTIVE PER CURRICULUM PER CATALOG YEAR KEY IS COURSE-ID CURRICULUM/STUDENT THIS SEGMENT ESTABLISHES A LOGICAL RELATIONSHIP BETWEEN THE CURRICULUM AND STUDENT DATA BASES KEY IS STUDENTS SOCIAL SECURITY NUMBER. 3.2.3 CLASS DATA BASE SEGMENTS. ------------------------ CLASS MASTER ONE ENTRY PER CLASS SECTION KEY IS CLASS-ID CLASS DETAIL ONE ENTRY PER ROOM/ INSTRUCTOR/TIME/DAYS PER CLASS SECTION KEY IS CLASS RECORD NUMBER CLASS REMARKS ONE ENTRY PER REMARK NUMBER KEY IS REMARK RECORD NUMBER CLASS COMBINE CODED DATA USED TO COMBINE >= 2 SECTIONS FOR PAS ANALYSIS KEY IS COMBINE-WITH-CLASS-ID CLASS SUBTITLE ONE ENTRY PER CLASS NO KEY CLASS/STUDENT THIS ESTABLISHES A LOGICAL RELATIONSHIP BETWEEN THE CLASS AND STUDENT DATA BASES KEY IS STUDENTS SOCIAL SECURITY NUMBER. 3.2.4 INSTRUCTOR DATA BASE SEGMENTS. ----------------------------- INSTRUCTOR MASTER ONE ENTRY PER INSTRUCTOR OR OTHER STAFF MENBER KEY IS INSTRUCTORS SOCIAL SECURITY NUMBER INSTRUCTOR RELEASE TIME ONE ENTRY PER RELEASE TIME ASSIGNMENT PER FACULTY MEMBER KEY IS TERM-ID AND IS NON-UNIQUE INSTRUCTOR/CLASS THIS ESTABLISHES A LOGICAL RELATIONSHIP BETWEEN THE INSTRUCTOR AND CLASS DATA BASES KEY IS CLASS KEY INSTRUCTOR/STUDENT THIS ESTABLISHES A LOGICAL RELATIONSHIP BETWEEN THE INSTRUCTOR AND STUDENT DATA BASES KEY IS STUDENT SOCIAL SECURITY NUMBER 3.2.5 COURSE DATA BASE SEGMENTS. ------------------------- DEPARTMENT MASTER ONE ENTRY PER DEPARTMENT KEY IS DEPARTMENT CODE COURSE SEGMENT ONE ENTRY PER COURSE KEY IS COURSE NUMBER AND IS NON-UNIQUE COURSE REQUISITE ONE ENTRY PER REQUISITE PER COURSE NO KEY COURSE WAIT ONE ENTRY PER STUDENT PER COURSE 3.2.6 ADVISOR DATA BASE SEGMENTS. -------------------------- ADVISOR MASTER ONE ENTRY PER ADVISOR OR COUNSELOR KEY IS ADVISOR-COUNSELOR KEY ADVISOR/STUDENT ONE ENTRY PER ADVISOR PER STUDENT OR ONE ENTRY PER COUNSELOR PER STUDENT THIS ESTABLISHES A LOGICAL RELATIONSHIP BETWEEN THE ADVISOR AND STUDENT DATA BASES ADVISOR/INSTRUCTOR ONE ENTRY PER ADVISOR PER INSTRUCTOR OR ONE ENTRY PER COUNSELOR PER INSTRUCTOR THIS ESTABLISHES A LOGICAL RELATIONSHIP BETWEEN THE ADVISOR AND INSTRUCTOR DATA BASES KEY IS INSTRUCTORS SOCIAL SECURITY NUMBER 3.2.7 WORK DATA BASE SEGMENTS. ----------------------- WORK MASTER ONE ENTRY PER PROGRAM USING WORK DATA BASE KEY IS PROGRAM-ID, CAMPUS WORK DETAIL SEQUENCED ONE ENTRY FOR EACH RECORD NEEDED KEY IS SOCIAL SECURITY NO. WORK DETAIL UNSEQUENCED ONE ENTRY FOR EACH RECORD NEEDED NO KEY * 4.0 PROGRAM DOCUMENTATION: --------------------- 4.1 INDEX OF REGISTRATION PROGRAMS: ------------------------------ ONLINE UPDATE AND INQUIRY ------------------------- PGM COLL PROGRAM NAME --- ---- ------------ REG010 AS REGISTRATION AND DROP/ADD (MORE THAN 12) REG020 TN REGISTRATION AND DROP/ADD REG025 VW MULTIPLE STUDENT REGISTRATIONS REG030 TN CLASS WITHDRAWAL REG040 TN STUDENT INQUIRY REG050 TN CLASS STATUS INQUIRY REG060 TN SELECTED CLASS ROLLS REG070 SR STUDENT APPLICATION DATA ENTRY REG090 TC SPECIAL OPPORTUNITY DATA ENTRY REG120 AS ONLINE TUITION REPORT (REG520) REG160 VW INSTR. WORKLOAD INQUIRY REG170 TN R & I FORMS REG180 CV STUDENT PROFILE REG220 TN ADDITIONAL RECOMMEND COURSE INFO REG230 TC UPDATE AID AUTHORIZED CODE REG250 TC MINI-APPLICATION SCREEN REG254 VW UPDATE PLACEMENT TEST SCORES REG255 SR DEVELOPMENTAL MATH ADD/DROP BATCH UPDATING PROGRAMS ----------------------- PGM COLL PROGRAM NAME --- ---- ------------ REG220 TN ADDITIONAL RECOMMEND COURSE INFO REG230 TC UPDATE AID AUTHORIZED CODE REG250 TC MINI-APPLICATION SCREEN REG254 VW UPDATE PLACEMENT TEST SCORES REG255 SR DEVELOPMENTAL MATH ADD/DROP REG301 TN SELF-ADVISING UPDATES REG302 SR CURRICULUM ACCEPTANCE UPDATE REG310 SR BACKOUT UNPAID STUDENTS REG320 TC AUDIT/WITHDRAWAL NOTIFICATION CARD REG341 SO DELETE COURSE WAIT/STUEXTEND SEGMENTS REG351 TN STUDENT PROFILES (WITH ADDT CRS) REG352 CV REGISTRATION SUMMMARY REPORT / BMP REG353 SR CAMPUS, ADV., CURR., CHANGE REPORT REG356 TN PRINT SELECTED CLASS ROLLS/LABELS / BMP REG360 TN HANDICAPPED STUDENTS MAIL LABELS REG363 TC CURRICULUM HEADCOUNT REPORT / BMP REG370 VW INSERT PLACEMENT TESTS FOR STUDENTS COMPLETING INTRODUCTORY CLASSES REG378 TN STUDENT ENROLLMENT SUMMARY REPORT / BMP REG397 TN ADDRESS CHANGE LABELS REG400 TN UPDATE ENROLL QTRS ON STUDENTM REG450 TC MERGE LECTURE/LAB CREDIT HOURS REG480 TC DELETE STUDENTS FROM CANCELED CLASSES REG483 TN ADMISSION FILE LABELS REG484 TN FLAG STUDENTS FOR FOLDER DESTROY REG485 TN MASS CURRICULUM CHANGES REG899 TN UPDATE ENROLL TERMS ON STUDENTM BATCH REPORTING PROGRAMS ------------------------ PGM COLL PROGRAM NAME --- ---- ------------ REG500 TC REGISTRATION SCHEDULING CARD REPORT/LABELS REG531 TN CLASS ROLLS REG540 SR CLASS STATUS REPORT REG545 VW FIX ARCHIVE FILE REG550 TC STUDENT PROFILE REG570 CV INSTRUCTOR WORKLOAD REPORT REG580 CV DIVISION/DEPARTMENT WORKLOAD REPORT REG590 CV STUDENT CURRICULUM LIST REG595 AS ADVISEE REPORT REG600 CV STUDENT BY ADVISOR REG605 TC STUDENTS ADMISSIONS SUMMARY REG615 TC SELECTED TRANSFER STUDENTS NOT ENROLLED REG620 TC STUDENT BY DIVISION REG640 TC CURRICULUM ENROLLMENT SUMMARY REPORT REG645 TC CURR. SPECIALIZATION ENROLLMENT SUMMARY REPORT REG650 CV LOCALITY DISTRIBUTION REPORT REG660 CV STUDENT LIST BY AREA HIGH SCHOOLS REG670 AS STUDENT NAME AND ADDRESS LIST REG680 AS STUDENT NAME LIST - ALPHA REG681 TC STD-DTL REPORT FILE BUILD REG700 TC STUDENT PERM RECORD HEADINGS REG711 TN PRINTS PERMIT TO REG. CARDS REG720 CV FACULTY SCHEDULES REG730 CV RACE CURRICULUM LIST REG740 SR ADDRESS LABELS PROGRAM REG742S AS ADDRESS LABELS SUBPROGRAM REG743 TN SELF ADVISING LIST AND LETTERS REG750 TN STUDENT LOCATOR REPORT REG760 TN STUDENT RETENTION RATE BY RACE REG770 AS DEVELOPMENTAL SATISFACTORY PROGRESS REPORT REG790 NR SCHEV B-8 REPORT REG791 NR STUDENTS BY AGE REPORT REG792 NR STUDENTS BY AGE WITHIN CURRICULUM REPORT REG793 SR STUDENTS AGE BY CAMPUS REG800 AS REPEATED CLASSES REPORT REG806 VW CLASS ROLLBOOK ON PREPRINTED FORMS REG817 VW STUDENT PAST PROGRESS REPORT REG851 TC PAST PROGRESS ROSTER REPORT REG853 VW STUDENT APPLICATIONS BY QTR REG858 VW STUDENTS APPLIED BUT NOT REGISTERED REG859 VW SELECT STUDENT PROFILE RECORDS REG860 VW STUDENT PROFILE REG861 VW STUDENT PROFILE SUMMARY REPORT REG862 CV SELF ADVISING REG864 VW STUDENT CURR. AND ADV. REPORT REG865 VW STUDENTS BY SELECTED CURRICULUM REG867 VW STUDENT OVERLOAD REPORT REG869 VW TRANSFER STUDENTS LISTING REG870 VW STUDENT ADDRESS LISTING REG872 NR STUDENT LIST BY ADVISOR REG874 CV OUT-OF-STATE STUDENTS REG875 VW FOREIGN STUDENTS REPORT REG877 VW STUDENT WITHOUT CURR/ADV CODES REG884 NR STUDENT ENROLLMENT BY ZIPCODE REG885 NR STUDENT ENROLLMENT BY CREDIT HRS REG887 CV PHI THETA KAPPA CANDIDTE LIST REG889 TN STUDENT VOTING LIST REG898 VW MULTIPLE ENROLLMENT LIST REG900 TN DEVELOPMENTAL STUDIES LIST REG901 TN STUDENT RATE OF RETURN REG902 CV INSTRUCTOR WORKLOAD REG903 VW SPRC SERV DEVELOP. COURSE LIST REG904 TC SERVICE MEMBERS OPPORTUNITY REPORT REG906 VW PRINTS CLASS ROLLS REG907 VW APPLICANTS BY QTR & PENDING CURR REG908 VW ACADEMIC SCHOLARSHIP LIST REG910 SR CROSS CAMPUS ENROLLMENT REG911 TN STUDENTS ADV. LIST BY DIVISION REG916 VW SPECIAL SERVICE STUDENT NOT REGISTERED REG917 VW SPECIAL SERVICE STUDENT BY INSTRUCTOR REG918 VW STUDENT NAME/SOC. SEC. LIST REG922 VW ENGLISH PLACEMENT SCORES REG923 TN STUDENTS ADMITTED VS ENROLLED REG926 TN ACTIVE UNCLASS STUDENT CR. HRS > 16 REG927S TN CALCULATE TERMS OF ENROLLMENT REG928 TN CURRICULUM MIS-MATCH REPORT REG930 TN ENROLLED STUDENTS ON SUSPENSION OR DISMISSAL REG931 NR STUDENTS UNDER AGE 18 REG932 SR SELECTED 3-UP LABELS BY COURSE REG933 VW PRINTS SELECTED BUS. STUDENTS REG938 VW ANNUAL HEADCOUNT REPORT REG939 VW STUDENTS WITH ADM FILE INCOMPLETE REG940 SO WAITLIST SEGMENTS REPORT REG942 VW INSTRUCTOR WORKLOAD - VWCC REG945 SO STUDENTS W/O TEST IDS AND PRE/CO-REQUISITES REG950 TC LECTURE/LAB MISMATCH REG951 VW STUDENT DIRECTORY REG952 VW MINORITY STUDENTS BY INSTRUCTOR REG953 VW STUD ENROLL PREV QTR NOT ENROLL REG954 TN GENERALIZED R&I FORM REG955 SR SELECTED LABELS/REPORT REG956 VW STUDENTS NOT CURRENTLY ENROLLED REG958 SR INSTATE FRESHMEN BY SEX/RACE REG959 SR CLASS STATUS FUNDING ANALYSIS REG960 TN STUDENT DATE OF BIRTH LIST REG963 SR ENROLLMENT COMPARISON BY QTR REG963A SR ENROLLMENT COMPARISON BY QTR/SEM REG964 TC STUDENTS WITH 3+ R/U GRADES REG965 TC STUDENT SCHOLARSHIP REPORTS REG967 TC INSTRUCTOR LABELS - 3-UP REG968 TC STATUS ON BENEFICIARIES REG969 TC SELECTED HIGH SCHOOL REPORT REG971 TC STUDENTS IN CO-OP CLASSES REG972 TC MINI APPLICATION IDENTIFICATION REG973 TC 2 + 2 CURRICULUM REPORT REG974 BR STUDENTS BY SELECTED CURRICULUM REG975 BR LISTING OF MINORITY STUDENTS REG976 AS STUDENTS BY ADVISOR REG977 SR ARCHIVE FILE REPORTS REG978 SR STUDENTS BY SEX, RACE, AGE REG979 TN RETURNING STUDENTS BY QTR REG980 AS STUDENT PROFILES AT OFF-CAMP CLS REG981 AS STUDENTS BY DIVISION/ADVISOR REG982 BR STUDENTS QTRS OF ENROLLMENT REG983 SR TOTAL STUDENTS BY ADVISOR REG984 SR CURR. CAMP. ADMISSION TOTALS REG985 SR CURR. LEVEL ENROLLMENT REG986 TN PROMOTION EVALUATION REPORT REG990 SR STUDENTS PENDING ADM. TO A CURR. REG991 SR INTERNATIONAL STUDENTS LIST REG992 TN BUILD FILES ADVISOR ASSIGN LETTER REG993 SR STUDENT LIBRARY LISTING REG994 TC HEADCOUNT/ENROLLMENT SELECTED CLS REG995 TC SOC CURRICULUM SUMMARY REPORT 5.0 PROGRAM DOCUMENTATION: --------------------- 5.1 VERSION NO: V3.03 CHANGE DATE: 10/05/87 PROGRAMMER NAME: R. H. CLARK PROGRAM CHANGE REQUEST NO: SCP-SO-148 DESCRIPTION OF CHANGE: REFERENCES TO QUARTER WERE CHANGED TO TERM IN DOCUMENTATION. 5.2 VERSION NO: V4.10 CHANGE DATE: 01/02/90 PROGRAMMER NAME: S. EDMONDS PROGRAM CHANGE REQUEST NO: 00004497 DESCRIPTION OF CHANGE: REVISED DOCUMENTATION BY ADDING THE FOLLOWING PROGRAMS TO THE 4.0 PROGRAM DOCUMENTATION SECTION: REG025 REG120 REG160 REG220 REG230 REG250 REG254 REG255 REG301 REG302 REG320 REG351 REG360 REG400 REG483 REG484 REG485 REG525 REG711 REG742S REG743 REG793 REG858 REG860 REG862 REG864 REG865 REG867 REG869 REG870 REG874 REG875 REG877 REG887 REG889 REG898 REG900 REG903 REG904 REG906 REG907 REG908 REG910 REG911 REG916 REG917 REG918 REG922 REG923 REG926 REG928 REG932 REG933 REG939 REG951 REG952 REG953 REG954 REG955 REG956 REG958 REG959 REG960 REG963 REG963A REG964 REG965 REG966 REG967 REG968 REG969 REG970 REG971 REG972 REG973 REG974 REG975 REG976 REG977 REG978 REG979 REG980 REG981 REG982 REG983 REG984 REG985 REG986 REG990 REG991 REG992 REG993 REG994 AND ALSO OMITTING REG539, REG571 AND REG888 FROM THE 4.0 PROGRAM DOCUMENTATION SECTION. 5.3 VERSION NO: V4.12 CHANGE DATE: 04/15/90 PROGRAMMER NAME: DANA BRYANT PROGRAM CHANGE REQUEST NO: 4420 DESCRIPTION OF CHANGE: ADDED NEW PROGRAM REG806 TO REPORT PROGRAM LIST. 5.4 VERSION NO: V5.15 CHANGE DATE: 08/15/94 PROGRAMMER NAME: BARBARA SHANKO PROGRAM CHANGE REQUEST NO: 00013853,13854,14476 DESCRIPTION OF CHANGE: REVISED DOCUMENTATION BY ADDING THE FOLLOWING PROGRAMS TO THE 4.0 PROGRAM DOCUMENTATION SECTION: REG341 REG940 REG945 APPENDIX A ---------- DATA BASE DIAGRAM ----------------- STUDENT DATA BASE ------------ ! ! ! STUDENT ! ! ! ------------ ! ! ------------------------------------------------------------- - - - ! ! ! ! ! ! ! ! ! ! ! ! -------- -------- -------- -------- -------- -------- ! !- ! !- ! !- ! !- ! !- ! !- ! REG !! ! ACCT !! ! TRANS!! ! SUBST!! ! GRAD !! ! TEST !! ! !! ! !! ! !! ! !! ! !! ! !! --------! --------! --------! --------! --------! --------! -------- -------- -------- -------- -------- -------- ! ! ! ! -------- -------- ! !- ! !- !DETAIL!! !DETAIL!! ! !! ! !! --------! --------! -------- -------- STUDENT DATA BASE (CONT.) ------------ ! ! ! STUDENT ! ! ! ------------ ! ! - - ------------------------------------------------------------- ! ! ! ! ! ! ! ! ! ! ! ! -------- -------- -------- -------- -------- -------- ! ! ! ! ! !- ! !- ! !- ! !- ! VEDS ! ! FIN ! ! OBLIG!! ! VEH !! ! USER !! ! DROP !! ! ! ! ! ! !! ! !! ! !! ! REG !! -------- -------- --------! --------! --------! --------! ! -------- -------- -------- -------- ! -------- ! !- !DETAIL !! ! !! -------- ! -------- STUDENT DATA BASE (CONT.) ------------ ! ! ! STUDENT ! ! ! ------------ ! ! - - -- ! ! -------- ! ! TYPE ! EXTEN ! (01 - MISC.) ! ! (08 - STUXWAIT) -------- -------- CURRICULUM DATA BASE CLASS DATA BASE ------------ ------------ ! ! ! ! !CURRICULUM! ! CLASS ! ! ! ! ! ------------ ------------ ! ! ! ! ------------ ------------------------------------- ! ! ! ! ! ! ! ! ! ! ! ! -------- -------- -------- -------- -------- -------- ! !- ! ! ! ! ! !- ! !- ! ! !DETAIL !! ! ELEC !! !DETAIL! !REMARK!! ! COMB !! ! SUB ! ! !! ! !! ! ! ! !! ! CLASS!! ! TITLE! -------- ! --------! -------- --------! ------- ! -------- -------- -------- -------- -------- INSTRUCTOR DATA BASE COURSE DATA BASE ------------ ------------ ! ! ! ! !INSTRUCTOR! !DEPARTMENT! ! ! ! ! ------------ ------------ ! ! ! ! -------- -------- ! !- ! !- !RELEAS!! !COURSE!! ! TIME !! ! !! --------! --------! -------- -------- ! ! ----------------------------- ! ! -------- -------- ! !- ! !- ! REQ !! ! WAIT !! ! !! ! !! -------- ! -------- ! -------- -------- ADVISOR DATA BASE SISWORK DATA BASE ------------ ------------ ! ! ! ! ! ADVISOR ! ! WORK ! ! ! ! ! ------------ ------------ ! ! ! ! ------------ ------------ ! ! ! ! ! ! ! ! -------- -------- -------- -------- ! !- ! !- ! !- ! !- !AD/STU!! !AD/INS!! ! SEQ !! ! UNSEQ!! ! !! ! !! ! !! ! !! --------! --------! --------! --------! -------- -------- -------- -------- LOGICAL RELATIONSHIPS ------------ ! ! ! ADVISOR ! ! ! ------------ ! ! ------------ ! ! ! ! ........ ........ ------------ . . . . ! ! .AD/STU. .AD/INS.****************!INSTRUCTOR! . . . . ! ! ........ ........ ------------ * ! * ! ------------ * ---------- ! ! * ! ! !CURRICULUM! * ! ! ! ! * -------- ........ ------------ * ! ! . . ! * !RELEAS! .IN/STU. ! * ! ! . . - - ----------- * -------- ........ ! ! * . ! ! * . -------- ........ * ------------ . ! ! . . * ! ! . ! ELEC ! .CR/STU.****************! STUDENT ! . ! ! . . ! ! -------- ........ ------------ * * * ------------ * ! ! * ! CLASS ! * ! ! * ------------ * ! * ! * - - - ---------- * ! ! * ! ! * -------- ........ * ! ! . . * ! SUB ! .CL/STU. * ! ! . . -------- ........