Configure Derivation Functions

Oracle Argus Insight lets you 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, you can create a new List Maintenance item called Report Type 1 and derive to this item all the have the Report Type attribute defined as Spontaneous, Literature, or Compassionate Use. As a result, Report Type 1 from the Report Type list and execute your query, the system returns only those cases that have the Report Type attribute specified as Spontaneous, Literature, or Compassionate Use.

You can specify more than one attribute. For example, you can create a further specialized List Maintenance item called Report Type 1 US and derive to this item 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