1. User Guide
  2. Business Rules Administration
  3. Application Specific Rules
  4. Lookup Table
  5. Navigation in the Detail Screen

5.3.6.1 Navigation in the Detail Screen

When you Add, Edit or View a Lookup Table rule, the Lookup Table Detail screen is displayed.

In addition to Name, Description, Folder and Access Type, the definition of a Lookup Table includes the specification of a source table and defining the lookup table columns.

Specify the Lookup Table rule's Name and Description, select a Folder in which the Lookup Table rule is to be stored, and specify whether you want the Lookup Table rule to be “Read/Write” or “Read Only” (Access Type). Naming your Lookup Table rule is required before you save it. The default values for Folder and Access Type are stored in User Preferences.

Figure 5-76 Lookup Table Details Pane


Specify the Lookup Table rule's Name and Description, select a Folder in which the Lookup Table rule is to be stored, and specify whether you want the Lookup Table rule to be “Read/Write” or “Read Only” (Access Type).

Lookup Table Source Selection Pane

Select a Source table to create your Lookup Table. The source table list is limited to the instrument tables available under PBSMCS. The Source column dropdown lists all the columns available in the selected source table, except the VARCHAR domain type columns.

Click on the ‘Add to Grid’ button to include the selected column into the grid.

Figure 5-77 Lookup Table Source Selection Pane


The source table list is limited to the instrument tables available under PBSMCS. The Source column dropdown lists all tables available in the selected source table, but limited to the column domain types of BALANCE, RATE, NUMBER, NUMERIC, PCT, DATE, CHAR, FLAG, LEAF and CODE.