Database structure for IWS rules – lookup table

For basic functionality, IWS rules need no database objects. Database tables are used only when IWS rule do value lookup in processing element CHANGE. In this case tws rule use data from database table rules_lookup.

Structure of table rules_lookup

column name	data type	description
Id_lookup	Varchar	Id of lookup, specified in XMLIWS rule in attribute ID_LOOKUP in element
Column1	Varchar	1st column with lookup values
Column2	Varchar	2nd column with lookup values

The lookup table data are managed using command line utility tws_rules_lut.cmd that is located in bin directory of your PMN installation. This utility is able to import, delete and show lookup data values

Lookup table values are used to replace values by matching against a list of values. Other possible use of lookup table outside the tws rules in customizing lists in pickers for various fields in edit dialog for tws application.