Previous Topic: 6.5.1.2 Daily Charges Summary ReportNext Topic: 6.5.1.4 Print Application Database Files


6.5.1.3 Audit Report


 
 The Audit Report lists individual charges, the date and time
 they were incurred, and the work unit involved.  Thus, it
 shows the quantity of resources consumed and the associated
 charges at the most detailed level of transactions.  Use the
 Audit Report as a diagnostic and tracking tool when you
 suspect there is a billing error, or to verify the amount of
 credit owed to a user.  There is a complex level and a unit
 level version of the report.
 
 The complex level audit report is a recap of the complex
 level audit file.  This file is created from the 01 cycles of
 the Debit File (ACTSDT) and Credit File (ACTSCT) and contains
 both standard and recurring debit and credit data.  The
 complex level audit file is updated when the INVOICE or
 FINRECAP job is run.
 
 The unit level report is a recap of the daily or monthly unit
 level audit file.  This file is created from the 01 cycles of
 the Accounting journal files.  Optionally, you can create the
 unit level report from one of the journal files.  Figure 6-20
 shows a sample unit level Audit Report created from the Batch
 Job Journal File (ACTJBJ).
 
 The report heading contains the installation name, the Audit
 Report label (for example, Accounting Audit Report for Unit:
 P), and the date on which the report was run.
 
 The first page of the report identifies the source of the
 data.  That is, the input file(s).  For a complex level
 report, this is the complex level audit file.  For a unit
 level report, this is the daily or monthly unit level audit
 file or a journal file.
 
 The report contains the following information:
 
     COST CENTER VALUE--The Cost Center identifier.
 
     WORKUNIT VALUE--The work unit (job, user, etc.).
 
     WORKAREA--The contents of the work area field of the
     Audit File record (for example, job group requested and
     received for batch jobs).
 
     BILLSTAT--The billing status.  B=Bill, N=No Bill.
 
     FILE--The original source of the data.  On the complex
     level audit report the FILE names are:
 
       EXT--External File
       SDT--Debit File
       SCT--Credit File
 
     On the unit level audit report the FILE names are the
     journal file identifiers.  For example, JBJ--Batch Job
     Journal File.
 
     SYSID--The system identifier.
 
     RUN or END TIMESTAMP--The RUN time stamp from the audit
     file indicating when the audit file was updated with the
     record, or, if the report was run from a journal file,
     the END time stamp from the journal file.  All records
     added to the audit file by a single DAILY or external
     file update job will have exactly the same run time stamp
     value.  Manually entered debits and credits will have run
     time stamps based on the entry date and time.
 
     BILLING TIMESTAMP--The date and time the transaction was
     billed.  The source of the billing time stamp differs
     depending on the record.  It is user-defined on the
     Journal File Eligibility panel.  By default, if the
     record is from the Batch Job Journal File, the source is
     RDRTS.  For other journal files, it is ENDTS.  If the
     record is from the Debit or Credit file, the billing time
     stamp is entered manually.
 
     YEAR/MONTH/DAY--The CA MICS date that the transaction
     occurred.  This is based on the ENDTS of the original
     data record.  For reports run from a journal file, this
     is the date of the record in the journal file.
 
     AYEAR/AMONTH/ADAY--The accounting date that the
     transaction occurred.
 
     INVC CTGY--The user-assigned invoice category, which
     identifies the resource consumed.
 
     COMP CODE--The computation code, which was assigned via
     the Algorithm Specification panel and the Rate Table
     parameter, and identifies the charging element used to
     measure the usage.
 
     QUANTITY--The measured quantity of the charging element.
 
     RATE--The rate at which the charging element was billed.
 
     CHARGE--The amount the user was charged.
 
 The report also shows a total charge by SYSID and a grand
 total for all charges contained in the report.
 
 Because the report is so long, you should not run it on a
 daily basis unless you need to track a particular item daily.
 If you need a full report, run it on microfiche rather than
 paper.
 
 
 RUNNING THE REPORT
 
 Run the complex level or unit level Audit Report by following
 the directions in Section 5.4, Producing Audit Reports.  You
 can select the complex or unit level report from the Audit
 Reports menu (MWF;4;2;4;5;1;4).
 
 You can also run a smaller report by specifying keyword
 values to limit the number of transactions included in the
 report.
 
 The necessary control cards must be read in via a //SELECTIN
 DD statement that is contained in the AUDITRPT member in
 sharedprefix.MICS.CNTL (complex level) or prefix.MICS.CNTL
 (unit level).  Each control card must have a keyword
 beginning in column one followed by the qualifying values,
 each separated by a space.  The keywords and the maximum
 number of possible qualifying values that can be read into
 the program are as follows:
 
         Keyword           Maximum Number of Occurrences
         -------           -----------------------------
         COSTCTR1-9        25
         COMPCODE          99
         INVCCAT           99
         SYSID             25
         BILLDATE          25
         FROMDATE          1
         TODATE            1
         RUNTS             25
         FRRUNTS           1
         TORUNTS           1
         RUNDT             25
         FRRUNDT           1
         TORUNDT           1
         WORKAREA          25
         W1AREA            25
         W2AREA            25
         WORKUNIT          25
         ZONE              9
 
 Keyword Notes:
 
 o At the complex level, use the WORKAREA keyword to specify
   values from the Reason field of the Debits and Credits Data
   Entry panel.
 
 o Use the BILLDATE keyword to specify values from the BILLTS
   field.
 
 o BILLDATE, FROMDATE, and TODATE are read in with a DATE9.
   format.  The following is a control card example for
   BILLDATE:
 
   BILLDATE 12SEP2002
 
 o Use BILLDATE to specify up to 25 Billing Time Stamps to
   include in the report.  Use FROMDATE to include any date
   later than or equal to the specified date.  Use TODATE to
   include any date prior to or equal to the specified date.
   Use FROMDATE and TODATE together to specify a range of
   dates to include in the report.
 
 o RUNDT, FRRUNDT, and TORUNDT are read in with a DATE9.
   format.  The following is a control card example for RUNDT:
 
   RUNDT 12SEP2002
 
 o Use RUNDT to specify up to 25 Run Date Time Stamps to
   include in the report.  Use FRRUNDT to include any date
   later than or equal to the specified date.  Use TORUNDT to
   include any date prior to or equal to the specified date.
   Use FRRUNDT and TORUNDT together to specify a range of
   dates to include in the report.
 
 o RUNTS is read in with a DATETIME21.2 format.  The following
   is a control card example for RUNTS:
 
   01SEP2002:01:19:08.17
 
 o Use RUNTS to specify up to 25 Run Time Stamps to include in
   the report (date is ignored).  Use FRRUNTS to specify the
   earliest time to include in the report.  Use TORUNTS to
   specify the latest time to include in the report.  Use
   FRRUNTS and TORUNTS together to specify a time range to
   include in the report.
 
 o W1AREA selects on bytes 1-8 of the WORKAREA field.
 
 o W2AREA selects on bytes 9-16 of the WORKAREA field.
 
 o Values containing embedded blanks can be read by coding the
   keyword followed immediately by an '=' and the value.  For
   example, a control card to select COSTCTR1 values of 'AAA
   BBB' (three embedded blanks) would be coded as follows:
 
   COSTCTR1=AAA   BBB
 

                                                  Y O U R  C O M P A N Y  N A M E           17:07 WEDNESDAY, DECEMBER 1, 2002   1                                                 ACCOUNTING AUDIT REPORT FOR UNIT: P   THE FOLLOWING INPUT FILE(S) WERE USED FOR THIS REPORT: ------------------------------------------------------ DETAIL.ACTJBJ01 ---------------------------------------------------------------------------------------------------------------------------------                                                   Y O U R  C O M P A N Y  N A M E           17:07 WEDNESDAY, DECEMBER 1, 2002   2                                                 ACCOUNTING AUDIT REPORT FOR UNIT: P                                                                             INVC COMP COST CENTER VALUE(S)          WORKUNIT VALUE                              CTGY CODE      QUANTITY         RATE             CHARGE --------------------------------------------------------------------------------------------------------------------------------- AS                            CJ1LH60                                     1100 0023        3.0600      $0.2200            $0.6700 C                               WORKAREA/BILLSTAT:      199@TSO    /B TSO                                    FILE/SYSID: JBJ/S008 000-000                             END TIMESTAMP: 01SEP2002:01:19:08.17 J                               BILLING TIMESTAMP: 31AUG2002:21:47:27.10 CJ1LH60                            YEAR/MONTH/DAY: 02/09/01                                 AYEAR/AMONTH/ADAY: 02/09/01 --------------------------------------------------------------------------------------------------------------------------------- SUB TOTAL                                                                                                                 $0.6700                               MINIMUM                                     9400 JMIN                    $2.0000            $2.0000                               ZONE DIFF                                   9500 ZDIF                    $3.0000            $3.0000                               SURCHARGE                                   9600 SURC                    $4.0000            $4.0000                               PRIORITY                                    9700 PRIX                    $5.0000            $5.0000 --------------------------------------------------------------------------------------------------------------------------------- SUB TOTAL                                                                                                                $14.0000 --------------------------------------------------------------------------------------------------------------------------------- TOTAL FOR RECORD        1:                                                                                               $14.6700                                                                                                               ===================

 
 Figure 6-20.  Unit Level Audit Report