Table Name & Fields

API Table NameDescriptionFields
bonusThe bonuses that an employee has earned.date, amount, reason, comment
commissionThe commissions that an employee has earned.date, amount, comment
compensationThe history of an employee's compensation rate.startDate, endDate, rate, type, exempt, reason, comment, paidPer, paySchedule, overtimeRate
contactsThe contacts of an employee in case of an emergency. Note that this table is identical to emergencyContacts.name, relationship, homePhone, addressLine1, addressLine2, zipcode, city, state, country, email, mobilePhone, workPhone, workPhoneExtension, primaryContact
dependentsThe dependents of an employee.firstName, middleName, lastName, relationship, gender, addressLine1, addressLine2, ssn, dateOfBirth, city, state, homePhone, country, zipcode
earningsThe annual earnings of an employee, used for tax forms such as the W2.date, priorYear
emergencyContactsA list of an employee's emergency contacts. Note that this table is identical to contacts.name, relationship, homePhone, addressLine1, addressLine2, zipcode, city, state, country, email, mobilePhone, workPhone, workPhoneExtension, primaryContact
employeeAssetsThe history of an employee's assets.category, description, serialNumber, dateLoaned, dateReturned, cost, notes
employeeCertificationsThe certifications that an employee has attained.title, completionDate, certificationNumber, expirationDate, notes
employeeEducationThe education that an employee has completed and/or is working towards.school, startDate, endDate, degree, major, gpa
employeeEquityGrantsThe history of an employee's equity grants.grantTypeId, customGrantTypeName, grantDate, vestingStartDate, numberOfEquityGranted, strikePrice, vestingScheduleTypeId, vestingMonths, cliffMonths
employeePassportsAn employee's relevant passport information and history.passportNumber, issuedDate, expiryDate, issuingCountry
employeeStockOptionsThe history of an employee's stock options.grantDate, numberOptionsGranted, optionPrice, vestingDate, plan, comments
employeeVisasAn employee's relevant visa information and history.date, visaType, country, issued, expires, note
employmentStatusThe history of an employee's employment status with the company.date, employmentStatus, comment, terminationReasonId, terminationTypeId, terminationRehireId, terminationRegrettableId
jobInfoThe history of an employee's role within a company.date, location, department, division, jobTitle, reportsTo