Book Contents

Book Index

Next Topic

Home

Customer_Dimension

This table describes details of customers whose credit history is maintained by the company.

Field Name

Data Type

Description/Example

Customer_Key

Integer

Primary Key

Customer_FirstName

Varchar

Customer First Name

Customer_LastName

Varchar

Customer Last Name

Current_Employer

Varchar

Current Employer

SSN

Varchar

Social Security Number

HomePhone

Varchar

Home phone

Age

Varchar

Customer Age

Sex

Varchar

Customer Sex

City

Varchar

Customer City

State

Integer

Customer Sate

Zip

Varchar

Zip code