SCRM 2006 SC_ProcessRuleMembershipFact_View

SC_ProcessRuleMembershipFact_View associates a rule to the rule groups it belongs to.

SC_ProcessRuleMembershipFact_View

Column Type Constraint Description

ConfigurationGroup_FK

bigint

Not Null

The management group where the process rule membership is defined.

DateAdded_FK

bigint

Not Null

The date the process rule membership was added.

DateTimeAdded

datetime

Not Null

The date and time the process rule membership was added.

DateTimeOfTransfer

datetime

Not Null

Date and time the process rule membership was transferred to the reporting database.

Level

bigint

Not Null

The level of the association.

ProcessRuleGroup_FK

bigint

Not Null

The rule group to which this rule belongs.

ProcessRuleMember_FK

bigint

Not Null

Details about the rule.

SMC_InstanceID

bigint

Not Null

The surrogate key for this item.

TimeAdded_FK

bigint

Not Null

The time the process rule membership was added.

See Also

Reference

SCRM 2006 SC_ProcessRuleDimension_View
SCRM 2006 SC_ProcessRuleToConfigurationGroupDimension_View

Other Resources

SCRM 2006 MOM Views
SCRM 2006 Report Customization
SCRM 2006 SMS Views
SCRM 2006 Stored Procedures