Manage Data Lookup Tables screen

The Manage Data Lookup Tables screen displays the data lookup table definitions that have been added to the system. From this screen, click View or Edit to view or edit a data lookup table definition, including its lookup function. Click Add Lookup to add a new data lookup table definition.

You cannot delete or edit a data lookup table that is referenced by an enabled rule.

Create New Lookup screen

Use the Create New Lookup screen to define a new data lookup table definition, which includes the lookup function. Unless marked as optional, all fields require a value.
Field Description
Source Table Data lookup table to query for data. Use the drop-down picker to select the table. After you select a table, PolicyCenter shows the names of the table columns and other information about the table at the bottom of the screen.
Name Name for the lookup function.
Description Optional description of the lookup function.
Table Code Hash code for data lookup table to query. PolicyCenter populates this field automatically.
Existence Boolean check box field with the following meaning:
  • Yes - Checks for the existence of a value in the designated input columns.
  • No - Returns the actual value from the column designated as the output column.
Table columns Use to select the table column or columns to include in the lookup function.

Setting the Existence field

After you select the table to query, you must then set the query Existence field. This field presents a Boolean choice of Yes or No. The following table summarizes the functionality of the Existence field.
Existence Table columns Returns
Yes For existence-type lookup functions. Do not designate an output value. All columns are inputs. Boolean true or false depending on whether values exist in all table columns marked as inputs.
No For non-existence lookup functions. Designate one, and only one, column as an output value. Actual value stored in the table column marked as the output to the query.

Setting the Input and Output columns

After you set the Existence field, you need to determine which table columns you want to be part of the query. PolicyCenter selects all table columns automatically for inclusion in the lookup function by default. To remove a column, select its check box and click Remove Column.

For the remaining table columns, you need to decide whether they are input or output columns, depending on how you set the Existence field.
  • If you set Existence to Yes, you must set all table columns to Input. If you attempt to do otherwise, PolicyCenter displays a validation error.
  • If you set Existence to No, you must set all but one of the table columns to Input. If you do not set one, and only one, table column to Output, PolicyCenter displays a validation error.

You can set a table column to either Input or Output, but not both values simultaneously.