Category Flattened Hierarchies

The category hierarchy flattened view object provides details about the categories hierarchy in a flattened format.

Data Store Key : CrmAnalyticsAM.ServiceExtractAM.SvcMgmtBiccExtractAM.CategoryHierarchyFlattenExtractPVO

Primary Keys : Lvl0CatId

Initial Extract Date : CreationDate

Incremental Extract Date : LastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

Name	Description
Categ	The unique identifier of the category in the in column flattened structure.
CreatedBy	The user who created the row.
CreationDate	The date and time when the row was created.
LastUpdateDate	The date and time when the row was last updated.
LastUpdateLogin	The session login of the user who last updated the row.
LastUpdatedBy	The user who last updated the row.
Lev	The level of the category in column flatten structure.
Lvl0CatId	The unique identifier of the base level category in column flatten structure.
Lvl1CatId	The unique identifier of the first level category.
Lvl2CatId	The unique identifier of the second level category.
Lvl3CatId	The unique identifier of the third level category.
Lvl4CatId	The unique identifier of the fourth level category.
Lvl5CatId	The unique identifier of the fifth level category.
Lvl6CatId	The unique identifier of the sixth level category.
Lvl7CatId	The unique identifier of the seventh level category.
Lvl8CatId	The unique identifier of the eighth level category.
Lvl9CatId	The unique identifier of the ninth level category.
Path	The path from root to node. This is renamed and used because some selects fail when using path as column name.