payroll
Pay for each two-week period. One row is one person's pay for one period.
- One row is
- one person's pay for one period
- Columns
- 7
- Rows in Sample
- 494,485
- Rows in Standard
- 494,485
- Rows in Full
- 494,485
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 |
|---|---|---|---|
| payroll_idkey | integer | Unique id for the row. | |
| employee_id | integer | Links to employees. | |
| period_start | date | First day of the period. | 2018-01-01 to 2025-12-22 |
| period_end | date | Last day of the period. | 2018-01-14 to 2026-01-04 |
| regular_hours | decimal | Hours paid at the normal rate. | 6 to 80 |
| overtime_hours | decimal | Hours over 40 in a week, paid at time and a half. | 0 to 52 |
| gross_pay | decimal | Pay before deductions, in dollars. | 53.88 to 6,480.77 |
How it connects
This table points to
- employee_id matches employees.employee_id
First five rows
Taken from the Sample size, exactly as they appear in the file. Empty cells are empty in the data.
| payroll_id | employee_id | period_start | period_end | regular_hours | overtime_hours | gross_pay |
|---|---|---|---|---|---|---|
| 1 | 216966 | 2018-01-01 | 2018-01-14 | 36 | 0 | 337.32 |
| 2 | 204376 | 2018-01-01 | 2018-01-14 | 36 | 0 | 340.2 |
| 3 | 216325 | 2018-01-01 | 2018-01-14 | 30 | 0 | 300.9 |
| 4 | 208083 | 2018-01-01 | 2018-01-14 | 72 | 0 | 725.76 |
| 5 | 208174 | 2018-01-01 | 2018-01-14 | 30 | 0 | 291.9 |