SCRM 2006 SC_ComputerRuleToProcessRuleGroupFact_View

SC_ComputerRuleToProcessRuleGroupFact_View associates rule groups to computer rules.

SC_ComputerRuleToProcessRuleGroupFact_View

Column Type Constraint Description

ComputerRule_FK

bigint

Not Null

The computer rule associated with the rule group.

ConfigurationGroup_FK

bigint

Not Null

The management group where the association is defined.

DateAdded_FK

bigint

Not Null

The date the association was added to the operations database.

DateTimeAdded

datetime

Not Null

The date and time the association was added to the operations database.

DateTimeOfTransfer

datetime

Not Null

The date and time the association was transferred to the reporting database.

ProcessRuleGroup_FK

bigint

Not Null

The rule group associated with the computer rule.

SMC_InstanceID

bigint

Not Null

The surrogate key for this item.

TimeAdded_FK

bigint

Not Null

The time the association was added.

See Also

Reference

SCRM 2006 SCRS_ComputerDimension_View
SCRM 2006 SC_ProcessRuleDimension_View

Other Resources

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