Understanding Lookup Table Requirements

As you create tables to be used by the table lookup utility, consider the following restrictions:

• The names of tables created by using Application Designer have the PS_ prefix. The names of tables not created by using Application Designer must begin with the PA_TL_ prefix.

• The first column must be an effective date field. Although many tables have only one effective date (with new data always being added under the same effective date), the field is still expected.

• The second column name must be TL_SEQ_NUM. This column contains sequencing information for the table and must be a key for the table.

• The next column or columns must contain the lookup basis. One-dimensional lookups use one column for the lookup basis; two-dimensional lookups use two columns for the lookup bases.

• The final column must have the result value.

• All numerics must be set up as decimals.