API Data Provider - Online Help
SageHR Profile
Connecting to SageHR
Using the Profile
ADO.NET
JDBC
ODBC
PowerBI
SSIS
Excel
SQL Compliance
SELECT Statements
SQL Functions
String Functions
Date Functions
Math Functions
EXECUTE Statements
Schema Discovery
ADO.NET
JDBC
System Tables
sys_tables
sys_tablecolumns
sys_procedures
Tables
ApplicantActions
Applicants
DocumentCategories
EmployeeCompensations
EmployeeCustomFields
EmployeeIndividualAllowances
Employees
EmployeeTimeOffBalances
KitDays
OffboardingTaskCategories
OnboardingTaskCategories
OutOfOfficeToday
Positions
QuarterlyCompanyGoals
QuarterlyGoalProgress
QuarterlyIndividualGoals
QuarterlyTeamGoals
RecruitmentPositions
TeamIndividualAllowances
Teams
TerminatedEmployees
TerminationReasons
TimeOffPolicies
TimeOffPolicyDetails
TimeOffRequests
Teams
Returns teams in company.
Columns
Name
Type
References
Id [KEY]
Integer
Name
String
ManagerIds
String
EmployeeIds
String