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

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

CalculationType

Specifies the calculation type of this field. The available options will be different depending on type of reporting point.

Options:

• None - If the field does not perform a calculation, set the CalculationType property to None.

• Accumulator - An Accumulator field keeps a tally of the accumulated total, but it does not supply a value to the reporting point until the reporting point triggers. An example of an accumulator field is one having a tag that counts the number of items that the plant produces. AVEVA™ Production Management does not capture the actual value of the tag; it captures the difference between the current value of the tag and the value of the tag when the last record was captured.

• Run Time - Total run time. Measures the time an equipment was running for the duration of the record. For example, if you use the Running status tag as the expression and capture the maintenance every 15 minutes, it will show how many seconds the expression was True during that 15 minutes. When you use this option, the data type must be Integer.

• Count - Counts the number of records. When you use this option, the data type must be Integer.

None, Accumulator, Run Time, Count

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 data type for the field. This is an important value for storing and aggregating data correctly.

If it is a numeric data type, you can optionally specify the Minimum and Maximum values under the Details Display category.

The data type is required information, however, sometimes can be supplied by the SourceField.

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.

If the data type is String, set the String-related properties that determine text entry properties.

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

StringType

This property appears when DataType is set to String. It specifies the formatting type of the string data.

Options:

• PlainText - This option enables the user to enter plain text only.

• HyperLink - This option enables user to enter a linked Internet address.

For String Type, set the MaximumEditLength and VisibleRows properties under the Details Display category.

PlainText, HyperLink

DisplayFormat

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

For each different numeric data type there is a default format; for example, 0.######.

For more information, see Configure the Display Format property for fields.

0.######

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 a historical expression that defines the raw field value.

Any valid expression

RefreshOnManualEntry

Specifies whether the expression is recalculated for the manual entry. Set the CaptureValueForManualRecords property to True for this property to be effective.

True, False

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