SCRM 2006 SC_ClassInstanceFact_View
SC_ClassInstanceFact_View lists MOM class instances.
SC_ClassInstanceFact_View
| Column | Type | Constraint | Description |
|---|---|---|---|
| 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. |
| bigint | Not Null | The last user to change the class instance. |