12.14. View and Edit Lookup Table Properties
To view lookup table properties from the Find: Lookup Table window:
- Select the table name from the display list.
- Select View Properties from the pop-up menu.
You see the properties window for the selected table.
This window is divided into four tabs: Properties, Relationships, Information and Column Descriptions.
Properties: You see the business properties of the table, such as the table name, table description and table type. Click the Edit button to edit these details.
Relationships: You see a list of the relationships that this table has to businesses and conditions.
Information: You see audit information about the creation and last editing operations.
Column Descriptions: You see a list of the table columns, their values and which column is specified as the Age column. Click the Edit Button to change the column specified as the Age column.
Table Details #
Table Details button
Click the Table Details button at the bottom of the Lookup TablesProperties window to see the table details.
You can also access table details from the Find window by selecting an item from the display list and selecting View Details from the pop-up menu.
Tables in SICS Life #
Tables with Only One Column #
Tables with only one column immediately display the column values.
Tables with More than One Column #
With tables that have more than one column, you see the View Table Values window.
Use the drop-down lists to specify the columns you wish to use as the column (x-axis) and row (y-axis). Specify any remaining criteria using the drop-down lists in the criteria panel and then click Display to display the selected table entries.
Tables in P&C #
The data in the Weight 1 and Weight 2 columns are not persitent on the database and they are calculated on-the-fly when the user presses the Display button.
Editing Lookup Tables #
Imported Lookup tables may not be edited from within SICS. These must be edited outside of SICS and then re-imported. Lookup tables defined within SICS may be edited before they are used.
To edit a user defined lookup table, use the viewing screens to select the table entries that you wish to edit, and click the Edit button on the bottom right of the window. You see an edit window where you can edit the values.
Linking Tables to Businesses #
Linking tables to businesses or conditions is done from a business window, not from the Find: Lookup Table window. When a user has the option to link a table to a business a table linkage form appears on the window.
Click the Edit Menu button and select Find from the pop-up menu. You see the Find: Lookup Tables window where you can do a search for the table you want to link. When you find the right table, select it and select Transfer from the pop-up menu. Or, double-click it to transfer it back to the business window.
You can also view the table values from here. Click the Edit Menu button and select View Table and you see the View Lookup Table window.