0.010/14/83 VAN HEMERT AND LEIMBACH 1.0 PROCEDURE NARRATIVE ------------------- THE PURPOSE OF THE SIP001 PROCEDURE IS TO LOAD A COLLEGE'S SIS BUILDING / ROOM DATA BASE FROM THEIR SIP FILES. THIS IS ACCOMPLISHED IN THE FOLLOWING STEPS: 1. THE SIP AND OTHER ASSOCIATED FILES ARE MERGED AND MANIPULATED TO FORM A TEMPORARY SEQUENTIAL FILE WHICH CONTAINS THE SEGMENTS OF THE SIS BUILDING / ROOM DATABASE. EACH RECORD CONTAINS A DATA BASE AND SEGMENT NUMBER TO IDENTIFY ITS CONTENTS TO THE LOAD PROGRAM. 2. THE SIS BUILDING / ROOM DATA BASE IS DELETED (IF ONE ALREADY EXISTS) AND THEN ALLOCATED ONCE AGAIN (THEREBY CREATING AN EMPTY DATA BASE). 3. THE DATA BASE PREREOGANIZATION UTILITY IS RUN FOR THE SIS BUILDING / ROOM DATA BASE. 4. THE SIS BUILDING / ROOM DATA BASE IS LOADED USING THE RECORDS IN THE TEMPORARY SEQUENTIAL FILE. BECAUSE OF THE CREATION AND USE OF CERTAIN FILES IN THE DL/I LOADING PROCESS, THIS PROCEDURE CAN ONLY BE RUN BY CALLING JOHN VAN HEMERT OR BILL LEIMBACH AT NEW RIVER COMMUNITY COLLEGE. 2.0 SAMPLE JCL ---------- 2.1 REQUIRED SYMBOLIC PARAMETERS ---------------------------- LETTER - LETTER CODE EXAMPLE: FOR NEW RIVER COMMUNITY COLLEGE, LETTER IS L (LETTER=L) SCD - SCHOOL CODE EXAMPLE: FOR NEW RIVER COMMUNITY COLLEGE, SNM IS NR (SCD=NR) SNM - SCHOOL NUMBER EXAMPLE: FOR NEW RIVER COMMUNITY COLLEGE, SNM IS 275 (SNM=275) 2.2 OPTIONAL SYMBOLIC PARAMETERS ---------------------------- VERSION - THE VERSION OF THE DATA BASE TO BE USED (DEFAULT: VERSION=PROD). PROD : THE PRODUCTION VERSION OF THE DATA BASE IS TO BE USED (DEFAULT). TEST : THE TEST VERSION OF THE DATA BASE IS TO BE USED. 2.3 EXTRA CARD INPUT: NONE ---------------- 2.4 JCL EXAMPLE ----------- THE FOLLOWING EXAMPLE WILL CREATE AND LOAD THE SIS BUILDING / ROOM DATABASE FOR NEW RIVER COMMUNITY COLLEGE: JOB CARD ROUTE CARD // EXEC SIP001,SCD=NR,SNM=275,LETTER=L // 3.0 JOB SETUP INSTRUCTIONS ---------------------- SPECIAL FORMS QUEUE: A000 FORMS BUFFER: STANDARD ALIGNMENT INSTRUCTIONS: STANDARD PRINTED OUTPUT: 1. OUTPUT FROM THE IDCAMS PROGRAM INDICATING WHETHER OR NOT THE SIS BUILDING / ROOM DATA BASE WAS DELETED AND WHETHER OR NOT THE DATA BASE WAS REDEFINED. 2. OUTPUT INDICATING WHETHER OR NOT THE PREREORGANIZATION UTILITY WAS SUCCESSFUL OR NOT. 3. SUMMARY INDICATING THE NUMBER OF DIFFERENT SEGMENTS IN THE SIS BUILDING / ROOM DATA BASE THAT WERE BUILT. FORMS TYPE: 14 X 11 SPECIAL INSTRUCTIONS: THIS PROCEDURE CAN ONLY BE RUN BY NEW RIVER COMMUNITY COLLLEGE 4.0 FILES ----- 4.1 DATA BASE/SEGMENTS USED ----------------------- 1. SIS BUILDING / ROOM DATA BASE: CREATED AND LOADED 4.2 ADDITIONAL FILES USED --------------------- 1. BUILDING DATA SET PRODUCED BY THE INITIAL LOAD FOR USE BY THE PREFIX RESOLUTION UTILITY IN THE SIP000 PROCEDURE 2. BUILDING CONTROL DATA SET PRODUCED BY THE PREREORGANIZATION UTILITY FOR USE BY THE PREFIX RESOLUTION UTILITY IN THE SIP000 PROCEDURE 3. F1A FICE CODE FILE 4. F1A ROOM INVENTORY FILE 5. SIP COURSE FILES (PCFILE AND CFFILE) 6. SIP QUARTER AND YEAR FILE FOR THE SIP PCFILE 7. SIP QUARTER AND YEAR FILE FOR THE SIP CFFILE 8. SIP ROOM REFERENCE FILE (ROFILE) 9. SIP TO F1A BUILDING AND ROOM CONVERSION FILE 4.3 INPUT/OUTPUT RECORD LAYOUT: NONE -------------------------- 5.0 SPECIAL OUTPUT MESSAGES ----------------------- 1. WHEN AN SIS BUILDING / ROOM SEGMENT ALREADY EXISTS, AN ERROR MESSAGE INDICATING THIS CONDITION IS PRINTED. 2. WHENEVER A DATA BASE ERROR OCCURS WHILE LOADING THE DATA BASE, AN ERROR MESSAGE INDICATING THE OFFENDING SEGMENT, THE VALUE OF THE SEGMENT, AND THE STATUS CODE OF THE ERROR IS PRINTED. 6.0 SPECIAL FEATURES: NONE ---------------- 7.0 PROGRAM OPTIONS: NONE --------------- 8.0 CHANGE HISTORY -------------- 8.1 VERSION NO: V1.3 CHANGE DATE: 10-14-83 PROGRAMMER NAME: JOHN VAN HEMERT AND BILL LEIMBACH PROGRAM CHANGE REQUEST NO: NONE DESCRIPTION OF CHANGE: FIRST COMPLETED