Fields and Check Boxes in the Derivation Fields Dialog Box

This section describes the fields and check boxes in the Derivation Fields dialog box.

Field or check box name	Description
LM Table	The LM Table field is the table name of the selected Oracle Argus Safety field (that is, populated).
Suppress	The Suppress check box is available for fields associated with the list maintenance data. When suppress is enabled for a field, the corresponding list maintenance values that are not present in any case are deleted and thus not available for querying. Note: The Suppress check box is applicable only if the condition specified in the SQL text box covers all the cases having the selected List Maintenance field.
Value	The Value field captures the value for the new derivation field. For the following four rules, you must enter the new value for the rule as a comma-separated value: Causality Report Type Age Group Last Daily Dose Note: Make sure that you enter the values for these rules as defined in the following sections. Unexpected results and/or ETL errors may result if the values are not entered as specified.
Causality Rule	Parameters: VALUE, REPORTABILITY where: VALUE = New value for the rule REPORTABILITY = Lower value of the group For example: New Causality,1
Report Type Rule	Parameters: VALUE, INC_LIT, INC_TRIAL, ABRV where: VALUE = New value for the rule INC_LIT = 1 if Literature Report Type else 0 INC_TRIAL = 1 if Clinical Trial Report Type else 0 ABRV = A 3-letter abbreviation for the Report Type For example: NewReportType,0,1,NRT
Age Group Role	Parameters: VALUE, GROUP_LOW, GROUP_HIGH where: VALUE = New value for the rule GROUP_LOW = Lowest value of the age group GROUP_HIGH = Highest value of the age group For example: NewAgeGroup,25,50 If you do not want to specify the High Value, then the comma is mandatory in the end. For example: Unknown,70,
Last Daily Dose Rule	Parameters: VALUE, DAILY_DOSE_SORTING_ORDER where: VALUE = New value for the rule DAILY_DOSE_SORTING_ORDER = 1 or 2 or 3 and so on to define the sorting order if there is more than 1 rule for the Last Daily Dose field. For example: 1 -> 0to1,1; 2 -> 2to3,2 3 -> 5to8,3
Priority	The Priority field captures the priority for a list of derivation rules applied to a single List Maintenance field. Valid values: 1–255. Note: The priority for derivation rules applicable to a single List Maintenance field must be unique.
SQL	The SQL field specifies the SQL statement to capture the cases for which the derivation rule is applicable. Note: The SQL statement must follow the correct syntax. The system does not validate the length of the new values against the database. Make sure that new values being inserted into the data mart do not exceed the limit defined in the database. Guidelines for correct SQL statement syntax: The SQL query configured against a rule cannot contain the table name. It must contain only the primary key column name(s) of the field in the SELECT clause. For example: Correct: SELECT CASE_ID FROM RPT_CASE WHERE... Incorrect: SELECT RPT_CASE.CASE_ID FROM RPT_CASE WHERE… Make sure that there is only one space after the SELECT clause in the SQL query. For example: Correct: SELECT CASE_ID, SEQ_NUM FROM RPT_PRODUCT WHERE... Incorrect: SELECT CASE_ID, SEQ_NUM FROM RPT_PRODUCT WHERE… Make sure that no Oracle keyword (such as DISTINCT) is used after the SELECT clause in the SQL query. For example: Correct: SELECT CASE_ID, SEQ_NUM FROM RPT_PRODUCT… Incorrect: SELECT DISTINCT CASE_ID, SEQ_NUM FROM RPT_PRODUCT…