Life Sciences

How To Configure Constrained Picklists In Siebel

A common requirement in Siebel is to configure constrained picklists. First, let’s define what a constrained pick list means. A constrained picklist is a list of values (LOV), in which the values are dependent on another field.

Say we have an applet that has two fields: medical type and medical product.

These are the values for medical type:

  • Vaccines
  • Medical Devices
  • Drugs

If you choose vaccines, then the values for medical product would be:

  • Hepatitis A
  • Flu
  • Chicken Pox

If you choose drugs, the values for products would be:

  • Aspirin
  • Lipitor
  • Benecol

So, how do you configure picklists? You need to use both Siebel Tools and the Siebel Open UI.

First, you need to create your picklists in Tools:

Life Sciences - How Artificial Intelligence Can Enhance the Clinical Data Review and Cleaning Process
How Artificial Intelligence Can Enhance the Clinical Data Review and Cleaning Process

This guide analyzes how artificial intelligence – including machine learning – can be used by pharmaceutical and medical device companies to improve the clinical data review and cleansing process.

Get the Guide

Next, you need to create the field on the associated business component (BC) with a normal pick map:

Next, you need to create the field for the medical product. Note, that for this field, you have two pick maps – the second is flagged as being the field that constrains this field:

After you add those two fields to the applet you want, you are ready to add the LOV data.

First, you need to create the LOV type:

 

And then the LOV data:

And there you have it!

About the Author

With 20 years of life sciences experience and 10 of working with Siebel, Rene is a Lead Technical consultant @ Perficient. Originally from Montreal, PQ, Rene now resides in Augusta, GA.

More from this Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Subscribe to the Weekly Blog Digest:

Sign Up