Table: dim_account_contact

Type: Dimension Columns: 16

Description

Account contact information. The data grain is contacts within accounts.

Columns

Column Name Description
contact_id

Unique identifier for the contact (A contact may belong to more than one account)

account_id

Unique identifier for the account

business_id

Unique identifier for the business

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

mobile_phone

The mobile phone number of the contact

home_phone

The home phone number of the contact

work_phone

The work phone number of the contact

country

The country where the contact is located

state

The state where the contact is located

city

The city where the contact is located

postal_code

The postal code of the contact's address

address

The first line of the contact's address