Adding a Lookup Table

Complete these steps to add a Lookup table:

Note: Once a table is created, the schema cannot be modified.

1. Go to RESOURCES > Lookup Table.

2. In the left panel, click on +.

3. In the Create a New Lookup Table window, from the Organization drop-down list, select the Organization that the Lookup table belongs to.

4. In the Table Name field, enter the name of the Lookup table.

5. (Optional) In the Description field, enter any additional information about the Lookup table.

6. In the Schema section, take the following actions.

   1. If adding a key to your Lookup table, select the Key checkbox, otherwise, if unselected, it becomes a column.
      

   2. In the Name field, enter a name for the key or the column.

   3. In the Type drop-down list, select the value type from LONG (for integers), STRING (character strings), or DOUBLE (for real numbers).

   4. Click + to add another Key value, and repeat steps a-c.
      

      Note: A maximum of 5 Key values may be created for a Lookup table.
      

   5. When done, click Save.