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     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