1. User Guide
  2. Business Rules Administration
  3. Lookup Table
  4. Summary and Detail Screens
  5. Navigation in Summary Screen
  6. Lookup Table Summary Table

3.12.1.1.2 Lookup Table Summary Table

This section presents a table containing all of the Lookup Tables that meet your search criteria. The table displays the details of the already created Lookup Tables.

Figure 3-75 Lookup Table Summary Table


The Lookup Table Summary Table displays the details of the existing Lookup Tables.

The Lookup Table Summary Table displays the following details:

  • Name: Displays the Lookup Table’s short name. Hovering over an Lookup Table name displays the Lookup Table’s object code and the object ID.
  • Description: Displays the Lookup Table’s long name.
  • Folder: Displays the folder in which the driver rule has been created.
  • Tags: Displays the tags.
  • Created By: Displays the name of the user who created the Lookup Table rule.
  • Creation Date: Displays the date and time at which an Lookup Table rule was created.
  • Modified By: Displays the name of the user who last modified the Lookup Table rule.
  • Modification Date: Displays the date and time at which an Lookup Table rule was last modified.
  • Access Type: Displays the “Read/Write” or “Read Only” property of an Lookup Table rule. Only the creator of a rule may change its Access Type.
  • Status: Displays the status of the Lookup table. The values that are possible as status are – ‘Draft’, ‘In Progress’, ‘Table Created’ and ‘Failed’.
  • Action: Displays the list of actions that can be performed on the Lookup Table rule.

The Action column in the Lookup Table Summary table offers the following actions based on the status of the lookup table:

  • Draft status - allowed actions: View, Edit, Save As, Delete, Create.
  • In Progress status - allowed actions: View.
  • Table Created status - allowed actions: View, Table Data.
  • Failed status - allowed actions: View, Edit, Save As, Delete, Create.

Draft status is derived when the user clicks on the ‘Save as Draft’ button from the Detail screen and this creates only the UI template of the lookup table while the actual database table is not created. The Edit, Save As, Delete, Create actions are applicable only for Lookup UI template before the database table is created.

While in the Draft status, the user can click on Create action available in the Summary table for the selected lookup table resulting in change of the status of the lookup table to In Progress.

The In Progress status results into either a Table Created status or a Failed status, based on whether the physical lookup table creation in the database is successful or failed, respectively.

The Table Created status is derived either through a resulting status after the ‘In Progress’ status or when the user clicks on the ‘Create’ button from the Detail screen. Create option creates the actual database lookup table from the UI template.

Once the database table is created, the actions of Edit, Save As, Delete are not allowed and the user can only View the created lookup table.

The following actions are available for the Lookup Table rule.

  • View: Click the View icon to view the contents of a Lookup Table rule on a read-only basis as the user is launched into the Lookup Table Detail screen in view mode.
  • Edit: Click the Edit icon to modify a previously saved Lookup Table as the user is launched into the Lookup Table Detail screen in edit mode.
  • Save As: Click the Save As option to create a copy of an existing Lookup Table rule. The Save As pop-up window allows you to enter the Name, Description, Folder, and Access Type Details for the copy Lookup Table rule.
  • Delete: Click Delete to delete the Lookup Table rules you have selected.
  • Create: Click Create to create the physical Lookup Table from the Draft status of the Lookup Table rule you have selected.
  • Table Data: Click Table Data to invoke the Lookup Table Data screen to view, add or delete lookup table data.

You may select or de-select all of the Lookup Table rules in the summary table by clicking on the check box in the upper left-hand corner of the summary table directly to the left of the Name column header.