0.006/05/84 VAN HEMERT AND LEIMBACH 1.0 INTRODUCTION ------------ THE PURPOSE OF THE SIP REPORTING PROCEDURES (SRP) IS TO PROVIDE THE SAME REPORTING PROCEDURES IN THE STUDENT INFORMATION SYSTEM (SIS) THAT WERE AVAILABLE IN THE STUDENT INFORMATION PACKAGE (SIP). IT SHOULD BE POINTED OUT THAT THE SIP LOOK-A-LIKE REPORTING PROCEDURES ARE NOT A PERMAMENT SOLUTION TO THE REPORTING NEEDS OF USERS OF THE STUDENT INFORMATION SYSTEM (SIS). THE USER SHOULD MAKE EVERY EFFORT TO FIRST SATISFY HIS/HER NEEDS USING THE SIS REPORTING PROCEDURES THAT HAVE BEEN DEVELOPED. IF THESE PROCEDURES DO NOT SATISFY YOUR NEEDS, YOU SHOULD PREPARE A PROGRAM REQUEST FORM EXPLAINING ANY REQUESTED CHANGES TO EXISTING REPORTS OR ANY REQUESTS FOR ADDITIONAL REPORTS. IF THE REPORT CANNOT BE CHANGED OR CREATED IN TIME, THEN THE USER SHOULD RELY ON THE SIP REPORTING PROCEDURES. 2.0 SYSTEM NARRATIVE ---------------- IN THE EVENT THAT A USER NEEDS TO RUN A REPORT THAT WAS AVAILABLE UNDER SIP USING SIS DATA, THE FOLLOWING STEPS SHOULD BE PERFORMED: 1. RUN THE SIP008 PROCEDURE TO BUILD THE SIP LOOK-A-LIKE FILES FOR A SPECIFIED QUARTER. 2. CHOOSE THE DESIRED SIP REPORT. 3. DETERMINE THE NAME OF THE SIP REPORTING PROCEDURE TO BE USED TO GENERATE THE DESIRED REPORT. THIS IS ACCOMPLISHED BY REPLACING THE PREFIX VCCS WITH SRP (INDICATING SIP REPORTING PROCEDURE). FOR EXAMPLE, THE VCCSRPT PROCEDURE IS RUN USING SIS DATA BY RUNNING THE SRPRPT PROCEDURE AND THE VCCS105 PROCEDURE IS RUN USING THE SRP105 PROCEDURE. 4. RUN THE SRP PROCEDURE. THE PARAMETERS REQUIRED FOR RUNNING THE SIP REPORTS USING THE LOOK-A-LIKE FILES ARE ARE THE SAME AS THE SIP PROCEDURES AND A DESCRIPTION OF THESE VALUES CAN BE FOUND IN YOUR SIP DATA CONTROL MANUAL. A LISTING OF THE AVAILABLE PROCEDURES CAN BE FOUND IN THE DOCUMENTATION OF THE SIP REPORTING PROCEDURE (SRP) SYSTEM. THERE ARE SOME ADDITIONAL POINTS TO BE MADE ABOUT USING THE SIP008 PROCEDURE AND THE SIP REPORTING PROCEDURES: 1. THE SIP008 PROCEDURE CAN BE RUN OVER AND OVER AGAIN THROUGHOUT THE QUARTER. REMEMBER, THE ONLY WAY THAT THESE FILES CAN CAPTURE THE LASTEST UPDATES IN SIS IS TO RUN THE SIP008 PROCEDURE. SO IF YOU NEED TO RUN A REPORT, BE SURE THAT THE SIP008 PROCEDURE HAS CAPTURED THE LATEST UPDATES. 2. EACH TIME AN SIP REPORTING PROCEDURE USING SIS DATA IS RUN, A MESSAGE IS PRINTED INDICATING THE DATE AND THE TIME AT WHICH THE SIP LOOK-A-LIKE FILES WERE BUILT. 3. DUE TO THE NATURE OF THE CONVERSION OF SIP DATA TO SIS DATA AND THE CONVERSION OF SIS DATA TO SIP LOOK-A-LIKE DATA, SOME DATA ITEMS WILL NOT BE PRESENT IN THE LOOK-A-LIKE FILES. 4. DUE TO THE NATURE OF GRADE REPORTING UNDER SIP REPORTING, THE USER SHOULD DETERMINE IF THE SIP LOOK-A-LIKE STUDENT FILE SHOULD BE BUILT FOR GRADE PROCESSING (SEE THE DESCRIPTION OF THE GRADES PARAMETER IN THE DOCUMENTATION OF THE SIP008 PROCEDURE). 5. THE USER NEEDS TO DETERMINE IF THE SIP STUDENT LOOK-A-LIKE FILE SHOULD CONTAIN THOSE STUDENTS (BUT NOT THEIR REGISTRATIONS) WHO HAVE TAKEN A CLASS IN ONE OF THREE PRIOR QUARTERS (SEE THE DESCRIPTION OF THE PAST3 PARAMETER IN THE DOCUMENTATION OF THE SIP008 PROCEDURE). 6. IN ADDITION, THE USER NEEDS TO DETERMINE IF THE SIP COURSE LOOK-A-LIKE SHOULD CONTAIN THE VALUE OF THE MAXIMUM ENROLLMENT FIELD OR THE ACTUAL ENROLLMENT FIELD OF THE SIS COURSE DATABASE (SEE THE DESCRIPTION OF THE ENROLL PARAMETER BELOW). 7. NOT ALL OF THE PROCEDURES WERE CONVERTED TO AN EQUIVALENT SIP REPORTING PROCEDURE UNDER SIS DUE TO THEIR NATURE OF UPDATING FILES. SINCE THE USE OF THE SIP REPORTING PROCEDURES IS ONLY TEMPORARY AND SINCE THE USER MUST FOCUS EXCLUSIVELY ON SIS, UPDATES TO THE LOOK-A-LIKE FILES WERE DEEMED INAPPROPRIATE. NOTE TOO, THAT SOME SIP PROCEDURES WITH UPDATING CAPABILITY WERE CONVERTED TO AN EQUIVALENT SIP REPORTING PROCEDURE UNDER SIS BUT THEIR UPDATING STEPS WERE REMOVED. 8. THE BACKUPS WHICH WERE NORMALLY PERFORMED IN SIP PROCEDURES HAVE BEEN ELIMINATED SINCE A BACKUP COPY OF THE DATA ALREADY EXISTS, NAMELY THE SIS DATABASES. 9. AND FINALLY, IF THERE IS AN SIP PROCEDURE THAT YOU NEED THAT HAS NOT BEEN CONVERTED TO USE THE LOOK-A-LIKE FILES, PLEASE CONTACT JOHN VAN HEMERT OR BILL LEIMBACH AT NEW RIVER COMMUNITY COLLEGE FOR ASSISTANCE. 3.0 DATA BASE DESIGN ---------------- THE SIP REPORTING PROCEDURES ARE RUN USING THE FOLLOWING SIP LOOK-A-LIKE FILES WHICH ARE CREATED USING THE SIP008 PROCEDURES: 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 LISTS THE NAME OF EACH SIP PROCEDURE (THE SIP PROCEDURE COLUMN) AND THE NAME OF THE PROCEDURE THAT PERFORMS THE SAME FUNCTION UNDER SIS USING THE SIP LOOK-A-LIKE FILES (THE SRP PROCEDURE). A VALUE OF NONE IN THE SRP PROCEDURE COLUMN INDICATES THAT THE SIP PROCEDURE HAS NOT BEEN CONVERTED TO RUN USING THE SIP LOOK-A-LIKE FILES. ------------------------------------------------------------------ SRP ] SIP ] PROCEDURE ] PROCEDURE ] DESCRIPTION ------------------------------------------------------------------ NONE ] VCCS003 ] BUILD COLLEGE REFERENCE FILES NONE ] VCCS004 ] BUILD PCFILE SRP007 ] VCCS007 ] UNFORMATTED LIST OF STUDENT / GRADE FILE SRP014 ] VCCS014 ] LIST STUDENT / GRADE FILE SRP040 ] VCCS040 ] PRINT VCCS MASTER REFERENCE FILES SRP051 ] VCCS051 ] PRINT COLLEGE REFERENCE FILES SRP014 ] VCCS070 ] LIST SELECTED STUDENTS FROM STUDENT / ] ] GRADE FILE ] ] NOTE: THIS PROCEDURE EXECUTES VCCS014 ] ] HENCE SRP014 WILL BE EXECUTED ------------------------------------------------------------------ SRP ] SIP ] PROCEDURE ] PROCEDURE ] DESCRIPTION ------------------------------------------------------------------ NONE ] VCCS102 ] UPDATE COLLEGE REFERENCE FILES NONE ] VCCS103 ] UPDATE PCFILE SRP105 ] VCCS105 ] PRINT CLASS ROLLS / ENROLLMENT SUMMARY SRP106 ] VCCS106 ] FINAL GRADE REPORT NONE ] VCCS107 ] FINAL GPA UPDATES SRP108 ] VCCS108 ] CORRECTED GRADE REPORTS NONE ] VCCS109 ] UPDATE CFFILE SRP105 ] VCCS111 ] INSTRUCTOR GRADE REPORTS ] ] NOTE: THIS PROCEDURE EXECUTES VCCS105 ] ] HENCE SRP105 WILL BE EXECUTED NONE ] VCCS112 ] CLASS ROLLS / PUNCH V CARDS SRP105 ] VCCS113 ] CLASS ROLLS ] ] NOTE: THIS PROCEDURE EXECUTES VCCS105 ] ] HENCE SRP105 WILL BE EXECUTED SRP115 ] VCCS115 ] SELECTED CLASS ROLLS NONE ] VCCS116 ] SELECTED CLASS ROLLS AND V CARDS SRP115 ] VCCS117 ] SELECTED FINAL CLASS ROLLS ] ] NOTE: THIS PROCEDURE EXECUTES VCCS115 ] ] HENCE SRP115 WILL BE EXECUTED SRP115 ] VCCS118 ] SELECTED INSTRUCTOR GRADE REPORTS ] ] NOTE: THIS PROCEDURE EXECUTES VCCS115 ] ] HENCE SRP115 WILL BE EXECUTED SRP120 ] VCCS120 ] PRINT CLASS ROLLS SRP121 ] VCCS121 ] PRINT SELECTED CLASS ROLLS NONE ] VCCS130 ] CHANGES CURRICULUM CODES ON THE STUDENT ] ] FILE SRP195 ] VCCS195 ] GRADUATE CLASS ROLLS AND V CARDS NONE ] VCCS196 ] PUNCH GRADUATE 'G' CARDS SRP199 ] VCCS199 ] GRADUATE GRADE REPORTS NONE ] VCCS200 ] PUNCH T CARDS NONE ] VCCS202 ] PUNCH V CARDS SRP204 ] VCCS204 ] RANDOM PRINT FROM MASTER FILE NONE ] VCCS316 ] FILE CONVERSION - STEP 1 NONE ] VCCS317 ] FILE CONVERSION - STEP 2 SRP321 ] VCCS321 ] ACADEMIC STATUS REPORTS SRP325 ] VCCS325 ] PRINT GRADE LABELS SRP328 ] VCCS328 ] PRINT SELECTED GRADE LABELS SRP303 ] VCCS333 ] CLASS ENROLLMENT STATUS REPORT ] ] NOTE: THIS PROCEDURE EXECUTES VCCS303 ] ] HENCE SRP303 WILL BE EXECUTED SRP337 ] VCCS337 ] PRINT STUDENT NAME AND ADDRESS LABELS ] ] IN SORTED SEQUENCES SRP337 ] VCCS339 ] PRINT STUDENT NAME AND ADDRESS LABELS ] ] FOR ENROLLED OR NON-ENROLLED ] ] STUDENTS IN SORTED SEQUENCES ------------------------------------------------------------------ SRP ] SIP ] PROCEDURE ] PROCEDURE ] DESCRIPTION ------------------------------------------------------------------ ] ] NOTE: THIS PROCEDURE EXECUTES VCCS337 ] ] HENCE SRP337 WILL BE EXECUTED SRP341 ] VCCS341 ] SELECTED STUDENT NAME / ADDRESS LABELS SRP353 ] VCCS353 ] STUDENT LIST BY HIGH SCHOOL CODE NONE ] VCCS357 ] STUDENT COURSE SUMMARY AND GPA REPORT ] ] BY SELECTED HIGH SCHOOLS ] ] NOTE: VCCS357 IS IN THE SIP DATA ] ] CONTROL MANUAL (NOVEMBER 1983) BUT ] ] IS NOT IN SYS3.PROCLIB SRP321 ] VCCS360 ] SELECTED ACADEMIC STATUS CODE REPORT ] ] NOTE: THIS PROCEDURE EXECUTES VCCS321 ] ] HENCE SRP321 WILL BE EXECUTED SRP370 ] VCCS370 ] PRINTS GRADE REPORTS IN SPECIFIED ] ] SEQUENCES SRP371 ] VCCS371 ] PRINT PERMAMENT RECORD CARDS SRP387 ] VCCS387 ] NAME AND ADDRESS LABELS FOR VETERANS NONE ] VCCS400 ] LIST UNCLASSIFIED STUDENTS WITH OVER 24 ] ] CREDIT HOURS COMPLETED NONE ] VCCS401 ] LIST UNCLASSIFIED STUDENTS WITH OVER 32 ] ] CREDIT HOURS COMPLETED NONE ] VCCS402 ] STUDENT QUARTER AND CUMMULATIVE GPA ] ] REPORT NONE ] VCCS404 ] LIST STUDENTS IN DESCENDING SEQUENCE ] ] BY CUMMULATIVE GPA NONE ] VCCS405 ] LIST STUDENTS IN DESCENDING SEQUENCE ] ] BY QUARTER GPA NONE ] VCCS700 ] LOAD STUDENT REGISTRATION DATA NONE ] VCCS701 ] PUNCH ADM101 / ADM102 CARDS SRP702 ] VCCS702 ] PRE-EDIT FOR AKT ] ] NOTE: THIS PROCEDURE SHOULD USE THE SIP ] ] MASTER FILES AND NO THE SIS / SIP ] ] MASTER FILES SRP703 ] VCCS703 ] BUILD AKT FILES ] ] NOTE: THIS PROCEDURE SHOULD USE THE SIP ] ] MASTER FILES AND NO THE SIS / SIP ] ] MASTER FILES NONE ] VCCS704 ] UPDATE STUDENT FILE WITH V CARDS NONE ] VCCS709 ] PUNCH ADM101 CARDS NONE ] VCCS710 ] UPDATE GRADE FILE WITH V CARDS NONE ] VCCS711 ] LOAD STUDENT REGISTRATION DATA AND PRINT ] ] R & I FORMS NONE ] VCCS713 ] UPDATES STUDENT FILE WITH REGISTRATION ] ] DATA AND PRINTS CLASS STATUS REPORT NONE ] VCCS714 ] UPDATE STUDENT FILE WITH REGISTRATION DATA NONE ] VCCS724 ] UPDATES TO STUDENT FILE ------------------------------------------------------------------ SRP ] SIP ] PROCEDURE ] PROCEDURE ] DESCRIPTION ------------------------------------------------------------------ NONE ] VCCS725 ] UPDATES TO GRADE FILE NONE ] VCCS726 ] UPDATES TO STUDENT AND GRADE FILES NONE ] VCCS736 ] PRINTS STUDENT ADDRESS LABELS FROM ADM101 ] ] AND ADM102 CARDS SRP780 ] VCCS780 ] PRINTS STATUS REPORT OF VETERANS NONE ] VCCS785 ] CREATES TEMPORARY FILES FROM HISTORY FOR ] ] DATA FROM 1974 THROUGH 1982 NONE ] VCCS786 ] CREATES TEMPORARY FILES FROM HISTORY ] ] BEGINNING WITH WINTER QUARTER 1983 NONE ] VCCS788 ] PRINT NON-RETURNING STUDENTS REPORT NONE ] VCCS789 ] PRINT NON-RETURNING STUDENTS REPORT FROM ] ] HISTORY FILES SRP805 ] VCCS805 ] CLASS ENROLLMENT REPORT FROM STUDENT FILE NONE ] VCCS870 ] DELETE CANCELED CLASS AND STUDENTS ] ] REGISTERED FOR CLASS NONE ] VCCS875 ] PRINTS CLASS ROLLS AND ENROLLMENT SUMMARY ] ] IN USER SPECIFIED SEQUENCES SRP880 ] VCCS880 ] PRINTS CLASS ROLLS AND ENROLLMENT SUMMARY ] ] IN USER SPECIFIED SEQUENCES AND DOES ] ] NOT UPDATE THE COURSE FILE SRP885 ] VCCS885 ] PRINT FACULTY SCHEDULE REPORT NONE ] VCCS900 ] BUILD PRELIMINARY PRELIMINARY FILE ] ] (PPFILE) NONE ] VCCS901 ] UPDATE PRELIMINARY PRELIMINARY FILE ] ] (PPFILE) NONE ] VCCS902 ] PUNCH T CARDS FROM PPFILE NONE ] VCCS903 ] BUILD QUARTER FILE FROM PPFILE SRP910 ] VCCS910 ] G.P.A. BY CURRICULUM REPORTS NONE ] VCCSTB15 ] STUDENT ENROLLMENT FROM AKT FILES SRPRPT ] VCCSRPT ] SIP REPORTING PROCEDURE ] ] ] ] NOTE: THE VCCSRPT PROCEDURE RESULTED FROM ] ] CONSOLIDATING A NUMBER OF PREVIOUSLY ] ] STAND-ALONE PROCEDURES. CONTROL CARDS ] ] FOR THIS PROCEDURE CONSISTS OF THE ] ] FORMER STAND-ALONE PROCEDURE NAMES. ] ] THESE WILL NOT CHANGE IN THE SIP ] ] REPORTING PROCEDURES (SRP). ] ] ] VCCS301 ] STUDENT ENROLLMENT SUMMARY ] VCCS302 ] TUITION RECONCILIATION ] VCCS304 ] MASTER COURSE SCHEDULE ENROLLMENT SUMMARY ] VCCS305 ] ROOM AVAILABILITY / CONFLICT ] VCCS306 ] SCHEDULE OF CLASSES ] VCCS307 ] STUDENTS BY CURRICULUM ------------------------------------------------------------------ SRP ] SIP ] PROCEDURE ] PROCEDURE ] DESCRIPTION ------------------------------------------------------------------ ] VCCS308 ] STUDENTS BY COUNSELOR ] VCCS309 ] STUDENTS BY ADVISOR ] VCCS310 ] STUDENTS BY DIVISION ] VCCS311 ] ROOM UTILIZATION ] VCCS312 ] INSTUCTOR WORKLOAD ] VCCS313 ] DIVISION / DEPARTMENT WORKLOAD ] VCCS314 ] CURRICULUM HEADCOUNT ] VCCS315 ] CURRICULUM ENROLLMENT ] VCCS318 ] SUSPENSION / DISMISSAL REPORT ] VCCS319 ] STUDENT FAILURE REPORT ] VCCS320 ] INCOMPLETE AND RE-ENROLL REPORT ] VCCS322 ] GRADE DISTRIBUTION REPORT ] VCCS323 ] LISTS PCFILE, CFFILE, OR PPFILE ] VCCS327 ] BORDER-LINE STUDENTS BY COUNSELOR ] VCCS330 ] RACE CURRICULUM LISTING ] VCCS331 ] LOCALITY DISTRIBUTION REPORT ] VCCS332 ] STUDENTS SCHEDULE REPORT ] VCCS335 ] JURISDICTION DISTRIBUTION REPORT ] VCCS350 ] MISSING DATA EDIT ] VCCS352 ] STUDENT'S CLASS SUMMARY ] VCCS365 ] S-2 REPORT FROM STFILE ] VCCS375 ] STUDENT CLASS CONFLICTS ] VCCS394 ] STUDENT LIST BY NAME ] VCCS740 ] PRE-REGISTRATION BY CURRICULUM ] VCCS742 ] APPLICATION ANALYSIS BY CURRICULUM ] VCCS790 ] DUPLICATE SOCIAL SECURITY NUMBER REPORT ] VCCS807 ] STUDENT TOTALS BY CURRICULUM ] VCCS825 ] CURRICULUM TOTALS WITHOUT AUDITS, SENIOR ] ] CITZENS, AND ADDED COURSES ] VCCS826 ] CURRICULUM TOTALS WITH ONLY AUDITS, ] ] SENIOR CITZENS, AND ADDED COURSES ] VCCS850 ] STUDENTS WITH A SELECTED GRADE ] VCCS852 ] STUDENTS WITH A SELECTED GRADE FOR ALL ] ] CLASSES ] VCCS860 ] STUDENT CLASS SUMMARY WITH GPA DATA ] VCCS865 ] STUDENT DIRECTORY ] VCCS881 ] APPROVED CURRICULUMS FOR THE COLLEGE ] VCCS957 ] STUDENT ENROLLMENT BY CREDIT HOURS ] VCCS958 ] UN-ASSIGNED GRADE REPORT ] VCCS998 ] STUDENTS BY CURRICULUM OF CHOICE ] VCCS999 ] STUDENTS BY CURRICULUM OF INTEREST ================================================================== THE FOLLOWING EXAMPLE SHOWS HOW THE VCCS105 PROCEDURE (CLASS ROLLS AND COURSE ENROLLMENT SUMMARY) CAN BE TRANSFORMED FROM USING SIP DATA TO USING SIP LOOK-A-LIKE FILES (A SNAPSHOT OF SIS DATA): (1) CLASS ROLLS AND COURSE ENROLLMENT SUMMARY USING NEW RIVER'S SIP DATA: JOB CARD ROUTE CARD // EXEC VCCS105,CAMPUS=NR275,QUARTR=NXT275,OPT=APC, // COURSE=PC,STUDENT=ST,MULTI=0 // (2) CLASS ROLLS AND COURSE ENROLLMENT SUMMARY USING NEW RIVER'S SIP LOOK-A-LIKE FILES (CAPTURED SIS DATA): JOB CARD ROUTE CARD // EXEC SRP105,CAMPUS=NR275,QUARTR=NXT275,OPT=APC, // COURSE=PC,STUDENT=ST,MULTI=0 // THE FOLLOWING EXAMPLE SHOWS HOW THE VCCS314 REPORT (CURRICULUM HEADCOUNT) OF THE VCCSRPT PROCEDURE CAN BE TRANSFORMED FROM USING SIP DATA TO USING SIP LOOK-A-LIKE FILES (A SNAPSHOT OF SIS DATA): (1) CURRICULUM HEADCOUNT REPORT USING NEW RIVER'S SIP DATA: JOB CARD ROUTE CARD // EXEC VCCSRPT,CAMPUS=NR275, // STUDENT=ST,COURSE=PC,QUARTR=NXT275 //DRIVER.CONTROL DD * VCCS314 CURRICULUM HEADCOUNT // (2) CURRICULUM HEADCOUNT REPORT USING NEW RIVER'S SIP LOOK-A-LIKE FILES (CAPTURED SIS DATA): JOB CARD ROUTE CARD // EXEC SRPRPT,CAMPUS=NR275, // STUDENT=ST,COURSE=PC,QUARTR=NXT275 //DRIVER.CONTROL DD * VCCS314 CURRICULUM HEADCOUNT //