BambooHR Tables

The provider models the data in API as a list of tables in a relational database that can be queried using standard SQL statements.

BambooHR Tables


Name	Description
BenefitCoverages	Returns benefit coverages.
BenefitDeductionTypes	Returns benefit deduction types.
BenefitGroupEmployees	Returns benefit group employees.
BenefitGroupPlanCosts	Returns benefit group plan costs.
BenefitGroupPlans	Returns benefit group plans.
BenefitGroups	Returns benefit groups.
BenefitPlanCoverages	Returns benefit plan coverages.
BenefitPlans	Returns benefit plans.
CompanyCategories	Lists company files and categories.
EmployeeBenefitDeductions	Returns benefit deductions for a given employee.
EmployeeBenefitPlanDeductions	Returns benefit plan deductions for a given employee.
EmployeeCategories	Lists employee files and categories.
EmployeeDeductions	Returns employee deductions by benefit plan.
EmployeeDependents	Returns all employee dependents.
EmployeeDirectDepositAccounts	Returns an employee's direct deposit information.
Employees	Gets employee directory.
EmployeeTimeOffCalculator	Returns time off balances for a given employee.
EmployeeTimeOffPolicies	Returns time off policies for a given employee.
EmployeeUnpaidPaystubs	Returns an employee's unpaid paystubs.
EmployeeWithholdings	Returns an employee's default withholdings.
Hours	Returns an hour record for a given time tracking ID.
TimeOffPolicies	Returns a list of time off policies.
TimeOffRequests	Returns a list of time off requests.
TimeOffTypes	Returns a list of time off types.
TimeSheets	Returns timesheet entries for a given period of time defined by the startDate and endDate filters.
Whosout	Returns a list, sorted by date, of employees who will be out, and company holidays, for a period of time.