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
AC200 ACVW.1 AP211 GL299 MX123 SN02.1
SNAC.1


UPDATED BY
AC10.1 MX500 AC210 MX202

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.
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.
MX500
AJV-MX-VALUE
Element: Attribute Value
Alpha 32
This is the value assigned to the attribute for the activity.
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
AC10.1 AC200
AC210 ACVW.1
AP211 GL299
MX123 MX202
MX500 SN02.1
SNAC.1
AJVSET2 MATRIX-CAT
MX-VALUE
OBJ-ID
KeyChange
AC200 AC210
ACVW.1 AP211
GL299 MX123
MX202 MX500
SN02.1 SNAC.1


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: Wed Jun 08 20:46:53 2016

Home
Contact Us



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