Configure Behavior properties

Action

Defines whether this field stores a value with each record or whether it retrieves a value from the Calendar when the record is accessed by AVEVA™ Production Management.

For more information, see Lookup Calendar.

If the Action property is set to LookupCalendar, specify the ItemName in the Calendar

If the Action property is set to Store, specify the calculation and capture values

Store, LookupCalendar

CalendarItem

The ItemName in the Calendar table. AVEVA™ Production Management retrieves the item value based on the ItemName and ActiveDateTime pair.

This property is available only when the Action property is LookupCalendar.

Example

ItemName [ActiveDateTime, Item Value]

ItemName [ActiveDateTime, Item Value]

This directs AVEVA™ Production Management to lookup the value of ItemValue associated with specified ItemName in the dbo.Calendar table, based on ActiveDateTime.

ItemName in the dbo.Calendar table of project data SQL database

CaptureValueForManualRecords

Specifies whether the field uses the expression result as the default value in manual records.

True, False

DataAvailabilityType

Specifies whether the data is immediately available or is late arriving.

Immediate or LateBound

DataType

The work order table field inherits its data type from the external work order table field. You would not usually change this setting.

The correct data type is critical to the ability of Production Analyst to display and aggregate information in fields.

For more information, see Configure the Data Type property for fields.

Boolean, Date, Double, Integer, Long, Single, String

DisplayFormat

This value specifies the formatting of numeric data types: Double, Integer, Long, and Single.

For Specifier detailed information, see DisplayFormat property specifier details.

FieldType

Specifies the type of field as an ID field or Other. When this value is set to ID, the FieldIDType property appears.

A field that has the DataType property set to String and the FieldType property set to ID is available for Grouping by in charts and reports.

For more information, see Configure the Field Type property for fields.

ID, Other

FieldIDType

This property appears when FieldType is set to ID. Specifies the type of ID field used in grouping data in the charts.

For more information, see Configure the Field ID Type property for fields.

ProductID, LotID, EquipmentID, Other

Filterable

Specifies whether the field is filterable in the Production Analyst data results.

True, False

HasBudget

Indicates whether the field has a budget associated with it. If the field should have a budget value, select True. A budget sub-item appears beneath the field.

True, False

HasTarget

Indicates whether the field has a target associated with it. If the field should have a target value, select True. A target sub-item appears beneath the field.

True, False

HasTrendDirection

Indicates whether the field has a trend direction associated with it. If the field should have an additional trend direction field, select True.

A trend direction sub-item appears beneath the field to specify properties of the trend direction field.

An additional Trend Direction field appears next to the custom field in the Results grid. An arrow indicates the trend over time based on the last 5 rows. The method of calculation is simple linear regression.

True, False

HistorialFieldExpression

Specifies the value or source of value to be stored.

Click Browse (...) to open the Expression Editor. Use the Expression Editor to build an an expression that defines what calculated the field makes.

Any valid expression

RefreshValueOnCapture

Specifies whether the value of an expression is refreshed when the field is captured, rather than only when the expression subscription triggers are activated.

In many cases, this value is set to True to enable accurate capture of the last recent value.

True, False

Units

Any string value to use as the units in the display. Used for display purposes in AVEVA™ Production Management.

Any string value