Siebel Life Sciences Guide > Managing MedEd Events >

Establishing Funds for MedEd Plans


A MedEd plan is a database record in which you specify common funding for a group of MedEd events that share a common objective. Each MedEd event can be funded by up to one MedEd plan for each event team member who is responsible for each event. Using the MedEd Activities view, you can track costs associated with each event. Because these events are automatically aggregated by plan, you can compare actual expenditures with MedEd plans across sales divisions.

Figure 8 shows the possible relationships between MedEd funds, master plans, subplans, events, sessions, activities, and invitees.

Figure 8.  Relationships Between Funds, Plans, Events, Sessions, Activities, and Invitees
Click for full size image

To establish a fund and associate it with a MedEd plan, you must:

  • Define an active period for the fund. Define an active period that can be assigned to a fund. For more information on defining periods, see Applications Administration Guide.
  • Establish the fund. Establish the fund by loading fund information into the database using Siebel Enterprise Integration Manager (EIM). To perform this task, you must consult Siebel Enterprise Integration Manager Administration Guide to determine which columns are included in the database table EIM_MDF and how those columns map to the columns in the base table S_MDF. Then, use a standard SQL utility to place information about the fund you are establishing in the EIM_MDF table.

    NOTE:  If you want the fund to be active immediately, make sure that the current date falls between the start date and end date that you specify for the fund.

    For more information on using EIM, see Siebel Enterprise Integration Manager Administration Guide.

  • Verify fund availability. Verify that the fund has been successfully established and is available for association with a MedEd plan. For more information, see the procedure To verify that a fund is available for association with a MedEd plan.

To verify that a fund is available for association with a MedEd plan

  1. Navigate to the Data Administration screen > MedEd Planning view.
  2. In the Plans list, select a plan.
  3. In the Plan Administration form, click the select button in the Funds field.

    All active funds listed in the S_MDF table appear.

  4. Verify the fund you want is available and then close the dialog box.
Siebel Life Sciences Guide Copyright © 2007, Oracle. All rights reserved.