Skip to content

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

ColumnTypeWhat it holdsValues or range
history_idkeyintegerUnique id for the row.
employee_idintegerLinks to employees.
effective_datedateFirst day of the period.2001-01-12 to 2026-01-01
end_datedateLast day of the period. Empty when current. Can be empty.2018-01-01 to 2026-01-01
actiontextWhat 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_idintegerLinks to positions.
pay_typetextHourly or salary.hourly; salary
pay_ratedecimalDollars per hour, or dollars per year for salary.8.08 to 168,500

How it connects

First five rows

Taken from the Sample size, exactly as they appear in the file. Empty cells are empty in the data.

history_idemployee_ideffective_dateend_dateactionposition_idpay_typepay_rate
12000012020-12-062022-01-31hired401hourly11.31
22000012022-02-012022-02-13merit increase401hourly11.62
32000012022-02-13separated: dismissed401hourly11.62
42000022019-06-282020-01-31hired201hourly10.46
52000022020-02-012021-01-31merit increase201hourly10.78

Download from Kaggle