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. |
See Also
Reference
SCRM 2006 SC_RelationshipDefinitionDimension_View
SCRM 2006 SC_RelationshipAttributeDefinitionDimension_View
Other Resources
SCRM 2006 MOM Views
SCRM 2006 Report Customization
SCRM 2006 SMS Views
SCRM 2006 Stored Procedures