ACACTMXVAL

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
AC112 AC113 AC120 AC121 AC123 AC128
AC130 AC145 AC147 AC160 AC165 AC169
AC190 AC191 AC196 AC197 AC198 AC200
AC203 AC206 AC207 AC213 AC218 AC220
AC225 AC240 AC246 AC247 AC256 AC261
AC265 AC290 AC295 AC297 AC298 AC30.3
AC310 AC311 AC32.1 AC346 AC400 AC401
AC410 AC412 AC420 AC421 AC440 AC460
AC471 AC472 AC473 AC480 AC490 AC493
AC494 AC527 AC580 AC583 AC90.1 AC92.1
AC93.1 AC94.1 AC95.1 AC97.1 SE90.1 AP211
ARLL.1 BR120 BR121 BR130 BR131 BR140
BR142 BR145 BR151 BR152 BR153 BR154
BR155 BR156 BR157 BR165 BR19.2 BR190
BR20.9 BR200 BR202 BR204 BR205 BR210
BR212 BR215 BR220 BR245 BR251 BR252
BR253 BR265 BR300 BR400 BR405 BR422
BR430 BR450 BR521 BR530 BR580 GL299
MX123 AC01.1 AC105 AC34.1 AC35.1 AC36.1
AC51.1 AC55.1 ACBA.1 ACDL.1 ACDM.2 ACDM.9
ACVW.1 BR254 SN02.1 SNAC.1


UPDATED BY
AC10.1 AC110 AC13.1 AC13.2 AC135 AC210
AC300 AC500 AC510 AC560 BR10.7 BR10.8
BR51.1 BR51.2 BR52.1 MX202 MX500

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AJV-OBJ-ID
Element: Object ID
Numeric 12
This field is used with activity attributes. Attribute matrix files are keyed by object ID.
AC110 AC13.1
AC13.2 AC135
AC500 AC510
AC560 BR10.8
MX500
AJV-MATRIX-CAT
Element: Attribute
Alpha 12
This is an attribute value assigned to an activity to track additional information. Attribute values can then be used in selection and sorting for reporting and analysis.
AC110 AC13.1
AC13.2 AC135
AC500 AC510
AC560 BR10.8
MX500
AJV-MX-VALUE
Element: Attribute Value
Alpha 32
This is the value assigned to the attribute for the activity.
AC110 AC13.1
AC13.2 AC135
AC500 AC510
AC560 BR10.7
BR10.8 MX500
AJV-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
This field displays the description.


ACACTMXVAL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AJVSET1 OBJ-ID
MATRIX-CAT
...
AC01.1 AC10.1
AC105 AC110
AC112 AC113
AC120 AC121
AC123 AC128
AC13.1 AC13.2
AC13.3 AC130
AC135 AC145
AC147 AC160
AC165 AC169
AC190 AC191
AC196 AC197
AC198 AC200
AC203 AC206
AC207 AC210
AJVSET2 MATRIX-CAT
MX-VALUE
OBJ-ID
KeyChange
...
AC01.1 AC105
AC112 AC113
AC120 AC121
AC123 AC128
AC13.3 AC130
AC135 AC145
AC147 AC160
AC165 AC169
AC190 AC191
AC196 AC197
AC198 AC200
AC203 AC206
AC207 AC210
AC213 AC218
AC220 AC225


ACACTMXVAL FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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


ACACTMXVAL FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Same Value ACACTMXVAL
AJV-MATRIX-CAT->AJV-MATRIX-CAT
AJV-MX-VALUE->AJV-MX-VALUE
  AJV-OBJ-ID


File created: Thu Jun 09 11:03:48 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.