Geo Hierarchy Node dimension
Module: Recruiting
GEOGRAPHY_NODE_ID
| 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.