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. |