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