0.009/21/98 SUE TATE 1.0 PROGRAM NARRATIVE: ACC700 IS A BATCH PROGRAM WHICH READS THREE FRS REPORT FILES AND BUILDS A SEQUENTIAL FILE. THE FILE IS THEN TRANSMITTED TO THE REGION AND ACC410 LOADS THE DATA INTO THE ACB DATA BASE. THE PROGRAM READS THE SUBSIDIARY LEDGER FILE TO OBTAIN THE REVISED BUDGET AMOUNTS AND CREATES A TRANSACTION TYPE OF '0'. THE FRS OPEN COMMITMENT FILE IS READ TO EXTRACT THE ENCUMBRANCES AND CREATE TRANSACTION TYPE '2' RECORDS. THE FRS DAILY TRANSACTION FILE IS READ TO GENERATE TRANSACTION TYPE '3' RECORDS. BUDGET TRANSACTIONS OF '020' THROUGH '029' ARE TYPE '4' RECORDS. THE RECORDS ARE SORTED BY FRS ACCOUNT AND TRANSACTION TYPE. A HEADER RECORD IS BUILT TO SHOW THE DATE THE FILE WAS CREATED, AS WELL AS, A TRAILER RECORD TO GIVE A COUNT OF THE RECORDS IN THE FILE. THE FILE IS BUILT WITH THE DATA FROM ALL LEDGERS AND INCLUDES DETAIL FROM ALL ACCOUNTS. ALTHOUGH A REPORT IS NOT GENERATED, CONTROL TOTALS ARE GIVEN OF THE NUMBER OF BUDGET RECORDS AND BUDGET AMOUNT, NUMBER OF ENCUM- BRANCE RECORDS AND AMOUNT, THE NUMBER OF EXPENDITURE RECORDS AND EXPENDITURE AMOUNT, AND A TOTAL OF ALL TRANSACTIONS. THE FRS FILES THAT ARE ACCESSED ARE THE REPORTING FILES WHICH ARE MIRROR COPIES OF THE PRODUCTION FILES. THE PERSON WHO WILL BE SUBMITTING THIS PROGRAM MUST FIRST OBTAIN ACCESS TO READ THE FILES THROUGH THEIR DP LIASION. 2.0 SAMPLE JCL ---------- 2.1 RUN JCL ______ //CCACC700 JOB (XXXX,YYYY),ACC700, // MSGCLASS=A,MSGLEVEL=(1,1),CLASS=O, // USER=UUUUUUU,PASSWORD=SSSSSSSSS /*ROUTE XEQ HOST /*ROUTE PRINT PPPPPPPP //ACC700 EXEC ACC700, // COLLEGE=CC //ACC700.PARMCARD DD * *** INPUT PARAMETERS *** /* //BDTRECV EXEC PGM=BDTXMIT,COND=EVEN //SYSPRINT DD SYSOUT=* //INTRDR DD SYSOUT=(*,INTRDR) //JCL1 DD DATA,DLM=XX //CCBDTREC JOB (XXXX,YYYY,9,9),BDT,CLASS=F,MSGCLASS=A, // PRTY=3,MSGLEVEL=(1,1) //LOGONID LLLLLLL //PASSWORD DDDDDDDD //ROUTE XEQ PPPP //ROUTE PRINT PPPP //BDTRECV EXEC PGM=BDTRECV //SYSPRINT DD SYSOUT=* //OUTRECV1 DD DSN=CCUSERS.ACCTRAN,DISP=(OLD,KEEP) //INPRECV1 DD * //XX //INP1 DD DSN=&ACCTRAN,DISP=SHR // WHERE (XXXX,YYYY) IS YOUR ACCOUNTING INFORMATION PPPPPPPP IS YOUR OUTPUT DESTINATION CC IS YOUR COLLEGE IDENTIFIER UUUUUUUU IS YOUR HOST USERID SSSSSSSS IS YOUR HOST PASSWORD LLLLLLLL IS YOUR REGION LOGONID DDDDDDDD IS YOUR REGION PASSWORD *** NOTE *** THE JOB SHOULD INCLUDE BULK DATA TRANSFER JCL AS SHOWN ABOVE TO TRANSMIT THE DATA AT THE HOST TO THE REGION. A SEQUENTIAL FILE SHOULD BE ALLOCATED FOR THE TRANS- ACTIONS USING THE FOLLOWING DCB INFORMATION: DCB=(RECFM=FB,LRECL=80,BLKSIZE=8000),UNIT=SYSDA, SPACE=(CYL,(5,5)) SYMBOLIC DESCRIPTION -------------------- REQUIRED RUNTYPE INDICATES WHETHER PRODUCTION LIBRARIES OR TEST ARE BEING ACCESSED. DEFAULT=PROD COLLEGE DENOTES THE TWO CHARACTER COLLEGE ABBREVIATION (EX. COLLEGE=SR) 2.2 INPUT PARAMETERS ---------------- PARMCARD 1: CC CONTENTS -- -------- 01 - 02 FRS COLLEGE CODE (I.E. GG,HH,ETC.) 03 - 04 FISCAL YEAR (I.E. 95) 05 - 80 NOT USED 3.0 JOB SETUP INSTRUCTIONS ---------------------- SPECIAL FORMS QUEUE: STANDARD FOR REPORT(S) FORMS BUFFER: STANDARD FOR REPORT(S) ALIGNMENT INSTRUCIONS: STANDARD PRINTED OUTPUT: FORMS TYPE: 11 X 14 7/8 SPECIAL INSTRUCTIONS: A HEADER CARD MUST BE PREPARED PRIOR TO RUNNING THIS JOB 4.0 FILES: 4.1 DATA BASES USED: NONE 4.2 ADDITIONAL FILES USED: SOADV.FRS.**.CLUSRPT1.FOFILE - FRS OPEN COMMITMENT FILE SOADV.FRS.**.CLUSRPT1.FSFILE - FRS SUBSIDIARY LEDGER FILE SOADV.FRS.**.CLUSRPT1.FTFILE - FRS TRANSACTION FILE WHERE ** DENOTES THE COLLEGE (IE. SR, JT, ETC.) 4.3 OUTPUT FILE LAYOUT: 01 ACT-TRAN-REC. 05 TYPE-RECORD PIC X(1). 05 REQUISITION PIC X(6). 05 FRS-ACCOUNT. 10 FUND-GROUP PIC X(1). 05 FRS-DEPT PIC X(4). 05 FRS-CAMPUS PIC X(1). 05 OBJECT-CODE PIC X(4). 05 PURCHASE-NO PIC X(5). 05 VOUCHER-NO PIC X(5). 05 ENTRY-DATE PIC X(6). 05 STATUS-CODE PIC X(1). 05 DESCRIPTION PIC X(15). 05 AMOUNT PIC S9(7)V99. 05 BATCH-NO PIC X(6). 05 OFFSET-ACCT PIC X(10). 05 FILLER PIC X(6). 5.0 SPECIAL OUTPUT MESSAGES: 5.1 VSAM ABNORMAL TERMINATION MESSAGES AS APPROPRIATE PARMCARD ERROR MESSAGES AS APPROPRIATE 6.0 SPECIAL FEATURES: 5.1 CALLING PROGRAMS: NONE 5.2 SUBPROGRAMS CALLED: N/A 5.3 MESSAGE SEGMENT CODES: N/A 5.4 MISCELLANEOUS FEATURES: N/A 7.0 PROGRAM OPTIONS: N/A 8.0 PROGRAM CHANGE HISTORY: 8.1 VERSION NO. V5.17 CHANGE DATE 10/15/94 PROGRAMMER NAME SUE TATE PROGRAM CHANGE REQUEST NO. 00014668 DESCRIPTION OF CHANGE: NEW PROGRAM 8.2 VERSION NO. V6.01 CHANGE DATE 02/15/96 PROGRAMMER NAME SUE TATE PROGRAM CHANGE REQUEST NO. 00016186 DESCRIPTION OF CHANGE: CHANGED PROGRAM TO INCLUDE BUDGET TRANSFER TRANSACTIONS '020' THROUGH '029' AS TYPE '4' RECORDS. 8.3 VERSION NO. V6.04 CHANGE DATE 06/15/96 PROGRAMMER NAME SUE TATE PROGRAM CHANGE REQUEST NO. 00016943 DESCRIPTION OF CHANGE: CHANGED PROGRAM TO LOAD THE REFERENCE DESCRIPTION INTO THE VOUCHER NUMBER FIELD FOR BUDGET TRANSFERS (4). 8.4 RELEASE VERSION: V7.01 CHANGE DATE: 06/15/98 PROGRAMMER: SUE TATE PROGRAM REQUEST NO: 18004 PROGRAM DESCRIPTION: -CHANGED PROGRAM TO LOAD LOCAL FUND ACCOUNTS. -EXPANDED FILE LAYOUTS FOR Y2K TO MATCH FRS. -ADDED THE OFFSET ACCOUNT TO TRANSACTION FILE.