DW_EB_X_EBS_COMMON_W_PARTY_D
Party Dimension includes all parties include B2B Customer and B2C Customer, Contact and Supplier data
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 |
|---|---|---|---|---|---|---|
| ROW_WID | NUMBER | 38 | True | Surrogate key to uniquely identify a record | ||
| ACCNT_FLG | VARCHAR2 | 1 CHAR | Account Flag | |||
| ACTIVE_FLG | VARCHAR2 | 1 CHAR | Active Flag | |||
| ALT_PHONE_NUM | VARCHAR2 | 30 CHAR | This is the customer's optional secondary phone number. | |||
| ANNL_INCOME | NUMBER | 28,10 | Annual Income | |||
| ANNUAL_REVENUE | NUMBER | 28,10 | Annual Revenue | |||
| 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. | |||
| AUX_CLASS_1_WID | NUMBER | 38 | Auxillary1 Class Wid | |||
| AUX_CLASS_2_WID | NUMBER | 38 | Auxillary2 Class Wid | |||
| AUX_CLASS_3_WID | NUMBER | 38 | Auxillary3 Class Wid | |||
| BASE_CURCY_CD | VARCHAR2 | 20 CHAR | Base Currency Code | |||
| BIRTH_DT | TIMESTAMP | 6 | Date of Birth of a Customer. | |||
| BIRTH_PLACE | VARCHAR2 | 100 CHAR | Place of Birth of a Customer | |||
| CHANGED_BY_WID | NUMBER | 38 | 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 | Source City Code | |||
| COMPETITOR_FLG | VARCHAR2 | 1 CHAR | Denotes whether an account is a competitor or not | |||
| COMPTR_PROD_PURCH_FLG | VARCHAR2 | 1 CHAR | Competitor Product Purchased Flag | |||
| CONTACT_FLG | VARCHAR2 | 1 CHAR | Contact Flag | |||
| COUNTRY_CODE | VARCHAR2 | 120 CHAR | Source Country Code | |||
| 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. | |||
| CREATED_SOURCE_CODE | VARCHAR2 | 80 CHAR | ||||
| 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_NUM | VARCHAR2 | 80 CHAR | This is the customer number that is unique for each customer. | |||
| CUST_CAT_CODE | VARCHAR2 | 80 CHAR | This identifies the category to which the customer belongs. | |||
| CUST_END_DT | TIMESTAMP | 6 | Customer End Date | |||
| CUST_SINCE_DT | TIMESTAMP | 6 | Customer Since Date | |||
| C_CITY_CODE | VARCHAR2 | 120 CHAR | Customized City Code | |||
| C_CONTINENT_CODE | VARCHAR2 | 120 CHAR | Customized Continent Code | |||
| C_COUNTRY_REGION_CODE | VARCHAR2 | 120 CHAR | Customized Country Region Code | |||
| C_COUNTY_CODE | VARCHAR2 | 120 CHAR | Customized County Code | |||
| C_REGION_CODE | VARCHAR2 | 120 CHAR | Customized Region Code | |||
| C_STATE_PROV_CODE | VARCHAR2 | 120 CHAR | ||||
| 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. | |||
| 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. | |||
| DUNS_NUM | VARCHAR2 | 15 CHAR | DUNS number | |||
| EDUCATION_BCKGND_CODE | VARCHAR2 | 80 CHAR | Education Background Code. | |||
| 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. | |||
| 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 email address of the customer. | |||
| EMP_COUNT | NUMBER | 28,10 | Number of Employee | |||
| EMP_FLG | VARCHAR2 | 1 CHAR | Employee Flag | |||
| ETHNICITY_CODE | VARCHAR2 | 80 CHAR | Ethnicity Code | |||
| 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. | |||
| EXIST_SALES_ACCNT_FLG | VARCHAR2 | 1 CHAR | Existing Sales Account Flag | |||
| FREQUENCY_SCORE | NUMBER | 5 | Frequency Score | |||
| GEO_WID | NUMBER | 38 | Geo Wid | DW_EB_X_EBS_COMMON_W_GEO_D | ||
| INDUSTRY_CODE | VARCHAR2 | 80 CHAR | Industry Code | |||
| INDUSTRY_WID | NUMBER | 38 | Industry Wid | DW_EB_X_EBS_COMMON_W_INDUSTRY_DH | ||
| INSTALL_BASE_FLG | VARCHAR2 | 1 CHAR | Installed Based Flag | |||
| 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. | |||
| INTERNET_HOME_PAGE | VARCHAR2 | 255 CHAR | This is the home page of the individual/organization. | |||
| LAST_CONTACT_DT | TIMESTAMP | 6 | Last Contacted Date | |||
| LAST_PROD_PURCH_DT | TIMESTAMP | 6 | Last Product Purchased Date | |||
| LAST_PURCH_PROD_ID | VARCHAR2 | 80 CHAR | Last Purchased Product ID | |||
| LEGAL_ENTITY_FLG | VARCHAR2 | 1 CHAR | Legal Entity Flag | |||
| LINE_OF_BUSINESS | VARCHAR2 | 240 CHAR | ||||
| MAIN_PH_NUM | VARCHAR2 | 40 CHAR | This is the customer's primary phone number. | |||
| MANUFACTURER_FLG | VARCHAR2 | 1 CHAR | ||||
| MARITAL_STAT_CODE | VARCHAR2 | 80 CHAR | Marital Status Code. | |||
| MARKETING_MODULE_FLG | VARCHAR2 | 1 CHAR | CRM Module Flag for Marketing | |||
| MONETARY_SCORE | NUMBER | 5 | Monetary Score | |||
| NAME | VARCHAR2 | 250 CHAR | This is the name of the customer & Name of the Account. | |||
| NUM_CONTACTED_LAST_MONTH | NUMBER | 5 | Number of Times Contacted Last Month. | |||
| NUM_CONTACTS | NUMBER | 5 | Number of Contacts | |||
| NUM_OPEN_SR | NUMBER | 5 | Number of Open Service Requests | |||
| NUM_PROD | NUMBER | 10 | Number of products | |||
| NUM_PROD_EFF_DT | TIMESTAMP | 6 | Number of products Effective Date | |||
| ORG_SIZE_CODE | VARCHAR2 | 80 CHAR | Organization Size Code. | |||
| ORG_TYPE_WID | NUMBER | 38 | Organization Type Wid. | |||
| PARTY_GROUP_WID | NUMBER | 38 | Party Group Wid | |||
| PARTY_ORG_WID | NUMBER | 38 | Party Organization Wid | DW_EB_X_EBS_COMMON_W_PARTY_ORG_D | ||
| PARTY_PER_WID | NUMBER | 38 | Party Person Wid | DW_EB_X_EBS_COMMON_W_PARTY_PER_D | ||
| PARTY_UNIQUE_NAME | VARCHAR2 | 250 CHAR | Customer Unique Name | |||
| POSTAL_CODE | VARCHAR2 | 120 CHAR | Postal Code or Zipcode | |||
| PRIMARY_PHONE_AREA_CODE | VARCHAR2 | 10 CHAR | This is the customer's primary phone number. | |||
| PRI_CONTACT_NAME | VARCHAR2 | 255 CHAR | Primary Contact Name of a Customer. | |||
| PRI_CONTACT_PHONE_NUM | VARCHAR2 | 40 CHAR | Primary Contact Phone Number | |||
| PROSPECT_FLG | VARCHAR2 | 1 CHAR | Prospect Flag | |||
| PRTNR_FLG | VARCHAR2 | 1 CHAR | Prtnr Flag | |||
| PTNTL_SLS_VOL | NUMBER | 28,10 | Ptntl Sls Vol | |||
| RECENCY_SCORE | NUMBER | 5 | Recency Score | |||
| REGION_CODE | VARCHAR2 | 120 CHAR | Source Region Code | |||
| RFM_SCORE | NUMBER | 5 | Recency Frequency and Monetary Score | |||
| SALES_ACCNT_FLG | VARCHAR2 | 1 CHAR | Sales Account Flag | |||
| SALES_ACCNT_TYPE_CODE | VARCHAR2 | 80 CHAR | Sales Account Flag | |||
| SALES_MODULE_FLG | VARCHAR2 | 1 CHAR | CRM Module Flag for Sales | |||
| SALES_REF_FLG | VARCHAR2 | 1 CHAR | Sales Ref Flag | |||
| SCD1_WID | NUMBER | 38 | Slow Changing Type 1 WID | |||
| SERVICE_MODULE_FLG | VARCHAR2 | 1 CHAR | CRM Module Flag for Service | |||
| SEX_MF_CODE | VARCHAR2 | 50 CHAR | Gender | |||
| SIC_CODE | VARCHAR2 | 80 CHAR | This is the Standard Industry Classification for the organization. | |||
| SOLICITATION_FLG | VARCHAR2 | 1 CHAR | Solicitation Flag | |||
| 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) | |||
| SRV_PROVDR_FLG | VARCHAR2 | 1 CHAR | Service Provider Flag | |||
| STATE_CODE | VARCHAR2 | 120 CHAR | Source State Code | |||
| ST_ADDRESS1 | VARCHAR2 | 255 CHAR | Street address1 where account is situated | |||
| ST_ADDRESS2 | VARCHAR2 | 200 CHAR | Street address2 where account is situated | |||
| ST_ADDRESS3 | VARCHAR2 | 200 CHAR | Street address3 where account is situated | |||
| ST_ADDRESS4 | VARCHAR2 | 200 CHAR | Street address4 where account is situated | |||
| SUPPLIER_FLG | VARCHAR2 | 1 CHAR | Supplier Flag | |||
| SUPPLIER_ID | VARCHAR2 | 80 CHAR | Supplier Id | |||
| SUPPLIER_NUM | VARCHAR2 | 30 CHAR | Supplier Number | |||
| SUPPLIER_TYPE_CODE | VARCHAR2 | 80 CHAR | Supplier Type Code | |||
| SUPPRESS_CALL_FLG | VARCHAR2 | 1 CHAR | Never Call Flag | |||
| SUPPRESS_EMAIL_FLG | VARCHAR2 | 1 CHAR | Never Email Flag | |||
| SUPPRESS_MAIL_FLG | VARCHAR2 | 1 CHAR | Never Mail Flag | |||
| 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. | |||
| TOT_GLOBAL1_ASSET_REV | NUMBER | 28,10 | Total Asset Revenue | |||
| TOT_GLOBAL1_LEAD_REV | NUMBER | 28,10 | Total Predicted Revenue | |||
| TOT_GLOBAL2_ASSET_REV | NUMBER | 28,10 | Total Asset Revenue | |||
| TOT_GLOBAL2_LEAD_REV | NUMBER | 28,10 | Total Predicted Revenue | |||
| TOT_GLOBAL3_ASSET_REV | NUMBER | 28,10 | Total Asset Revenue | |||
| TOT_GLOBAL3_LEAD_REV | NUMBER | 28,10 | Total Predicted Revenue | |||
| TOT_GLOBAL4_ASSET_REV | NUMBER | 28,10 | Total Asset Revenue | |||
| TOT_GLOBAL4_LEAD_REV | NUMBER | 28,10 | Total Predicted Revenue | |||
| TOT_GLOBAL5_ASSET_REV | NUMBER | 28,10 | Total Asset Revenue | |||
| TOT_GLOBAL5_LEAD_REV | NUMBER | 28,10 | Total Predicted Revenue | |||
| VIS_PR_BU_ID | VARCHAR2 | 15 CHAR | Visibility Primary BU | |||
| VIS_PR_POSTN_DH_WID | NUMBER | 38 | Vis Pr Postn Dh Wid | DW_EB_X_EBS_COMMON_W_POSITION_DH | ||
| VIS_PR_POS_ID | VARCHAR2 | 15 CHAR | Visibility Primary BU Name | |||
| W_COUNTRY_CODE | VARCHAR2 | 120 CHAR | ||||
| W_CRM_MODULE_CODE | VARCHAR2 | 80 CHAR | CRM Module Code | |||
| W_FREQUENCY_CAT_CODE | VARCHAR2 | 80 CHAR | Frequency Category Code | |||
| W_MONETARY_CAT_CODE | VARCHAR2 | 80 CHAR | Monetary Category Code | |||
| W_PARTY_TYPE_CODE | VARCHAR2 | 80 CHAR | Type of account, e.g. Commercial | |||
| W_RECENCY_CAT_CODE | VARCHAR2 | 80 CHAR | Recency Category | |||
| X_CUSTOM | VARCHAR2 | 10 CHAR | This column is used as a generic field for customer extensions. | |||
| X_NUM_PROD | NUMBER | 10 | Number of products Extensions | |||
| W$_INSERT_DT | TIMESTAMP | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 6 |