DW_CXS_CONTACT_D

Contact resource dimension

Details

Module:

Key Columns

CONTACT_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
CONTACT_ID NUMBER 38 0 True Unique identifier for the Contact    
SOURCE_RECORD_ID VARCHAR2 64     Unique identifier    
FULL_NAME VARCHAR2 512     Competitor name.    
ADDRESS_LINE_1 VARCHAR2 256     Contact address line 1    
ADDRESS_LINE_2 VARCHAR2 256     Contact address line 2    
ADDRESS_LINE_3 VARCHAR2 256     Contact address line 3    
ADDRESS_LINE_4 VARCHAR2 256     Contact address line 4    
CITY VARCHAR2 64     City    
STATE VARCHAR2 64     State    
POSTAL_CODE VARCHAR2 64     Postal Code    
JOB_TITLE VARCHAR2 128     Job Title of Contact    
EMAIL_ADDRESS VARCHAR2 512     Email Address of Contact    
COUNTRY VARCHAR2 16     Country    
CONTACT_OWNER_ID NUMBER 38 0   Party identifier for sales resource marked as owner for contact DW_CXS_RESOURCE_D RESOURCE_ID
CONTACT_TYPE_CODE VARCHAR2 64     Contact type DW_CXS_CONTACT_TYPE_CODE_D_TL CODE
COUNTY VARCHAR2 64     County    
LATITUDE NUMBER       Latitude    
LONGITUDE NUMBER       Longitude    
INTERNAL_STATUS VARCHAR2 16     Internal status of a sales account    
PROVINCE VARCHAR2 64     Province    
PRIMARY_CUSTOMER_ID NUMBER 38 0   Primary Customer Identifier    
SALES_ACCOUNT_ID NUMBER 38 0   Sales account identifier    

Copyright © 2019, 2023, Oracle and/or its affiliates.