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