SCRM 2006 SC_RelationshipAttributeInstanceFact_View
SC_RelationshipAttributeInstanceFact_View lists instances of relationship attributes, which are defined in SC_RelationshipAttributeDefinitionDimension_View.
SC_RelationshipAttributeInstanceFact_View
| Column | Type | Constraint | Description |
|---|---|---|---|
| ConfigurationGroup_FK | bigint | Not Null | The management group where the relationship attribute instance is defined. |
| DateAdded_FK | bigint | Not Null | The date the relationship attribute instance was added. |
| DateLastModified_FK | bigint | Not Null | The date the relationship attribute instance was last changed. |
| DateTimeAdded | datetime | Not Null | The date and time the relationship attribute instance was added. |
| DateTimeLastModified | datetime | Not Null | The date and time the relationship attribute instance was last changed. |
| DateTimeOfTransfer | datetime | Not Null | Date and time the relationship attribute instance was transferred to the reporting database. |
| bigint | Not Null | The definition on which this relationship attribute is based. | |
| RelationshipAttributeInstanceID | uniqueidentifier | Not Null | The GUID identifying this relationship attribute instance. |
| RelationshipInstanceID | uniqueidentifier | Not Null | The ID of the relationship instance associated with this attribute. |
| SMC_InstanceID | bigint | Not Null | The surrogate key for this item. |
| SourceClassInstanceKeyValue | nvarchar(400) | Not Null | The name of the key value for the source class instance. |
| TargetClassInstanceKeyValue | nvarchar(400) | Not Null | The name of the key value for the target class instance. |
| TimeAdded_FK | bigint | Not Null | The time the relationship attribute instance was added. |
| TimeLastModified_FK | bigint | Not Null | The time the relationship attribute instance was last changed. |
| bigint | Not Null | The last user to change the relationship attribute instance. | |
| Value | nvarchar(255) | Null values allowed | The value of the relationship attribute instance. |