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, 2024, Oracle and/or its affiliates.