Lookup Tables

There are circumstances that arise in which it is useful to group certain data together on a table within IMan.

This can be for translating data, if the target database has no extra space for creating new fields within a record, or for collating data that may be spread across a database or system.

Initial Setup

The lookup tables are configured within the Setup tab.

To get there:

  1. Select the Setup tab from the primary navigation strip.
  2. Choose Lookup Tables from the left-hand panel to open their setup screen.

setup > Lookup Tables > Options

All existing lookup tables appear in this grid. New tables can be created and fields added here.

Lookup Id

The unique Id of the internal lookup table. This value is used to reference the lookup from the Lookup formula.

Description

The description of the lookup table.

Definable Fields

It is possible to add fields with the name and field length defined by the user, by double clicking a row.

Setup > Lookup tables > Security

Attached to each table is a set of permissions as to the jobs associated with the table. When a table is associated with a job, the users with the ‘Maintain Lookups’ permission for the job can maintain the table.

Setup > Lookup Table Maint

The values for the lookups are maintained in the screen.

Lookup Table Drop Down

Select the table from the drop down to display lookup values.

If the user is an administrative user, the drop displays all the tables, otherwise only the tables which are associated with a job, where the user has the Maintain Lookup’ permission are display.

Lookup Key

This is the value which is used to match against.

Lookup Result

This is the result or return value of the lookup. In the screen shot above, if the value ‘0’ were queried, the return value of the lookup is ‘1’

Description

A description or comment to give the lookup value. This may be left blank. It is possible to have the description as a return value of the lookup.

Up to 20 user defined fields can appear after the description. In the above screen-shots, GL Code is a user defined field.