0.005/15/94 JUDY GAULDIN 1.0 INTRODUCTION: ------------ THIS SUBSYSTEM SUPPORTS THE UPDATING OF DATA ELEMENTS ON THE STUDENT SEGMENT AND USER SEGMENT OF THE STUDENT DATA BASE. IT READS THE CURRICULUM DATA BASE, ADVISOR DATA BASE, INSTRUCTOR DATA BASE AND CONTROL DATA BASE TO GET NAMES OF DATA ELEMENTS WHEN CODES ARE UPDATED. THE FOLLOWING OPTIONS ARE AVAILABLE: 1. UPDATE NAME, ADDRESS, SSN 2. UPDATE ADVISOR, COUNSELOR, CURRICULUM OR DIVISION 3. UPDATE MISCELLANEOUS DATA 4. UPDATE SIP USER FIELDS 5. UPDATE STUDENT READMIT DATA 6. UPDATE CIRRICULUM LEVEL/CIRRICULUM UPON GRADUATION 2.0 SUBSYSTEM NARRATIVE: ------------------- AFTER A STUDENT HAS BEEN ENTERED ON THE COMPUTER BY THE REGISTRATION SUBSYSTEM, UPDATES MAY BE MADE TO THE STUDENT SEGMENT AND THE USER SEGMENT BY USING THE STUDENT DATA CHANGES SUBSYSTEM. IF A SOCIAL SECURITY NUMBER CHANGE IS ENTERED, THE NEW SOCIAL SECURITY NUMBER WILL BE ADDED TO THE STUDENT SEGMENT LEAVING ALL OTHER INFORMATION AS IS ON THAT RECORD. ALL OTHER SEGMENTS OF THE STUDENT DATA BASE ARE SEARCHED FOR THE OLD SOCIAL SECURITY NUMBER. WHEN ONE IS FOUND, A RECORD CONTAINING THE NEW SOCIAL SECURITY IS ADDED TO THE APPROPRIATE SEGMENT LEAVING ALL OTHER INFORMATION AS IS ON THAT RECORD. AFTER ALL RECORDS HAVE BEEN ADDED WITH THE NEW SOCIAL SECURITY NUMBER, THE RECORDS CONTAINING THE OLD SOCIAL SECURITY NUMBER ARE DELETED FROM THE DATA BASE. LOGICAL RELATIONSHIPS FOR CURRICULUM/STUDENT, ADVISOR/ STUDENT AND CLASS/STUDENT ARE ALSO UPDATED. OTHER DATA ELEMENTS THAT MAY BE UPDATED BY EACH PROGRAM OF THIS SUBSYSTEM ARE: STU020 - UPDATE NAME, ADDRESS, SSN NAME, ADDRESS, CITY, STATE, ZIP CODE, HOME PHONE, AND JURISDICTION STU025 - UPDATE NAME, ADDRESS, PHONE NUMBER STU030 - UPDATE ADVISOR, COUNSELOR, CURRICULUM OR DIVISION CAMPUS, SELF ADVISING, DIVISION, ADVISOR, COUNSELOR, CURRICULUM AND 2 + 2. LOGICAL RELATIONSHIPS FOR ADVISOR/STUDENT AND CURRICULUM/STUDENT ARE ALSO UPDATED. STU040 - UPDATE MISCELLANEOUS DATA QUARTER ADMISSION, BIRTH DATE, FORMER NAME, BUSINESS PHONE, SEX, CITIZENSHIP, STUDENT TYPE, RACE, YEAR HIGH SCHOOL GRADUATION OR GED, HIGH SCHOOL CODE, COLLEGE LAST ATTENDED, YEAR OF LAST COLLEGE, ADMISSION FILE COMPLETE FLAG, RI PRINT FLAG, SPECIAL SERVICES, BAD CHECK, SPECIAL AGENCY RATE ELIGIBILITY, QUARTER FIRST ENROLL, QUARTER PREVIOUS ENROLL, QUARTER LAST ENROLL, QUARTER GRADUATED, QUARTER REAPPLIED AND QUARTER ELIGIBLE FOR CONTRACT CLASS. STU060 - UPDATE SIP USER FIELDS USER FIELDS 1 THRU 21. STU061 - STUDENT SIP USER-FIELD INQUIRY THIS INQUIRY PROGRAM RETRIEVES THE COLLEGE SIP-USER-FIELD TITLES FROM THE PROGRAM OPTIONS SEGMENT, READS THE STUDENT'S SOCIAL SECURITY NUMBER, RETRIEVES THE STEDENT RECORD AND THE SIP RECORD. THE SIP RECORD CONTAINS SIP-USER-FIELDS WHICH ARE DESIGNED TO HOLD ADDITIONAL SPECIFIC INFORMATION ABOUT THE STUDENT AND ARE TO BE USED AS EACH COLLEGE REQUIRES. STU080 - UPDATE STUDENT READMIT DATA QUARTER REAPPLY, BIRTH DATE, HOME PHONE, BUSINESS PHONE, DATE OF HIGH SCHOOL GRAD- UATION OR GED, YEAR OF COLLEGE LAST ATTENDED, SEX, RACE, CITIZEN, STUDENT TYPE, HIGH SCHOOL CODE, COLLEGE LAST ATTENDED, AND JURISDICTION. STU090 - UPDATE STUDENT VASA TYPE & NO. THIS ONLINE PROGRAM UPDATES THE STUDENTH/ STUDENTM VISA TYPE AND VISA NUMBER. STU100 - LIBRARY DATA UPDATE THIS ONLINE PROGRAM UPDATE LIBRARY DATA IN THE STUDENT SEGMENT OF THE HISTORY OR STUDENT DATA BASE. FIELDS UPDATED INCLUDE: LIBRARY CAMPUS, LIBRARY CARD NUMBER AND TERM-ID LAST RENEWED. STU350 - CIRRICULUM LEVEL / CIRRICULUM UPDATE THIS BATCH PROGRAM MOVES A '5024' TO THE STUDENTM CIRRICULUM LEVEL / CIRRICULUM FOR STUDENTS WHO HAVE BEEN GRADUATED FOR THE SPECIFIED TERM AND YEAR ON THE PARMCARD; NO UPDATE OCCURS UNLESS A MATCHING GRADUATE CIRRICULUM EXISTS. 2.1 SYSTEM FLOWCHART ---------------- ____________ ____________ ____________ ____________ ____________ ] ] ] ] ] ] ] ] ] ] ] ADVDBD ] ] CLSDBD ] ] CTLDBD ] ] CURDBD ] ] STUDBD ] ]__________] ]__________] ]__________] ]__________] ]__________] ] ] ] ] ] ] ] ] ] ] ]_____________]_____________]_____________]_____________] ] ] ____________________________]____________________________ ] ] ] ] ] ] ] ] ] ] ] ] ] ] ] ] ] ] _____]______ ]_____]______ ]_____]______ ]_____]______ ]_____]______ ]__STU020__] ]]__STU030__] ]]__STU040__] ]]__STU060__] ]]__STU061__] ] UPDATE ] ]] UPDATE ] ]] UPDATE ] ]] UPDATE ] ]] STUDENT ] ] NAME, ] ]]ADV, COUN,] ]] MISC. ] ]] SIP USER ] ]]SIP USER- ] ] ADDRESS, ] ]] CURR OR ] ]] DATA ] ]] FIELDS ] ]] FIELD ] ] SSN ] ]] DIV ] ]] ] ]] ] ]] INQUIRY ] ]__________] ]]__________] ]]__________] ]]__________] ]]__________] ] ] ] ] ] ] ] ] ____]_______ ____]_______ ____]_______ ____]_______ ]__STU080__] ]__STU090__] ]__STU100__] ]__STU350__] ] UPDATE ] ] UPDATE ] ] LIBRARY ] ] UPDATE ] ] STUDENT ] ]STUDENT ] ] DATA ] ]STUDENTM ] ] READMIT ] ]VISA TYPE ] ] UPDATE ] ]CIRRICULUM] ] DATA ] ]& NO. ] ] ] ]LEVEL ] ]__________] ]__________] ]__________] ]__________] _ 3.0 DATA BASE DESIGN: ---------------- THE FOLLOWING DATABASES ARE READ AND/OR UPDATED: 1. STUDENT DATABASE 2. CONTROL DATABASE 3. CURRICULUM DATABASE 4. ADVISOR DATABASE 5. INSTRUCTOR DATABASE 4.0 PROGRAM DOCUMENTATION: --------------------- THE FOLLOWING TABLE SUMMARIZES THE PROGRAMS WHICH COMPRISE THE STUDENT DATA CHANGES SUBSYSTEM: --------------------------------------------------------------- PROGRAM ] DESCRIPTION --------------------------------------------------------------- STU020 ] UPDATE NAME, ADDRESS, SSN --------------------------------------------------------------- STU025 ] UPDATE NAME, ADDRESS, PHONE NUMBER --------------------------------------------------------------- STU030 ] UPDATE ADV, COUN, CURR, OR DIV --------------------------------------------------------------- STU040 ] UPDATE MISCELLANEOUS DATA --------------------------------------------------------------- STU060 ] UPDATE SIP USER FIELDS --------------------------------------------------------------- STU061 ] STUDENT SIP USER-FIELD INQUIRY ---------------------------------------------------------------- STU080 ] UPDATE STUDENT READMIT DATA --------------------------------------------------------------- STU090 ] UPDATE STUDENT VISA TYPE & NO. --------------------------------------------------------------- STU100 ] LIBRARY DATA UPDATE --------------------------------------------------------------- STU350 ] UPDATE STUDENTM CIRRICULUM LEVEL / CIRRICULUM --------------------------------------------------------------- 8.0 CHANGE HISTORY -------------- 8.1 VERSION NO: V4.09 CHANGE DATE: 01/10/90 PROGRAMMER NAME: S. EDMONDS PROGRAM CHANGE REQUEST NO: 00004497 DESCRIPTION OF CHANGE: REVISED DOCUMENTATION BY ADDING THE PROGRAMS STU061, STU090 AND STU100 TO THIS DOCUMENT. 8.2 VERSION NO: V5.12 CHANGE DATE: 05/17/94 PROGRAMMER NAME: A. HASLETT PROGRAM CHANGE REQUEST NO: 00014138 DESCRIPTION OF CHANGE: REVISED DOCUMENTATION BY ADDING PROGRAM STU350