employee_dimension

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

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