DW_WORKER_LOCATION_D

Business location Dimension

Details

Module:

Key Columns

LOCATION_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
LOCATION_ID NUMBER 38 0 True Business Location ID DW_WORKER_LOCATION_D_TL LOCATION_ID
SOURCE_RECORD_ID NUMBER 38 0   This column is for Oracle Internal use only. Unique record Identifier.Business location ID as Primary Key    
LOCATION_CODE VARCHAR2 256     Internal Location Code    
ADDRESS_LINE_1 VARCHAR2 256     First line of address    
ADDRESS_LINE_2 VARCHAR2 256     Second line of address    
ADDRESS_LINE_3 VARCHAR2 256     Third line of address    
ADDRESS_LINE_4 VARCHAR2 256     Fourth line of address    
TOWN_OR_CITY VARCHAR2 64     Name of the Town or City for the address    
POSTAL_CODE VARCHAR2 32     Postal code of the address    
REGION1 VARCHAR2 128     Primary region in which the address is located.    
REGION2 VARCHAR2 128     Sub-region of Region 1.    
REGION3 VARCHAR2 128     Sub-region of Region 2.    
COUNTRY VARCHAR2 64     Country of the address. For translation refer table DW_COUNTRY_D_TL. DW_COUNTRY_D_TL COUNTRY
MAIN_PHONE_NUMBER VARCHAR2 256     Main Phone Number    
MAIN_PHONE_EXTENSION VARCHAR2 64     Main Phone Extension    
FAX_NUMBER VARCHAR2 256     Fax Number    
FAX_NUMBER_EXTENSION VARCHAR2 64     Fax Extension    
OTHER_PHONE_NUMBER VARCHAR2 256     Other Phone Number    
OTHER_PHONE_EXTENSION VARCHAR2 64     Pther pHone extension    
EMAIL_ADDRESS VARCHAR2 256     Email Address    
ACTIVE VARCHAR2 32     Active    
INVENTORY_ORGANIZATION_NAME VARCHAR2 256     Represents the inventory organization id the location is attached. This attribute is not supported.    

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