Siebel Life Sciences Guide > Managing Products for Life Sciences >

How Siebel Life Sciences Stores Product Information

Siebel Life Sciences provides two different tables for storing product information:

• An internal product table (S_PROD_INT)
• An external product table (S_PROD_EXT)

These tables supply data used in various chart views, such as those in the Analysis screen.

About the Internal Product Table

The internal product table (S_PROD_INT) is used primarily for proprietary product data, including products that are detailed or distributed as (pharmaceutical) samples or promotional items by sales representatives. The administrator can categorize products according to product level, therapeutic class, and product type as well as define market categories, such as an antibiotics market. For more information on entering products in the internal product table, see Defining Internal Products.

NOTE:  After you enter a product into the internal product table, you cannot delete it. However, you can prevent it from appearing in drop-down lists and dialog boxes by making it inactive. For more information, see the procedure To make a product inactive.

About the External Product Table

The external product table (S_PROD_EXT) is used for syndicated data from content providers, and for any additional data the administrator chooses to enter about competitive or complementary products. Check with your content provider for information on the product identifiers they use. For more information on loading syndicated data, see Importing Data into Life Sciences.

Products entered in the external product table can also be entered in the internal product table. However, for any product that is entered in both tables, make sure that the product name and other product identifiers match exactly in both tables.

For more information on entering products in the external product table, see Defining External Products.