The Custom Lookup Tables screen allows you to view existing custom lookup tables. If you need to create new ones, use this procedure to access the screen, and then see Adding Custom Lookup Tables.
1.In the Designer window, in the Go to drop-down list, select Lookup Tables. 2.Click the Custom tab. The Custom Lookup Tables screen appears.
3.Select the appropriate user-defined lookup table in the Show items belonging to drop-down list. 4.Select the appropriate node in the in node drop-down list, if necessary. A list of items available for the selected lookup table or its selected node appears below the drop-down lists.
|
The following table describes the items in the custom lookup tables screen.
Field or button
|
Description
|
New lookup table name
|
Important: Use this field only if you want to create a lookup table.
Enter a name for a new custom lookup table.
Maximum length is 50 alphanumeric characters. However, Data Warehouse only supports a maximum of 35 characters.
|
Unique Code
|
Important: Use this field only if you want to create a lookup table.
Enter a four-character alphanumeric code that is unique across all custom lookup tables.
Note: You can enter the unique code in uppercase or lowercase, however, in the database, it is saved in uppercase.
|
Add Table
|
Click to add the new table to the custom lookup tables listed in the Show items belonging to drop-down list.
|
Show items belonging to
|
Select the custom lookup table where you want to view, add, edit, or delete items.
|
in node
|
Select the node (hierarchy level), if necessary, to locate the appropriate item or items.
|
Delete Table
|
Click to delete the selected table in the Show items belonging to drop-down list. See Deleting Custom Lookup Tables.
|
Item Name
|
Enter a name for the option as it should be displayed in the field.
Maximum length is 50 alphanumeric characters.
|
Order
|
Enter an integer, indicating the Order for the item in the list. The items with the same Order are sorted alphabetically and displayed accordingly.
Tip: It may be helpful to enter orders in increments of five. If you ever have to add more options, you will have some leeway as to where in the list you can place the additional items.
|
Tree Position
|
Enter a four-character alphanumeric combination that uniquely identifies the lookup item within the node in which you are adding it.
Note: You can enter the tree position in uppercase or lowercase, however, in the database, it is saved in uppercase.
|
Is Active
|
•YES—The lookup table item is active •NO—The lookup table item is inactive and cannot be selected by end users. For more details, see Inactivating Custom Lookup Table Items. |
Lookup Item List
|
Displays a list of lookup items in the selected node of the table.
Select or clear the corresponding check-boxes on the left to delete or edit lookup items.
|
|
