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:
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:
|
Parent topic: Configure Derivation Functions