0.008/16/98 DIANE LIVELY 1.0 PROGRAM NARRATIVE ----------------- THIS PROGRAM PRINTS A DETAILED LISTING OF ENCUMBRANCES AND EXPENDITURES FOR EACH FRS BUDGET ITEM. THE PROGRAM COMPUTES THE TOTAL BUDGET AMOUNT, TOTAL ENCUMBRANCES, TOTAL EXPENDITURES, AND THE BALANCE FOR EACH OBJECT CODE, OBJECT CODE SERIES (XX00-XX99), FRS ACCOUNT, COST CENTER, AND FOR THE COLLEGE. BUDGET TRANSFERS ARE ALSO SHOWN ON THE REPORT. THESE TRANSACTIONS ARE NOT COUNTED IN THE TOTALS. THEY ARE LISTED ON THE REPORT WITH 'BUDGET TRANSFER' AS THE VENDOR AND THE AMOUNT SHOWN WHERE THE BUDGET AMOUNT WOULD NORMALLY APPEAR. NOTE: THIS PROGRAM IS THE FRS VERSION OF ACC910, AND CAN ONLY BE RUN FOR BUDGET YEARS 9394 OR AFTER. THE BUDGET SEGMENTS AND TRANSACTION SEGMENTS ARE READ FOR THE BUDGET YEAR SPECIFIED ON THE PARMCARD. THE RECORDS ARE SORTED BY COST CENTER, FRS ACCOUNT CODE (FUND GROUP, DEPARTMENT, CAMPUS), OBJECT CODE, TYPE OF RECORD (BUDGET, ENCUMBRANCE, EXPENDITURE, OR BUDGET TRANSFER) AND THE TRANSACTION DATE. OTHER FIELDS SHOWN INCLUDE TRANSACTION DESCRIPTION, BATCH NUMBER, PURCHASE ORDER NUMBER, VOUCHER NUMBER, AND STATUS CODE. THIS REPORT CAN BE PRINTED FOR ALL COST CENTERS OR ONE SELECTED COST CENTER. THERE IS AN OPTION TO INCLUDE ONLY ONE FUND GROUP OR ALL. THERE IS ALSO AN OPTION ON WHETHER TO INCLUDE PERSONAL SERVICES (OBJECT CODE LESS THAN 1200). THE COLLEGE NAME IS OBTAINED FROM THE BUDGET CAMPUS SEGMENT IN THE CONTROL DATA BASE (CAMPUS 1). THE OBJECT CODE MASTER IS READ FOR THE OBJECT CODE DESCRIPTION. THE FRS DEPARTMENT/CAMPUS MASTER IS READ FOR THE FRS DEPARTMENT NAME. THE COST CENTER MASTER IS READ FOR THE COST CENTER NAME AND MANAGER'S NAME. THE CONTROL OPTION SEGMENT FOR THE BUDGET YEAR IS READ TO OBTAIN THE DATE THE DATA BASE WAS LAST UPDATED BY ACC410. 2.0 SAMPLE JCL: ---------- 2.1 RUN JCL ------- //XXACC610 JOB (WWWW,XXXX,9,29),ACC610, // MSGCLASS=A,CLASS=F,PRTY=3 /*ROUTE PRINT YYYYYYYY //ACC610 EXEC ACC610, // AGENCY=DDD, // COLLEGE=DD, // COPIES=1, // DBTYPE=PROD, // FORM=A000, // QUEUE='*', // RUNTYPE=PROD, // SRTSIZE=3 //ACC610.PARMCARD DD * ----SEE INPUT CARD BELOW---- /* // SYMBOLIC DESCRIPTION ******************** REQUIRED - AGENCY COLLEGE AGENCY CODE NUMBER (E.G. AGENCY=283) COLLEGE TWO CHARACTER COLLEGE NAME ABBREVIATION (E.G. COLLEGE=SR) OPTIONAL - COPIES THE NUMBER OF COPIES OF OUTPUT DEFAULT: 1 (E.G. COPIES=3) DBTYPE INDICATES WHETHER TO USE TEST OR PRODUCTION DATA BASES DEFAULT: PROD (E.G. DBTYPE=TEST) FORM FORM NUMBER THE REPORT IS TO BE STORED UNDER DEFAULT: A000 (E.G. FORM=0001) QUEUE QUEUE CLASS THE OUTPUT IS TO BE SPOOLED UNDER DEFAULT: * (E.G. QUEUE=A) RUNTYPE INDICATES WHETHER TO USE TEST OR PRODUCTION FILES DEFAULT: PROD (E.G. RUNTYPE=TEST) SRTSIZE AMOUNT OF DASD STORAGE IN CYLINDERS ALLOCATED TO EACH SORT WORK FILE DEFAULT: 3 (E.G. SRTSIZE=4) 2.2 INPUT PARAMETERS ---------------- WWWW - PROGRAMMER NUMBER XXXX - ROOM NUMBER YYYYYYYY - PRINTER INPUT CARD CC DESCRIPTION -- ----------- 1 - 4 BUDGET YEAR (I.E. 9394; MUST BE 9394 OR AFTER) 5 - 5 SELECTED COST CAMPUS (BLANK FOR ALL) 6 - 7 SELECTED COST CENTER (BLANK FOR ALL) 8 FUND GROUP CODE ('@' OR SPACE FOR ALL) 9 INCLUDE PERSONAL SERVICES (OBJECT CODES < 1200) 'Y' OR 'N' (DEFAULT = 'N') 3.0 JOB SETUP INSTRUCTIONS: ---------------------- SPECIAL FORMS QUEUE: STANDARD FORMS BUFFER: STANDARD ALIGNMENT INSTRUCTIONS: STANDARD PRINTED OUTPUT: FRS ENC/EXP REPORT BY COST CENTER FORMS TYPE: 11 X 14 7/8 SPECIAL INSTRUCTIONS: A PARMCARD MUST BE PREPARED PRIOR TO RUNNING THIS JOB. 4.0 FILES: ----- 4.1 DATA BASE SEGMENTS USED CONTROL DATA BASE 1. CTLBCAMP (READ ONLY) 2. CTLFDEPT (READ ONLY) 3. CTLCSTCR (READ ONLY) 4. CTLOBJCT (READ ONLY) 5. CTLPROPT (READ ONLY) ACCOUNTING DATA BASE 1. ACBBUDGT (READ ONLY) 2. ACBTRANS (READ ONLY) 4.2 ADDITIONAL FILES USED: NONE 4.3 INPUT/OUTPUT RECORD LAYOUTS: N/A 5.0 SPECIAL OUTPUT MESSAGES ----------------------- 5.1 *** FATAL ERROR - ACC610 NO PARM RECORD *** FATAL ERROR - ACC610 5.2 *** FATAL ERROR - ACC610 BUDGET YEAR ON PARMCARD IS INVALID *** FATAL ERROR - ACC610 MEANING: THE BUDGET YEAR ON THE PARMCARD IS NOT NUMERIC OR THE ENDING YEAR SUBTRACTED BY THE BEGINNING YEAR DOES NOT EQUAL +1. 5.3 *** FATAL ERROR - ACC610 BUDGET YEAR MUST BE 9394 OR AFTER FOR FRS *** FATAL ERROR - ACC610 MEANING: THE BUDGET YEAR ON THE PARMCARD IS LESS THAN 9394. USE ACC910 FOR BUDGET YEARS PRIOR TO FRS. 5.4 *** FATAL ERROR - ACC610 COST CENTER ON PARMCARD IS INVALID *** FATAL ERROR - ACC610 MEANING: THE COST CENTER ON THE PARMCARD WAS NOT FOUND IN THE COST CENTER MASTER FILE. 5.5 *** FATAL ERROR - ACC610 INVALID FUND GROUP CODE ON PARMCARD *** FATAL ERROR - ACC610 MEANING - MUST BE SPACES OR '@' FOR ALL, OR ELSE NUMERIC. 5.6 *** FATAL ERROR - ACC610 INVALID OPTION TO INCLUDE PERSONAL SERVICES *** FATAL ERROR - ACC610 MEANING - MUST BE 'Y' TO INCLUDE OR 'N' OR SPACE TO EXCLUDE. 5.7 PROGRAM OPTION SEGMENT NOT FOUND MEANING: WHEN THE PROGRAM OPTION SEGMENT IS FOUND, THE "AS OF" DATE APPEARS IN THE HEADING. THERE SHOULD BE A PROGRAM OPTION SEGMENT FOR EVERY BUDGET YEAR ON THE DATA BASE. 6.0 SPECIAL FEATURES ---------------- 6.1 CALLING PROGRAMS: NONE 6.2 SUBPROGRAMS CALLED: UTL100S 6.3 MESSAGE SEGMENT CODES: NONE 7.0 PROGRAM OPTIONS: ---------------- ACCS00 XX - WHERE XX EQUALS LAST TWO DIGITS OF THE BUDGET YEAR. POSITION NAME VALUE DESCRIPTION 1 STATUS P BUDGET YEAR IS PAST C BUDGET YEAR IS CURRENT F BUDGET YEAR IS FUTURE 2 N/A 3-10 DATE XX/XX/XX DATE ACC410 LAST UPDATED THE DATA 8.0 PROGRAM CHANGE HISTORY: ----------------------- 8.1 VERSION NO: V5.17 CHANGE DATE: 10/15/94 PROGRAMMER NAME: DIANE LIVELY PROGRAM CHANGE REQUEST NO: 14676 DESCRIPTION OF CHANGE: FRS VERSION OF ACC910. 8.2 VERSION NO: V6.01 CHANGE DATE: 02/15/96 PROGRAMMER NAME: DIANE LIVELY PROGRAM CHANGE REQUEST NO: 16470 DESCRIPTION OF CHANGE: CHANGED PROGRAM TO HANDLE A RECORD TYPE OF 4 (BUDGET TRANSFER) AS NOT COUNTED IN ANY TOTALS BUT SHOWN ON THE REPORT. 8.3 VERSION NO: V7.00 CHANGE DATE: 11/16/97 PROGRAMMER NAME: DIANE LIVELY PROGRAM CHANGE REQUEST NO: 00017868 DESCRIPTION OF CHANGE: ADDED A SUBTOTAL BY THE FIRST TWO TWO DIGITS OF THE OBJECT CODE (XX00-99). 8.4 VERSION NO: V7.02 CHANGE DATE: 08/16/98 PROGRAMMER NAME: DIANE LIVELY PROGRAM CHANGE REQUEST NO: 00018006 DESCRIPTION OF CHANGE: ADDED AN OPTION TO RUN BY CAMPUS. ADDED OFFSET-ACCOUNT TO THE REPORT. CHANGED PROGRAM FOR THE NEW COMPILER AND YEAR-2000. ADDED SUBTOTAL FOR PERSONAL SERVICES AND THE REST.