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 |