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
AC01.1 AC105 AC112 AC113 AC120 AC121
AC123 AC128 AC130 AC145 AC147 AC160
AC165 AC169 AC190 AC191 AC196 AC197
AC198 AC200 AC203 AC206 AC207 AC210
AC213 AC218 AC220 AC225 AC240 AC246
AC247 AC256 AC261 AC265 AC290 AC295
AC297 AC298 AC30.3 AC310 AC311 AC32.1
AC34.1 AC346 AC35.1 AC36.1 AC400 AC401
AC410 AC412 AC420 AC421 AC440 AC460
AC471 AC472 AC473 AC480 AC490 AC493
AC494 AC51.1 AC527 AC55.1 AC580 AC583
AC90.1 AC92.1 AC93.1 AC94.1 AC95.1 AC97.1
ACBA.1 ACDL.1 ACDM.2 ACDM.9 ACVW.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 BR254 BR265 BR300 BR400
BR405 BR422 BR430 BR450 BR51.1 BR51.2
BR52.1 BR521 BR530 BR580 GL299 MX123
MX202 SN02.1 SNAC.1


UPDATED BY
AC10.1 AC110 AC13.1 AC13.2 AC135 AC300
AC500 AC510 AC560 BR10.7 BR10.8 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 02:02:44 2016

Home
Contact Us



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