1. User Guide
  2. Business Rules Administration
  3. Application Specific Rules
  4. Lookup Table

5.3.6 Lookup Table

Lookup Tables are user-defined database tables that are created to hold user data to match Instrument level measures or attributes and thereby deduce a return factor.

The user data is generally matched conditionally with the similar columns of a PBSMCS instrument table and a user specified value is returned that is stored under the return columns of the Lookup table.

A Lookup table by itself is a non executing component of the Profitability application. It is rendered meaning when used inside an allocation rule with the help of a Lookup Table Driver.

To open the summary page, from the LHS menu, select Maintenance, and then select Lookup Table. A summary screen is displayed showing a set of Lookup Table rules. Using search criteria, you can control the set of rules displayed. When you Add, Edit, or View a rule, it displays a detailed screen.

Figure 5-75 Lookup Table - Summary page


Summary screen is displayed showing a set of Lookup Table rules.

The Lookup Table summary screen has two panes: Search and Lookup Table summary table.

The title bar of the summary page provides several actions for the user. They are:

  • Add: Click the Add icon to build a new Lookup Table. The Add icon is disabled if any rows in the table are selected.
  • Multiple Delete: Select one or more drivers in the table and then click the Multiple Delete icon at the top right of the summary page to delete more than one rule at the same time.
  • Export: Click Export to download the displayed information in the summary table in .xls format.
  • Refresh: Click the Refresh icon to refresh the summary page.
  • Help: Click the Help icon to view the Lookup Table help.

Searching for a Lookup Table Rule

To search the Lookup Tables, follow these steps:

  1. Click the Search icon on the search pane to collapse (display) the criteria window.
  2. Enter the Lookup Table Name or Description and click Search to display the Lookup Tables that match the criteria.
  3. Click Cancel to remove the filter criteria on the search window and refresh the window.

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.

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.
  • Folder: Displays the folder in which the driver rule has been created.
  • Tags: Displays the tags associated with the rule.
  • 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 – ‘Creation in Progress’, ‘Table Created’, ‘Failed’ and ‘Deletion in Progress’.
  • Action: Displays the following 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:

    1. If status is ‘Creation in Progress’, allowed action is only View.
    2. If status is ‘Table Created’, allowed actions are View, Save As, Delete, Check Dependencies and Table Data.
    3. If status is ‘Failed’, allowed actions are View and Delete.
    4. If status is ‘Deletion in Progress’, allowed action is only View.

    The ‘Creation 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 following actions are available for the Lookup Table rule.

    • View: Click the View icon to open the created table in view mode. View is enabled for table status in (Creation in Progress, Table Created, Deletion in Progress, Failed).
    • Save As: Click on this 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.

      Delete is enabled for table status in (Table Created, Failed).

      For Failed state tables, Delete will delete the row from Summary.

      Once Delete is clicked, the status of the table becomes 'Deletion in Progress' and once delete operation is successfully completed (meaning, the table is dropped successfully from the database), the corresponding lookup table row is deleted from the Summary grid.

      If deletion operation fails due to any reason, the table appears in the Summary but now with status='Failed'.

    • Check Dependencies: This action button is to check for any dependency of the selected object with other objects in the application. Check Dependencies is enabled for table status only in (Table Created).
    • Table Data: Click Table Data to invoke the Lookup Table Data screen to view, add or delete the data residing in the lookup table. This is enabled for table status only in (Table Created).

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.