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