Share via


SCRM 2006 SC_RelationshipAttributeInstanceFact_View

SC_RelationshipAttributeInstanceFact_View lists instances of relationship attributes, which are defined in SC_RelationshipAttributeDefinitionDimension_View.

SC_RelationshipAttributeInstanceFact_View

Column Type Constraint Description

ConfigurationGroup_FK

bigint

Not Null

The management group where the relationship attribute instance is defined.

DateAdded_FK

bigint

Not Null

The date the relationship attribute instance was added.

DateLastModified_FK

bigint

Not Null

The date the relationship attribute instance was last changed.

DateTimeAdded

datetime

Not Null

The date and time the relationship attribute instance was added.

DateTimeLastModified

datetime

Not Null

The date and time the relationship attribute instance was last changed.

DateTimeOfTransfer

datetime

Not Null

Date and time the relationship attribute instance was transferred to the reporting database.

RelationshipAttributeDefinition_FK

bigint

Not Null

The definition on which this relationship attribute is based.

RelationshipAttributeInstanceID

uniqueidentifier

Not Null

The GUID identifying this relationship attribute instance.

RelationshipInstanceID

uniqueidentifier

Not Null

The ID of the relationship instance associated with this attribute.

SMC_InstanceID

bigint

Not Null

The surrogate key for this item.

SourceClassInstanceKeyValue

nvarchar(400)

Not Null

The name of the key value for the source class instance.

TargetClassInstanceKeyValue

nvarchar(400)

Not Null

The name of the key value for the target class instance.

TimeAdded_FK

bigint

Not Null

The time the relationship attribute instance was added.

TimeLastModified_FK

bigint

Not Null

The time the relationship attribute instance was last changed.

UserLastModified_FK

bigint

Not Null

The last user to change the relationship attribute instance.

Value

nvarchar(255)

Null values allowed

The value of the relationship attribute instance.

See Also

Reference

SCRM 2006 SC_RelationshipDefinitionDimension_View
SCRM 2006 SC_RelationshipAttributeDefinitionDimension_View

Other Resources

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