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
2,743,072 rows · page 1 of 109,723
| balance_id | employee_id ↑ | employee_name | leave_type_code | leave_type | accrued_days | taken_days | scheduled_days | available_days |
|---|---|---|---|---|---|---|---|---|
| BAL-0000001-0 | EMP-0000001 | Alonso Maiden | PTO | Paid time off | 14.1 | 0 | 0 | 14.1 |
| BAL-0000001-1 | EMP-0000001 | Alonso Maiden | SICK | Sick leave | 7 | 0 | 0 | 7 |
| BAL-0000001-2 | EMP-0000001 | Alonso Maiden | PARENT | Parental leave | 59.1 | 0 | 0 | 59.1 |
| BAL-0000001-3 | EMP-0000001 | Alonso Maiden | BEREAV | Bereavement leave | 3.5 | 0 | 0 | 3.5 |
| BAL-0000001-4 | EMP-0000001 | Alonso Maiden | JURY | Jury duty | 7 | 0 | 0 | 7 |
| BAL-0000001-5 | EMP-0000001 | Alonso Maiden | UNPAID | Unpaid leave of absence | 21.1 | 0 | 0 | 21.1 |
| BAL-0000001-6 | EMP-0000001 | Alonso Maiden | VOL | Volunteer day | 1.4 | 0 | 0 | 1.4 |
| BAL-0000001-7 | EMP-0000001 | Alonso Maiden | SAB | Sabbatical | 21.1 | 0 | 0 | 21.1 |
| BAL-0000002-0 | EMP-0000002 | Nour Whitfield | PTO | Paid time off | 14.1 | 0 | 0 | 14.1 |
| BAL-0000002-1 | EMP-0000002 | Nour Whitfield | SICK | Sick leave | 7 | 0 | 0 | 7 |
| BAL-0000002-2 | EMP-0000002 | Nour Whitfield | PARENT | Parental leave | 59.1 | 0 | 0 | 59.1 |
| BAL-0000002-3 | EMP-0000002 | Nour Whitfield | BEREAV | Bereavement leave | 3.5 | 0 | 0 | 3.5 |
| BAL-0000002-4 | EMP-0000002 | Nour Whitfield | JURY | Jury duty | 7 | 0 | 0 | 7 |
| BAL-0000002-5 | EMP-0000002 | Nour Whitfield | UNPAID | Unpaid leave of absence | 21.1 | 0 | 0 | 21.1 |
| BAL-0000002-6 | EMP-0000002 | Nour Whitfield | VOL | Volunteer day | 1.4 | 0 | 0 | 1.4 |
| BAL-0000002-7 | EMP-0000002 | Nour Whitfield | SAB | Sabbatical | 21.1 | 0 | 0 | 21.1 |
| BAL-0000003-0 | EMP-0000003 | Edward Maclean | PTO | Paid time off | 14.1 | 0 | 0 | 14.1 |
| BAL-0000003-1 | EMP-0000003 | Edward Maclean | SICK | Sick leave | 7 | 0 | 0 | 7 |
| BAL-0000003-2 | EMP-0000003 | Edward Maclean | PARENT | Parental leave | 59.1 | 0 | 0 | 59.1 |
| BAL-0000003-3 | EMP-0000003 | Edward Maclean | BEREAV | Bereavement leave | 3.5 | 0 | 0 | 3.5 |
| BAL-0000003-4 | EMP-0000003 | Edward Maclean | JURY | Jury duty | 7 | 0 | 0 | 7 |
| BAL-0000003-5 | EMP-0000003 | Edward Maclean | UNPAID | Unpaid leave of absence | 21.1 | 0 | 0 | 21.1 |
| BAL-0000003-6 | EMP-0000003 | Edward Maclean | VOL | Volunteer day | 1.4 | 0 | 0 | 1.4 |
| BAL-0000003-7 | EMP-0000003 | Edward Maclean | SAB | Sabbatical | 21.1 | 0 | 0 | 21.1 |
| BAL-0000004-0 | EMP-0000004 | Franklin Weatherby | PTO | Paid time off | 14.1 | 0 | 0 | 14.1 |
Showing 1–25 of 2,743,072Next →