call_center_dimension

This table describes all the chain’s call centers.

Column Name Data Type NULLs
call_center_key
INTEGER No
cc_closed_date
DATE Yes
cc_open_date
DATE Yes
cc_date
VARCHAR(50) Yes

cc_class

VARCHAR(50) Yes
cc_employees
INTEGER Yes
cc_hours
CHAR(20) Yes
cc_manager
VARCHAR(40) Yes
cc_address
VARCHAR(256) Yes
cc_city
VARCHAR(64) Yes
cc_state
CHAR(2) Yes
cc_region
VARCHAR(64) Yes