0.003/02/84 VAN HEMERT AND LEIMBACH 1.0 INTRODUCTION ------------ THE PURPOSE OF THE SIP-TO-SIS CONVERSION SUBSYSTEM IS THE FOLLOWING: 1. TO PREPARE THE STUDENT INFORMATION PACKAGE (SIP) FILES FOR THEIR CONVERSION TO STUDENT INFORMATION (SIS) DATA. THIS INVOLVES ASSURING THAT A COLLEGE'S SIP DATA IS AS ACCURATE AND COMPLETE AS POSSIBLE. THIS ALSO INVOLVES CHECKING TO INSURE THAT CERTAIN CONDITIONS DO NOT OCCUR IN A COLLEGE'S SIP DATA SUCH AS MULTIPLE STUDENT SOCIAL SECURITY NUMBERS, MULTIPLE ADVISOR CODES, MULTIPLE COUNSELOR CODES, OR COURSES WITH MULTIPLE SIS COURSE KEYS. THESE ERROR CONDITIONS MUST BE CORRECTED BEFORE THE SIS DATA BASES CAN BE LOADED. 2. TO LOAD AND CREATE THE SIS DATA BASES FROM SIP FILES. 3. TO VERIFY AND TEST THE CONVERSION OF SIP DATA TO SIS DATA. 4. TO VERIFY AND TEST THE OPERATION OF ONLINE SIS APPLICATION PROGRAMS. 5. TO BUILD SIP LOOK-A-LIKE FILES FROM SIS DATA BASES IN ORDER TO PROVIDE USERS WITH THE ABILITY TO RUN SIP REPORTING PROCEDURES USING THESE LOOK-A-LIKE FILES AND TO PROVIDE A METHOD FOR PREVIOUSLY WRITTEN USER PROGRAMS TO ACCESS SIS DATA IN A SIP FORMAT. 6. TO VERIFY AND TEST THE CONVERSION OF SIS DATA TO SIP LOOK-A-LIKE FILES. 2.0 SYSTEM NARRATIVE ---------------- THE FOLLOWING STEPS SHOULD BE USED FOR LOADING A COLLEGE'S SIS DATA BASES FROM THEIR SIP FILES: 1. MAKE SURE THE INFORMATION IN THE SIP STUDENT FILES (STFILE AND GRFILE) IS COMPLETE AS POSSIBLE BY RUNNING THE VCCS350 REPORT OF THE VCCSRPT PROCEDURE. THE VCCS350 REPORT IS A MISSING DATA EDIT REPORT AND SHOULD BE RUN FOR: A. THE SIP STFILE B. THE SIP GRFILE ONCE THESE MISSING DATA ELEMENTS ARE IDENTIFIED, THEY CAN BE UPDATED BY RUNNING THE FOLLOWING PROCEDURES: A. VCCS724 UPDATES THE SIP STFILE B. VCCS725 UPDATES THE SIP GRFILE 2. RESOLVE ANY CONFLICTS BETWEEN THE SIP STUDENT AND SIP COURSE FILES (I.E. RESOLVE ANY CONFLICTS BETWEEN THE SIP STFILE AND THE SIP PCFILE AND BETWEEN THE SIP GRFILE AND THE SIP CFFILE). THESE CONFLICTS CAN BE FOUND BY RUNNING THE VCCS702 PROCEDURE WHICH IS A PRE-EDIT FOR AKT USING THE: A. THE SIP STFILE AND THE SIP PCFILE B. THE SIP GRFILE AND THE SIP CFFILE NOTE THAT ONCE THESE CONFLICTS ARE IDENTIFIED, THEY CAN UPDATED BY RUNNING THE FOLLOWING PROCEDURES: A. VCCS103 UPDATES THE SIP PCFILE B. VCCS109 UPDATES THE SIP CFFILE C. VCCS724 UPDATES THE SIP STFILE D. VCCS725 UPDATES THE SIP GRFILE 3. RUN THE SIP009 PROCEDURE WHICH DISPLAYS SOCIAL SECURITY NUMBERS WITH MULTIPLE STUDENTS IN THE SIP STUDENT FILES (STFILE OR GRFILE). IF THESE ARE ANY MULTIPLE SOCIAL SECURITY NUMBERS IN THE SIP STFILE, THEY SHOULD BE CORRECTED USING THE VCCS724 PROCEDURE AND IF THERE ARE ANY MULTIPLE SOCIAL SECURITY NUMBERS IN THE SIP GRFILE, THEY SHOULD BE CORRECTED USING THE VCCS725 PROCEDURE. ONCE THESE UPDATES HAVE BEEN PERFORMED, RERUN THE SIP009 PROCEDURE TO VERIFY YOUR UPDATES. 4. RUN THE SIP010 PROCEDURE WHICH DISPLAYS NON-BLANK COUNSELOR CODES WITH MULTIPLE INSTRUCTORS IN THE SIP INSTRUCTOR FILE (IRFILE). IF THERE ARE ANY MULTIPLE COUNSELOR CODES IN THE SIP IRFILE, THEY SHOULD BE CORRECTED USING THE VCCS102 PROCEDURE. ONCE THESE UPDATES HAVE BEEN PERFORMED, RERUN THE SIP010 PROCEDURE TO VERIFY YOUR UPDATES. 5. RUN THE SIP011 PROCEDURE WHICH DISPLAYS NON-BLANK ADVISOR CODES WITH MULTIPLE INSTRUCTORS IN THE SIP INSTRUCTOR FILE (IRFILE). IF THERE ARE ANY MULTIPLE ADVISOR CODES IN THE SIP IRFILE, THEY SHOULD BE CORRECTED USING THE VCCS102 PROCEDURE. ONCE THESE UPDATES HAVE BEEN PERFORMED, RERUN THE SIP011 PROCEDURE TO VERIFY YOUR UPDATES. 6. RUN THE SIP013 PROCEDURE WHICH DISPLAYS COURSES WITH MULTIPLE SIS COURSE KEYS IN THE SIP PPFILE, PCFILE, CFFILE. IF THERE ARE ANY MULTIPLE SIS COURSE KEYS IN THE SIP PPFILE, THEY SHOULD BE CORRECTED USING THE VCCS901 PROCEDURE. IF THERE ARE ANY MULTIPLE SIS COURSE KEYS IN THE SIP PCFILE, THEY SHOULD BE CORRECTED USING THE VCCS103 PROCEDURE. AND FINALLY, IF THERE ARE ANY MULTIPLE SIS COURSE KEYS IN THE SIP CFFILE, THEY SHOULD BE CORRECTED USING THE VCCS109 PROCEDURE. ONCE THESE UPDATES HAVE BEEN PERFORMED, RERUN THE SIP013 PROCEDURE TO VERIFY YOUR UPDATES. 7. RUN THE SIP027 PROCEDURE WHICH LISTS THE STUDENT INQUIRY KEYS OF THOSE STUDENTS WHO ARE ON THE SIP GRFILE BUT ARE NOT IN THE SIP STFILE. IF ANY OF THESE STUDENTS EXIST, THEY SHOULD BE CORRECTED BY MAKING UPDATES TO THE SIP STFILE THROUGH THE VCCS724 PROCEDURE AND TO THE SIP GRFILE THROUGH THE VCCS725 PROCEDURE. ONCE THESE UPDATES HAVE PERFORMED, RERUN THE SIP027 PROCEDURE TO VERIFY YOUR UPDATES. 8. AT THIS POINT, THE COLLEGE'S SIS DATA BASES CAN BE BUILT FROM THEIR SIP FILES. BUT BECAUSE OF THE CREATION AND USE OF CERTAIN FILES IN THE DL/I LOADING PROCESS, THE USER SHOULD CALL JOHN VAN HEMERT OR BILL LEIMBACH AT NEW RIVER COMMUNITY COLLEGE TO COMPLETE THE SIP TO SIS CONVERSION (THIS TASK IS COMPLETED BY RUNNING THE SIP001 THROUGH SIP007 PROCEDURES, AND THEN THE SIP016, SIP000, AND THE SIP012 PROCEDURES). HOWEVER, THE USE WILL HAVE TO PROVIDE THE FOLLOWING INFORMATION: A. WHETHER THE GRADE INFORMATION FOR EACH STUDENT IN THE SIP GRFILE SHOULD COME FROM THE SIP STFILE OR THE SIP GRFILE. B. CLASS INFORMATION ON THE QUARTER THAT RESIDES IN THE SIP CFFILE (INPUT NECESSARY FOR THE SIP002 PROCEDURE): (1) YEAR IN WHICH THE QUARTER STARTS (2) MONTH IN WHICH THE QUARTER STARTS (3) DAY IN WHICH THE QUARTER STARTS (4) YEAR IN WHICH THE QUARTER ENDS (5) MONTH IN WHICH THE QUARTER ENDS (6) DAY IN WHICH THE QUARTER ENDS (7) YEAR OF THE CENSUS DATE (8) MONTH OF THE CENSUS DATE (9) DAY OF THE CENSUS DATE (10) YEAR OF THE LAST DROP DATE (11) MONTH OF THE LAST DROP DATE (12) DAY OF THE LAST DROP DATE C. CLASS INFORMATION ON THE QUARTER THAT RESIDES IN THE SIP PCFILE (INPUT NECESSARY FOR THE SIP002 PROCEDURE): (1) YEAR IN WHICH THE QUARTER STARTS (2) MONTH IN WHICH THE QUARTER STARTS (3) DAY IN WHICH THE QUARTER STARTS (4) YEAR IN WHICH THE QUARTER ENDS (5) MONTH IN WHICH THE QUARTER ENDS (6) DAY IN WHICH THE QUARTER ENDS (7) YEAR OF THE CENSUS DATE (8) MONTH OF THE CENSUS DATE (9) DAY OF THE CENSUS DATE (10) YEAR OF THE LAST DROP DATE (11) MONTH OF THE LAST DROP DATE (12) DAY OF THE LAST DROP DATE D. INFORMATION ABOUT THE QUARTER WHOSE DATA RESIDES IN THE SIP PCFILE AND INFORMATION ABOUT THE QUARTER WHOSE DATA RESIDES IN THE SIP CFFILE (INPUT NECESSARY FOR THE SIP006 PROCEDURE): (1) LAST TWO DIGITS OF THE YEAR OF THE QUARTER (2) QUARTER CODE WHERE 1 IS WINTER 2 IS SPRING 3 IS SUMMER 4 IS FALL (3) YEAR IN WHICH THE QUARTER STARTS (4) MONTH IN WHICH THE QUARTER STARTS (5) DAY IN WHICH THE QUARTER STARTS (6) YEAR IN WHICH THE QUARTER ENDS (7) MONTH IN WHICH THE QUARTER ENDS (8) DAY IN WHICH THE QUARTER ENDS (9) RATE FOR CONTRACT CLASSES (10) NAME OF THE QUARTER (11) YEAR OF THE QUARTER (12) IN-STATE TUITION RATE (13) OUT-OF-STATE TUITION RATE 9. IN ADDITION TO LOADING THE SIP PCFILE AND THE SIP CFFILE, THE USER MAY WANT TO ADD THE COURSE DATA CONTAINED IN THE SIP PPFILE TO THE SIS CLASS DATA BASE. IF THIS IS THE CASE, THEN THE USER SHOULD CALL JOHN VAN HEMERT OR BILL LEIMBACH AT NEW RIVER COMMUNITY COLLEGE AS WELL AS PROVIDE THE FOLLOWING INFORMATION: (1) YEAR IN WHICH THE QUARTER STARTS (2) MONTH IN WHICH THE QUARTER STARTS (3) DAY IN WHICH THE QUARTER STARTS (4) YEAR IN WHICH THE QUARTER ENDS (5) MONTH IN WHICH THE QUARTER ENDS (6) DAY IN WHICH THE QUARTER ENDS (7) YEAR OF THE CENSUS DATE (8) MONTH OF THE CENSUS DATE (9) DAY OF THE CENSUS DATE (10) YEAR OF THE LAST DROP DATE (11) MONTH OF THE LAST DROP DATE (12) DAY OF THE LAST DROP DATE 10. IN ADDITION TO LOADING THE SIP PCFILE, THE SIP CFFILE, AND THE SIP PPFILE, THE USER MAY WANT TO ADD THE SIP HISTORY COURSE FILE TO THE SIS CLASS DATA BASE. IF THIS IS THE CASE, THEN THE USER SHOULD CALL JOHN VAN HEMERT OR BILL LEIMBACH AT NEW RIVER COMMUNITY COLLEGE AS WELL AS PROVIDE THE FOLLOWING INFORMATION: (1) YEAR IN WHICH THE QUARTER STARTS (2) MONTH IN WHICH THE QUARTER STARTS (3) DAY IN WHICH THE QUARTER STARTS (4) YEAR IN WHICH THE QUARTER ENDS (5) MONTH IN WHICH THE QUARTER ENDS (6) DAY IN WHICH THE QUARTER ENDS (7) YEAR OF THE CENSUS DATE (8) MONTH OF THE CENSUS DATE (9) DAY OF THE CENSUS DATE (10) YEAR OF THE LAST DROP DATE (11) MONTH OF THE LAST DROP DATE (12) DAY OF THE LAST DROP DATE AND: (1) THE NAME OF THE QUARTER (2) THE YEAR OF THE QUARTER 11. IN ADDITION, THE USER MAY WANT TO ADD THE SIP HISTORY STUDENT FILE TO THE SIS STUDENT FILE. IF THIS IS THE CASE, THEN THE USER SHOULD CALL JOHN VAN HEMERT OR BILL LEIMBACH AT NEW RIVER COMMUNITY COLLEGE AS WELL AS PROVIDE THE FOLLOWING INFORMATION: (1) THE NAME OF THE QUARTER (2) THE YEAR OF THE QUARTER 12. ONCE THE SIS DATA BASES HAVE BEEN SUCCESSFULLY CREATED AND LOADED, THE USER CAN CAPTURE A GIVEN QUARTER OF A SIS DATA AND PLACE IT IN SIP LOOK-A-LIKE FILES BY RUNNING THE SIP008 PROCEDURE. ONCE THESE LOOK-A-LIKE FILES HAVE BEEN CREATED, THE USER MAY RUN SIP REPORTS USING THIS LOOK-A-LIKE DATA AS WELL AS ACCESS THIS DATA WHICH HAS BEEN PLACED IN THE SAME FORMAT AS SIP FILES (THUS THE NAME LOOK-A-LIKE). 3.0 DATA BASE DESIGN ---------------- THE RESULT OF THE SIP-TO-SIS CONVERSION PROCEDURES IS THE FOLLOWING SIS DATA BASES: 1. SIS ADVISOR / COUNSELOR DATA BASE 2. SIS BUILDING / ROOM DATA BASE 3. SIS CLASS DATA BASE 4. SIS CONTROL DATA BASE 5. SIS CURRICULUM DATA BASE 6. SIS DEPARTMENT / COURSE DATA BASE 7. SIS INSTRUCTOR DATA BASE 8. SIS STUDENT DATA BASE HOWEVER, BECAUSE THE SIS DATA BASES ARE MORE COMPREHENSIVE IN THE AMOUNT OF INFORMATION THAT THEY STORE THAN THE SIP FILES, NOT ALL OF THE FIELDS IN THE SIS DATA BASES WILL BE DEFINED. THEREFORE, ONCE THE SIS DATA BASES HAVE BEEN CREATED AND LOADED, THE USER SHOULD RUN REPORTS TO LIST THE INFORMATION IN THE SIS DATA BASES AND BEGIN TO FILL IN THE HOLES IN THE DATA. ANOTHER BY-PRODUCT OF THIS SUBSYSTEM IS THE SIP008 PROCEDURE WHICH ALLOWS THE USER TO TAKE A SNAPSHOT OF THE SIS DATA BASES AT A PARTICULAR POINT IN TIME AND CREATE THE FOLLOWING SIP LOOK-A-LIKE FILES WHICH CAN ALLOW USERS TO GENERATE SIP REPORTS AND TO ACCESS THIS SIS DATA IN A SIP FILE FORMAT: 1. SIP COURSE LOOK-A-LIKE FILE 2. SIP COURSE REFERENCE LOOK-A-LIKE FILE 3. SIP CURRICULUM REFERENCE LOOK-A-LIKE FILE 4. SIP DEPARTMENT REFERENCE LOOK-A-LIKE FILE 5. SIP DIVISION REFERENCE LOOK-A-LIKE FILE 6. SIP EXPANDED CURRICULUM REFERENCE LOOK-A-LIKE FILE 7. SIP INSTRUCTOR REFERENCE LOOK-A-LIKE FILE 8. SIP JURISDICTION REFERENCE LOOK-A-LIKE FILE 9. SIP QUARTER HEADER LOOK-A-LIKE FILE 10. SIP ROOM REFERENCE LOOK-A-LIKE FILE 11. SIP STUDENT LOOK-A-LIKE FILE 4.0 PROCEDURE DOCUMENTATION ----------------------- THE FOLLOWING TABLE SUMMARIZES THE PROCEDURES WHICH ARE AVAILABLE UNDER THE SIP SUBSYSTEM: ------------------------------------------------------------------- PROCEDURE ] DESCRIPTION ------------------------------------------------------------------- SIP000 ] PERFORMS PREFIX RESOLUTION ] ] NOTE: (1) THIS PROCEDURE SHOULD ONLY BE RUN BY NEW ] RIVER COMMUNITY COLLEGE ] (2) THIS PROCEDURE SHOULD ONLY BE RUN AFTER THE ] SIP001 THROUGH SIP007 AND SIP016 PROCEDURES ] HAVE BEEN SUCCESSFULLY RUN -----------+------------------------------------------------------- SIP001 ] LOADS BUILDING / ROOM DATABASE FROM SIP FILES ] ] NOTE: THIS PROCEDURE SHOULD ONLY BE RUN BY NEW RIVER ] COMMUNITY COLLEGE -----------+------------------------------------------------------- SIP002 ] LOADS CLASS DATABASE FROM SIP FILES ] ] NOTE: THIS PROCEDURE SHOULD ONLY BE RUN BY NEW RIVER ] COMMUNITY COLLEGE -----------+------------------------------------------------------- SIP003 ] LOADS DEPARTMENT / COURSE DATABASE FROM SIP FILES ] ] NOTE: THIS PROCEDURE SHOULD ONLY BE RUN BY NEW RIVER ] COMMUNITY COLLEGE -----------+------------------------------------------------------- SIP004 ] LOADS CURRICULUM DATABASE FROM SIP FILES ] ] NOTE: THIS PROCEDURE SHOULD ONLY BE RUN BY NEW RIVER ] COMMUNITY COLLEGE -----------+------------------------------------------------------- SIP005 ] LOADS INSTRUCTOR DATABASE FROM SIP FILES ] ] NOTE: THIS PROCEDURE SHOULD ONLY BE RUN BY NEW RIVER ] COMMUNITY COLLEGE -----------+------------------------------------------------------- SIP006 ] LOADS CONTROL DATABASE FROM SIP FILES ------------------------------------------------------------------- PROCEDURE ] DESCRIPTION ------------------------------------------------------------------- ] ] NOTE: THIS PROCEDURE SHOULD ONLY BE RUN BY NEW RIVER ] COMMUNITY COLLEGE -----------+------------------------------------------------------- SIP007 ] LOADS STUDENT DATABASE FROM SIP FILES ] ] NOTE: THIS PROCEDURE SHOULD ONLY BE RUN BY NEW RIVER ] COMMUNITY COLLEGE -----------+------------------------------------------------------- SIP008 ]BUILDS THE FOLLOWING SIP LOOK-A-LIKE FILES: ] ] (1) SIP COURSE LOOK-A-LIKE FILE ] (2) SIP COURSE REFERENCE LOOK-A-LIKE FILE ] (3) SIP CURRICULUM REFERENCE LOOK-A-LIKE FILE ] (4) SIP DEPARTMENT REFERENCE LOOK-A-LIKE FILE ] (5) SIP DIVISION REFERENCE LOOK-A-LIKE FILE ] (6) SIP EXPANDED CURRICULUM REFERENCE LOOK-A-LIKE ] FILE ] (7) SIP INSTRUCTOR REFERENCE LOOK-A-LIKE FILE ] (8) SIP JURISDICTION REFERENCE LOOK-A-LIKE FILE ] (9) SIP QUARTER HEADER LOOK-A-LIKE FILE ] (10) SIP ROOM REFERENCE LOOK-A-LIKE FILE ] (11) SIP STUDENT LOOK-A-LIKE FILE ] ] WHOSE PURPOSE IS TO: ] ] (1) PROVIDE THE SAME REPORTING PROCEDURES IN SIS ] THAT WERE AVAILABLE IN SIP AND TO ] (2) PROVIDE A MEANS OF ACCESSING SIS STUDENT, ] COURSE, AND REFERENCE DATA IN THA SAME ] FORMAT AS SIP DATA FOR AD-HOC REPORTS THAT ] HAVE BEEN PREVIOUSLY DEVELOPED AND FOR ] INSTITUTIONAL RESEARCH NEEDS. -----------+------------------------------------------------------- SIP009 ] DISPLAYS SOCIAL SECURITY NUMBERS WITH MULTIPLE ] STUDENTS IN THE SIP STFILE OR GRFILE ] ] NOTE: RUN THIS PROCEDURE AND RESOLVE ANY CONFLICTS ] BEFORE THE SIP007 PROCEDURE IS RUN -----------+------------------------------------------------------- SIP010 ] DISPLAYS NON-BLANK COUNSELOR CODES WITH MULTIPLE ] INSTRUCTORS IN THE SIP IRFILE ] ] NOTE: RUN THIS PROCEDURE AND RESOLVE ANY CONFLICTS ] BEFORE THE SIP005 AND SIP016 PROCEDURES ARE ] RUN ------------------------------------------------------------------- PROCEDURE ] DESCRIPTION ------------------------------------------------------------------- SIP011 ] DISPLAYS NON-BLANK ADVISOR CODES WITH MULTIPLE ] INSTRUCTORS IN THE SIP IRFILE ] ] NOTE: RUN THIS PROCEDURE AND RESOLVE ANY CONFLICTS ] BEFORE THE SIP005 AND SIP016 PROCEDURES ARE ] RUN -----------+------------------------------------------------------- SIP012 ] COPIES THE FOLLOWING DATABASES FROM A SELECTED ] COLLEGE'S DATABASES: ] ] (1) CONTROL MESSAGE DATABASE ] (2) CONTROL TRANSACTION DATABASE ] (3) CONTROL PROGRAM OPTION DATABASE ] ] AND CREATES 1 RECORD IN THE CONTROL SECURITY DATABASE ] FOR A SPECIFIED COLLEGE ] ] NOTE: (1) THIS PROCEDURE SHOULD ONLY BE RUN BY NEW ] RIVER COMMUNITY COLLEGE ] (2) THIS PROCEDURE SHOULD ONLY BE RUN AFTER THE ] SIP001 THROUGH SIP007, SIP016, AND SIP000 ] PROCEDURES HAVE BEEN SUCCESSFULLY RUN -----------+------------------------------------------------------- SIP013 ] DISPLAYS COURSES WITH MULTIPLE SIS COURSE KEYS IN THE ] SIP PPFILE, PCFILE, OR CFFILE ] ] NOTE: RUN THIS PROCEDURE AND RESOLVE ANY CONFLICTS ] BEFORE THE SIP002 PROCEDURE IS RUN -----------+------------------------------------------------------- SIP016 ] BUILDS THE SIS ADVISOR / COUNSELOR DATABASE FROM SIP ] FILES ] ] NOTE: RUN THIS PROCEDURE AND RESOLVE ANY CONFLICTS ] BEFORE THE SIP007 AND SIP016 PROCEDURES ARE ] RUN -----------+------------------------------------------------------- SIP018 ] COMPARES ALL DATA IN THE SIP STUDENT FILE (STFILE OR ] GRFILE) AND THE SIP LOOK-A-LIKE STUDENT FILE WITH ] THE EXCEPTION OF REGISTRATION DATA. FIELDS THAT ] ARE NOT MOVED FROM SIP TO SIS OR FROM SIS TO SIP ] ARE IGNORED. WHEN DISCREPANCIES OCCUR, BOTH ] RECORDS ARE DISPLAYED AND THE OFFENDING COLUMNS ] ARE INDICATED. ] ] NOTE: THIS PROCEDURE SHOULD ONLY BE RUN BY NEW RIVER ] COMMUNITY COLLEGE ------------------------------------------------------------------- PROCEDURE ] DESCRIPTION ------------------------------------------------------------------- SIP019 ] COMPARES STUDENT REGISTRATION DATA IN THE SIP STUDENT ] FILE (STFILE OR GRFILE) AND THE SIP LOOK-A-LIKE ] STUDENT FILE. FIELDS THAT ARE NOT MOVED FROM SIP ] TO SIS OR FROM SIS TO SIP ARE IGNORED. WHEN ] DISCREPANCIES OCCUR, BOTH RECORDS ARE DISPLAYED ] AND THE OFFENDING COLUMNS ARE INDICATED. ] INDICATED. ] ] NOTE: THIS PROCEDURE SHOULD ONLY BE RUN BY NEW RIVER ] COMMUNITY COLLEGE -----------+------------------------------------------------------- SIP020 ] COMPARES DATA IN THE SIP COURSE FILE (PPFILE, PCFILE, ] OR CFFILE) AND THE SIP LOOK-A-LIKE COURSE FILE. ] FIELDS THAT ARE NOT MOVED FROM SIP TO SIS OR FROM ] SIS TO SIP ARE IGNORED. WHEN DISCREPANCIES OCCUR, ] BOTH RECORDS ARE DISPLAYED AND THE OFFENDING ] COLUMNS ARE INDICATED. ] ] NOTE: THIS PROCEDURE SHOULD ONLY BE RUN BY NEW RIVER ] COMMUNITY COLLEGE -----------+------------------------------------------------------- SIP021 ] COMPARES DATA IN THE SIP INSTRUCTOR FILE (IRFILE) AND ] THE SIP LOOK-A-LIKE INSTRUCTOR FILE. FIELDS THAT ] ARE NOT MOVED FROM SIP TO SIS OR FROM SIS TO SIP ] ARE IGNORED. WHEN DISCREPANCIES OCCUR, BOTH ] RECORDS ARE DISPLAYED AND THE OFFENDING COLUMNS ARE ] INDICATED. ] ] NOTE: THIS PROCEDURE SHOULD ONLY BE RUN BY NEW RIVER ] COMMUNITY COLLEGE -----------+------------------------------------------------------- SIP022 ] COMPARES DATA IN THE SIP ROOM FILE (ROFILE) AND THE ] SIP LOOK-A-LIKE ROOM FILE. FIELDS THAT ARE NOT ] MOVED FROM SIP TO SIS OR FROM SIS TO SIP ARE ] IGNORED. WHEN DISCREPANCIES OCCUR, BOTH RECORDS ] ARE DISPLAYED AND THE OFFENDING COLUMNS ARE ] INDICATED. ] ] NOTE: THIS PROCEDURE SHOULD ONLY BE RUN BY NEW RIVER ] COMMUNITY COLLEGE -----------+------------------------------------------------------- SIP023 ] COMPARES DATA IN THE SIP DIVISION FILE (DVFILE) AND ] THE SIP LOOK-A-LIKE DIVISION FILE. FIELDS THAT ] ARE MOVED FROM SIP TO SIS OR FROM SIS TO SIP ARE ] IGNORED. WHEN DISCREPANCIES OCCUR, BOTH RECORDS ] ARE DISPLAYED AND THE OFFENDING COLUMNS ARE ------------------------------------------------------------------- PROCEDURE ] DESCRIPTION ------------------------------------------------------------------- ] INDICATED. ] ] NOTE: THIS PROCEDURE SHOULD ONLY BE RUN BY NEW RIVER ] COMMUNITY COLLEGE -----------+------------------------------------------------------- SIP024 ] ADDS THE SIP PPFILE TO THE CLASS DATABASE ] ] NOTE: THIS PROCEDURE SHOULD ONLY BE RUN BY NEW RIVER ] COMMUNITY COLLEGE -----------+------------------------------------------------------- SIP025 ] ADDS THE SIP HISTORY COURSE FILE TO THE SIS CLASS DATA ] BASE ] ] NOTE: THIS PROCEDURE SHOULD ONLY BE RUN BY NEW RIVER ] COMMUNITY COLLEGE -----------+------------------------------------------------------- SIP026 ] ADDS THE SIP HISTORY STUDENT FILE TO THE SIS STUDENT ] DATA BASE ] ] NOTE: (1) THIS PROCEDURE SHOULD ONLY BE RUN BY NEW ] RIVER COMMUNITY COLLEGE ] (2) THIS PROCEDURE SHOULD ONLY BE RUN AFTER THE ] SIP025 PROCEDURE HAS BEEN SUCCESSFULLY RUN -----------+------------------------------------------------------- SIP027 ] LISTS THE STUDENT INQUIRY KEYS OF THOSE STUDENTS ] WHO ARE IN THE SIP GRFILE BUT ARE NOT IN THE ] SIP STFILE ] ] NOTE: RUN THIS PROCEDURE AND RESOLVE ANY CONFLICTS ] BEFORE THE SIP007 PROCEDURE IS RUN ===================================================================