Previous Topic

Next Topic

Book Contents

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

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

Send Feedback