Value
The Value field captures the value for the new derivation field. For the following 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 to 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
Example: NewCausality,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
Example: NewReportType,0,1,NRT
Age Group Rule
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
Example: NewAgeGroup,25,50
If you do not want to specify the High Value, then the comma is mandatory in the end.
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
Examples: 1 -> 0to1,1; 2 -> 2to3,2 3 -> 5to8,3