0.009/21/98 JUDY GAULDIN, VWCC 1.0 PROGRAM NARRATIVE: ----------------- STU020 IS AN ON-LINE PROGRAM WHICH IS USED TO CHANGE OR DELETE A STUDENT'S SOCIAL SECURITY NUMBER ON THE STUDENT DATA BASE, HISTORY DATA BASE, FINANCIAL AID DATA BASE, FIN020 LOG RECORDS WHICH ARE FOUND ON THE SISWORK DATA BASE, ACCOUNTING DATA BASE, AND LOGICAL RELATIONSHIPS MAINTAINED IN THE CLASS DATA BASE, ADVISOR DATA BASE, & CURRICULUM DATA BASE. THESE CHANGES ARE LOGGED TO THE SISWORK DATA BASE. THE PROGRAM OPERATES IN THE FOLLOWING MANNER: 1. AFTER USER HAS INPUT STUDENT SOCIAL SECURITY NUMBER (WHICH HAS BEEN VALIDATED); ALL PERTINENT INFORMATION IS DISPLAYED ON THE SCREEN. 2. CHANGES AND DELETES ARE LOGGED ON THE SIS-WORK FILE. 3. IF A SOCIAL SECURITY NUMBER CHANGE OCCURS, SEVERAL DATA BASES WILL BE UPDATED (STUDENT, HISTORY, FIN-AID, FIN020 LOG RECORDS FOUND ON THE SISWORK DATA BASE, ACCOUNTING, AND LOGICAL RELATIONSHIPS FOR CLASS, ADVISOR, AND CURRICULUM). THE SOCIAL SECURITY CHANGE UTILIZES THE FOLLOWING STEPS: * AFTER VALIDATION THAT THE NEW SSN DOESN'T EXIST FOR ANOTHER STUDENT, THE PROGRAM READS ALL SEGMENTS FOR EACH DATA BASE, INSERTING EACH ONE UNDER THE NEW NUMBER. * AFTER ALL SEGMENTS HAVE BEEN INSERTED, THE ROOT SEGMENT IS THEN DELETED FOR THE SPECIFIC DATA BASE. * ALL FIN020 LOG RECORDS ARE READ AND THE SSN CHANGED IF MATCH IS FOUND (SSN IS NOT PART OF KEY FOR THESE LOG RECORDS). 4. IF DATA BASE ERRORS ARE FOUND WHILE DURING PROCESSING THEN THE PROGRAM WILL ABEND WITH A CODE OF 778. ALL CHANGES MADE TO THE DATA BASES WILL BE BACKED OUT WITH ERROR MESSAGE DISPLAYED ON THE TERMINAL. THE IMS SLAVE PRINTER WILL ALSO PRINT A MORE DETAILED MESSAGE WHICH SHOULD THEN BE EXAMINED BY THE REGIONAL COORDINATOR AT THE REGIONAL CENTER. 5. STU020 ALSO ALLOWS FOR A STUDENT TO BE DELETED. IF USER INDICATES THE DESIRE TO DELETE A STUDENT, STU020 ASKS THE OPERATOR TO CONFIRM THE DELETE BY INDICATING THE INTENT TO DELETE A SECOND TIME. AFTER THE USER INDICATES THE DESIRE TO DELETE THE STUDENT A SECOND TIME, STU020 CHECKS THE FOLLOWING SEGMENTS AND PREVENTS THE DELETION IF ANY OF THESE EXIST FOR THE STUDENT: STUREGIS, STUACCTD, STUOBLIG, STUADCRS, STUGRADM, STUTESTD, STUQUART, STUVEHIC, STUOBAUD, STURPREG, STUALERT, STUEXTEN, STUUSER1(ALL IN STUDENT MASTER DBD), STUHREGI, STUTRACL, STUTRACR, STUASDTY, STUSUBTM, STUHQUAR, STUHTEXT, STUHHIST, STUHRPRG, STUHEXTE, STUHGRAD, STUHOBLI(ALL IN HISTORY STUDENT DBD) OR FINMASTR(FINANCIAL AID DATA BASE). A MESSAGE IS DISPLAYED STATING NO DELETE MAY TAKE PLACE IF ANY OF THE ABOVE ARE FOUND; THE MESSAGE ALSO WILL LIST AN ABBREVIATION FOR EACH SEGMENT FOUND. ASSUMING THE STUDENT CAN BE DELETED, THE ROOT SEGMENT IN THE STUDENT DBD IS DELETED, THE ROOT SEGMENT IN THE HISTORY DATABASE IS DELETED, AND THE FOLLOWING LOGICAL RELATIONSIPS ARE DELETED IF THEY EXIST: ADVISOR, COUNSELOR AND CURRICULUM. A MESSAGE IS NEXT DISPLAYED STATING THE STUDENT HAS BEEN DELETED AND TO CONTINUE. 6. AN OPTION EXISTS WHICH WILL CROSS-CHECK THE OLD AND NEW SSN (OR ONLY OLD IN CASE OF DELETES) TO THE CEU DATA BASE (CEU STUDENT SEGMENT). THIS CROSS-CHECK IS DONE FOR THE PURPOSE OF DISPLAYING INFORMATIONAL TYPE MESSAGES ONLY, NO UPDATES TO THE CEU DATA BASE ARE MADE. THE INFORMATIONAL MESSAGES INSTRUCT USER TO VERIFY DATA BETWEEN THE SYSTEMS AND UPDATE USING CEU055 AND/OR STU025. 2.0 USER OPERATING INSTRUCTIONS: --------------------------- 1. ENTER THE SOCIAL SECURITY NUMBER FOR THE STUDENT TO BE UPDATED AND PRESS 'ENTER'. 2. THE STUDENT'S INFORMATION WILL APPEAR ON THE SCREEN WITH THE FOLLOWING MESSAGE: "CURRENT DATA SHOWN; ENTER CHANGE OR 'D' TO DELETE SSN." 3. IF YOU DO NOT WANT TO MAKE CHANGES TO THIS SPECIFIC STUDENT, PLEASE ENTER A NEW STUDENT SOCIAL SECURITY NUMBER. 4. TO CHANGE A STUDENT'S SOCIAL SECURITY NUMBER, PLACE THE NEW NUMBER IN THE NEW SOCIAL SECURITY FIELD. PRESS 'ENTER'. IF NO OTHER STUDENT HAS THIS NUMBER, THE RECORDS UNDER THE OLD NUMBER WILL BE TRANSFERRED TO THE NEW NUMBER AND THE MESSAGE 'SOCIAL SECURITY NUMBER CHANGED' WILL BE DISPLAYED AT THE BOTTOM OF THE SCREEN. 5. TO DELETE A STUDENT, ENTER 'D' IN FIELD AFTER THE MESSAGE: 'ENTER "D" TO DELETE STUDENT'. THE PROGRAM WILL ASK YOU TO ENTER 'Y' AGAIN TO CONFIRM THE DELETE. IF YOU ENTER 'Y' A SECOND TIME, THE STUDENT WILL BE DELETED IF CERTAIN DETAIL DOES NOT EXIST FOR THE STUDENT. IF YOU DECIDE TO NOT DELETE THE STUDENT AFTER INDICATING YOU WANTED TO INITIALLY, ENTER A NEW SOCIAL SECURITY NUMBER AND THE STUDENT WILL NOT BE DELETED. 6. RETURN TO STEP 1 OR TAB THE CURSOR TO TRANS. NO. FIELD AND ENTER A NEW TRANSACTION NUMBER TO EXIT THIS PROGRAM. * 3.0 SCREEN LAYOUT: ------------- ======================================================================= TRAN NO: STU020 LT: :::::::: ::::::::::::::::::::::::: :::::::::::::::: STUDENT SOCIAL SECRUTIY NUMBER CHANGE/DELETE SOCIAL-SECURITY 1. KEY STUDENT SOCIAL SECURITY AND PRESS ENTER ___ - __ - ____ 2. KEY NEW SSN, 'D' TO DELETE OR NEW TRANS TO END NEW SOCIAL SECURITY ___ - __ - ____ ENTER 'D' TO DELETE STUDENT: _ STUDENT-NAME FORMER-LAST-NAME CAMPUS TRM LAST ENR :::::::::::::::: :::::::::: : :: :::::::::::::::: : :::::: :: STREET-ADDRESS CITY ST ZIP-CODE :::::::::::::::::::::: :::::::::::::::: :: ::::: - :::: HOME-PHONE BUSINESS-PHONE ::: - ::: - :::: ::: - ::: - :::: ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: ======================================================================== 4.0 FILES: ----- 4.1 DATA BASES / SEGMENTS USED: STUDENT DATA BASE 1. STUDENT MASTER SEGMENT (ADD, DELETE) 2. REGISTRATION SEGMENT (ADD, DELETE) 3. ACCOUNT SEGMENT (ADD, DELETE) 4. OBLIGATION SEGMENT (ADD, DELETE) 5. ADDITIONAL REQUIRED COURSES SEGMENT (ADD, DELETE) 6. GRADUATE MASTER SEGMENT (ADD, DELETE) 7. GRADUATE DETAIL SEGMENT (ADD, DELETE) 8. TEST SEGMENT (ADD, DELETE) 9. QUARTER SEGMENT (ADD, DELETE) 10. VEHICLE SEGMENT (ADD, DELETE) 11. USER SEGMENT (ADD, DELETE) 12. DROP REGISTRATION SEGMENT (ADD, DELETE) 13. REPEAT REGISTRATION SEGMENT (ADD, DELETE) 14. OBLIGATION AUDIT SEGMENT (ADD, DELETE) 15. ALERT SEGMENT (ADD, DELETE) 15. EXTENSION SEGMENT (ADD, DELETE) CONTROL DATA BASE 1. JURISDICTION CONTROL SEGMENT (READ ONLY) 2. MESSAGE CONTROL SEGMENT (READ ONLY) 3. PROGRAM OPTION CONTROL SEGMENT (READ ONLY) CLASS DATA BASE 1. CLASS MASTER SEGMENT (READ ONLY) 2. CLASS STUDENT SEGMENT (ADD DELETE) CURRICULUM DATA BASE 1. CURRICULUM MASTER SEGMENT (READ ONLY) 2. CURRICULUM STUDENT SEGMENT (ADD DELETE) ADVISOR DATA BASE 1. ADVISOR MASTER SEGMENT (READ ONLY) 2. ADVISOR STUDENT SEGMENT (ADD DELETE) HISTORY DATA BASE 1. STUDENT ID NUMBER SEGMENT (ADD, DELETE) 2. STUDENT SEGMENT (ADD, DELETE) 3. REGISTRATION SEGMENT (ADD, DELETE) 4. TRANSFER COLLEGE SEGMENT (ADD, DELETE) 5. TRANSFER COURSES SEGMENT (ADD, DELETE) 6. ADVANCED STANDING TYPE SEGMENT (ADD, DELETE) 7. ADVANCED STANDING COURSE SEGMENT (ADD, DELETE) 8. SUBSTITUTION SEGMENT (ADD, DELETE) 9. QUARTER SEGMENT (ADD, DELETE) 10. GRADUATION SEGMENT (ADD, DELETE) 11. VEDS SEGMENT (ADD, DELETE) 12. OBLIGATION SEGMENT (ADD, DELETE) 13. VCCS TRANSFER HOURS SEGMENT (ADD, DELETE) 14. REPEAT REGISTRATION SEGMENT (ADD, DELETE) 15. EXTENSION SEGMENT (ADD, DELETE) 16. TEXT SEGMENT (ADD, DELETE) 17. HISTORY SEGMENT (ADD, DELETE) FINANCIAL AID DATA BASE 1. FINANCIAL AID MASTER (ADD, DELETE) 2. PELL AWARD MASTER (ADD, DELETE) 3. PELL AWARD ADJ (ADD, DELETE) 4. PELL AWARD DISBURSEMENT (ADD, DELETE) 6. PELL QUARTER TOTALS (ADD, DELETE) 7. LOAN MASTER (ADD, DELETE) 8. LOAN AWARD ADJ (ADD, DELETE) 9. LOAN DISBURSEMENT (ADD, DELETE) 10. LOAN QUARTER TOTALS (ADD, DELETE) 11. CWSP AWARD MASTER (ADD, DELETE) 12. CWSP AWARD ADJ (ADD, DELETE) 13. CWSP PAYROLL (ADD, DELETE) 14. CWSP QUARTER TOTALS (ADD, DELETE) 15. SEOG AWARD MASTER (ADD, DELETE) 16. SEOG AWARD ADJ (ADD, DELETE) 17. SEOG AWARD DISBURSEMENT (ADD, DELETE) 18. SEOG QUARTER TOTALS (ADD, DELETE) 19. CSAP AWARD MASTER (ADD, DELETE) 20. CSAP AWARD ADJ (ADD, DELETE) 21. CSAP AWARD DISBURSEMENT (ADD, DELETE) 22. CSAP QUARTER TOTALS (ADD, DELETE) 23. GRANT/SCHOLARSHIP AWARD MASTER (ADD, DELETE) 24. GRANT/SCHOLARSHIP AWARD ADJ (ADD, DELETE) 25. GRANT/SCHOLARSHIP AWARD DISBURSEMENT (ADD, DELETE) 26. GRANT/SCHOLARSHIP QUARTER TOTALS (ADD, DELETE) CEU STUDENT DATA BASE 1. CEU STUDENT MASTER SEGMENT (READ) WORK DATA BASE 1. WORK MASTER (ADD) 2. WORK DATAU (ADD) 3. WORK DATAR (ADD,DELETE,REPLACE) 4.2 ADDITIONAL FILES USED: N/A 4.3 INPUT/OUTPUT RECORD LAYOUTS: N/A 5.0 SPECIAL FEATURES: ---------------- 5.1 CALLING PROGRAMS: N/A 5.2 SUBPROGRAMS CALLED: N/A 5.3 MESSAGE SEGMENT CODES: 000001 000005 000087 000326 000002 000027 000138 000327 000007 000056 000310 6.0 PROGRAM OPTIONS: --------------- STU020 -- PROGRAM OPTION RECORD #1 :==================================================================: ] POSITION ] OPTION NAME ] VALUE ] PROCESSING DESCRIPTION ] ]----------]---------------------]-------]-------------------------] ] 1 ] OPTION TO LOG ] Y ] LOG FINAID SSN CHANGES ] ] ] CHANGE OR DELETION ] ] OR DELETIONS. ] ] FINAID ] OF STUDENT'S SSN ] ] ] ] LOGGING ] ONLY IF SSN FOUND ]-------]-------------------------] ] OPTION ] ON FINDBD. ] N ] DO NOT LOG FINAID SSN ] ] ] ] ] CHANGES OR DELETIONS. ] ] ] ] ] ] ]==========]=====================]=======]=========================] ] 2 ] OPTION TO LOG ] Y ] LOG SSN CHANGES OR ] ] ] CHANGE OR DELETION ] ] DELETIONS. ] ] ] OF STUDENT'S SSN. ] ] ] ] ] ] ] ] ] LOGGING ] ]-------]-------------------------] ] OPTION ] ] N ] DO NOT LOG SSN CHANGES ] ] ] ] ] OR DELETIONS. ] ] ] ] ] ] ]==========]=====================]=======]=========================] ]==========]=====================]=======]=========================] ] 3 ] OPTION TO CROSS- ] Y ] CROSS-CHECK OLD AND NEW ] ] ] CHECK SSN TO CEU ] ] (FOR CHANGES) SSN TO ] ] ] DATA BASE. ] ] CEU STUDENT MASTER FOR ] ] ] ] ] PURPOSE OF ISSUING ] ] ] ] ] INFORMATIONAL MESSAGES ] ] CEU ] ] ] ONLY. ] ] X-CHECK ] ]-------]-------------------------] ] OPTION ] ] N ] DO NOT CROSS CHECK TO ] ] ] ] ] CEU DATA BASE. ] ] ] ] ] ] ]==========]=====================]=======]=========================] *** SPECIAL NOTE: REG970 CAN BE RUN TO PRINT THESE LOG RECORDS SEE REG970 DOCUMENTATION FOR RUN INSTRUCTIONS 7.0 PROGRAM CHANGE HISTORY: --------------------------- 7.1 VERSION: V1.2 CHANGE DATE: 1-14-84 PROGRAMMER NAME: JUDY GAULDIN PROGRAM CHANGE REQUEST NO: NR/013 DESCRIPTION OF CHANGE: MODIFIED INPUT DESCRIPTOR NAME FOR SUFFIX SO THAT IT WOULD BE SAME AS OUTPUT DESCRIPTOR NAME. ----------------------------------------------------------------------- 7.2 VERSION: V1.3 CHANGE DATE: 2-10-84 PROGRAMMER NAME: JUDY GAULDIN PROGRAM CHANGE REQUEST NO: NR/020 DESCRIPTION OF CHANGE: DELETED THE NUMERIC EDIT FOR JURISDICTION CODES. ----------------------------------------------------------------------- 7.3 VERSION: V1.4 CHANGE DATE: 3/7/84 PROGRAMMER NAME: JUDY GAULDIN PROGRAM CHANGE REQUEST NO: VW003 DESCRIPTION OF CHANGE: MODIFIED TO USE ADV-CAMPUS AS THE STUDENT'S HOME CAMPUS INSTEAD OF CAMPUS OF FOLDER-LOCATION. ----------------------------------------------------------------------- 7.4 VERSION: V1.5 CHANGE DATE: 4/13/84 PROGRAMMER NAME: JUDY GAULDIN PROGRAM CHANGE REQUEST NO: NR035 DESCRIPTION OF CHANGE: MODIFIED TO UDPATE CLASS/STUDENT, CURRICULUM/STUDENT AND ADVISOR/STUDENT LOGICAL RELATIONSHIPS ON A SOCIAL SECURITY NUMBER CHANGE. ----------------------------------------------------------------------- 7.5 VERSION: V1.8 CHANGE DATE: 6/29/84 PROGRAMMER NAME: JUDY GAULDIN PROGRAM CHANGE REQUEST NO: N/A DESCRIPTION OF CHANGE: MODIFIED TO CLEAR OUT NEW-SSN AREA AFTER A SOCIAL SECURITY CHANGE HAS BEEN MADE. ----------------------------------------------------------------------- 7.6 VERSION: SPECIAL RELEASE CHANGE DATE: 11/16/84 PROGRAMMER NAME: RODNEY WALLACE PROGRAM CHANGE REQUEST NO: N/A DESCRIPTION OF CHANGE: MODIFIED TO CORRECT THE HANDLING OF UPDATING LOGICAL RELATIONSHIPS AND USE ROLL CALL TO BACK OUT UPDATES ALREADY DONE WHEN ERRORS ARE ENCOUNTERED ON THE DATA BASE. ALSO ADDED CODE TO DISPLAY MESSAGES ON THE USERS' TERMINAL AND THE SLAVE PRINTER FOR IMS WHEN THIS OCCURS. ----------------------------------------------------------------------- 7.7 VERSION: V1.13 CHANGE DATE: 12/19/84 PROGRAMMER NAME: RODNEY WALLACE PROGRAM CHANGE REQUEST NO: N/A DESCRIPTION OF CHANGE: MODIFIED TO CORRECT THE HANDLING OF UPDATING LOGICAL RELATIONSHIPS FOR COUNSELOR CODES ----------------------------------------------------------------------- 7.8 VERSION: V2.06 CHANGE DATE: 02/25/86 PROGRAMMER NAME: RODNEY WALLACE PROGRAM CHANGE REQUEST NO: STCSR034, STCSR041, STCSR017, STCVW041 DESCRIPTION OF CHANGE: MODIFIED PROGRAM TO UPDATE HISTORY DATA BASE WHEN STUDENT DATA RESIDES ON THE HISTORY DATA BASE. ----------------------------------------------------------------------- 7.9 VERSION: V2.10 CHANGE DATE: 05/15/86 PROGRAMMER NAME: RODNEY WALLACE PROGRAM CHANGE REQUEST NO: STCVW073, STCSR077 DESCRIPTION OF CHANGE: MODIFIED PROGRAM TO UPDATE ACCTSTUD SEGMENTS ON ACCOUNTING DATA BASE WHEN STUDENT SSN IS CHANGED. MODIFIED PROGRAM TO CHECK HISTORY DATA BASE PRIOR TO DOING A SSN CHANGE. ----------------------------------------------------------------------- 7.10 VERSION NO: V2.11 CHANGE DATE: 09/22/86 PROGRAMMER NAME: RICHARD GILLETTE PROGRAM CHANGE REQUEST NO: STC-TN-056 DESCRIPTION OF CHANGE: MODIFIED PROGRAM TO UPDATE THE FINANCIAL AID DATABASE WHEN SOCIAL SECURITY NUMBER CHANGES. THIS REQUIRED A PSB CHANGE. THE PROGRAM WILL GET THE FIRST QUARTER THE SCHOOL IS ON FINANCIAL AID FROM FROM THE MESSAGE MASTER 000087 (POSITIONS 10-12; FORMAT: YYQ). THIS CHECKS THE DATABASE FROM THAT POINT THROUGH TWO FINANCIAL AID ACADEMIC YEARS PAST THE CURRENT QUARTER FOR STUDENTS ON FINANCIAL AID. A MAP CHANGE WAS DONE TO HOLD THE NECESSARY DATA. PROGRAM CHANGE REQUEST NO: STC-TC-010 DESCRIPTION OF CHANGE: MODIFIED PROGRAM TO OPTIONALLY WRITE AN ENTRY TO SISWORK DATA BASE WHEN THE STUDENT'S ADDRESS (ADDRESS, CITY, STATE, OR ZIPCODE) CHANGES. TIDEWATER COMMUNITY COLLEGE IS TO WRITE A BATCH PROGRAM TO USE THIS ENTRY TO PRODUCE A ADDRESS CHANGE PRODUCE A ADDRESS CHANGE LABEL TO BE USED TO UPDATE A STUDENT'S PERMANENT RECORD. A MAP CHANGE WAS DONE TO HOLD THE COLLEGE'S OPTION. PROGRAM CHANGE REQUEST NO: STC-SO-198 DESCRIPTION OF CHANGE: PROGRAM MODIFIED TO NOT CHECK ACCOUNT BALANCE WHEN DETERMINING WHETHER TO INSERT AN ACCTSTUD SEGMENT FOR A CHANGED SOCIAL SECURITY NUMBER. IF AN ACCTSTUD EXISTS FOR THE OLD SOCIAL SECURITY NUMBER, ONE IS INSERTED FOR THE CHANGED SOCIAL SECURITY NUMBER. ----------------------------------------------------------------------- 7.11 VERSION NO: V3.2 CHANGE DATE: 08-15-87 PROGRAMMER NAME: HARRY L. WALDRON PROGRAM CHANGE REQUESTS: STC-TN-096, STC-TN-098, SCP-SO-123 SCP-SO-272, STC-TN-081, STC-TC-162 DESCRIPTION OF CHANGES: (1) ADDED COMMENTS, RENAMED DATA FIELDS AND PARAGRAPHS, AND DELETED DEAD CODE ... (PARAGRAPHS 290-340 IN OLD PGM) (2) CHANGED ALL REFERENCES OF QUARTER TO TERM. (3) ADD UPDATE FOR: BUS-PHONE, TUITION-REV-TERM, DECEASED (4) RESTRUCTURED MFS CODE & SCREEN FOR NEW FIELDS (5) ALLOW CHANGE OF SSN TO FIN-AID DB FOR GREATER 2 YEARS (6) VERIFY TERM AGAINST CONTROL DATA BASE (7) AVOID ADDRESS EDITS IF NO CHANGE WAS MADE. (8) ADD SPECIAL LOGGING OF SIS-WORK-RECORDS IF CHANGES WERE MADE TO THE FINANCIAL AID DATA BASE. (9) EXPANDED DOCUMENTATION TO INCLUDE SEGMENT NAMES FOR FINANCIAL AID DATA BASE. (10) REVISED NARRATIVE, USER OPERATING INSTRUCTIONS, AND SCREEN LAYOUTS. (11) CORRECTED OPTION PROCESSING FOR SIS WORK LOGGING (12) ADDED DOCUMENTATION FOR THE SIS WORK LOGGING CONTROL RECORD (STU02001). A "Y" MUST BE IN COL. 1 FOR LOGGING. ----------------------------------------------------------------------- 7.12 VERSION NO: V3.3 CHANGE DATE: 09-21-87 PROGRAMMER NAME: BOB PARCELL PROGRAM CHANGE REQUESTS: STC-SR-054 DESCRIPTION OF CHANGES: (1) ADDED LOGIC TO ALLOW FOR DELETION OF STUDENT. USER INDICATES BY ENTERING 'Y' IN APPROPRIATE FIELD TO DELETE A STUDENT. STU020 WILL ASK FOR THE USER TO ENTER 'Y' AGAIN TO CONFIRM THE DELETE. STU020 WILL DELETE THE STUDENT FROM THE STUDENT DB, HISTORY DB AND ADVISOR AND CURRICULUM LOGICAL RELATIONSHIPS IF THE STUDENT IS ALLOWED TO BE DELETED. THE STUDENT MAY NOT BE DELETED IF THE STUDENT IS ON FINANCIAL AID OR HAS CERTAIN HISTORY OR STUDENT MASTER DETAIL. ----------------------------------------------------------------------- 7.13 VERSION NO: V3.6 CHANGE DATE: 01-26-88 PROGRAMMER NAME: BOB PARCELL PROGRAM CHANGE REQUESTS: STC-VW-426 DESCRIPTION: 1. MODIFIED DELETE LOGIC TO READ THE FINANCIAL AID DB IN ALL CASES IN DETERMINING WHETHER OR NOT A STUDENT CAN BE DELETED. PREVIOUSLY, IF THE QTR-LAST-FIN-AID IN THE STUDENT MASTER RECORD = SPACES, THE FIN DB WAS NOT READ. 2. MODIFIED THE 283-ACCT-MASTER-READ PARAGRAPH. REMOVED FOLLOWING IF STATEMENT AFTER THE GU CALL. IF ACCOUNT-GROUP NOT = 'NA' AND NOT = 'B ' GO TO 283-ACCT-MASTER-UPDTE-EXIT ADDED LOGIC IN THE 283-ACCTSTUD-UPDTE PARAGRAPH. IF THE GNP STATUS IS 'GE' AND THE ACCOUNT-GROUP = 'NB' OR 'NC' THEN THE REMAINING ISRT AND DELETE LOGIC IS BYPASSED. THE ABOVE MODIFICATIONS WERE DONE BECAUSE OF FINANCIAL AID AND ACCOUNT DATA THAT EXISTED FOR STUDENTS WHO WERE NOT ON THE STUDENT MASTER DB. CHANGE DATE: 02/11/88 PROGRAMMER NAME: RICHARD GILLETTE PROGRAM CHANGE REQUESTS: STC-NR-042 DESCRIPTION OF CHANGE: MODIFIED PROGRAM TO NOT ISSUE A ROLL CALL WHEN CHANGING A SOCIAL SECURITY NUMBER FOR A STUDENT WHO HAS ONLY VOIDED ACCOUNT DETAILS. PROGRAM CHANGE REQUESTS: STC-TN-239 DESCRIPTION OF CHANGE: MODIFIED PROGRAM TO NOT ISSUE A ROLL CALL WHEN CHANGING A SOCIAL SECURITY NUMBER FOR A STUDENT WHO HAS ADVANCED STANDING/TRANSFER OR NON-TRANSFER COURSES. ----------------------------------------------------------------------- 7.14 VERSION NO: V3.7 CHANGE DATE: 2-3-88 PROGRAMMER NAME: HARRY L. WALDRON PROGRAM CHANGE REQUESTS: STC-VW-420 (NEW LOGGING OPTIONS) DESCRIPTION OF CHANGES: (1) REQUEST: STC-VW-420 ... ADDED NEW LOGGING OPTION TO ALLOW COLLEGES TO CHOOSE WHETHER THEY WANT THE STANDARD ADDRESS LOGGING PROVIDED BY STU020. THE PROGRAM ALSO HAS AN EXISTING OPTION WHICH PROVIDES SPECIAL LOGGING FOR STUDENTS WHO ARE ON FINANCIAL AID; (I.E. LOGS CHANGES IN NAME, ADDRESS, HOME PHONE, OR SSN). THE FOLLOWING TABLE PROVIDES AN EXAMPLE OF HOW AN ADDRESS CHANGE WOULD FUNCTION UNDER THIS LOGGING: FIN-AID STANDARD ADDRESS CHANGE ADDRESS CHANGE SPECIAL ADDRESS FOR STUDENTS FOR STUDENTS LOGGING LOGGING ON FIN. AID NOT ON FIN. AID OPTION-1 OPTION-2 (TYPE LOGGING) (TYPE LOGGING) -------- -------- -------------- --------------- N N NONE NONE N Y STANDARD ONLY STANDARD ONLY Y N FIN-AID ONLY NONE Y Y STD & FIN-AID STANDARD ONLY ----------------------------------------------------------------------- 7.15 VERSION NO: V3.12 CHANGE DATE: 6-21-88 PROGRAMMER NAME: MARY HARVEY PROGRAM CHANGE REQUESTS: STC-SR-373 DESCRIPTION OF CHANGES: MOVED SPACES TO THE SSN-SAVE AREA AFTER A STUDENT WAS DELETED. PRIOR TO THIS CHANGE AFTER A STUDENT WAS DELETED IF ONE PRESSED ENTER AGAIN WITH THE SAME SSN A SEVERE DATA BASE ERROR WAS ENCOUNTERED. NOW IF ONE PRESSES ENTER WITH THE SAME SSN IMMEDIATELY AFTER A DELETION THE MESSAGE 'STUDENT NOT ON FILE FOR THIS SSN....CHECK AND REENTER' WILL APPEAR ON SCREEN. ------------------------------------------------------------------------ 7.16 VERSION NO: V3.13 CHANGE DATE: 08-23-88 PROGRAMMER NAME: KATHY HARCUM PROGRAM CHANGE REQUEST: STC-TC-366 DESCRIPTION: -ADDED ABILITY TO ENTER NEW FIELD TUITION-REV-CATEGORY CONTAINED ON THE STUDENTM SEGMENT. THIS FIELD WILL INDICATE THE SPECIFIC TUTION REVIEW CATEGORY THAT QUALIFIES THE STUDENT FOR IN-STATE RATES AS FOLLOWS: ' ' - UNKNOWN OR NOT APPLICABLE '1' - NON-RESIDENT WORKING IN VIRGINIA '2' - DEPENDENT OF DOMICILED PARENT '3' - MILITARY SPOUSE EXCEPTION '4' - DEPENDENT OF MILITARY SPOUSE EXCEPTION THIS FIELD CAN ONLY BE ENTERED WHEN THE TUTION REVIEW TERM IS PRESENT; HOWEVER IT IS NOT REQUIRED. NO ENTRY DEFAULTS TO ' ' WHICH INDICATES UNKNOWN/NOT APPLICABLE. ----------------------------------------------------------------------- 7.17 VERSION NO: V4.00 CHANGE DATE: 03/21/89 PROGRAMMER NAME: RICHARD GILLETTE PROGRAM CHANGE REQUEST: 00001548 DESCRIPTION: MODIFIED TO ACCOMMODATE STUSUBTM KEY CHANGE. PROGRAM CHANGE REQUEST: 00001578 DESCRIPTION: REMOVED REFERENCES TO STUHOBLI SEGMENT. PROGRAM CHANGE REQUEST: 00001647 DESCRIPTION: MODIFIED TO ACCOMMODATE STUTESTD KEY CHANGE. PROGRAM CHANGE REQUEST: 00001990 DESCRIPTION: REMOVED REFERENCES TO STUVEDS AND STUVEHIC SEGMENTS. ----------------------------------------------------------------------- 7.18 VERSION NO: V4.1 CHANGE DATE: 03/31/89 PROGRAMMER NAME: RH.CLARK PROGRAM CHANGE REQUEST NO: I:00002156 DESCRIPTION OF CHANGE: -MODIFIED THE PROGRAM TO CHECK TO SEE IF THE STUDENTM SEGMENT HAS BEEN CHANGED SINCE STU020 BEGAN TO UPDATE THE STUDENTM SEGMENT. IF AN INTERIM CHANGE HAS BEEN MADE THE TERMINAL USE IS NOTIFIED AND NEW DATA IS SHOWN. ----------------------------------------------------------------------- 7.19 VERSION NO: V4.03 CHANGE DATE: 05-30-89 PROGRAMMER NAME: RH.CLARK PROGRAM CHANGE REQUEST: I:00003020,00002836,00002940, 00001389,00001828,00003060 DESCRIPTION: -MODIFIED THE PROGRAM TO CHECK THE FIRST SEMESTER TERM VALUE TO PREVENT QUARTER NOT ON MASTER FILE MESSAGE WHEN EDITING THE TERM ENTERED. -MODIFED THE PROGRAM TO HANDLE BLANK FIN-AID DATA IN MESSAGE MASTER 000087. -ADDED AN OPTION TO THE PROGRAM OPTION RECORD. THIS NEW OPTION ALLOWS THE COLLEGE TO SELECT WHETHER THEY WILL ALLOW A BLANK ZIP CODE OR NOT. -MODIFIED THE PROGRAM TO USE SPACES INSTEAD OF THE CATALOG-YEAR TO ACCESS THE CURRICULUM DATABASE. -MODIFED THE PROGRAM TO SEND A MESSAGE WHEN THE JURISDICTION CODE IS CHANGED FROM OUT OF STATE TO TO IN-STATE OR VICE VERSA. -CORRECTED AN ERROR IN THE PROGRAM THAT PRODUCED THE INTERIM CHANGE MESSAGE FOR EVERY HISTORY STUDENT. ----------------------------------------------------------------------- 7.20 VERSION NO: V4.04 CHANGE DATE: 07-15-89 PROGRAMMER NAME: RH.CLARK PROGRAM CHANGE REQUEST: I:00003323 DESCRIPTION: -MODIFIED THE PROGRAM TO CHECK THE FOR SEGMENTS ADDED TO THE STUDENT DATABASE IN VERSIUON 4.00. THESE SEGMENTS SHOULD BE ADDED TO THE NEW SOCIAL SECURITY RECORD WHEN A SOCIAL SECURITY CHANGE OCCURS. ----------------------------------------------------------------------- 7.21 VERSION NO: V4.05 CHANGE DATE: 07-10-89 PROGRAMMER NAME: RH.CLARK PROGRAM CHANGE REQUEST: I:00003382, 00003327 DESCRIPTION: -MODIFIED THE PROGRAM TO ISSUE A SCREEN READ AFTER THE SCREEN WRITE WHEN THE FINANCIAL AID YEAR IS BLANK. -MODIFIED THE PROGRAM TO REPLACE THE INTERIM CHANGE RECORD WHEN AN UPDATE OR DELETE OCCURS SUCCESSFULLY. ----------------------------------------------------------------------- 7.22 VERSION NO: V4.07 CHANGE DATE: 09-29-89 PROGRAMMER NAME: RH.CLARK PROGRAM CHANGE REQUEST: I:00003593,000003458,00003020 DESCRIPTION: -MODIFIED THE PROGRAM TO CORRECT A PROBLEM THAT ALLOWS NUMERICS IN THE LAST NAME FIELD. -MODIFIED THE PROGRAM TO LOG JURISDICTION CHANGES FOR REPORTING BY REG970 ON THE CONTROL DATABASE. ----------------------------------------------------------------------- 7.23 VERSION NO: V4.07 CHANGE DATE: 09-29-89 PROGRAMMER NAME: RH.CLARK PROGRAM CHANGE REQUEST: N/A DESCRIPTION: -MODIFIED THE PROGRAM TO COMPILE AND LINK UNDER COBOL II ----------------------------------------------------------------------- 7.24 VERSION NO: V4.15 CHANGE DATE: 08/01/90 PROGRAMMER NAME: RH.CLARK CHANGE REQUEST NO: 00006005, 00005268, 00003987, 00005349, 00004091 DESCRIPTION OF CHANGE: -CHANGED THE EDIT ROUTINE FOR THE LAST NAME TO MATCH THE EDIT ROUTINE IN REG070. -FIXED AN IF STATEMENT THAT CAUSED THE SLAVE PRINTER ROUTINE TO BE INVOKED WHENEVER A STUDENT WAS DELETED. -ADDED THE DATE APPLICATION FIELD TO THE SCREEN AS A PROTECTED FIELD. -ADDED THE IO-AREA TO THE DELETE CALL FOR THE WORK DATA- BASE WHICH ALSO TRIGGERED A MESSAGE TO THE SLAVE PRINTER -INCREASED THE KEY FEEDBACK LENGTH FOR THE WORK DATA- BASE FROM 10 BYTES TO 17 BYTES. ----------------------------------------------------------------------- 7.25 VERSION NO: V4.17 CHANGE DATE: 10/10/90 PROGRAMMER NAME: K. CAMPER CHANGE REQUEST NO: 00006414 DESCRIPTION OF CHANGE: -CORRECTED PROCESSING OF FINANCIAL AID MASTER SEGMENTS SO THAT ALL AID DATA WILL BE ACCESSED ON THE DELETE, SSNO CHANGE, AND SIS LOGGING ROUTINES. PROGRAM WAS PREVIOUSLY USING COLLEGE'S FIRST FINANCIAL AID TERM/YEAR AS THE STARTING POINT FOR THE "GU" CALLS TO THE FINMASTR, BUT WAS LEAVING THE LOOP(S) AS SOON AS A "GE" STATUS CODE WAS RECEIVED. THIS WOULD CAUSE AID DATA THAT DID NOT MATCH THE FIRST AID YEAR TO BE BYPASSED. EVEN IF THE STUDENT DID HAVE AID DATA FOR THE FIRST AID/YEAR, BUT THEN SKIPPED ON OR MORE YEARS BEFORE HE NEXT HAD AID, SUBSEQUENT YEAR(S) DATA WOULD BE BYPASSED AS WELL. THIS COULD CAUSE STUDENTS TO BE DELETED WHEN THEY HAD AID DATA, OR LEAVE FINMASTR SEGMENTS UNDER THE OLD SSNO ON A SSNO CHANGE, OR TO NOT LOG NAME/ADDRESS/JURISDIC- TION CHANGES FOR SOME FINANCIAL AID STUDENTS. MODIFIED LOGIC TO CONTINUE LOOP UNTIL ALL YEARS THROUGH THE LATEST YEAR THE COLLEGE CAN HAVE AID DATA. THIS IS DETERMINED BY FINDING THE LATEST FIN AID YEAR KEY ON THE FINANCIAL AID DATA BASE. MODIFIED SO THAT FIRST AID YEAR IS DETERMINED AS THE FIRST VALID NUMERIC ACADEMIC YEAR ACCESSIBLE ON THE FINANCIAL AID DATA BASE. -INCREASED SAVEAREA BY 5 BYTES TO ACCOMODATE A FIN AID END YEAR FIELD AND ALLOW FOR A FEW FILLER BYTES. THE FIN AID END YEAR FIELD IS SAVED TO PROVIDE AN ENDING POINT ON THE CALLS TO THE FINANCIAL AID DATA BASE FOR INDIVIDUAL STUDENTS. -CORRECTED DISCREPANCY IN INPUT AND OUTPUT MESSAGE DESC- RIPTIONS WHERE THE ZIP CODE OPTION FIELD IN THE SAVE AREA WAS DESCRIBED AS 2 BYTES IN THE INPUT MAP AND 1 BYTE IN THE OUTPUT MAP (1 BYTE WAS CORRECT LENGTH). -CORRECTED DESCRIPTION OF OUTPUT MAP SAVE AREA TO AN 05 LEVEL ITEM, SO THAT LOGIC THAT MOVES SPACES TO THE STUDENT DESCRIPTION AREA OF THE MAP WOULD NOT OVERLAY THE SAVE AREA VALUES AS WELL. -CORRECTED DELETE PROCESSING LOGIC THAT BYPASSED READING OF THE HISTORY DATA BASE IF AN ACTIVE STUDENT MASTER HAD ALREADY BEEN FOUND. IF STUDENT HAD ONLY A STUDENTM SEGMENT ON THE ACTIVE DATA BASE, BUT ALSO HAD HISTORY SEGMENTS SUCH AS TRANSFER CLASS OR GRADUATE, NO WARNING MESSAGE WAS BEING GENERATED, AND THE DELETE WAS BEING ALLOWED. -DELETED CALL TO MESSAGE MASTER 000087 TO GET FIRST TERM VALUE FOR FINANCIAL AID PURPOSES, SINCE PROGRAM NOW GETS FIRST AID YEAR FROM THE FINANCIAL AID DATA BASE ITSELF. -MODIFIED PROGRAM TO ELIMINATE AN EXTRA CALL TO THE MESSAGE MASTER THAT WAS DONE WHEN A NEW SSNO HAD BEEN ENTERED THAT WAS NOT FOUND ON EITHER ACTIVE OR HISTORY DATA BASE. THE MESSAGE WAS BEING RETRIEVED TWICE, ONCE ON THE CALL TO THE ACTIVE, AND ONCE ON THE CALL TO THE HISTORY DATA BASES. THE SCREEN WAS ONLY WRITTEN ONCE. -MODIFIED STATUS CODE CHECKING ON CALLS TO FINANCIAL AID DATA BASE TO CHECK FOR BOTH "GE" AND "GB" WHEN USING GN CALL-FUNCTION WITH A QUALIFIED SSA. ----------------------------------------------------------------------- 7.26 VERSION NO: V4.27 CHANGE DATE: 09/16/91 PROGRAMMER NAME: MARIE GORDON CHANGE REQUEST NO: 00008047 DESCRIPTION OF CHANGE: VERIFIED THAT STUACCTD DATA IS MAINTAINED WHEN NEW SEGMENTS ARE INSERTED DUE TO A SOCIAL SECURITY CHANGE. RECOMPILED AND TESTED AGAINST CONVERTED DATABASE. ----------------------------------------------------------------------- 7.27 VERSION NO: V4.42 CHANGE DATE: 01/25/93 PROGRAMMER NAME: KATHY HARCUM CHANGE REQUEST NO: 00011470 DESCRIPTION OF CHANGE: -MODIFIED PSB TO PROVIDE SENSITIVITY TO FINEXTEN SEGMENT PER FINAID DB CHANGES. ----------------------------------------------------------------------- 7.28 VERSION NO: V5.00 CHANGE DATE: 05/15/93 PROGRAMMER NAME: CAROLYN SMITH PROGRAM CHANGE REQUEST NO: 00012169 DESCRIPTION OF CHANGE: - THE PROGRAM HAS BEEN RECOMPILED AS A PART OF THE VERSION 5.O DATA BASE CHANGES. - THE PROGRAM HAS BEEN CHANGED AS A PART OF THE VERSION 5.O DATA BASE CHANGES. REPEATED REGISTRATION SEGMENT CHANGED FROM LEVEL 03 TO LEVEL 02, WAS A CHILD OF STUREGIS. MODIFIED STUDBD REMOVED STUREPRG ADDED STURPREG MODIFIED HSTDBD REMOVED STUHREPR ADDED STUHRPRG ----------------------------------------------------------------------- 7.29 VERSION NO: V5.11 CHANGE DATE: 04/15/94 PROGRAMMER NAME: BARBARA SHANKO PROGRAM CHANGE REQUEST NO: 00006499 DESCRIPTION OF CHANGE: - CHANGED THE PROGRAM TO ONLY CHANGE OR DELETE A STUDENT'S SOCIAL SECURITY NUMBER. JURISDICTION, TUITION REVIEW TERM, TUITION REVIEW CATEGORY AND DECEASED CODE FIELDS WERE REMOVED FROM THE SCREEN. NAME, ADDRESS, CITY, STATE, ZIP CODE, HOME TELEPHONE AND BUSINESS TELEPHONE FIELDS WERE CHANGED TO DISPLAY ONLY. PROGRAM CHANGE REQUEST NO: 00012215 DESCRIPTION OF CHANGE: MODIFIED PROGRAM TO BRING 'CBLTDLI' CALLS INTO COMPLIANCE WITH THE STANDARD USE OF IOAREA PER PAGE 9 IN THE AUGUST 92 PROGRAM STANDARDS, PROCEDURES AND GUIDELINES MANUAL. 7.30 VERSION NO: V5.14 00830000 CHANGE DATE: 06/11/94 00840000 PROGRAMMER NAME: KATHY HARCUM 00850001 PROGRAM CHANGE REQUEST NO: 00014092 00860000 DESCRIPTION OF CHANGE: -ADDED OPTION TO STU02001 OPTION RECORD, CC. 3, WHICH WILL DIRECT PROGRAM TO CROSS-CHECK 'OLD' AND 'NEW' SSN'S TO THE CEU DATABASE FOR THE PURPOSE OF ISSUING INFORMATIONAL TYPE MESSAGES ONLY. NO CHANGES ARE AFFECTED TO THE CEU DATA, ANY NECESSARY MODIFICATION TO CEU DATA MUST BE MADE USING CEU055 TRANSACTION. -MAP MODIFIED FOR ADDITIONAL MESSAGE AREAS AND CORRECTED LENGTH OF SAVE AREA IN MAP TO AGREE WITH PROGRAM. -MODIFIED PSB FOR ACCESS TO CSTUDENT SEGMENT OF CEUDBD. PROGRAM CHANGE REQUEST NO: 00014249 00860000 DESCRIPTION OF CHANGE: -PROGRAM MODIFIED TO CHANGE SSN ON ANY/ALL FIN020 LOG RECORDS NECESSARY. CHECK OF LOG RECORDS ONLY MADE IF STUDENT FOUND ON FINDBD. -ADDED SECOND PSB ACCESS TO SISWKDB FOR ABOVE UPDATES SO THAT STU020 LOGGING/INTERIM UPDATE POSITIONING IS NOT DISPLACED (ELIMINATES NEED FOR 'RE-READS' TO KEEP POSITIONING IN ORDER). 7.31 VERSION NO: V5.18 00830000 CHANGE DATE: 11/15/94 00840000 PROGRAMMER NAME: BARBARA SHANKO 00850001 PROGRAM CHANGE REQUEST NO: 00014699 00860000 DESCRIPTION OF CHANGE: - CHANGED THE PROGRAM TO DISPLAY 'NO CHANGE MADE' WHEN THERE HAD BEEN NO CHANGE IN THE DATA. 7.32 VERSION NO: V7.00 CHANGE DATE: 09/97 PROGRAMMER NAME: KATHY HARCUM PROGRAM CHANGE REQUEST NO: 00016642 DESCRIPTION OF CHANGE: -RECOMPILED FOR 7.0 7.33 VERSION NO: V7.01 CHANGE DATE: 05/98 PROGRAMMER NAME: KATHY HARCUM PROGRAM CHANGE REQUEST NO: 00018008 DESCRIPTION OF CHANGE: -MODIFIED TO ENSURE COMPLIANCE WITH YEAR 2000 PROCESSING AND NEW COBOL COMPILER.