IRV_CUR_RULE

This view contains the most recent definition of each rule installed into the study.

Column Name (Key indicator) Column Description
RULECOUNT Always 1; indicates that the row represents one rule.
RULEID (PK) Numeric identifier for the rule.
RULEREV Current revision number for the rule.
RREVS Number of times the rule has been revised.
MINRREV Revision number for the first time the rule was revised.
MAXRREV Revision number for the most recent time the rule was revised.
RULEREFNAME RefName for the rule.
RULEDESCRIPTION Rule description.
RULEENABLED

Rule enabled status:

0 - Disabled

1 - Enabled

EVENTTYPEID Numeric identifier for the rule event type.
ETINITIALREVISIONNUMBER Revision number for the first time the event type was revised.
SCRIPTTYPE

Rule type:

0 - Unknown

1 - Server rule

2 - Browser

3 - Server calculation

4 - Conversion

5 - Randomization

6 - Clintrial rule

7 - Clintrial derivation

8 - Server rule calculation

9 - Server rule calculated randomization

10 - Workflow rule

11 - GlobalCondition rule

12 - Server or Calc, or Rand or WF or GF rule

HELPTEXTID Numeric identifier for the rule Help text.
DESIGNNOTE Design note for the rule, as provided by the study designer.
CTMSGTEXT Rule message text; Clintrial rules only.
CTRULEACTION Rule action; Clintrial rules only.
CTRULEOPTIONS Rule options; Clintrial rules only.
CREATEDBYUSERID User ID of the user whose action resulted in the given view row being created.
CREATEDBYDATETIME Date and time when the view row was created.
MODIFIEDBYUSERID User ID of the user whose action resulted in the most recent change to data in the given view row.
MODIFIEDDATETIME Date and time when the data in the view row was most recently updated.