Managing Picklists

Objective

After completing this lesson, you will be able to create and populate picklists.

Managing Picklists

Creating and Populating Picklists

The next step in configuring Global Benefits is to create and populate the picklists that will be used throughout the application. A picklist is a list of values that make up the selections in dropdown lists. For example, a field called Country can contain a picklist with the values USA, Germany, Brazil, and so on.

Picklists are managed using the Picklist Center.

Picklists for Different Benefit Types

Some benefit types, such as pensions and insurance, have required picklists that must be created before the benefit can be configured. The following tables show the required picklists for common benefit types. Keep in mind that the picklist names are case sensitive.

Picklists relevant for all benefit types:

Picklist Name(external code)Example Values
BenefitContactTypeHR Admin, Payroll Admin
paymentModeCheck, Cash, Bank Transfer, Payroll

Pension relevant picklists:

Picklist Name(external code)Example Values
relationShipTypeMother, Father, Spouse

Insurance relevant picklists:

Picklist Name(external code)Example Values
benefitInsuranceDependentOptionSelf, Self + Spouse, Self + Family
benefitInsuranceCoverageLevelOne Bed, Two Bed
insurancetypeLife/Term, Medical, Dental, Vision
relationShipTypeMother, Father, Spouse
MaritalStatusMarried, Single

Create Picklists

In this exercise, you will create several picklists that will be used to create benefits. You will also edit the Insurance Type picklist to add the DENTAL entry.

Steps

  1. Use the Admin Search to open the Picklist Center.

  2. Add the DENTAL entry to the Insurance Type picklist.

    Values for the Picklist Insurance Type

    Picklist ValueField Values
    Dental

    External Code: DENTAL

    Label: Dental

    Status: Active

    1. Use the Search field to search for the picklist insuranceType.

    2. Select the hyperlink to open the picklist.

    3. Select the currently active picklist.

    4. Select "Add New Value (+)".

    5. Enter the details given in the table.

    6. Select Create.

  3. Create a picklist to contain the payment modes that will be used for the benefits payouts with the following details:

    FieldValue
    CodepaymentMode
    NamePayment Mode
    Effective Start DateJan 1, 1990
    StatusActive
    1. Use the Action Search and navigate to the Picklist Center tool.

    2. Select (+) to create a new picklist.

    3. Enter the values given in the table above.

    4. Select Save. The Picklist Values screen will appear.

  4. Add the following values to the picklist:

    Picklist ValueField Values
    Bank Transfer

    External Code: banktransfer

    Label: Bank Transfer

    Status: Active

    Non-Unique External Code: Bank Transfer

    Check

    External Code: check

    Label: Check

    Status: Active

    Non-Unique External Code: Check

    Cash

    External Code: cash

    Label: Cash

    Status: Active

    Non-Unique External Code: Cash

    Payroll

    External Code: payroll

    Label: Payroll

    Status: Active

    Non-Unique External Code: Payroll

    1. Select (+).

    2. Enter the values given for picklist value Bank Transfer.

    3. Select Create.

    4. Repeat the steps a-c, to add the values for Check, Cash and Payroll to the picklist.

  5. Create a picklist called relationShipType with the values Spouse and Child.

    Picklist ValueField Values
    Spouse

    External Code: SPOUSE

    Label: Spouse

    Status: Active

    Child

    External Code: CHILD

    Label: Child

    Status: Active

    1. Select (+).

    2. Enter the values given in the table above.

    3. Select Save. The picklist screen will appear.

  6. Create a picklist called benefitInsuranceDependentOption with the value "EMPLOYEE".

    Picklist ValueField Values
    Employee

    External Code: EMPLOYEE

    Label: Employee

    Status: Active

    1. Select (+).

    2. Enter the values given in the table above.

    3. Select Save. The picklist screen will appear.

Summary

  • Picklists encompass the values used in dropdown lists.

  • Picklist values vary depending on the type of benefits.

  • Picklists are managed using the Picklist Center.