LeaveBalances

Queries the leave balance for an employee, showing how much leave they have accrued and used, as well as how much leave is available for future use.

Columns


Name	Type	Filterable	Description
EmployeeID [KEY]	String		The unique identifier of the employee assigned by Xero. This ID links the leave records to a specific employee in the payroll and HR system.
LeaveTypeID [KEY]	String		The unique identifier of the leave type assigned by Xero. This helps distinguish between various types of leave, such as annual leave or sick leave.
LeaveName	String		The name of the leave type, such as 'Annual Leave', 'Sick Leave', or 'Compassionate Leave'. This allows for easy identification of the type of leave associated with the employee.
NumberOfUnits	Double		The balance of leave available for the employee. This value represents how much of the specified leave the employee has remaining.
TypeOfUnits	String		The unit type of the leave balance, such as 'Days', 'Hours', or 'Shifts'. This defines the unit of measurement for the leave and helps in accurate calculation and usage tracking.
TenantId	String		The ID of the tenant (organization) to query instead of the connection tenant. This ensures that leave data is retrieved from the correct organization within Xero, particularly useful for companies with multiple tenants.