0.003/13/99 RICHARD GILLETTE 1.0 PROGRAM NARRATIVE ----------------- THIS PROGRAM (REC910) GENERATES 6 CEU ACCOUNTS RECEIVABLE REPORTS FOR A SELECTED TERM. THE REPORTS LIST MISMATCHES OF CEU REGISTRATION DATA VERSUS CEU ACCOUNTING DATA. A MISMATCH IS DEFINED AS A CSTREGIS SEGMENT AND/OR ONE OR MORE CSTACCTD SEGMENT(S), FOR A GIVEN SSN AND CLASS-ID, HAVING A NONZERO UNPAID-TUITION AND/OR UNPAID-CHARGES VALUE. THESE (AND OTHER) VALUES ARE COMPUTED AS FOLLOWS: -- TOTAL-CHARGES: THE SUM OF THE 'C' TRANSACTION AMOUNTS + THE SUM OF THE 'A+' TRANSACTION AMOUNTS - THE SUM OF THE 'A-' TRANSACTION AMOUNTS. -- TOTAL-CHARGE-PAYMENTS: THE SUM OF THE 'PC' TRANSACTION AMOUNTS. -- UNPAID-CHARGES: TOTAL-CHARGES - TOTAL-CHARGE-PAYMENTS. -- TUITION: TUITION-RATE + LAB-FEE + STUDENT-MISC-FEE. (IF NO CSTREGIS SEGMENT EXISTS FOR THIS SSN AND CLASS-ID, TUITION EQUALS ZERO.) -- TOTAL-SIMPLE-PAYMENTS: THE SUM OF THE 'P' TRANSACTION AMOUNTS. -- TOTAL-REFUNDS: THE SUM OF THE 'R' TRANSACTION AMOUNTS. -- TOTAL-REAPPLIES: THE SUM OF THE 'RA' TRANSACTION AMOUNTS. -- AMOUNT-PAID: TOTAL-SIMPLE-PAYMENTS + TOTAL-CHARGE-PAYMENTS - TOTAL-REFUNDS - TOTAL-REAPPLIES. -- UNPAID-TUITION: TUITION - AMOUNT-PAID. THE 6 REPORTS ARE: -- RECEIVABLES REPORT: THOSE MISMATCHES THAT COULD BE RESOLVED VIA RECEIVING PAYMENT FOR ALL CHARGES THAT HAVE BEEN BILLED. -- MISMATCH REPORT: THOSE MISMATCHES THAT AREN'T INCLUDED ON THE RECEIVABLES REPORT. -- REFUND REPORT: THOSE MISMATCHES THAT COULD BE RESOLVED VIA ISSUING A REFUND TO THE STUDENT AND/OR THE SPONSOR. (THIS IS A SUBSET OF THE MISMATCH REPORT.) -- UNBILLED CHARGES REPORT: THOSE MISMATCHES FOR WHICH BILLING IS NEEDED. (THIS IS A SUBSET OF THE MISMATCH REPORT.) -- UNPAID PRIOR CLASS REPORT: THOSE MISMATCHES THAT MEET THESE CRITERIA: - THE UNPAID TUITION IS GREATER THAN ZERO, AND IS GREATER THAN THE UNPAID CHARGES. - THERE ARE NO UNBILLED CHARGES. - THE CLASS HAS ALREADY BEGUN. (THIS IS A SUBSET OF THE MISMATCH REPORT.) -- MISCELLANEOUS REPORT: THOSE MISMATCHES THAT AREN'T INCLUDED ON THE RECEIVABLES, REFUND, UNBILLED CHARGES, OR UNPAID PRIOR CLASS REPORT. (THIS IS A SUBSET OF THE MISMATCH REPORT.) EACH OF THE 6 REPORTS INCLUDES THESE FIELDS: -- RUN TERM. -- STUDENT'S CAMPUS. (INCLUDED ONLY WHEN SEQUENCE-OPTION '2' IS SELECTED.) -- STUDENT'S NAME AND SSN. -- IDENTIFICATION OF THE CLASS (COURSE-ID, SECTION NUMBER, AND CAMPUS CODE). -- STARTING DATE OF THE CLASS (IN "MM/DD" FORMAT). -- MISMATCH REASON, WHICH IS ONE OF THE FOLLOWING: -- 'UNPAID TUITION'. -- 'UNPAID CHARGES'. -- 'REFUND NEEDED'. -- 'ADJUST. NEEDED'. -- TUITION. -- AMOUNT PAID. -- UNPAID TUITION. -- ALL CEU ACCOUNTING TRANSACTIONS (FOR THE CLASS) OF TYPES 'P', 'R', 'RA', 'C', 'A+', 'A-', AND 'PC'; THE FIELDS REPORTED ARE: -- TRANSACTION TYPE. -- AMOUNT. -- ACCOUNT CODE. -- BILL-PAY-DATE (IN "MM/DD/YY" FORMAT), OR BLANK (WHEN ZERO). -- REPORT TOTALS OR CAMPUS TOTALS: -- TUITION. -- AMOUNT PAID. -- UNPAID TUITION. -- RECORD COUNT. 2.0 SAMPLE JOB CONTROL LANGUAGE (JCL) --------------------------------- 2.1 RUN JCL ------- //REC910 JOB (XXXX,XXXX,9,50),REC910,MSGLEVEL=(1,1), // MSGCLASS=A,CLASS=F,PRTY=3 /*ROUTE PRINT XXXXXXXX //* //REC910 EXEC REC910, // AGENCY=XXX, // COLLEGE=XX //REC910.PARMCARD DD * -- INPUT PARAMETERS -- /* // SYMBOLIC PARAMETERS ------------------- REQUIRED PARAMETERS ------------------- AGENCY = AGENCY CODE NUMBER (E.G. AGENCY=283) COLLEGE = COLLEGE NAME ABBREVIATION (E.G. COLLEGE=SR) OPTIONAL PARAMETERS ------------------- COPIES1 = NUMBER OF TIMES THE MISCELLANEOUS REPORT IS TO BE PRINTED ON THE SELECTED FORM (DEFAULT = 01) (E.G. COPIES1=03) COPIES2 = NUMBER OF TIMES THE MISMATCH REPORT IS TO BE PRINTED ON THE SELECTED FORM (DEFAULT = 01) (E.G. COPIES2=03) COPIES3 = NUMBER OF TIMES THE RECEIVABLES REPORT IS TO BE PRINTED ON THE SELECTED FORM (DEFAULT = 01) (E.G. COPIES3=03) COPIES4 = NUMBER OF TIMES THE REFUND REPORT IS TO BE PRINTED ON THE SELECTED FORM (DEFAULT = 01) (E.G. COPIES4=03) COPIES5 = NUMBER OF TIMES THE UNBILLED CHARGES REPORT IS TO BE PRINTED ON THE SELECTED FORM (DEFAULT = 01) (E.G. COPIES5=03) COPIES6 = NUMBER OF TIMES THE UNPAID PRIOR CLASS REPORT IS TO BE PRINTED ON THE SELECTED FORM (DEFAULT = 01) (E.G. COPIES6=03) DBTYPE = TYPE OF DATABASES TO BE USED (DEFAULT = PROD) (E.G. DBTYPE=TEST) FORM1 = FORM NUMBER THE MISCELLANEOUS REPORT IS TO BE STORED UNDER (DEFAULT = A000) (E.G. FORM1=0002) FORM2 = FORM NUMBER THE MISMATCH REPORT IS TO BE STORED UNDER (DEFAULT = A000) (E.G. FORM2=0002) FORM3 = FORM NUMBER THE RECEIVABLES REPORT IS TO BE STORED UNDER (DEFAULT = A000) (E.G. FORM3=0002) FORM4 = FORM NUMBER THE REFUND REPORT IS TO BE STORED UNDER (DEFAULT = A000) (E.G. FORM4=0002) FORM5 = FORM NUMBER THE UNBILLED CHARGES REPORT IS TO BE STORED UNDER (DEFAULT = A000) (E.G. FORM5=0002) FORM6 = FORM NUMBER THE UNPAID PRIOR CLASS REPORT IS TO BE STORED UNDER (DEFAULT = A000) (E.G. FORM6=0002) IMSNODE = TYPE OF IMS SOFTWARE MODULES TO BE USED (DEFAULT = MVS) (E.G. IMSNODE=DEV) QUEUE1 = QUEUE CLASS THE MISCELLANEOUS REPORT IS TO BE SPOOLED UNDER (DEFAULT = '*') (E.G. QUEUE1=A) QUEUE2 = QUEUE CLASS THE MISMATCH REPORT IS TO BE SPOOLED UNDER (DEFAULT = '*') (E.G. QUEUE2=A) QUEUE3 = QUEUE CLASS THE RECEIVABLES REPORT IS TO BE SPOOLED UNDER (DEFAULT = '*') (E.G. QUEUE3=A) QUEUE4 = QUEUE CLASS THE REFUND REPORT IS TO BE SPOOLED UNDER (DEFAULT = '*') (E.G. QUEUE4=A) QUEUE5 = QUEUE CLASS THE UNBILLED CHARGES REPORT IS TO BE SPOOLED UNDER (DEFAULT = '*') (E.G. QUEUE5=A) QUEUE6 = QUEUE CLASS THE UNPAID PRIOR CLASS REPORT IS TO BE SPOOLED UNDER (DEFAULT = '*') (E.G. QUEUE6=A) RUNTYPE = TYPE OF APPLICATION SOFTWARE MODULES TO BE USED (DEFAULT = PROD) (E.G. RUNTYPE=TEST) SRTSIZE = AMOUNT OF DASD STORAGE IN CYLINDERS ALLOCATED TO EACH SORT WORK FILE (DEFAULT = 3) (E.G. SRTSIZE=1) 2.2 INPUT PARAMETERS ---------------- POSITIONS DESCRIPTION --------- --------------------------------------------------- 01 - 06 RUN TERM NAME. (MUST BE 'FALL ', 'SPRING', OR 'SUMMER'.) 07 - 08 RUN TERM YEAR. (MUST BE NUMERIC.) 09 - 09 SEQUENCE OPTION: '1' -- THE 6 REPORTS WILL BE SEQUENCED IN ASCENDING ORDER BY (MAJOR TO MINOR) STUDENT'S NAME, STUDENT'S SSN, AND CLASS-ID. '2' -- THE 6 REPORTS WILL BE SEQUENCED IN ASCENDING ORDER BY (MAJOR TO MINOR) STUDENT'S CAMPUS, STUDENT'S NAME, STUDENT'S SSN, AND CLASS-ID. 10 - 80 NOT USED. 2.3 SORT PARAMETERS --------------- NONE. 3.0 JOB SETUP INSTRUCTIONS ---------------------- NONE. 4.0 FILES ----- 4.1 DATABASE SEGMENTS USED ---------------------- DATABASE SEGMENT TYPE TYPE OF ACCESS -------- ------------ -------------- CCLDBD CCLSMSTR GET CSTDBD CSTUDENT GET CSTREGIS GET CSTACCTD GET CTLDBD CTLCAMPM GET 4.2 ADDITIONAL FILES USED --------------------- NONE. 4.3 INPUT/OUTPUT RECORD LAYOUTS --------------------------- NONE. 5.0 SPECIAL OUTPUT MESSAGES ----------------------- 1. 'NO PARMCARD WAS FOUND IN THE JOBSTREAM.' RE-SUBMIT THE JOB CORRECTLY. 2. 'THE RUN TERM NAME SPECIFIED ON THE PARMCARD IS INVALID.' RE-SUBMIT THE JOB CORRECTLY. 3. 'THE RUN TERM YEAR SPECIFIED ON THE PARMCARD IS NON-NUMERIC.' RE-SUBMIT THE JOB CORRECTLY. 4. 'THE SEQUENCE OPTION SPECIFIED ON THE PARMCARD IS INVALID.' RE-SUBMIT THE JOB CORRECTLY. 5. 'THE CAPACITY OF THE REGISTRATION-TABLE HAS BEEN EXCEEDED.' CONTACT YOUR REGIONAL COORDINATOR. 6. 'ERROR - THE CAPACITY OF THE TRAN-TABLE HAS BEEN EXCEEDED. THE FOLLOWING TRANSACTION DATA WILL BE IGNORED:' '___________________.' CONTACT YOUR REGIONAL COORDINATOR. 7. 'WARNING - SUBPROGRAM UTL560S WAS UNABLE TO CONVERT THE BILL-PAY-DATE VALUE (QUESTION MARKS WERE SUBSTITUTED).' 'NAME = ___________________________.' 'SSN = _________.' 'CLASS-ID = ______________.' CONTACT YOUR REGIONAL COORDINATOR. 8. 'A DL/I CALL WAS UNSUCCESSFUL.' 'PARAGRAPH OR SECTION NAME: ______________________________' 'CALL-COUNT CONTENTS : _____' 'CALL-FUNCTION CONTENTS : ____' 'PCB MASK CONTENTS : __________________________________' CONTACT YOUR REGIONAL COORDINATOR. 6.0 SPECIAL FEATURES ---------------- 6.1 CALLING PROGRAMS ---------------- NONE. 6.2 SUBPROGRAMS CALLED ------------------ UTL560S 6.3 MESSAGE SEGMENT CODES --------------------- NONE. 6.4 ERROR MESSAGES -------------- (REFER TO SECTION 5.0) 7.0 PROGRAM OPTIONS --------------- NONE. 8.0 PROGRAM CHANGE HISTORY ---------------------- 8.1 VERSION NO: V5.04 CHANGE DATE: 09/07/93 PROGRAMMER NAME: EUGENE WALLO PROGRAM CHANGE REQUEST NUMBER: 00012575 DESCRIPTION OF CHANGE: NEW PROGRAM 8.2 VERSION NO: V5.09 CHANGE DATE: 02/16/94 PROGRAMMER NAME: EUGENE WALLO PROGRAM CHANGE REQUEST NUMBER: 00013283 DESCRIPTION OF CHANGE: - CHANGED THE DOCUMENTATION AND PROC TO ACCOMMODATE THE REMOVAL OF OUTPUT-CLASS "J" FROM OUR MVS ENVIRONMENT. - CHANGED THE SOFTWARE TO PROCESS RE-APPLY ('RA') TRANSACTIONS. THEY NOW APPEAR ON THE REPORT (ALONG WITH THE EXISTING 6 TYPES OF TRANSACTIONS), AND ARE BEING PROCESSED THE SAME WAY AS REFUND ('R') TRANSACTIONS IN COMPUTING THE AMOUNT-PAID VARIABLE. - REMOVED TWO FIELDS (MIDDLE INITIAL AND LECTURE-LAB INDICATOR) FROM THE REPORT, TO ALLOW SPACE FOR THE CLASS-START-DATE FIELD. - ADDED THE CLASS-START-DATE FIELD (MONTH AND DAY ONLY) TO THE REPORT. THE CCLSMSTR SEGMENT-TYPE OF THE CCLDBD DATABASE IS NOW PROCESSED. - CHANGED THE SOFTWARE TO GENERATE 6 REPORTS INSTEAD OF ONE. THE 6 REPORTS ARE: 1) MISCELLANEOUS REPORT -- THIS IS A SUBSET OF THE MISMATCH REPORT. 2) MISMATCH REPORT -- THIS CONTAINS THE SAME DATA AS CATEGORY 2 ("BILLING OR OTHER ACTION REQUIRED") OF THE ORIGINAL REPORT. 3) RECEIVABLES REPORT -- THIS CONTAINS THE SAME DATA AS CATEGORY 1 ("AWAITING PAYMENT OF BILLED CHARGES") OF THE ORIGINAL REPORT. 4) REFUND REPORT -- THIS IS A SUBSET OF THE MISMATCH REPORT. 5) UNBILLED CHARGES REPORT -- THIS IS A SUBSET OF THE MISMATCH REPORT. 6) UNPAID PRIOR CLASS REPORT -- THIS IS A SUBSET OF THE MISMATCH REPORT. EACH REPORT IS NOW GENERATED EVEN WHEN THERE ARE NO RECORDS FOR IT (ONLY A "ZERO" TOTALS PAGE). (PREVIOUSLY, A TOTALS PAGE WASN'T GENERATED FOR A REPORT CATEGORY HAVING NO RECORDS.) 4 SETS OF SYMBOLIC PROC PARAMETERS WERE ADDED TO THE SOFTWARE, AND 2 SETS WERE CHANGED. SUBPROGRAM UTL550S IS NO LONGER USED BY THIS PROGRAM. - CHANGED THE SOFTWARE'S TITLE FROM "CEU REGIS/ACCOUNT MISMATCH REPORT" TO "CEU ACCOUNTS RECEIVABLE REPORTS". - CHANGED THE SOFTWARE'S STATUS FROM "PROD" TO "BETA," IN THE SIS INDEX. - CHANGED THE SOFTWARE SO THAT GROUP-INDICATING IS USED FOR THE NAME AND SSN FIELDS OF EACH REPORT. 8.3 VERSION NO: V6.00 CHANGE DATE: 11/14/95 PROGRAMMER NAME: EUGENE WALLO PROGRAM CHANGE REQUEST NUMBER: 00016115 DESCRIPTION OF CHANGE: - RE-COMPILED THE PROGRAM, TO REFERENCE THE LATEST VERSION OF COPYLIB MEMBER 'STUACCTD'. 8.4 VERSION NO: V7.00 CHANGE DATE: 10/21/97 PROGRAMMER NAME: RICHARD GILLETTE PROGRAM CHANGE REQUEST NUMBER: 00016631 DESCRIPTION OF CHANGE: - RE-COMPILED THE PROGRAM, TO REFERENCE THE LATEST VERSION OF COPYLIB MEMBER 'STUACCTD'. 8.5 VERSION NO: V7.02 CHANGE DATE: 10/08/98 PROGRAMMER NAME: SUE TATE PROGRAM CHANGE REQUEST NUMBER: Y2K DESCRIPTION OF CHANGE: - RE-COMPILED WITH NEW COMPILER AND MADE Y2K CHANGES.