4. CUSTOMIZATION › 4.4 Accounting for Complex-Level External Files › 4.4.5 Entering Cost Center Look Up Table Values

4.4.5 Entering Cost Center Look Up Table Values

The Accounting & Chargeback product provides a facility that
allows you to translate the value of an input variable into
something meaningful for setting COSTCTRs.  For example, your
external input file contains information about NT resource
usage by user IDs and machine name.  You can use the
Accounting & Chargeback feature 'Cost Center Look Up Table'
to associate the user IDs with a group, and the machine names
with a department.

A SAS format is built from the entries you enter in the Cost
Center Look Up Table panel.  You can use this format in the
Cost Center Derivation routine (COSTRTE) documented in
Section 4.1.3 to set the cost center values.

Each external file has a unique format associated with it.
The format name is $ACTUfff, where fff is the last three
characters in the external file name.

Using the previous NT resource file as an example, where the
input data contains the variables MACHINE and USERID, you can
use the Cost Center Look Up facility to assign USERIDs to
groups and MACHINEs to departments.  Assuming COSTCTR1
identifies departments and COSTCTR2 identifies groups, you
can then use the generated SAS format in the cost center
routine as follows:

COSTCTR1=PUT(MACHINE,$ACTUfff);
IF COSTCTR1=MACHINE THEN COSTCTR1='unknown dept';
COSTCTR2=PUT(USERID,$ACTUfff);
IF COSTCTR2=USERID THEN COSTCTR2='unknown group';

where fff is the last three characters of the external file
name.

This facility is optional if you activate CA MICS-provided
interface for NSM Asset Management Option (AMO), NT resource
accounting data (NTA), and CA-IAM.  For your own external
file definition, you must enter the original value
(complex-level external file input record value) and the cost
center value (translated value). You can assign multiple
input values with a cost center value. You can also assign
values for multiple cost centers as discussed above.

The following sections contain a worksheet and example to
help you complete the Cost Center Look Up Table:

 1 - Cost Center Look Up Table Worksheet
 2 - Cost Center Look Up Table Example