IRV_CUR_RULEITEM

This view contains associations between rules and items on forms (MedML AttachRuleSet element).

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

1 - APPLIED

2 - TRIGGER

3 - DEPENDOR

ACTIVE

Rule active status:

0 - Rule is not run for this item.

1 - Rule is 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.