Previous Topic

Next Topic

Book Contents

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
Column Name (Key indicator)

IRV_CUR_RULE
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.

Send Feedback