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.