ACACTMXVAL FILE
Activity List Attribute Values
This file contains activity attributes from AC13.1 (Activity Attributes) and
attribute values from AC13.2 (Values by Activity Attributes). It contains a
record for each activity level, with the level attribute from AC10.1
(Activity). The file includes the activity object ID and the attributes and
values assigned to the activity.
You can define unlimited attributes for the Activity Management system, to be
used in tracking additional information for reporting and analysis. You define
attributes in AC13.1.
REFERENCED BY
AC105 AC112 AC115 AC123 AC130 AC14.1
AC160 AC165 AC170 AC190 AC191 AC196
AC20.1 AC20.2 AC20.3 AC20.4 AC203 AC206
AC207 AC210 AC214 AC215 AC216 AC240
AC265 AC290 AC295 AC297 AC30.2 AC30.3
AC32.1 AC401 AC410 AC412 AC415 AC416
AC420 AC421 AC440 AC450 AC460 AC470
AC471 AC472 AC473 AC480 AC490 AC51.1
AC530 AC55.1 AC79.1 ACBA.1 MX123
UPDATED BY
AC10.1 AC110 AC120 AC13.1 AC13.2 AC300
AC310 AC500 AC510 AC950
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AJV-OBJ-ID Numeric 12 AC10.1 AC110
Object ID This field is used with activity AC120 AC13.1
attributes. Attribute matrix files are AC13.2 AC500
keyed by object ID. AC510 AC950
AJV-MATRIX-CAT Alpha 12 AC10.1 AC110
Attribute This is an attribute value assigned to AC120 AC13.1
an activity to track additional AC13.2 AC500
information. Attribute values can then AC510 AC950
be used in selection and sorting for
reporting and analysis.
AJV-MX-VALUE Alpha 20 AC10.1 AC110
Attribute Value This is the value assigned to the AC120 AC13.1
attribute for the activity. AC13.2 AC500
AC510 AC950
ACACTMXVAL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AJVSET1 OBJ-ID AC10.1 AC105
MATRIX-CAT AC110 AC112
AC115 AC120
AC123 AC13.1
AC13.2 AC13.3
AC130 AC14.1
AC160 AC165
AC170 AC190
AC191 AC196
AC20.1 AC20.2
AC20.3 AC20.4
AC203 AC206
AC207 AC210
AC214 AC215
AC216 AC240
...
AJVSET2 MATRIX-CAT KeyChange AC105 AC110
MX-VALUE AC112 AC115
OBJ-ID AC120 AC123
AC13.3 AC130
AC14.1 AC160
AC165 AC170
AC190 AC191
AC196 AC20.1
AC20.2 AC20.3
AC20.4 AC203
AC206 AC207
AC210 AC214
AC215 AC216
AC240 AC265
AC290 AC295
...
ACACTMXVAL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acactivity ACACTIVITY Required
AJV-OBJ-ID -> ACV-OBJ-ID
Mxcatdef MXCATDEF Required
AJV-MATRIX-CAT -> MXC-MATRIX-CAT
Mxobjcat MXOBJCAT Required
"ACTVY" -> MOC-OBJ-TYPE
AJV-MATRIX-CAT -> MOC-MATRIX-CAT
|