# DW_TA_GEO_HIERARICHAL_NODES_D

Geo Hierarchy Node dimension

## Details

Module: Recruiting

## Key Columns

GEOGRAPHY_NODE_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
GEOGRAPHY_NODE_ID | NUMBER | 38 | 0 | True | Unique geography node identifier |  |
SOURCE_RECORD_ID | VARCHAR2 | 128 |  |  | This column is for Oracle Internal use only. source record identifier |  |
GEOGRAPHY_TYPE | VARCHAR2 | 32 |  |  | geography type attribute |  |
GEOGRAPHY_NAME | VARCHAR2 | 512 |  |  | Primary Name of the geography |  |
GEOGRAPHY_CODE | VARCHAR2 | 32 |  |  | User identifier for this geography |  |
COUNTRY_CODE | VARCHAR2 | 16 |  |  | Code of the Country to which the Geography belongs |  |
START_DATE | DATE |  |  |  | Start date from which this geography is valid for use |  |
END_DATE | DATE |  |  |  | Date from which this geography is no longer valid |  |
GEOGRAPHY_ELEMENT1 | VARCHAR2 | 512 |  |  | Name of denormalized parent of the geography |  |
GEOGRAPHY_ELEMENT1_ID | NUMBER | 38 | 0 |  | Unique identifier of denormalized parent of the geography |  |
GEOGRAPHY_ELEMENT1_CODE | VARCHAR2 | 32 |  |  | Code of denormalized parent of the geography |  |
GEOGRAPHY_ELEMENT2 | VARCHAR2 | 512 |  |  | Name of denormalized parent of the geography |  |
GEOGRAPHY_ELEMENT2_ID | NUMBER | 38 | 0 |  | Unique identifier of denormalized parent of the geography |  |
GEOGRAPHY_ELEMENT2_CODE | VARCHAR2 | 32 |  |  | Code of denormalized parent of the geography |  |
GEOGRAPHY_ELEMENT3 | VARCHAR2 | 512 |  |  | Name of denormalized parent of the geography |  |
GEOGRAPHY_ELEMENT3_ID | NUMBER | 38 | 0 |  | Unique identifier of denormalized parent of the geography |  |
GEOGRAPHY_ELEMENT3_CODE | VARCHAR2 | 32 |  |  | Code of denormalized parent of the geography |  |
GEOGRAPHY_ELEMENT4 | VARCHAR2 | 512 |  |  | Name of denormalized parent of the geography |  |
GEOGRAPHY_ELEMENT4_ID | NUMBER | 38 | 0 |  | Unique identifier of denormalized parent of the geography |  |
GEOGRAPHY_ELEMENT4_CODE | VARCHAR2 | 32 |  |  | Code of denormalized parent of the geography |  |
GEOGRAPHY_ELEMENT5 | VARCHAR2 | 512 |  |  | Name of denormalized parent of the geography |  |
GEOGRAPHY_ELEMENT5_ID | NUMBER | 38 | 0 |  | Unique identifier of denormalized parent of the geography |  |
GEOGRAPHY_ELEMENT5_CODE | VARCHAR2 | 32 |  |  | Code of denormalized parent of the geography |  |
GEOGRAPHY_ELEMENT6 | VARCHAR2 | 512 |  |  | Name of denormalized parent of the geography |  |
GEOGRAPHY_ELEMENT6_ID | NUMBER | 38 | 0 |  | Unique identifier of denormalized parent of the geography |  |
GEOGRAPHY_ELEMENT7 | VARCHAR2 | 512 |  |  | Name of denormalized parent of the geography |  |
GEOGRAPHY_ELEMENT7_ID | NUMBER | 38 | 0 |  | Unique identifier of denormalized parent of the geography |  |
GEOGRAPHY_ELEMENT8 | VARCHAR2 | 512 |  |  | Name of denormalized parent of the geography |  |
GEOGRAPHY_ELEMENT8_ID | NUMBER | 38 | 0 |  | Unique identifier of denormalized parent of the geography |  |
GEOGRAPHY_ELEMENT9 | VARCHAR2 | 512 |  |  | Name of denormalized parent of the geography |  |
GEOGRAPHY_ELEMENT9_ID | NUMBER | 38 | 0 |  | Unique identifier of denormalized parent of the geography |  |
GEOGRAPHY_ELEMENT10 | VARCHAR2 | 512 |  |  | Name of denormalized parent of the geography |  |
GEOGRAPHY_ELEMENT10_ID | NUMBER | 38 | 0 |  | Unique identifier of denormalized parent of the geography |  |

Copyright © 2019, 2025, Oracle and/or its affiliates.