SCRM 2006 SC_CollectionHierarchy_BRIDGE_View

2006-09-10

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 `NULL` value indicates this row contains the current information. A date value indicates the last date that this row was known to be valid.
CollectionBridgeEndDateKey	int	Null values allowed	End of the time period that this row was valid. A `NULL` value indicates this row contains the current information. A date value indicates the last date that this row was known to be valid.
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