IRV_CUR_RULEITEM
This view contains associations between rules and items on forms (MedML AttachRuleSet element).
Columns in the IRV_CUR_RULEITEM view
IRV_CUR_RULEITEM |
IRV_CUR_RULEITEM |
---|---|
RULEITEMCOUNT |
Always 1; indicates that the row represents one rule item. |
RULEITEMID (PK) |
Numeric identifier for the rule-item association. |
RIREVS |
Number of times the rule item has been revised. |
MINRIREV |
First time the rule item was revised. |
MAXRIREV |
Most recent time the rule item was revised. |
RULEITEMREFNAME |
RefName for the item with which the rule is associated. |
APPLYEVENT |
Rule dependency type: 0 - DEPENDENCY |
ACTIVE |
Rule active status: 0 - Rule is not run for this item. |
RULEID |
Numeric identifier for the rule. |
CHAPTERID |
Numeric identifier (VISITID) for the visit in which the rule item exists. |
PAGEID |
Numeric identifier (FORMID) for the form on which the rule item exists. |
SECTIONID |
Numeric identifier for the section in which the rule item exists. |
ITEMSETID |
Numeric identifier for the itemset in which the rule item exists. |
ITEMID |
Numeric identifier for the item with which the rule is associated. |
RULESETID |
Rule item identifier of parent rule item. If blank, this rule item is a key context. Child rule items are additional dependencies for the rule. |
ITEMSETEVENTID |
Numeric identifier for the itemset event with which the rule is associated. |
ITEMSETHELPID |
Numeric identifier for the Help for the itemset with which the rule is associated. |
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. |