Table: dim_customer_contact

Type: Dimension Columns: 8

Description

Customer contact information. The data grain is contacts within customer.

Columns

Column Name Description
customer_id

Unique identifier for the customer

contact_last_name

The last name of the contact

contact_first_name

The first name of the contact

contact_type

The type of contact; enumerated: 'Primary' or 'Non-Primary'

email

The email of the contact

primary_phone

The primary phone number of the contact

account_status

The status of the account; enumerated: 'Account' or 'No Account'

business_id

Unique identifier for the business