ACMXVAL FILE

                       AC Trans Attribute Values

This file contains information on activity transaction attribute values.
These values are used in determining billing rates.

REFERENCED BY

AC190     AC256     AC290     AC54.1

UPDATED BY

AC300     AC310     AC40.1    AC41.1    AC42.1    AC45.1
AC530     AC540     AC70.3    AC70.4    GL146     GL190
GL199     GL45.1    IFGT.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

ATV-OBJ-ID           Numeric 12                                  AC40.1  AC41.1
Object Identifier    Required key. This is the identifier of     AC42.1  AC530
                     the object for the attribute.               AC540   AC70.3
                                                                 AC70.4  GL146
                                                                 GL190   GL199
                                                                 GL45.1  IFGT.1

ATV-MATRIX-CAT       Alpha 12                                    AC40.1  AC41.1
Matrix Category      Required key. An attribute is a name        AC42.1  AC530
                     assigned to an object (for example, job     AC540   AC70.3
                     code in Payroll) to track additional        AC70.4  GL199
                     information. Attribute values can then      IFGT.1
                     be linked to transactions for reporting
                     and analysis.

ATV-MX-VALUE         Alpha 20                                    AC40.1  AC41.1
Matrix Value         This is the value of the object for the     AC42.1  AC530
                     attribute.                                  AC540   AC70.3
                                                                 AC70.4  GL199
                                                                 IFGT.1

                         ACMXVAL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ATVSET1   OBJ-ID                                                 AC190   AC256
          MATRIX-CAT                                             AC290   AC300
                                                                 AC310   AC40.1
                                                                 AC41.1  AC42.1
                                                                 AC45.1  AC530
                                                                 AC54.1  AC540
                                                                 AC70.3  GL146
                                                                 GL190   GL45.1

ATVSET2   MATRIX-CAT                                             AC256
          MX-VALUE
          OBJ-ID*

                         ACMXVAL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Mxcatdef       MXCATDEF     Required

                            ATV-MATRIX-CAT    -> MXC-MATRIX-CAT

Mxobjcat       MXOBJCAT     Required

                            "ACTRN"           -> MOC-OBJ-TYPE
                            ATV-MATRIX-CAT    -> MOC-MATRIX-CAT