Geography Hierarchies
The HZ_GEO_HIERARCHY_CF view object contains geography hierarchies in ten level of column-flattened structure.
Data Store Key : CrmAnalyticsAM.CrmExtractAM.HzBiccExtractAM.GeoHierarchyCfExtractPVO
Primary Keys : HierarchyNodeId
Initial Extract Date : CreationDate
Incremental Extract Date : LastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| BaseGeoCode | Code of the lowest level geography. |
| BaseGeoId | Unique identifier of lowest level geography. |
| BaseGeoName | Name of lowest level geography. |
| BaseZoneName | Name of base zone in column flatten structure. |
| CreatedBy | The user who created the row. |
| CreationDate | The date and time of the creation of the row. |
| EffectiveEndDate | Indicates the date at the end of the date range within which the row is effective. |
| EffectiveStartDate | Indicates the date at the beginning of the date range within which the row is effective. |
| FixedHierLevel | Stores the number of level that the node is fixed. For a 10 level hierarchy, the top node has 9. The base has 0 as value for this attribute. |
| HierarchyNodeId | Unique hierarchy node identifier. |
| HierarchyType | The hierarchy type name. |
| LastUpdateDate | The date and time when the row was last updated. |
| LastUpdateLogin | Th login of the user who last updated the row. |
| LastUpdatedBy | The user who last updated the row. |
| LeafFlag | Indicates if the base geography is a leaf. Y if it's the lowest level, otherwise N. |
| Level01GeoCode | Code of geography in column flatten structure. |
| Level01GeoId | Unique identifier of geography in column flatten structure. |
| Level01GeoName | Name of geography in column flatten structure. |
| Level01ZoneName | Name of level_01 zone in column flatten structure. |
| Level02GeoCode | Code of geography in column flatten structure. |
| Level02GeoId | Unique identifier of geography in column flatten structure. |
| Level02GeoName | Name of geography in column flatten structure. |
| Level02ZoneName | Name of level_02 zone in column flatten structure. |
| Level03GeoCode | Code of geography in column flatten structure. |
| Level03GeoId | Unique identifier of geography in column flatten structure. |
| Level03GeoName | Name of geography in column flatten structure. |
| Level03ZoneName | Name of level_03 zone in column flatten structure. |
| Level04GeoCode | Code of geography in column flatten structure. |
| Level04GeoId | Unique identifier of geography in column flatten structure. |
| Level04GeoName | Name of geography in column flatten structure. |
| Level04ZoneName | Name of level_04 zone in column flatten structure. |
| Level05GeoCode | Code of geography in column flatten structure. |
| Level05GeoId | Unique identifier of geography in column flatten structure. |
| Level05GeoName | Name of geography in column flatten structure. |
| Level05ZoneName | Name of level_05 zone in column flatten structure. |
| Level06GeoCode | Code of geography in column flatten structure. |
| Level06GeoId | Unique identifier of geography in column flatten structure. |
| Level06GeoName | Name of geography in column flatten structure. |
| Level06ZoneName | Name of level_06 zone in column flatten structure. |
| Level07GeoCode | Code of geography in column flatten structure. |
| Level07GeoId | Unique identifier of geography in column flatten structure. |
| Level07GeoName | Name of geography in column flatten structure. |
| Level07ZoneName | Name of level_07 zone in column flatten structure. |
| Level08GeoCode | Code of geography in column flatten structure. |
| Level08GeoId | Unique identifier of geography in column flatten structure. |
| Level08GeoName | Name of geography in column flatten structure. |
| Level08ZoneName | Name of level_08 zone in column flatten structure. |
| Status | Indicates if this hierarchy is active. A if it's active and I if it's inactive. |
| TopGeoCode | Code of the highest level geography. |
| TopGeoId | Unique identifier of highest level geography. |
| TopGeoName | Name of highest level geography. |
| TopZoneName | Name of top zone in column flatten structure. |