4. CUSTOMIZATION › 4.4 Accounting for Complex-Level External Files

4.4 Accounting for Complex-Level External Files

CA MICS Accounting and Chargeback supports input from data
sources other than CA MICS products (for example, TMS and
ASM2) using external files:

- At the complex level, through a system of additional debit
  entries.  CA MICS-supplied, or user-written, routines
  create records in the 00 cycle of the Debit File. These
  records are included in the Financial Recap File and on the
  invoice.

- At the unit level, by creating a CA MICS unit and
  installing only CA MICS Accounting and Chargeback (this is
  an "external file unit") and creating external journal
  files.  The external journal files are processed just like
  standard journal files, except there is no associated
  CA MICS DAILY processing to create the journal file.
  Instead, you submit the MAGRUN to generate an update job
  for each external file and then submit the update job to
  create the associated journal file and update the ledger
  file.  Refer to Section 4.3 for information about
  specifying options for external journal files.


ACCOUNTING FOR COMPLEX-LEVEL EXTERNAL FILES

The standard CA MICS-supplied routines require you to
periodically run operational jobs to add records to the
ACTSDT file.  You must define parameters for each of your
external data sources.  The operational jobs are created
based on your parameter definitions.  If you define more than
one charging algorithm for an external file, you must use
algorithm qualification to specify the external file records
to which each algorithm applies.

You specify rates for external file charging at the complex
level in the External File Rate Table.  Code will be
generated to compute the charges and add the records to the
Debit File.  Since the file's input format is not known to
CA MICS Accounting and Chargeback, the code invokes a
user-coded macro to input the data.  Any number of external
files can be supported.


STEPS TO ACCOUNT FOR COMPLEX-LEVEL EXTERNAL FILES

The external file parameters are defined using Option 1,
External File Specifications, on the External File
Definition - File Options menu (MWF;4;2;3;7;1).

Based on the parameters you specify, the external file
parameter generation job, EXTFILE in sharedprefix.MICS.CNTL,
generates the following items:


      #ACTXfff--in sharedprefix.MICS.SOURCE. One module is
                generated for each external file that you
                have selected (where fff is the external file
                ID).  Each module contains SAS code to
                compute the charges for the external file.
                This member refers to the ACTUfffI macro to
                read the file, and contains source code to
                assign computation codes and rates and
                compute charges.  The generation also creates
                a member ACTfffTB in sharedprefix.MICS.CNTL
                for each external file.  ACTfffTB contains
                the JCL used to actually perform the external
                file charging.  It includes the INPUTACT DD
                that defines the file.

      $ACTBaaa--in sharedprefix.MICS.MCOLIB. One format is
                generated for each external file control
                variable charging algorithm (where aaa is the
                algorithm ID).  Each format relates a control
                variable name and value to a computation
                code, rate, and rate effective date.

      $ACTAaaa--in sharedprefix.MICS.MCOLIB. One format is
                generated for each algorithm (where aaa is
                the algorithm ID).  Each format relates a
                computation code to a rate and rate effective
                date.

      $ACTUfff--in sharedprefix.MICS.MCOLIB. One format can
                be generated for each external file (where
                fff is last three positions of filename).
                The format relates the original value to the
                new cost center values that were entered on
                the Cost Center Look Up Table panel.

      ACTfffTB--in sharedprefix.MICS.CNTL. One job is
                generated for each external file that you
                have selected (where fff is the external file
                ID).  Each job inputs the external file and
                outputs charges to the Debit File using the
                code in the #ACTXfff module (where fff is the
                external file ID).  Run the ACTfffTB jobs at
                the end of each billing period by selecting
                Option 1, Complex-Level External Files, from
                the External File Update menu.  You can run
                this job multiple times but it must be run
                prior running the CLOSETBL job.

You can review the external file update jobs after the
generation process is done by selecting option 1,
Complex-Level External Files, from the External File Update
menu (MWF;4;2;2;1;1).

At the end of the month, submit the ACTfffTB job (where fff
is the last three characters of the external file name) for
each file from the sharedprefix.MICS.CNTL library
(MWF;4;2;2;1;1).

The following sections guide you through the process of
accounting for complex-level external files.

 1 - Specifying Complex-Level Ext. File Characteristics
 2 - Defining the Complex-Level Ext. File Input Routine
 3 - Specifying and Qualifying External File Algorithms
 4 - Defining a Complex-Level External File Exit
 5 - Entering Cost Center Look Up Table Values
 6 - CA MICS AMO Extract (MICSAMO)