DW_EB_X_EBS_COMMON_W_CUSTOMER_LOC_D
This table stores customer locations.
Details
Module: Common Tables (EBS_COMMON)
Key Columns
Key column information is not documented in the supplied metadata.
Columns
| Name | Datatype | Length | Precision | Not Null | 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, Siebel 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 | Indicates if customer location is active. | |||
| ADDRESS_TITLE | VARCHAR2 | 255 CHAR | This is the title of the address. | |||
| ADDR_LATITUDE | NUMBER | 22,10 | This is the latitude geographical location identifier for the address in degrees, minutes, seconds and hundredths of a second. | |||
| ADDR_LONGITUDE | NUMBER | 22,10 | This is the longitude geographical location identifier for the address in degrees, minutes, seconds and hundredths of a second. | |||
| AUTO_ROUTING_CODE | VARCHAR2 | 50 CHAR | This is the automatic routing code. | |||
| AUX1_CHANGED_ON_DT | TIMESTAMP | 6 | Siebel 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 | Siebel 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 | Siebel 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 | Siebel 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. | |||
| 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 | VARCHAR2 | 120 CHAR | This is the city of the customer location. | |||
| COUNTRY_CODE | VARCHAR2 | 120 CHAR | This code identifies the country code of the customer location. For example, USA stands for United States of America, UK stands for United Kingdom etc. | |||
| COUNTRY_REGION | VARCHAR2 | 120 CHAR | This code indentifies the country region of the customer location. | |||
| COUNTY | VARCHAR2 | 120 CHAR | This is the name of the county of the customer location. | |||
| 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. | |||
| CUSTOMER_WID | NUMBER | 38 | Identifies the customer. This is an obsoleted column and not used by downstream fact tables. Hence it is defaulted to '0' in the mapping. It is retained to support upgrade and patching. It may get deprecated in the future releases. | DW_EB_X_EBS_COMMON_W_PARTY_D | ||
| C_CITY_CODE | VARCHAR2 | 120 CHAR | Bill To Location City Code | |||
| C_CONTINENT_CODE | VARCHAR2 | 120 CHAR | Bill To Location Continent Code | |||
| C_COUNTRY_REGION_CODE | VARCHAR2 | 120 CHAR | Bill To Location Country Region Code | |||
| C_COUNTY_CODE | VARCHAR2 | 120 CHAR | Bill To Location County Code | |||
| C_REGION_CODE | VARCHAR2 | 120 CHAR | Bill To Location Region Code | |||
| C_STATE_PROV_CODE | VARCHAR2 | 120 CHAR | Bill To Location State 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 | This is the e-mail address of the customer location. | |||
| ETL_PROC_WID | NUMBER | 38 | Siebel System Field. This column is the unique identifier for the specific ETL process used to create or update this data. | |||
| FAX_NUM | VARCHAR2 | 30 CHAR | This is the facsimile number of the customer location. | |||
| GEO_WID | NUMBER | 38 | Geo wid | |||
| PHONE_NUM | VARCHAR2 | 30 CHAR | This is the phone number of the customer location. | |||
| POSTAL_CODE | VARCHAR2 | 120 CHAR | This is the postal code of the customer location. | |||
| PRMRY_CNTCT_NAME | VARCHAR2 | 255 CHAR | This is the primary contact name of this customer location. | |||
| ROW_WID | NUMBER | 38 | Surrogate key to uniquely identify a record. | |||
| SET_ID | VARCHAR2 | 30 CHAR | This column represents an unique identifier often 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_PROV_CODE | VARCHAR2 | 120 CHAR | This code identifies the state of the customer location. Examples include AZ, CA etc. | |||
| STATE_REGION | VARCHAR2 | 120 CHAR | This is the state region of the customer location. This is group of states. | |||
| ST_ADDRESS1 | VARCHAR2 | 255 CHAR | This is the street name of the customer location. | |||
| ST_ADDRESS2 | VARCHAR2 | 255 CHAR | This is the street number of the customer location. | |||
| ST_ADDRESS3 | VARCHAR2 | 255 CHAR | This is the street description of the address. | |||
| ST_ADDRESS4 | VARCHAR2 | 255 CHAR | This is the street description of the address. | |||
| 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 | This is the web site address of the customer location. | |||
| W_COUNTRY_CODE | VARCHAR2 | 120 CHAR | Bill To Location Country 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 |