shifts
Scheduled shifts for hourly staff. One row is one person's shift on one day.
- One row is
- one person's shift on one day
- Columns
- 8
- Rows in Sample
- 3,490,509
- Rows in Standard
- 3,490,509
- Rows in Full
- 3,490,509
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 |
|---|---|---|---|
| shift_idkey | integer | Unique id for the row. | |
| employee_id | integer | Links to employees. | |
| location_id | integer | The work location. Links to work_locations. | |
| shift_date | date | The day. | 2018-01-01 to 2025-12-31 |
| scheduled_start | date and time | Planned start. | 2018-01-01 04:30 to 2025-12-31 18:00 |
| scheduled_end | date and time | Planned end. | 2018-01-01 11:00 to 2026-01-01 00:30 |
| status | text | Worked, or called out. | called out; worked |
| hours_worked | decimal | Hours actually worked. 0 when called out. | 0 to 10 |
How it connects
This table points to
- employee_id matches employees.employee_id
- location_id matches work_locations.location_id
First five rows
Taken from the Sample size, exactly as they appear in the file. Empty cells are empty in the data.
| shift_id | employee_id | location_id | shift_date | scheduled_start | scheduled_end | status | hours_worked |
|---|---|---|---|---|---|---|---|
| 500000001 | 203235 | 124 | 2018-01-01 | 2018-01-01 04:30:00 | 2018-01-01 13:00:00 | worked | 8 |
| 500000002 | 207290 | 124 | 2018-01-01 | 2018-01-01 04:30:00 | 2018-01-01 13:00:00 | worked | 8 |
| 500000003 | 200187 | 124 | 2018-01-01 | 2018-01-01 04:30:00 | 2018-01-01 13:00:00 | worked | 8 |
| 500000004 | 205613 | 124 | 2018-01-01 | 2018-01-01 04:30:00 | 2018-01-01 13:00:00 | worked | 8 |
| 500000005 | 205001 | 124 | 2018-01-01 | 2018-01-01 04:30:00 | 2018-01-01 13:00:00 | worked | 8 |