Managed Care

This ERD (see the following figure) illustrates how plan design, formulary, and formulary product are used in Siebel Life Sciences. An account contains plan designs, which have relationships to contacts. Each plan design contains formularies, which are associated with markets that are essentially products. Each formulary contains formulary products, which are child products for the market with which the formulary is associated.

The following table lists the entities in this ERD and their corresponding tables.

Entity	Table
Account	S_ORG_EXT, S_PARTY
Formulary	S_INSPLN_FRMLY
Formulary Product	S_PLNFRMLY_PROD
Health Care Professional	S_CONTACT, S_PARTY
Managed Care Plan	S_INS_PLAN
Plan Design Contact	S_INSPLAN_CON
Product, Market	S_PROD_INT