API Data Provider - Online Help
SmartHR Profile
Connecting to SmartHR
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
BankAccountSettings
BizEstablishments
CrewCustomFieldTemplateGroups
CrewCustomFieldTemplates
CrewInputForms
Crews
CrewsBankAccounts
CrewsCustomFields
CrewsDepartments
CrewsProfileImages
Departments
DependentRelations
Dependents
EmploymentTypes
JobTitles
MailFormats
PaymentPeriods
Users
SmartHR Stored Procedures