Derivations

A Derivation must have a unique name which can contain letters, digits and the underscore character.

Logic

The logic of the Derivation Check determines whether or not the Check Actions will be performed. Derivation logic can be written using Clinical Query Language (CQL) which will be automatically converted to Rave's 'quickedit' format. Content-sensitive help will be displayed as you type. If the syntax is invalid an error message will be displayed.

Derivations can only use functions and operators which are valid for Rave Derivations. For example, this is NOT a valid Derivation:

SCREEN.DM.SEX.CodedValue == "FEMALE"

Warning

Medidata Rave Derivation Step Ordinals are not always consecutive and do not always start at 1. TrialGrid will not changed the Derivation Step Ordinals when importing a Draft from Medidata Rave but if the Derivation is modified in TrialGrid the Ordinals might change, and the Derivation should not then be merged into the existing Draft in Medidata Rave.

Warning

Rave allows Derivations to include steps which will not be evaluated into the final result, and TrialGrid will also allow this. For example the first step in the following Derivation, referencing the AGE field, will not be included in the Derivation result, which will be the value of the second step:

SCREEN.DM.AGE
SCREEN.DM.SEX.CodedValue