# MyVacations: Horeko My Holidays Returns vacation balance Returns information for vacation balance This is a read-only table. The Horeko API may not support modifying the data, or the Invantive UniversalSQL driver for Horeko does not support it. In the latter case, use the table NativePlatformScalarRequests to upload data to the Horeko API. - Catalog: `Horeko` - Schema: `Statistics` - Label: My Holidays ## Table Columns The columns of the table `MyVacations` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `BalanceHours` | `double` | Balance (hours) | ☐ | | | `CorrectionsValue` | `double` | Correction Value | ☐ | | | `EarnedHours` | `double` | Earned (hours) | ☐ | | | `EmployeeId` | `int32` | Employee ID | ☐ | | | `EmployeeName` | `string` | Employee Name | ☐ | | | `Period` | `string` | Period | ☐ | | | `PeriodType` | `int32` | Period Type | ☐ | | | `PlusMinusHours` | `double` | Plus/Minus Hours | ☐ | | | `UsedHours` | `double` | Used (hours) | ☐ | | | `VacationBalanceDays` | `double` | Holiday Balance (days) | ☐ | | | `VacationBalanceHours` | `double` | Holiday Balance (hours) | ☐ | | | `VacationSaldo` | `double` | Holiday Balance | ☐ | |