employee_dimension

This table contains information about all the people who work for the retail chain.

Column Name Data Type NULLs
employee_key
INTEGER No
employee_gender
VARCHAR(8) Yes
courtesy_title
VARCHAR(8) Yes
employee_first_name
VARCHAR(64) Yes
employee_middle_initial
VARCHAR(8) Yes
employee_last_name
VARCHAR(64) Yes
employee_age
INTEGER Yes
hire_date
DATE Yes
employee_street_address
VARCHAR(256) Yes
employee_city
VARCHAR(64) Yes
employee_state
CHAR(2) Yes
employee_region
CHAR(32) Yes
job_title
VARCHAR(64) Yes
reports_to
INTEGER Yes
salaried_flag
INTEGER Yes
annual_salary
INTEGER Yes
hourly_rate
FLOAT Yes
vacation_days
INTEGER Yes