SCRM 2006 SC_ClassAttributeInstanceFact_View
SC_ClassAttributeInstanceFact_View lists MOM class instance attributes.
SC_ClassAttributeInstanceFact_View
| Column | Type | Constraint | Description |
|---|---|---|---|
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. |
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