Configure Derivation Functions

You can create a new List Maintenance item and derive specific cases to this item based on case attributes. These attributes are supplied to the system as SQL.

For example:

1. Create a new List Maintenance item called Report Type 1, and derive all the cases with the Report Type attribute defined as Spontaneous, Literature, or Compassionate Use.

   The Report Type 1 appears as an option in the query tool interface corresponding to the Report Type attribute.

2. From the Report Type, select Report Type 1, and execute the query.

   Cases with the Report Type attribute specified as Spontaneous, Literature, or Compassionate Use are returned.

You can specify more than one attribute.

For example, create a further specialized List Maintenance item called Report Type 1 US, and derive all the cases that have the Report Type attribute defined as Spontaneous, Literature, or Compassionate Use, and the Country of Incidence attribute defined as United States.

Note:

There can be situations where two different List Maintenance items you create contain similar attributes in the SQL criteria. In this case, you can assign a priority level to individual List Maintenance items. The priority level determines which List Maintenance item SQL executes first.

For more information, see:

• Open the Derivation Fields Dialog Box
  
• Icons in the Derivation Fields Dialog Box
  
• Field Mapping Derivation Rules
  
• Fields and Check Boxes in the Derivation Fields Dialog Box