DW_EB_X_EBS_COMMON_W_BUSN_LOCATION_D

Business Locations Entity stores information about the Physical locations that Internal Businesses occupy for various purposes.Typical examples of Business locations are: Inventory Storage Locations, Plant Location, Recipient Location etc.The grain of this table is at the level of ?Location for that purpose". This table is designed to be a slowly changing dimension that supports Type-2 changes. The various types of Business locations are differentiated by the BUSN_LOC_TYPE column.

Details

Module: Common Tables (EBS_COMMON)

Business Name: Business Location Dimension

Key Columns

Key column information is not documented in the supplied metadata.

Columns

Columns
Name	Datatype	Length	Precision	Comments	Referred Table
DATASOURCE_NUM_ID	NUMBER		10	This column is the unique identifier of the source system from which data was extracted. In order to be able to trace the data back to its source, Oracle recommends that you define separate unique source IDs for each of your different source instances.
EFFECTIVE_FROM_DT	TIMESTAMP		6	This column stores the date from which the dimension record is effective. A value is either assigned by Siebel Applications or extracted from the source.
INTEGRATION_ID	VARCHAR2	80 CHAR		This column is the unique identifier of a dimension or fact entity in its source system. In case of composite keys, the value in this column can consist of concatenated parts.
ACTIVE_FLG	VARCHAR2	1 CHAR		Indicate if the current location active.
ADDRESS_TYPE_CODE	VARCHAR2	80 CHAR		Identifies the address type code for the location.
AUX1_CHANGED_ON_DT	TIMESTAMP		6	System field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table.
AUX2_CHANGED_ON_DT	TIMESTAMP		6	System field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table.
AUX3_CHANGED_ON_DT	TIMESTAMP		6	System field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table.
AUX4_CHANGED_ON_DT	TIMESTAMP		6	System field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table.
BUSN_LOC_NUM	VARCHAR2	255 CHAR		Identifies the location number of the business location.
CHANGED_BY_WID	NUMBER		38	This is a foreign key to the DW_EB_X_EBS_COMMON_W_USER_D dimension indicating the user who last modified the record in the source system.	DW_EB_X_EBS_COMMON_W_USER_D
CHANGED_ON_DT	TIMESTAMP		6	Identifies the date and time when the record was last modified in the source system.
CITY_CODE	VARCHAR2	120 CHAR		Identifies the source city code in source system.
CITY_DATASOURCE_NUM_ID	NUMBER		10
CITY_INTEGRATION_ID	VARCHAR2	80 CHAR
CONTACT_NAME	VARCHAR2	255 CHAR		Identifies the name of the contact person for a given location.
CONTACT_NUM	VARCHAR2	30 CHAR		Identifies the contact number of the business location.
COUNTRY_REGION_CODE	VARCHAR2	120 CHAR		Identifies the source country region code in source system.
COUNTY_CODE	VARCHAR2	120 CHAR		Identifies the source county code in source system.
CREATED_BY_WID	NUMBER		38	This is a foreign key to the DW_EB_X_EBS_COMMON_W_USER_D dimension indicating the user who created the record in the source system.	DW_EB_X_EBS_COMMON_W_USER_D
CREATED_ON_DT	TIMESTAMP		6	Identifies the date and time when the record was initially created in the source system.
CURRENT_FLG	VARCHAR2	1 CHAR		This is a flag for marking dimension records as "Y" in order to represent the current state of a dimension entity. This flag is typically critical for Type II slowly-changing dimensions, as records in a Type II situation tend to be numerous.
C_CITY_CODE	VARCHAR2	120 CHAR		Identifies the customer conformed city domain code.
C_COUNTRY_REGION_CODE	VARCHAR2	120 CHAR		Identifies the customer conformed country region domain code. Country region is the geography district below country and above state/province.
C_COUNTY_CODE	VARCHAR2	120 CHAR		Identifies the customer conformed county domain code.
C_REGION_CODE	VARCHAR2	120 CHAR		Identifies the customer conformed region domain code.
C_STATE_PROV_CODE	VARCHAR2	120 CHAR		Identifies the customer conformed state or province domain code.
DELETE_FLG	VARCHAR2	1 CHAR		This flag indicates the deletion status of the record in the source system. A value of "Y" indicates that the record is deleted from the source system and logically deleted from the data warehouse; a value of "N" indicates that the record is active.
EFFECTIVE_TO_DT	TIMESTAMP		6	This column stores the date up to which the dimension record is effective. A value is either assigned by Siebel Applications or extracted from the source.
EMAIL_ADDRESS	VARCHAR2	255 CHAR		Identifies the email address of the location.
ETL_PROC_WID	NUMBER		38	System Field. This column is the unique identifier for the specific ETL process used to create or update this data.
FAX_NUM	VARCHAR2	60 CHAR		Identifies the fax number of the location.
GEO_COUNTRY_WID	NUMBER		38	Foreign key to the geography country dimension DW_EB_X_EBS_COMMON_W_GEO_COUNTRY_D.	DW_EB_X_EBS_COMMON_W_GEO_COUNTRY_D
GEO_WID	NUMBER		38	Foreign key to the geography dimension DW_EB_X_EBS_COMMON_W_GEO_D.	DW_EB_X_EBS_COMMON_W_GEO_D
LOCATOR_ID	VARCHAR2	80 CHAR		Inventory locator identifier.
LOCATOR_LVL_INT_ID	VARCHAR2	80 CHAR		The INTEGRATION_ID for stock locator level in the inventory locator hierarchy.
LOCATOR_TYPE_CODE	VARCHAR2	80 CHAR		Identifies the source locator type code
LOC_ATTR_CHAR_001	VARCHAR2	255 CHAR
LOC_ATTR_CHAR_002	VARCHAR2	255 CHAR
LOC_ATTR_CHAR_003	VARCHAR2	255 CHAR
LOC_ATTR_CHAR_004	VARCHAR2	255 CHAR
LOC_ATTR_CHAR_005	VARCHAR2	255 CHAR
LOC_ATTR_CHAR_006	VARCHAR2	255 CHAR
LOC_ATTR_CHAR_007	VARCHAR2	255 CHAR
LOC_ATTR_CHAR_008	VARCHAR2	255 CHAR
LOC_ATTR_CHAR_009	VARCHAR2	255 CHAR
LOC_ATTR_CHAR_010	VARCHAR2	255 CHAR
LOC_ATTR_CHAR_011	VARCHAR2	255 CHAR
LOC_ATTR_CHAR_012	VARCHAR2	255 CHAR
LOC_ATTR_CHAR_013	VARCHAR2	255 CHAR
LOC_ATTR_CHAR_014	VARCHAR2	255 CHAR
LOC_ATTR_CHAR_015	VARCHAR2	255 CHAR
LOC_ATTR_CHAR_016	VARCHAR2	255 CHAR
LOC_ATTR_CHAR_017	VARCHAR2	255 CHAR
LOC_ATTR_CHAR_018	VARCHAR2	255 CHAR
LOC_ATTR_CHAR_019	VARCHAR2	255 CHAR
LOC_ATTR_CHAR_020	VARCHAR2	255 CHAR
LOC_ATTR_CHAR_021	VARCHAR2	255 CHAR
LOC_ATTR_CHAR_022	VARCHAR2	255 CHAR
LOC_ATTR_CHAR_023	VARCHAR2	255 CHAR
LOC_ATTR_CHAR_024	VARCHAR2	255 CHAR
LOC_ATTR_CHAR_025	VARCHAR2	255 CHAR
LOC_ATTR_CHAR_026	VARCHAR2	255 CHAR
LOC_ATTR_CHAR_027	VARCHAR2	255 CHAR
LOC_ATTR_CHAR_028	VARCHAR2	255 CHAR
LOC_ATTR_CHAR_029	VARCHAR2	255 CHAR
LOC_ATTR_CHAR_030	VARCHAR2	255 CHAR
LOC_ATTR_DATE_001	TIMESTAMP		6
LOC_ATTR_DATE_002	TIMESTAMP		6
LOC_ATTR_DATE_003	TIMESTAMP		6
LOC_ATTR_DATE_004	TIMESTAMP		6
LOC_ATTR_DATE_005	TIMESTAMP		6
LOC_ATTR_DATE_006	TIMESTAMP		6
LOC_ATTR_DATE_007	TIMESTAMP		6
LOC_ATTR_DATE_008	TIMESTAMP		6
LOC_ATTR_DATE_009	TIMESTAMP		6
LOC_ATTR_DATE_010	TIMESTAMP		6
LOC_ATTR_DATE_011	TIMESTAMP		6
LOC_ATTR_DATE_012	TIMESTAMP		6
LOC_ATTR_DATE_013	TIMESTAMP		6
LOC_ATTR_DATE_014	TIMESTAMP		6
LOC_ATTR_DATE_015	TIMESTAMP		6
LOC_ATTR_NUM_001	NUMBER
LOC_ATTR_NUM_002	NUMBER
LOC_ATTR_NUM_003	NUMBER
LOC_ATTR_NUM_004	NUMBER
LOC_ATTR_NUM_005	NUMBER
LOC_ATTR_NUM_006	NUMBER
LOC_ATTR_NUM_007	NUMBER
LOC_ATTR_NUM_008	NUMBER
LOC_ATTR_NUM_009	NUMBER
LOC_ATTR_NUM_010	NUMBER
LOC_ATTR_NUM_011	NUMBER
LOC_ATTR_NUM_012	NUMBER
LOC_ATTR_NUM_013	NUMBER
LOC_ATTR_NUM_014	NUMBER
LOC_ATTR_NUM_015	NUMBER
LOC_ATTR_NUM_016	NUMBER
LOC_ATTR_NUM_017	NUMBER
LOC_ATTR_NUM_018	NUMBER
LOC_ATTR_NUM_019	NUMBER
LOC_ATTR_NUM_020	NUMBER
ORGANIZATION_CODE	VARCHAR2	80 CHAR		Identify organication code.
ORGANIZATION_ID	VARCHAR2	80 CHAR		Organization identifier.
ORG_LVL_INT_ID	VARCHAR2	80 CHAR		The INTEGRATION_ID for organization level in the inventory locator hierarchy.
PARENT_LOC_NUM	VARCHAR2	80 CHAR		Identifies the parent location name with which the current location is associated.
PHONE_NUM	VARCHAR2	60 CHAR		Identifies the phone number of the location.
POSTAL_CODE	VARCHAR2	120 CHAR		Identifies postal code.
REGION_CODE	VARCHAR2	120 CHAR		Identifies the source region code in source system.
ROW_WID	NUMBER		38	Surrogate key to uniquely identify a record.
SET_ID	VARCHAR2	30 CHAR		This column represents a unique identifier used by source systems for the purpose of data sharing, reducing redundancies and minimizing system maintenance tasks, or even to drive data visibility. From a datawarehouse standpoint, the intended use of this column is to drive dimensional data security, primarily.
SRC_EFF_FROM_DT	TIMESTAMP		6	This column stores the date from which the source record (in the Source system) is effective. The value is extracted from the source (whenever available)
SRC_EFF_TO_DT	TIMESTAMP		6	This column stores the date up to which the source record (in the Source system) is effective. The value is extracted from the source (whenever available)
STATE_DATASOURCE_NUM_ID	NUMBER		10
STATE_PROV_CODE	VARCHAR2	120 CHAR		Identifies the source state or province code in source system.
STATE_PROV_INTEGRATION_ID	VARCHAR2	80 CHAR
ST_ADDRESS1	VARCHAR2	255 CHAR		Identifies the later part of the street address
ST_ADDRESS2	VARCHAR2	255 CHAR		Identifies the later part of the street address
SUBINVENTORY_TYPE_CODE	VARCHAR2	80 CHAR		Identifies subinventory type.
SUBINV_LVL_INT_ID	VARCHAR2	80 CHAR		The INTEGRATION_ID for subinventory level in the inventory locator hierarchy.
TENANT_ID	VARCHAR2	80 CHAR		This column is the unique identifier for a Tenant in a multi-tenant environment. This would typically be used in an Application Service Provider (ASP) / Software As a Service (SOAS) model.
WEB_ADDRESS	VARCHAR2	255 CHAR		Identifies the web address of the location.
W_BUSN_LOC_TYPE_CODE	VARCHAR2	80 CHAR		Categorizes the business location by the type of location. Examples include warehouse, customer center, branch, plant, inventory location, shipping location, etc.
W_COUNTRY_CODE	VARCHAR2	120 CHAR		Identifies the data warehouse conformed country domain code.
X_CUSTOM	VARCHAR2	10 CHAR		This column is used as a generic field for customer extensions.
W$_INSERT_DT	TIMESTAMP		6
W$_UPDATE_DT	TIMESTAMP		6