Vacation overview
bamboohr_vacation_overviewGet a company-wide vacation report for any calendar year, showing balances, used time, planned and unplanned days, and longest continuous blocks. Filter to employees missing a 14-day vacation block to identify coverage risks.
Instructions
Company-wide vacation report for one calendar year. For every current employee: vacation balance as of a date, used year-to-date, vacation planned after that date (approved or requested), unplanned balance (balance minus planned), the longest continuous vacation block in calendar days, and whether they have at least one 14-day continuous block. Adjacent requests are merged into one block. Use onlyMissingFourteenDayBlock to list only employees who have not taken or booked a 14-day vacation. The summary counts all employees before the onlyMissingFourteenDayBlock filter is applied. Note: planned vacation excludes a request already in progress on the as-of date, on the assumption that BambooHR's balance has already deducted it.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| asOf | No | Balance date, YYYY-MM-DD, must be inside the year. Default: today (or Dec 31 for past years). | |
| year | No | Calendar year. Default: current year. | |
| department | No | Only employees in this department (exact name, case-insensitive). | |
| timeOffType | No | Vacation time-off type name or id. Default: BAMBOOHR_VACATION_TYPE, else a type named like 'vacation' or 'puhkus'. | |
| onlyMissingFourteenDayBlock | No | Return only employees without a 14-day continuous block. |