Lookup Tables

Lookup Tables are used to substitute one value for another by looking at values defined in a table.

Lookup Tables are used in the Production Field Formula Builder to convert a value of some format into a numeric value that can be used in the calculation.

The following table describes the fields on this screen shown below:

Field Description
<list of lookup tables> The list of Lookup Tables defined.

The names are listed in alphabetical order.
Condition Type The data type to be looked up in the input field.

Select a valid value from the drop-down list. By default, the value is set to Integer. Valid values are:

    • Integer - the Condition value must be entered as an integer number.
    • Float - the Condition value can be entered as a decimal number.
    • Duration - the Condition value must be entered as valid duration number, such as 7mo for seven months and 7d for seven days.
    • Date - the Condition value must be entered as date.
    • Text - the Condition value is entered as a text value.

all data in the Condition column of the grid must be entered using this type.

Return value type The format of the data to be returned by the lookup. All data in the Value column of the grid must be entered using this type.

Select a valid value from the drop-down list. By default, the value is set to Integer.

To be implemented in later versions of DTS.
Condition Specifies the list of available values to lookup.

You can enter as many Condition/Value pairs as needed.
Return Value Specifies the value to be returned where the value in a Task field matches the Condition.

By default, the value is set to zero.

If the lookup value is not found, the value returned is zero.

Apply Click to apply your changes
Close Click to apply your changes and close the form
Cancel Click to lose the changes you made and close the screen.
Help Click to display the help for this screen.