ccdw_dim_customer

This table contains detailed information about registered customers. Unregistered buyers (guest checkouts) aren’t included in this table. In fact tables, records for unregistered buyers have customer_id = 1, which can’t be used to distinguish one unregistered buyer from another.

Column Alias	Data Type	Key	Description	Index?
`customer_id (PK)`	BIGINT	PK	Unique identifier for a customer.	Yes
`ncustomer_id`	VARCHAR		Natural key of the customer, representing the ID of the customer in the source system.	Yes
`login`	VARCHAR		Customer’s login name or ID.	No
`salutation`	VARCHAR		Customer’s salutation (for example, “Mr.”, “Ms.”).	No
`title`	VARCHAR		Customer’s title.	No
`job_title`	VARCHAR		Customer’s job title.	No
`first_name`	VARCHAR		Customer’s first name.	No
`second_name`	VARCHAR		Customer’s middle name.	No
`last_name`	VARCHAR		Customer’s last name.	No
`suffix`	VARCHAR		Customer’s name suffix.	No
`gender`	VARCHAR		Customer’s gender.	No
`dob`	DATE		Customer’s date of birth.	No
`email_address`	VARCHAR		Customer’s email address.	No
`phone_home`	VARCHAR		Customer’s home phone number.	No
`phone_business`	VARCHAR		Customer’s business phone number.	No
`phone_mobile`	VARCHAR		Customer’s mobile phone number.	No
`fax`	VARCHAR		Customer’s fax number.	No
`repeat_buyer`	BOOLEAN		Boolean indicating if the customer is a repeat buyer.	No
`purchase_count`	INTEGER		Total number of purchases made by the customer.	No