HZ_GEO_HIERARCHY_CF
The HZ_GEO_HIERARCHY_CF table contains geography hierarchies in ten level of column-flattened structure.
Details
-
Schema: FUSION
-
Object owner: HZ
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
HZ_GEO_HIERARCHY_CF_PK |
HIERARCHY_NODE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| HIERARCHY_NODE_ID | NUMBER | 18 | Yes | Unique hierarchy node identifier. | |
| HIERARCHY_TYPE | VARCHAR2 | 30 | Yes | The hierarchy type name (i.e. MASTER_REF or TM) | |
| EFFECTIVE_START_DATE | DATE | Yes | Date Effective Entity: indicates the date at the beginning of the date range within which the row is effective. | ||
| EFFECTIVE_END_DATE | DATE | Yes | Date Effective Entity: indicates the date at the end of the date range within which the row is effective. | ||
| STATUS | VARCHAR2 | 1 | Yes | Indicates if this hierarchy is active. A if it is active and I if it is inactive. | |
| BASE_GEO_ID | NUMBER | 18 | Yes | Unique identifier of lowest level geography (Foreign key to HZ_GEOGRAPHIES.GEOGRAPHY_ID) | |
| BASE_GEO_NAME | VARCHAR2 | 360 | Yes | Name of lowest level geography | |
| BASE_GEO_CODE | VARCHAR2 | 30 | Code of the lowest level geography | ||
| LEAF_FLAG | VARCHAR2 | 1 | Yes | Indicates if the base geography is a leaf. Y if it is the lowest level, otherwise N. | |
| FIXED_HIER_LEVEL | NUMBER | 2 | Yes | 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. | |
| LEVEL_01_GEO_ID | NUMBER | 18 | Yes | Unique identifier of geography in column flatten structure (Foreign key to HZ_GEOGRAPHIES.GEOGRAPHY_ID) | |
| LEVEL_01_GEO_NAME | VARCHAR2 | 360 | Yes | Name of geography in column flatten structure | |
| LEVEL_01_GEO_CODE | VARCHAR2 | 30 | Code of geography in column flatten structure | ||
| LEVEL_02_GEO_ID | NUMBER | 18 | Yes | Unique identifier of geography in column flatten structure (Foreign key to HZ_GEOGRAPHIES.GEOGRAPHY_ID) | |
| LEVEL_02_GEO_NAME | VARCHAR2 | 360 | Yes | Name of geography in column flatten structure | |
| LEVEL_02_GEO_CODE | VARCHAR2 | 30 | Code of geography in column flatten structure | ||
| LEVEL_03_GEO_ID | NUMBER | 18 | Yes | Unique identifier of geography in column flatten structure (Foreign key to HZ_GEOGRAPHIES.GEOGRAPHY_ID) | |
| LEVEL_03_GEO_NAME | VARCHAR2 | 360 | Yes | Name of geography in column flatten structure | |
| LEVEL_03_GEO_CODE | VARCHAR2 | 30 | Code of geography in column flatten structure | ||
| LEVEL_04_GEO_ID | NUMBER | 18 | Yes | Unique identifier of geography in column flatten structure (Foreign key to HZ_GEOGRAPHIES.GEOGRAPHY_ID) | |
| LEVEL_04_GEO_NAME | VARCHAR2 | 360 | Yes | Name of geography in column flatten structure | |
| LEVEL_04_GEO_CODE | VARCHAR2 | 30 | Code of geography in column flatten structure | ||
| LEVEL_05_GEO_ID | NUMBER | 18 | Yes | Unique identifier of geography in column flatten structure (Foreign key to HZ_GEOGRAPHIES.GEOGRAPHY_ID) | |
| LEVEL_05_GEO_NAME | VARCHAR2 | 360 | Yes | Name of geography in column flatten structure | |
| LEVEL_05_GEO_CODE | VARCHAR2 | 30 | Code of geography in column flatten structure | ||
| LEVEL_06_GEO_ID | NUMBER | 18 | Yes | Unique identifier of geography in column flatten structure (Foreign key to HZ_GEOGRAPHIES.GEOGRAPHY_ID) | |
| LEVEL_06_GEO_NAME | VARCHAR2 | 360 | Yes | Name of geography in column flatten structure | |
| LEVEL_06_GEO_CODE | VARCHAR2 | 30 | Code of geography in column flatten structure | ||
| LEVEL_07_GEO_ID | NUMBER | 18 | Yes | Unique identifier of geography in column flatten structure (Foreign key to HZ_GEOGRAPHIES.GEOGRAPHY_ID) | |
| LEVEL_07_GEO_NAME | VARCHAR2 | 360 | Yes | Name of geography in column flatten structure | |
| LEVEL_07_GEO_CODE | VARCHAR2 | 30 | Code of geography in column flatten structure | ||
| LEVEL_08_GEO_ID | NUMBER | 18 | Yes | Unique identifier of geography in column flatten structure (Foreign key to HZ_GEOGRAPHIES.GEOGRAPHY_ID) | |
| LEVEL_08_GEO_NAME | VARCHAR2 | 360 | Yes | Name of geography in column flatten structure | |
| LEVEL_08_GEO_CODE | VARCHAR2 | 30 | Code of geography in column flatten structure | ||
| TOP_GEO_ID | NUMBER | 18 | Yes | Unique identifier of highest level geography (Foreign key to HZ_GEOGRAPHIES.GEOGRAPHY_ID) | |
| TOP_GEO_NAME | VARCHAR2 | 360 | Yes | Name of highest level geography | |
| TOP_GEO_CODE | VARCHAR2 | 30 | Code of the highest level geography | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| BASE_ZONE_NAME | VARCHAR2 | 360 | Name of base zone in column flatten structure | ||
| LEVEL_01_ZONE_NAME | VARCHAR2 | 360 | Name of level_01 zone in column flatten structure | ||
| LEVEL_02_ZONE_NAME | VARCHAR2 | 360 | Name of level_02 zone in column flatten structure | ||
| LEVEL_03_ZONE_NAME | VARCHAR2 | 360 | Name of level_03 zone in column flatten structure | ||
| LEVEL_04_ZONE_NAME | VARCHAR2 | 360 | Name of level_04 zone in column flatten structure | ||
| LEVEL_05_ZONE_NAME | VARCHAR2 | 360 | Name of level_05 zone in column flatten structure | ||
| LEVEL_06_ZONE_NAME | VARCHAR2 | 360 | Name of level_06 zone in column flatten structure | ||
| LEVEL_07_ZONE_NAME | VARCHAR2 | 360 | Name of level_07 zone in column flatten structure | ||
| LEVEL_08_ZONE_NAME | VARCHAR2 | 360 | Name of level_08 zone in column flatten structure | ||
| TOP_ZONE_NAME | VARCHAR2 | 360 | Name of top zone in column flatten structure |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| HZ_GEO_HIERARCHY_CF | hz_geographies | BASE_GEO_ID |
| HZ_GEO_HIERARCHY_CF | hz_geographies | TOP_GEO_ID |
| HZ_GEO_HIERARCHY_CF | hz_geographies | LEVEL_01_GEO_ID |
| HZ_GEO_HIERARCHY_CF | hz_geographies | LEVEL_02_GEO_ID |
| HZ_GEO_HIERARCHY_CF | hz_geographies | LEVEL_03_GEO_ID |
| HZ_GEO_HIERARCHY_CF | hz_geographies | LEVEL_04_GEO_ID |
| HZ_GEO_HIERARCHY_CF | hz_geographies | LEVEL_05_GEO_ID |
| HZ_GEO_HIERARCHY_CF | hz_geographies | LEVEL_06_GEO_ID |
| HZ_GEO_HIERARCHY_CF | hz_geographies | LEVEL_07_GEO_ID |
| HZ_GEO_HIERARCHY_CF | hz_geographies | LEVEL_08_GEO_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| HZ_GEO_HIERARCHY_CF_N1 | Non Unique | Default | HIERARCHY_TYPE, BASE_GEO_ID, FIXED_HIER_LEVEL |
| HZ_GEO_HIERARCHY_CF_N10 | Non Unique | Default | LEVEL_08_GEO_ID, FIXED_HIER_LEVEL |
| HZ_GEO_HIERARCHY_CF_N2 | Non Unique | Default | BASE_GEO_ID, FIXED_HIER_LEVEL |
| HZ_GEO_HIERARCHY_CF_N3 | Non Unique | Default | LEVEL_01_GEO_ID, FIXED_HIER_LEVEL |
| HZ_GEO_HIERARCHY_CF_N4 | Non Unique | Default | LEVEL_02_GEO_ID, FIXED_HIER_LEVEL |
| HZ_GEO_HIERARCHY_CF_N5 | Non Unique | Default | LEVEL_03_GEO_ID, FIXED_HIER_LEVEL |
| HZ_GEO_HIERARCHY_CF_N6 | Non Unique | Default | LEVEL_04_GEO_ID, FIXED_HIER_LEVEL |
| HZ_GEO_HIERARCHY_CF_N7 | Non Unique | Default | LEVEL_05_GEO_ID, FIXED_HIER_LEVEL |
| HZ_GEO_HIERARCHY_CF_N8 | Non Unique | Default | LEVEL_06_GEO_ID, FIXED_HIER_LEVEL |
| HZ_GEO_HIERARCHY_CF_N9 | Non Unique | Default | LEVEL_07_GEO_ID, FIXED_HIER_LEVEL |
| HZ_GEO_HIERARCHY_CF_U1 | Unique | Default | HIERARCHY_NODE_ID |