Share via


SCRM 2006 SC_ClassAttributeInstanceFact_View

SC_ClassAttributeInstanceFact_View lists MOM class instance attributes.

SC_ClassAttributeInstanceFact_View

Column Type Constraint Description

ClassAttributeDefinition_FK

bigint

Not Null

The GUID of the class attribute definition on which this class attribute instance is based.

ClassAttributeInstanceID

uniqueidentifier

Not Null

The GUID identifying the class attribute instance.

ClassInstanceID

uniqueidentifier

Not Null

The GUID of the class instance related to this class attribute instance.

ClassInstanceKeyValue

nvarchar(400)

Not Null

The key value of the source class instance.

ConfigurationGroup_FK

bigint

Not Null

The management group on which the class attribute instance is defined.

DateAdded_FK

bigint

Not Null

The date the class attribute instance was added.

DateLastModified_FK

bigint

Not Null

The date the class attribute instance was last changed.

DateTimeAdded

datetime

Not Null

The date and time the class attribute instance was added.

DateTimeLastModified

datetime

Not Null

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

DateTimeOfTransfer

datetime

Not Null

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

SMC_InstanceID

bigint

Not Null

The surrogate key for this item.

TimeAdded_FK

bigint

Not Null

The time the class attribute instance was added.

TimeLastModified_FK

bigint

Not Null

The time the class attribute instance was last changed.

UserLastModified_FK

bigint

Not Null

The last user to change the class attribute instance.

Value

nvarchar(255)

Null values allowed

The value of the class attribute instance.

See Also

Reference

SCRM 2006 SC_ClassAttributeDefinitionDimension_View

Other Resources

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