IRV_CUR_RULE
This view contains the most recent definition of each rule installed into the study.
Columns in the IRV_CUR_RULE view
IRV_CUR_RULE |
IRV_CUR_RULE |
---|---|
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 |
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. |