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.