Time off balance
Accrued, taken and available leave per employee per leave type. Computed from tenure, the accrual policy and approved absences rather than stored.
derived · primary key balance_id · read-only
1,782,808 rows · page 3 of 71,313
| balance_id | employee_id ↑ | employee_name | leave_type_code | leave_type | accrued_days | taken_days | scheduled_days | available_days |
|---|---|---|---|---|---|---|---|---|
| BAL-0000007-2 | EMP-0000007 | Erin Murakami | PARENT | Parental leave | 32.9 | 0 | 0 | 32.9 |
| BAL-0000007-3 | EMP-0000007 | Erin Murakami | BEREAV | Bereavement leave | 2 | 0 | 0 | 2 |
| BAL-0000007-4 | EMP-0000007 | Erin Murakami | JURY | Jury duty | 3.9 | 0 | 0 | 3.9 |
| BAL-0000007-5 | EMP-0000007 | Erin Murakami | UNPAID | Unpaid leave of absence | 11.8 | 0 | 0 | 11.8 |
| BAL-0000007-6 | EMP-0000007 | Erin Murakami | VOL | Volunteer day | 0.8 | 0 | 0 | 0.8 |
| BAL-0000007-7 | EMP-0000007 | Erin Murakami | SAB | Sabbatical | 11.8 | 0 | 0 | 11.8 |
| BAL-0000008-0 | EMP-0000008 | Genevieve Bauer | PTO | Paid time off | 4.7 | 0 | 0 | 4.7 |
| BAL-0000008-1 | EMP-0000008 | Genevieve Bauer | SICK | Sick leave | 2.4 | 0 | 0 | 2.4 |
| BAL-0000008-2 | EMP-0000008 | Genevieve Bauer | PARENT | Parental leave | 19.8 | 0 | 0 | 19.8 |
| BAL-0000008-3 | EMP-0000008 | Genevieve Bauer | BEREAV | Bereavement leave | 1.2 | 0 | 0 | 1.2 |
| BAL-0000008-4 | EMP-0000008 | Genevieve Bauer | JURY | Jury duty | 2.4 | 0 | 0 | 2.4 |
| BAL-0000008-5 | EMP-0000008 | Genevieve Bauer | UNPAID | Unpaid leave of absence | 7.1 | 0 | 0 | 7.1 |
| BAL-0000008-6 | EMP-0000008 | Genevieve Bauer | VOL | Volunteer day | 0.5 | 0 | 0 | 0.5 |
| BAL-0000008-7 | EMP-0000008 | Genevieve Bauer | SAB | Sabbatical | 7.1 | 0 | 0 | 7.1 |
| BAL-0000009-0 | EMP-0000009 | Ines Mubarak | PTO | Paid time off | 14.1 | 0 | 0 | 14.1 |
| BAL-0000009-1 | EMP-0000009 | Ines Mubarak | SICK | Sick leave | 7 | 0 | 0 | 7 |
| BAL-0000009-2 | EMP-0000009 | Ines Mubarak | PARENT | Parental leave | 59.1 | 0 | 0 | 59.1 |
| BAL-0000009-3 | EMP-0000009 | Ines Mubarak | BEREAV | Bereavement leave | 3.5 | 0 | 0 | 3.5 |
| BAL-0000009-4 | EMP-0000009 | Ines Mubarak | JURY | Jury duty | 7 | 0 | 0 | 7 |
| BAL-0000009-5 | EMP-0000009 | Ines Mubarak | UNPAID | Unpaid leave of absence | 21.1 | 0 | 0 | 21.1 |
| BAL-0000009-6 | EMP-0000009 | Ines Mubarak | VOL | Volunteer day | 1.4 | 0 | 0 | 1.4 |
| BAL-0000009-7 | EMP-0000009 | Ines Mubarak | SAB | Sabbatical | 21.1 | 0 | 0 | 21.1 |
| BAL-0000013-0 | EMP-0000013 | Hannah Mohammed | PTO | Paid time off | 14.1 | 0 | 0 | 14.1 |
| BAL-0000013-1 | EMP-0000013 | Hannah Mohammed | SICK | Sick leave | 7 | 0 | 0 | 7 |
| BAL-0000013-2 | EMP-0000013 | Hannah Mohammed | PARENT | Parental leave | 59.1 | 0 | 0 | 59.1 |