ACT 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.
micsrm140cd
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 the Assigning Cost Center Values section 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
MICS
-provided interface for NSM Asset Management Option (AMO) or NT resource accounting data (NTA). 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 subsections contain a worksheet and example to help you complete the Cost Center Look Up Table:
Cost Center Look Up Table Worksheet
+----------------------------------------------------------------------------------------------------------+ | | | Date: ____/____/____ Administrator: ____________________________________________ | +----------------------------------------------------------------------------------------------------------+ COST CENTER LOOK UP TABLE WORKSHEET Original Value Cost Center Value --------- ----------------- ______________________ _________________________________ ______________________ _________________________________ ______________________ _________________________________ ______________________ _________________________________ ______________________ _________________________________ ______________________ _________________________________ ______________________ _________________________________ ______________________ _________________________________ ______________________ _________________________________ _______________________________________________________________________________________________________________
Use the Cost Center Look Up Table Worksheet to define the following parameters:
Original Value
Description: A predetermined set of values that come in from the external file records. Every external file might have a different set of values based on a specific variable in the external file.
Default: None
Values: Character, length 24
Note:
This value typically represents the contents of account field in the input record. You have the ability to translate the input value to a different value with this feature.
Cost Center Value
Description: The COSTCTR value(s) in which the charges associated with the original value will be recorded.
Default: None
Values: Character, length 30
Note:
A single new value can be specified for a single original value. However, both the original value and cost center value can consist of multiple variables that you can parse in your SAS coding in the Cost Center Derivation (COSTRTE) routine.
Cost Center Look Up Table Example
In the following Cost Center Look Up Table Example, charges in the external file from NSM NT resource Accounting can use both the MACHINE and USERID variables values to determine COSTCTR variable values.
_____________________________________________________________ +-----------------------------------------------------------+ | Date: __/__/__ Administrator: _________ | +-----------------------------------------------------------+ Original Value Cost Center Value machineIDval1_______ DEPT1_______________ machineIDval2_______ DEPT2_______________ userIDval1__________ GROUP1______________ userIDval2__________ GROUP2______________ ____________________ ____________________ _____________________________________________________________