SCRM 2006 SC_CollectionHierarchy_BRIDGE_View
SC_CollectionHierarchy_BRIDGE_View lists the relationship between a parent collection and every subcollection below it.
SC_CollectionHierarchy_BRIDGE_View
| Column | Type | Constraint | Description |
|---|---|---|---|
CollectionBridgeParentCollectionKey |
int |
Not Null |
Key that uniquely identifies a given parent collection. |
CollectionBridgeSubCollectionKey |
int |
Not Null |
Key that uniquely identifies a child collection below a parent collection. |
CollectionBridgeEndTimeKey |
int |
Null values allowed |
End of the time period that this row was valid. A |
CollectionBridgeEndDateKey |
int |
Null values allowed |
End of the time period that this row was valid. A |
CollectionBridgeEndDateLineageKey |
int |
Null values allowed |
Key that references the DTS lineage of the package that detected that this collection-to-sub-collection relationship no longer exists or has changed in the SMS site database. |
CollectionBridgeStartTimeKey |
int |
Not Null |
Start of the time period that this row was known to be valid. Indicates time that this collection-to-sub-collection relationship was first inventoried by SMS. |
CollectionBridgeStartDateKey |
int |
Not Null |
Start of the time period that this row was known to be valid. Indicates time that this collection-to-sub-collection relationship was first inventoried by SMS. |
CollectionBridgeStartDateLineageKey |
int |
Not Null |
Key that references the DTS lineage of the package that first detected that this collection-to-sub-collection relationship exists in the SMS site database. |
CollectionBridgeLevelsFromParent |
int |
Not Null |
Indicator for the number of levels below the parent collection that the child collection exists. |
CollectionBridgeBottomFlag |
tinyint |
Not Null |
Flag that indicates that this collection is at the bottom level of the Collection Hierarchy. |
CollectionBridgeTopFlag |
tinyint |
Not Null |
Flag that indicates that this collection is at the top level of the Collection Hierarchy. |
See Also
Other Resources
SCRM 2006 MOM Views
SCRM 2006 Report Customization
SCRM 2006 SMS Views
SCRM 2006 Stored Procedures