Payslip
Per-period earnings, taxes and deductions. Computed on demand from the employee record and the payroll calendar rather than stored: at roster scale this table would be tens of millions of rows per instance with no added information.
derived · primary key payslip_id · read-only
20 rows matching · page 1 of 1
| payslip_id | employee_id | employee_name | payroll_run_id | period_end | pay_date ↑ | gross_pay | net_pay |
|---|---|---|---|---|---|---|---|
| PAY-0162517-0020 | EMP-0162517 | Lucian A. Sinclair | RUN-0020 | 2024-05-12 | 2024-05-16 | $2,005 | $1,236 |
| PAY-0162517-0019 | EMP-0162517 | Lucian A. Sinclair | RUN-0019 | 2024-04-27 | 2024-05-01 | $2,005 | $1,236 |
| PAY-0162517-0018 | EMP-0162517 | Lucian A. Sinclair | RUN-0018 | 2024-04-12 | 2024-04-16 | $3,207 | $1,977 |
| PAY-0162517-0017 | EMP-0162517 | Lucian A. Sinclair | RUN-0017 | 2024-03-28 | 2024-04-01 | $2,005 | $1,236 |
| PAY-0162517-0016 | EMP-0162517 | Lucian A. Sinclair | RUN-0016 | 2024-03-13 | 2024-03-17 | $2,005 | $1,236 |
| PAY-0162517-0015 | EMP-0162517 | Lucian A. Sinclair | RUN-0015 | 2024-02-27 | 2024-03-02 | $2,005 | $1,236 |
| PAY-0162517-0014 | EMP-0162517 | Lucian A. Sinclair | RUN-0014 | 2024-02-12 | 2024-02-16 | $2,005 | $1,236 |
| PAY-0162517-0013 | EMP-0162517 | Lucian A. Sinclair | RUN-0013 | 2024-01-28 | 2024-02-01 | $2,005 | $1,236 |
| PAY-0162517-0012 | EMP-0162517 | Lucian A. Sinclair | RUN-0012 | 2024-01-13 | 2024-01-17 | $3,207 | $1,977 |
| PAY-0162517-0011 | EMP-0162517 | Lucian A. Sinclair | RUN-0011 | 2023-12-29 | 2024-01-02 | $2,005 | $1,236 |
| PAY-0162517-0010 | EMP-0162517 | Lucian A. Sinclair | RUN-0010 | 2023-12-14 | 2023-12-18 | $2,005 | $1,236 |
| PAY-0162517-0009 | EMP-0162517 | Lucian A. Sinclair | RUN-0009 | 2023-11-29 | 2023-12-03 | $2,005 | $1,236 |
| PAY-0162517-0008 | EMP-0162517 | Lucian A. Sinclair | RUN-0008 | 2023-11-14 | 2023-11-18 | $2,005 | $1,236 |
| PAY-0162517-0007 | EMP-0162517 | Lucian A. Sinclair | RUN-0007 | 2023-10-30 | 2023-11-03 | $2,005 | $1,236 |
| PAY-0162517-0006 | EMP-0162517 | Lucian A. Sinclair | RUN-0006 | 2023-10-15 | 2023-10-19 | $3,207 | $1,977 |
| PAY-0162517-0005 | EMP-0162517 | Lucian A. Sinclair | RUN-0005 | 2023-09-30 | 2023-10-04 | $2,005 | $1,236 |
| PAY-0162517-0004 | EMP-0162517 | Lucian A. Sinclair | RUN-0004 | 2023-09-15 | 2023-09-19 | $2,005 | $1,236 |
| PAY-0162517-0003 | EMP-0162517 | Lucian A. Sinclair | RUN-0003 | 2023-08-31 | 2023-09-04 | $2,005 | $1,236 |
| PAY-0162517-0002 | EMP-0162517 | Lucian A. Sinclair | RUN-0002 | 2023-08-16 | 2023-08-20 | $2,005 | $1,236 |
| PAY-0162517-0001 | EMP-0162517 | Lucian A. Sinclair | RUN-0001 | 2023-08-01 | 2023-08-05 | $2,005 | $1,236 |
Showing 1–20 of 20