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