Lookups supply many of the list of values in Oracle HRMS and lookup values are the valid entries that appear in the list of values. They make choosing information quick and easy, and they ensure that users enter only valid data into Oracle HRMS.

Some Lookup Types have been predefined. You only need to define values for these types.

To create a new lookup type, add values to an existing lookup type, or prevent existing values from appearing in a lookup type, use the Application Utilities Lookups window.

Defining Lookup Types

You can create your own lookup types to provide lists of values, for example to validate element entries.

   To define a new lookup type and lookup values:

1. Choose the access level for the lookup type.

2. Enter the lookup type.

3. Enter the user name of the lookup. This is the name that users will see from within the application.

   Note: For US Federal users: Do not prefix EIT definitions with GHR_US. This prefix is reserved for the predelivered US Federal definitions.

4. Select the application in which the lookup will be used.

5. Optionally, add a description of the lookup type.

6. If you want to add lookup values specific to the security group/business group linked to your current responsibility, un-check the Global Security Group check box. Existing lookup values are available to all business groups.

   Attention: The Global Security Group check box only displays if you are using Security Group Enabled Security with a non-default security group. If you use Standard HRMS security, or the default (Standard) security group in Security Group Enabled Security, all lookup types are global.

   See: Categorizing Information By Security Groups

7. Enter the code, meaning and optionally a description for each value. Leave the Tag column blank.

   If you do not enter a start date, the new lookup is valid immediately. If you do not enter an end date, the new lookup is valid indefinitely.

8. Save your work.

Defining Lookup Values

   To add lookup values to an existing lookup type:

1. Query the lookup type to which you want to add a value.

   You cannot add values if the access level is System.

2. If you want to add lookup values specific to the security group/business group linked to your current responsibility, un-check the Global Security Group check box. Existing lookup values are available to all business groups.

   Attention: The Global Security Group check box only displays if you are using Security Group Enabled Security with a non-default security group. If you use Standard HRMS security, or the default (Standard) security group in Security Group Enabled Security, all lookup types are global.

3. Enter the code, meaning and optionally a description for each value. Leave the Tag column blank.

   Caution: Do not change or remove any legislation codes that are shown in the Tag column for existing lookup values. This may have implications elsewhere in your HRMS system.

   If you do not enter a start date, the new lookup is valid immediately. If you do not enter an end date, the new lookup is valid indefinitely.

4. Save your work.