API Data Provider - Online Help

SageHR 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.

SageHR Tables

Name Description
ApplicantActions Returns applicant's process throught the recruitment pipeline. Newest, first.
Applicants Returns applicants for a given position.
DocumentCategories Returns document categories.
EmployeeCompensations Returns compensations for a given employee.
EmployeeCustomFields Returns custom fields for a given employee.
EmployeeIndividualAllowances Report with individual allowances for given employee.
Employees Returns active employees in company.
EmployeeTimeOffBalances Returns employee time off balances.
KitDays Returns all KIT days of an employee in a policy.
OffboardingTaskCategories Returns offboarding task categories.
OnboardingTaskCategories Returns onboarding task categories.
OutOfOfficeToday Returns employees out of office today.
Positions Returns positions in company.
QuarterlyCompanyGoals Quarterly company goals.
QuarterlyGoalProgress Overview of quarterly goal progress.
QuarterlyIndividualGoals Quarterly individual goals.
QuarterlyTeamGoals Quarterly team goals.
RecruitmentPositions Returns recruitment positions.
TeamIndividualAllowances Report with individual allowances for given team.
Teams Returns teams in company.
TerminatedEmployees Returns terminated employees in company.
TerminationReasons Returns termination reasons in company.
TimeOffPolicies Returns time off policies in company.
TimeOffPolicyDetails Returns details about a time off policy.
TimeOffRequests Returns time off requests.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060.0