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 This column is for Oracle Internal use only. 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