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