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