4. CUSTOMIZATION › 4.15 Defining and Submitting Utility Jobs
4.15 Defining and Submitting Utility Jobs
With CA MICS Accounting and Chargeback, you can enter certain
types of data online using the ISPF dialogs and tables
provided. These data types include debits, credits, budgets,
cost center attributes, cost center groups, external file
cost center lookup tables, cost center validation tables,
charge element tables, and prorating tables.
If you have any of this data available in your own files, you
may prefer to enter the data in batch instead of online,
using your files as input. You can do this with the Define
Utility Jobs and Submit Utility Jobs options.
CA MICS Accounting and Chargeback provides the following
standard utilities. In addition, you can create your own.
ADJ Debit and Credits
BGT Budgets
CCA Cost Center Attributes
CCG Cost Center Groups
CCL External File Cost Center Lookup Table
CC1 Cost Center 1 Validation Table
(through)
CC9 Cost Center 9 Validation Table
PRO Prorating Table
ELM Charge Element Table
THE ADJ UTILITY
The ADJ utility replaces all debits and credits in the online
table and the Debit and Credit Files. It uses the macro
%ACTJADJO to do this. This macro is invoked and documented
in sharedprefix.MICS.SOURCE(ACTJADJO) and passed three
arguments:
FUNCTION=REPLACE to indicate that the entire contents of
the table are replaced rather than
updated.
DBCR=BOTH to indicate that both debits and credits
are to be entered.
ENTRY=BOTH to indicate that both standard and
recurring entries are to be made.
THE CCG UTILITY
The CCG utility only updates the ISPF table cost center
groups that are contained in your specified input data set.
No other groups are changed and the ISPF table is not
replaced.
If you have validation tables for the cost center groups that
you are updating, the values in your input data set are
validated using the validation tables.
THE ELM UTILITY
The ELM utility is used to update charge element ISPF table
with comma-separated value(CSV) input file. This utility
allows users to add new user-defined computation codes in CSV
file format.
STEPS TO DEFINE AND SUBMIT A CHARGE ELEMENT UTILITY JOB
__ 1. Select the Define Utility Jobs panel (Option 3 on the
Special Requirements Menu--MWF;4;2;S;3).
o Select Job ID ELM 'CHARGE ELEMENT UPDATE TABLE' on
the Utility Selection panel.
o Select Option 1 on the Options Menu to define Charge
element utility by specifying the name of the CSV
file.
The input variables to read the input CSV file should
be in this order.
ElMCCODE - Computation Code
ELMICAT - Invoice Category
ELMXTRN - Complex-Level External File Element
(YES or NO)
ELMFILE - component file ID
ELMNAME - Element Name
ELMUNIT - Units Description
ELMDESC - Text describing the charging element
The input record layout is documented in
sharedprefix.MICS.SOURCE(ACTJELMI).
o Run the ACTUTILG job to generate the utility job(s)
that you defined to sharedprefix.MICS.CNTL.
__ 2. The charge element utility job will process the CSV
file using the DSD (Delimiter-Sensitive Data)
parameter on the INFILE statement. This parameter
automatically sets the default delimiter to comma,
although the DLM(delimiter) can be overridden as a
single character or as a hexidecimal value. Another
common delimiter is the tab that is denoted by
dlm='09'x. When a space character is used for the
delimiter, enclose the fields in quotes. To override
the delimiter character, update the DLM value in
sharedprefix.MICS.CNTL(ACTJELMO) under the DDname
SYSIN.
o Submit the generated utility jobs called ACTJELMO,
using the Submit Utility Jobs panel (Option 4 on the
Special Requirements Menu, MWF;4;2;S;4).
OR
Submit sharedprefix.MICS.CNTL(ACTJELMO).
The utility job does the following:
o Reads the specified input CSV file using the
ACTJELMI input routine.
o Replaces the contents of the charge element ISPF
table and corresponding SAS files or PROC FORMATS.
STEPS TO CREATE A UTILITY JOB
If you need to replace just debits or credits, or just
standard or recurring entries, or if you want to add entries
to the ISPF table rather than replace it, you can make your
own utility and use the %ACTJADJO macro in your output
routine.
__ 1. Select Option 3, Define Utility Jobs, on the Special
Requirements Menu (MWF;4;2;S;3).
o Use the I line command to insert a new utility ID.
__ 2. Select Option 1 on the Options Menu and specify your
input data set name on the Utility Control
Specification panel.
o Enter ACTXADJ for the generation source member name.
If you do not enter ACTXADJ, your utility will not
generate the debit and credit SAS files in the
TABLES database.
__ 3. Select Option 2 on the Options Menu and code your input
routine. You can copy an example from
sharedprefix.MICS.SOURCE(ACTJADJI).
__ 4. Select Option 3 on the Options Menu and copy your
output routine from sharedprefix.MICS.SOURCE(ACTJADJO).
Modify the %ACTJADJO macro to specify what you want to
do.
For example, if you want to replace all standard credit
entries you would code:
%ACTJADJO(FUNCTION=REPLACE,DBCR=C,ENTRY=S);
If you want to add standard and recurring debit entries
you would code:
%ACTJADJO(FUNCTION=UPDATE,DBCR=D,ENTRY=BOTH);
WARNING! You can only invoke this macro once per
utility because it will read your entire input file.
__ 5. END from Utilities and submit the ACTUTILG job to
generate your utility when prompted.
The following sections describe the parameters and SAS code
that you need to define the utility jobs.
1 - Specifying Utility Job Control Characteristics
2 - Defining the Utility Job Input Routine
3 - Defining the Utility Job Processing Routine
