API Data Provider - Online Help
Humanity Profile
Connecting to Humanity
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
Budget
Business
Companies
CompanySettings
CustomFields
CustomReports
DashboardOnNow
EmployeeAvailabilityApprove
EmployeeFutureAvailability
EmployeePositions
EmployeeReport
Employees
EmployeesPreclockin
EmployeeWeeklyAvailability
ForecastDatapoints
ForecastDatapointsByDatatypeUniqueId
ForecastDatatypes
GroupPermissions
GroupReports
Leaves
LeaveTypeForEmployee
LeaveTypes
Locations
Me
Message
Messages
Note
Notes
Notices
NumberOfRequests
PayrollRatecards
PayrollReport
PositionBreakRules
Positions
Preclockins
ScheduleReport
ShiftBreaks
Shifts
Skills
TimeclockEvents
TimeclockLocations
TimeClocks
TimeClockStatus
TimeclockTerminal
TimesheetsReport
Trade
Trades
TrainingSections
WallMessages
WeeklyTimeframeAvailability
WorkunitsDailyReport
Notes
Returns schedule notes
Columns
Name
Type
References
Status
Integer
Data
String
Error
String