SCRM 2006 SC_ClassInstanceFact_View

SC_ClassInstanceFact_View lists MOM class instances.

SC_ClassInstanceFact_View

Column	Type	Constraint	Description
ClassDefinition_FK	bigint	Not Null	Represents the class definition of the class instance. Foreign key to the ClassDefinitionDimension.
ClassInstanceID	Unique identifier	Not Null	The GUID identifying the class instance.
ConfigurationGroup_FK	bigint	Not Null	The management group where the class instance is defined.
DateAdded_FK	bigint	Not Null	The date the class instance was added to the operations database.
DateLastModified_FK	bigint	Not Null	The date the class instance was last changed.
DateTimeAdded	datetime	Not Null	The date and time the class instance was added to the operations database.
DateTimeLastModified	datetime	Not Null	The date and time the class instance was last changed.
DateTimeOfTransfer	datetime	Not Null	The date and time the class instance was transferred to the reporting database.
KeyValue	nvarchar(400)	Not Null	The key value of the class instance.
SMC_InstanceID	bigint	Not Null	The surrogate key for this item.
State	int	Null values allowed	The state of the class instance.
TimeAdded_FK	bigint	Not Null	The time the class instance was added to the operations database.
TimeLastModified_FK	bigint	Not Null	The time the class instance was last changed.
UserLastModified_FK	bigint	Not Null	The last user to change the class instance.