employment_history
Pay and position changes over each person's time at the resort. One row is one period at one pay rate.
- One row is
- one period at one pay rate
- Columns
- 8
- Rows in Sample
- 47,804
- Rows in Standard
- 47,804
- Rows in Full
- 47,804
This table describes the company, not individual guests, so it is identical in all three sizes.
Columns
| Column | Type | What it holds | Values or range |
|---|---|---|---|
| history_idkey | integer | Unique id for the row. | |
| employee_id | integer | Links to employees. | |
| effective_date | date | First day of the period. | 2001-01-12 to 2026-01-01 |
| end_date | date | Last day of the period. Empty when current. Can be empty. | 2018-01-01 to 2026-01-01 |
| action | text | What started the period: hire, raise, promotion, or leaving. | hired; merit increase; promotion; separated: dismissed; separated: end of season; separated: resigned; separated: retired; wage adjustment |
| position_id | integer | Links to positions. | |
| pay_type | text | Hourly or salary. | hourly; salary |
| pay_rate | decimal | Dollars per hour, or dollars per year for salary. | 8.08 to 168,500 |
How it connects
This table points to
- employee_id matches employees.employee_id
- position_id matches positions.position_id
First five rows
Taken from the Sample size, exactly as they appear in the file. Empty cells are empty in the data.
| history_id | employee_id | effective_date | end_date | action | position_id | pay_type | pay_rate |
|---|---|---|---|---|---|---|---|
| 1 | 200001 | 2020-12-06 | 2022-01-31 | hired | 401 | hourly | 11.31 |
| 2 | 200001 | 2022-02-01 | 2022-02-13 | merit increase | 401 | hourly | 11.62 |
| 3 | 200001 | 2022-02-13 | separated: dismissed | 401 | hourly | 11.62 | |
| 4 | 200002 | 2019-06-28 | 2020-01-31 | hired | 201 | hourly | 10.46 |
| 5 | 200002 | 2020-02-01 | 2021-01-31 | merit increase | 201 | hourly | 10.78 |