4. CUSTOMIZATION › 4.1 Defining Cost Centers › 4.1.2 Modifying the Cost Center Structure
4.1.2 Modifying the Cost Center Structure
When you change the number of cost center levels or the
length or description of a cost center level, you must modify
the cost center structure.
Run the ACTCGEN job in sharedprefix.MICS.CNTL after changing
the cost center structure. This job generates the ACTACCT
and ACTCLEN macros in sharedprefix.MICS.MACAUTOS. The macros
contain SAS LABEL, LENGTH, and KEEP information. If you
change the number of cost center levels or decrease the
length of a cost center level, you must also retrofit the
month-to-date and year-to-date Ledger Files and the TABLES
Files.
STEPS TO MODIFY THE COST CENTER STRUCTURE
Follow the checklist below to modify the cost center
structure:
__ 1. Suspend operation of CA MICS Accounting and
Chargeback in each database unit in which it is
installed. Mark the Checkpoint File in each unit
"non-updatable" by setting B=900 to B=999 in the
first record of each unit's prefix.MICS.CHECKPT.DATA.
__ 2. Select Option 1, Cost Center Definition, on the
Parameter Specifications menu.
Select Option 1, Cost Center Structure, on the Cost
Center Definition Menu. This places you in ISPF Edit
of sharedprefix.MICS.PARMS(COSTCTR). Modify the
definition as required.
__ 3. Submit the job ACTCGEN in sharedprefix.MICS.CNTL. If
you have changed the cost center structure, you are
automatically asked to submit this job when you END
from the Cost Center Definition Menu.
You can also submit this job from TSO as follows:
SUB 'sharedprefix.MICS.CNTL(ACTCGEN)'
NOTE: The online panels will not recognize the new
cost center structure until the ACTCGEN
completes. If you are in the Workstation
Facility (MWF), you must exit and re-enter MWF.
__ 4. If you need to change the contents of any cost center
level, follow the checklist in Section 4.1.4,
Modifying Cost Center Values.
__ 5. Run the unit level MAGRUN job from TSO for units that
have accounting installed:
SUB 'prefix.MICS.CNTL(MAGRUN)'
__ 6. If you changed the number of cost center levels or
decreased the length of a cost center level, you must
retrofit the files listed below. The files must be
retrofitted even if they do NOT contain observations,
because the SAS file directory has the length values.
MONTHS - ACTLGRnn
YEARS - ACTLGRnn
TABLES - ACTRCPnn
ACTSCTnn
ACTSDTnn
ACTBGTnn
ACTCCAnn
ACTCNVnn
ACT_YRnn
ACTHOLD
ACT_RCnn
ACT_SCnn
ACT_YTnn
ACT_YTH
NOTES: It is not necessary to retrofit the journal
files and DAYS Ledger Files. They will be
aged and deleted in normal processing.
ACTHOLD and ACT_YTH have the same format as
the Year-to-Date Financial Recap File
(ACT_YR). They are used to hold the current
versions of the Year-to-Date Financial Recap
File (ACT_YR) and the Multi-Site Year-to-Date
Financial Recap File (ACT_YT).
a. Back up the files before and after the retrofit.
b. Before attempting to retrofit any of the files,
refer to Sections 6.3.2 and 6.3.3 of the System
Modification Guide for information on
retrofitting files.
c. Develop the retrofit code for the online
database. Be aware of the following potential
dangers:
o Specify the length of the new or changed cost
center levels with either a LENGTH statement
or an assignment statement with the correct
length. The standard CA MICS macro
'%xxxLEN(TS=sss)' gives the generated length
statements, where xxx is the file identifier.
o If the values in the cost centers change, be
sure to add the sort.
Sample code to retrofit the month-to-date Ledger
File follows:
DATA WORK.ACTLGR00 (KEEP=%LGRKEEP(TS=MONTHS));
%LGRLEN(TS=MONTHS);
%LGRLBL;
SET &ACTM..ACTLGR00;
... add retrofit code here ...
RUN;
PROC SORT DATA=WORK.ACTLGR00 OUT=&ACTM..ACTLGR00;
BY %LGRSEQ(TS=MONTHS);
RUN;
NOTE: You should test the retrofit logic on one
file and print a PROC CONTENTS of the
resulting file to ensure the correct
placement and size of the cost center
fields by using the following coding:
PROC CONTENTS DATA=&ACTM..ACTLGR00;
For the TABLES files the TS option is
APPL. For example, the ACTSDT00 file
retrofit code would use a %SDTLEN(TS=APPL)
macro to reset the lengths in the file.
d. Run the job(s) to retrofit all of the online
databases that you constructed in step c.
__ 7. Run the following jobs IN THE ORDER THEY ARE LISTED
to recreate the ISPF tables. The jobs are located in
sharedprefix.MICS.CNTL.
ACTBGTL0
ACTBGTL1
ACTCCALD
ACTADJLD*
* You must run ACTADJLD twice, once for cycle 00 and
once for cycle 01. After running the job the first
time, edit the job and change the SYSPARM from
"CYCLE=00" to "CYCLE=01". Then run the job again.
__ 8. If you use cost center validation tables, review them
using the Cost Center Validation Tables option
(MWF;4;2;3;1;4) and change them, if necessary. If
you make a change to the validation tables, you will
be prompted to run the ACTXCCC job in
sharedprefix.MICS.CNTL.
__ 9. If you decreased the number of cost center levels,
you must delete the validation tables for the levels
you are no longer using. Delete the member ACTCCn,
in sharedprefix.MICS.ISPTLIB, where "n" is the cost
center level 1-9.
__ 10. If you changed the length of your COSTCTR1 level,
review any COSTCTR1 values used in Rate Table
Algorithm Qualification (MWF;4;2;3;6;4) and in any
COSTCTR1 qualification groups (MWF;4;2;3;9).
__ 11. Review the number of levels of invoice reporting in
the Accounting Options panel. Review the Rate Table,
External File definition, Prorating, and
Qualification Group definitions for any references to
specific cost centers that need to be changed.
__ 12. Resume normal processing in each database unit in
which CA MICS Accounting and Chargeback is installed.
Mark the Checkpoint File in each database unit
"updatable" by resetting B=999 to B=900 in the first
record of the prefix.MICS.CHECKPT.DATA file in each
unit.
__ 13. If you changed the number of cost center levels,
optionally, reprint Appendix B, the Data Dictionary.
Each file's Sequence/Summary Data Element list will
have the updated COSTCTRn data elements.