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
680,536 rows · page 2 of 27,222
| balance_id | employee_id ↑ | employee_name | leave_type_code | leave_type | accrued_days | taken_days | scheduled_days | available_days |
|---|---|---|---|---|---|---|---|---|
| BAL-0000004-1 | EMP-0000004 | Abdul Nakamura | SICK | Sick leave | 7 | 0 | 0 | 7 |
| BAL-0000004-2 | EMP-0000004 | Abdul Nakamura | PARENT | Parental leave | 59.1 | 0 | 0 | 59.1 |
| BAL-0000004-3 | EMP-0000004 | Abdul Nakamura | BEREAV | Bereavement leave | 3.5 | 0 | 0 | 3.5 |
| BAL-0000004-4 | EMP-0000004 | Abdul Nakamura | JURY | Jury duty | 7 | 0 | 0 | 7 |
| BAL-0000004-5 | EMP-0000004 | Abdul Nakamura | UNPAID | Unpaid leave of absence | 21.1 | 0 | 0 | 21.1 |
| BAL-0000004-6 | EMP-0000004 | Abdul Nakamura | VOL | Volunteer day | 1.4 | 0 | 0 | 1.4 |
| BAL-0000004-7 | EMP-0000004 | Abdul Nakamura | SAB | Sabbatical | 21.1 | 0 | 0 | 21.1 |
| BAL-0000005-0 | EMP-0000005 | Yosef Beltran | PTO | Paid time off | 14.1 | 0 | 0 | 14.1 |
| BAL-0000005-1 | EMP-0000005 | Yosef Beltran | SICK | Sick leave | 7 | 0 | 0 | 7 |
| BAL-0000005-2 | EMP-0000005 | Yosef Beltran | PARENT | Parental leave | 59.1 | 0 | 0 | 59.1 |
| BAL-0000005-3 | EMP-0000005 | Yosef Beltran | BEREAV | Bereavement leave | 3.5 | 0 | 0 | 3.5 |
| BAL-0000005-4 | EMP-0000005 | Yosef Beltran | JURY | Jury duty | 7 | 0 | 0 | 7 |
| BAL-0000005-5 | EMP-0000005 | Yosef Beltran | UNPAID | Unpaid leave of absence | 21.1 | 0 | 0 | 21.1 |
| BAL-0000005-6 | EMP-0000005 | Yosef Beltran | VOL | Volunteer day | 1.4 | 0 | 0 | 1.4 |
| BAL-0000005-7 | EMP-0000005 | Yosef Beltran | SAB | Sabbatical | 21.1 | 0 | 0 | 21.1 |
| BAL-0000006-0 | EMP-0000006 | Aleksander Murakami | PTO | Paid time off | 14.1 | 0 | 0 | 14.1 |
| BAL-0000006-1 | EMP-0000006 | Aleksander Murakami | SICK | Sick leave | 7 | 0 | 0 | 7 |
| BAL-0000006-2 | EMP-0000006 | Aleksander Murakami | PARENT | Parental leave | 59.1 | 0 | 0 | 59.1 |
| BAL-0000006-3 | EMP-0000006 | Aleksander Murakami | BEREAV | Bereavement leave | 3.5 | 0 | 0 | 3.5 |
| BAL-0000006-4 | EMP-0000006 | Aleksander Murakami | JURY | Jury duty | 7 | 0 | 0 | 7 |
| BAL-0000006-5 | EMP-0000006 | Aleksander Murakami | UNPAID | Unpaid leave of absence | 21.1 | 0 | 0 | 21.1 |
| BAL-0000006-6 | EMP-0000006 | Aleksander Murakami | VOL | Volunteer day | 1.4 | 0 | 0 | 1.4 |
| BAL-0000006-7 | EMP-0000006 | Aleksander Murakami | SAB | Sabbatical | 21.1 | 0 | 0 | 21.1 |
| BAL-0000007-0 | EMP-0000007 | Yasmin Bauer | PTO | Paid time off | 7.8 | 0 | 0 | 7.8 |
| BAL-0000007-1 | EMP-0000007 | Yasmin Bauer | SICK | Sick leave | 3.9 | 0 | 0 | 3.9 |