Threshold Definition

This page is accessed via Business Process Automation > Agents and Milestones > Threshold. Click the Threshold Definition tab.

Use this page to define the threshold attributes.

Defining Threshold Attributes

1. Select an object attribute from Column.

   Note: Some of the attributes are calculated fields and do not appear on any of the manager screens.

   Note: Calculated fields cannot be used as a threshold comparison. For example, the order release weight thresholds cannot be used since they are a calculated field.

   Note: Agents do not support thresholds with object attributes that are calculated fields such as order release "Total Gross Weight". Many fields which start with "Total" are calculated fields.

2. Selecting a Date attribute displays a series of prompts to enter a time change (day/minute/hour) from the current value. The threshold is triggered by a change of the current date value to any value greater than the current date/time plus the threshold displacement, or any value less than the current value minus the threshold displacement. The modify event would be raised for any change meeting the following definition (current value - displacement) > new value > (current value + displacement). Date columns do not allow for a percentage change, only a delta.
   
   For all other attribute types, the following three controls are presented.
   • a prompt for entering the Numeric Value of the threshold.
   • a list to select the Unit of Measure.
   • a list to select whether to use Percentage change or Delta change.
   Percentage change ignores any unit of measure selected as they will be the same as the underlying value.
   
   Delta is the difference between two values. A delta threshold looks at the difference between the old value and the new value. For example if the old value was 50 and the new value is 40, then the delta is 10.
   
   If you use both a delta and a percentage threshold on the same column, if either threshold fails to be met, the event is called.

   Note: If the units of the threshold are different than the original data value's units, then the threshold value and the current data value is converted to a common unit of measure before comparison.

3. Click Save.
4. After completing a threshold, create a threshold profile for your threshold.
   
   The threshold condition appears as follows:
   • table_name.column_name=Numeric Value Unit of Measure Threshold Type
   • ob_ship_unit.weight=25 TON Delta
   • ob_ship_unit.weight=25 TON %
   • order_release.early_pickup_date=3600 S

     Note: Date thresholds are expressed as the number of seconds representing the day/minute/hour duration.