SCRM 2006 SC_RelationshipInstanceFact_View
The SC_RelationshipInstanceFact_View lists instances of relationships between two MOM items. The possible relationships are defined in the SC_RelationshipDefinitionDimension_View.
SC_RelationshipInstanceFact_View
| Column | Type | Constraint | Description |
|---|---|---|---|
| ConfigurationGroup_FK | bigint | Not Null | The management group where the relationship instance is defined. |
| DateAdded_FK | bigint | Not Null | The date the relationship instance was added. |
| DateLastModified_FK | bigint | Not Null | The date the relationship instance was last changed. |
| DateTimeAdded | datetime | Not Null | The date and time the relationship instance was added. |
| DateTimeLastModified | datetime | Not Null | The date and time the relationship instance was last changed. |
| DateTimeOfTransfer | datetime | Not Null | Date and time the relationship instance was transferred to the reporting database. |
| bigint | Not Null | The relationship definition on which this relationship instance is based. | |
| RelationshipInstanceID | uniqueidentifier | Not Null | The GUID identifying this relationship instance. |
| SMC_InstanceID | bigint | Not Null | The surrogate key for this item. |
| SourceClassInstanceID | uniqueidentifier | Not Null | The ID of the relationship's source class. |
| SourceClassInstanceKeyValue | nvarchar(400) | Not Null | The name of the source class's key value. |
| TargetClassInstanceID | uniqueidentifier | Not Null | The ID of the relationship's target class. |
| TargetClassInstanceKeyValue | nvarchar(400) | Not Null | The name of the target class's key value. |
| TimeAdded_FK | bigint | Not Null | The time the relationship instance was added. |
| TimeLastModified_FK | bigint | Not Null | The time the relationship instance was last changed. |
| bigint | Not Null | The last user to change the relationship instance. |