Share via


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.

See Also

Reference

SCRM 2006 SC_ClassDefinitionDimension_View

Other Resources

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