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
12 rows matching · page 1 of 1
| payslip_id | employee_id | employee_name | payroll_run_id | period_end | pay_date ↑ | gross_pay | net_pay |
|---|---|---|---|---|---|---|---|
| PAY-0153423-0012 | EMP-0153423 | Frederick A. Leonard | RUN-0012 | 2024-01-13 | 2024-01-17 | $1,781 | $1,098 |
| PAY-0153423-0011 | EMP-0153423 | Frederick A. Leonard | RUN-0011 | 2023-12-29 | 2024-01-02 | $1,254 | $773 |
| PAY-0153423-0010 | EMP-0153423 | Frederick A. Leonard | RUN-0010 | 2023-12-14 | 2023-12-18 | $1,254 | $773 |
| PAY-0153423-0009 | EMP-0153423 | Frederick A. Leonard | RUN-0009 | 2023-11-29 | 2023-12-03 | $1,254 | $773 |
| PAY-0153423-0008 | EMP-0153423 | Frederick A. Leonard | RUN-0008 | 2023-11-14 | 2023-11-18 | $1,254 | $773 |
| PAY-0153423-0007 | EMP-0153423 | Frederick A. Leonard | RUN-0007 | 2023-10-30 | 2023-11-03 | $1,254 | $773 |
| PAY-0153423-0006 | EMP-0153423 | Frederick A. Leonard | RUN-0006 | 2023-10-15 | 2023-10-19 | $1,781 | $1,098 |
| PAY-0153423-0005 | EMP-0153423 | Frederick A. Leonard | RUN-0005 | 2023-09-30 | 2023-10-04 | $1,254 | $773 |
| PAY-0153423-0004 | EMP-0153423 | Frederick A. Leonard | RUN-0004 | 2023-09-15 | 2023-09-19 | $1,254 | $773 |
| PAY-0153423-0003 | EMP-0153423 | Frederick A. Leonard | RUN-0003 | 2023-08-31 | 2023-09-04 | $1,254 | $773 |
| PAY-0153423-0002 | EMP-0153423 | Frederick A. Leonard | RUN-0002 | 2023-08-16 | 2023-08-20 | $1,254 | $773 |
| PAY-0153423-0001 | EMP-0153423 | Frederick A. Leonard | RUN-0001 | 2023-08-01 | 2023-08-05 | $1,254 | $773 |
Showing 1–12 of 12