Employee

employee

Fields

Label ID Type UI Workbook SuiteScript / SuiteTalk REST Web Services Connect
Account accountnumber text Yes Yes Yes
Accrued Time accruedtime sublist Yes Yes Yes
Address Book addressbook sublist Yes Yes Yes
Alien Number aliennumber text Yes Yes Yes
Authorized to Work Until authworkdate date Yes Yes Yes
Base Wage basewage nonnegfloat Yes Yes Yes
Base Wage Type basewagetype select Yes Yes Yes
Billing Class billingclass select Yes Yes Yes
Birth Date birthdate date Yes Yes Yes
Bonus Target bonustarget nonnegfloat Yes Yes Yes
Bulk Merge bulkmerge sublist Yes Yes Yes
Campaigns campaigns sublist Yes Yes Yes
Class class select Yes Yes Yes
Company Contributions companycontribution sublist Yes Yes Yes
Compensation Currency compensationcurrency select Yes Yes Yes
Compensation Type usetimedata select Yes Yes Yes
Currency currency select Yes Yes Yes
Date Created datecreated datetime Yes Yes Yes
Deductions deduction sublist Yes Yes Yes
Default Account for Corporate Card Expenses defaultacctcorpcardexp select Yes Yes Yes
Default Currency For Expense Reports defaultexpensereportcurrency select Yes Yes Yes
Default Job Resource Role defaultjobresourcerole select Yes Yes Yes
Department department select Yes Yes Yes
Driver's License Number driverslicensenumber text Yes Yes Yes
Earnings earning sublist Yes Yes Yes
Education hreducation sublist Yes Yes Yes
Eligible for Commission eligibleforcommission checkbox Yes Yes Yes
Email email email Yes Yes Yes
Emergency Contacts emergencycontact sublist Yes Yes Yes
Employee FTE Status employeeftestatus select Yes Yes Yes
Employee Status employeestatus select Yes Yes Yes
Employment Category jobemploymentcategory select Yes Yes Yes
Enable Online Bill Pay billpay checkbox Yes Yes Yes
Entity ID entityid text Yes Yes Yes
Ethnicity ethnicity select Yes Yes Yes
Expense Approval Limit approvallimit currency Yes Yes Yes
Expense Approver approver select Yes Yes Yes
Expense Limit expenselimit currency Yes Yes Yes
Expense Report Currencies currencylist sublist Yes Yes Yes
External ID externalid text Yes Yes Yes
Extra Allowed IP Addresses ipaddressrule textarea Yes Yes Yes
Fax fax phone Yes Yes Yes
First Name firstname text Yes Yes Yes
Gender gender select Yes Yes Yes
Global Subscription Status globalsubscriptionstatus select Yes Yes Yes
Hire Date hiredate date Yes Yes Yes
Home Phone homephone phone Yes Yes Yes
Hourly Rate rate currency Yes Yes Yes
I-9 Verified i9verified checkbox Yes Yes Yes
Include in Payroll useperquest checkbox Yes Yes Yes
Inherit Allowed IP Addresses from Company inheritiprules checkbox Yes Yes Yes
Initials initials text Yes Yes Yes
Internal ID id integer Yes Yes Yes
Is Inactive isinactive checkbox Yes Yes Yes
Job job select Yes Yes Yes
Job Description jobdescription textarea Yes Yes Yes
Job Manager isjobmanager checkbox Yes Yes Yes
Job Resource isjobresource checkbox Yes Yes Yes
Job Title title text Yes Yes Yes
Labor Cost laborcost currency Yes Yes Yes
Last Name lastname text Yes Yes Yes
Last Review Date lastreviewdate date Yes Yes Yes
Location location select Yes Yes Yes
Login Access giveaccess checkbox Yes Yes Yes
Marital Status maritalstatus select Yes Yes Yes
Middle Name middlename text Yes Yes Yes
Mobile Phone mobilephone phone Yes Yes Yes
Mr./Ms... salutation text Yes Yes Yes
Next Review Date nextreviewdate date Yes Yes Yes
Notes comments textarea Yes Yes Yes
Office Phone officephone phone Yes Yes Yes
Passport Number passportnumber text Yes Yes Yes
Pay Frequency payfrequency select Yes Yes Yes
Permissions empperms sublist Yes Yes Yes
Phone phone phone Yes Yes Yes
Positions hcmposition sublist Yes Yes Yes
Purchase Approval Limit purchaseorderapprovallimit currency Yes Yes Yes
Purchase Approver purchaseorderapprover select Yes Yes Yes
Purchase Limit purchaseorderlimit currency Yes Yes Yes
Rates rates sublist Yes Yes Yes
Resident Status residentstatus select Yes Yes Yes
Sales Rep issalesrep checkbox Yes Yes Yes
Sales Role salesrole select Yes Yes Yes
Start Date for Time-Off Calculations startdatetimeoffcalc date Yes Yes Yes
Subscription Message History subscriptionmessagehistory sublist Yes Yes Yes
Subscriptions subscriptions sublist Yes Yes Yes
Subsidiary subsidiary select Yes Yes Yes
Supervisor supervisor select Yes Yes Yes
Support Rep issupportrep checkbox Yes Yes Yes
Target Comments bonustargetcomment textarea Yes Yes Yes
Target Frequency bonustargetpayfrequency select Yes Yes Yes
Target Type bonustargettype select Yes Yes Yes
Target Utilization targetutilization percent Yes Yes Yes
Tax Options emptaxoptions sublist Yes Yes Yes
Termination/Release Date releasedate date Yes Yes Yes
Termination Details terminationdetails textarea Yes Yes Yes
Termination Reason terminationreason select Yes Yes Yes
Termination Reason Category terminationcategory select Yes Yes Yes
Termination Regretted terminationregretted select Yes Yes Yes
Time Approver timeapprover select Yes Yes Yes
Time-Off Plan timeoffplan select Yes Yes Yes
Type employeetype select Yes Yes Yes
Use Direct Deposit directdeposit checkbox Yes Yes Yes
User Notes usernotes sublist Yes Yes Yes
Visa Expiration Date visaexpdate date Yes Yes Yes
Visa Type visatype select Yes Yes Yes
Work Assignment workassignment select Yes Yes Yes
Work Calendar workcalendar select Yes Yes Yes
Workplace workplace select Yes Yes Yes

Joins

Join Target Record UI Workbook SuiteScript / SuiteTalk REST Web Services Connect
Accrued Time to Payroll Item (payrollItem.id) accrued time (employeeaccruedtime, employeeaccruedtime.payrollitem) No Yes Yes
Accrued Time to Payroll Item Type (payItemType.key) accrued time (employeeaccruedtime, employeeaccruedtime.paytype) Yes Yes Yes
Address to Address (employeeAddressbookEntityAddress.nkey) address (employeeaddressbook, employeeaddressbook.addressbookaddress) No Yes Yes
Company Contributions to Payroll Item (payrollItem.id) company contributions (employeecompanycontribution, employeecompanycontribution.payrollitem) No Yes Yes
Deductions to Payroll Item (payrollItem.id) deductions (employeededuction, employeededuction.payrollitem) No Yes Yes
RECORDLABEL.permissiontype to Permissions (employeeEmpPerms.permkey1) recordlabel.permissiontype (permissiontype, permissiontype.key) Yes Yes Yes
Permissions to RECORDLABEL.permissionlevel (permissionLevel.key) permissions (employeeempperms, employeeempperms.permlevel1) Yes Yes Yes
Taxes to Payroll Item (payrollItem.id) taxes (employeetaxoptions, employeetaxoptions.payrollitemid) No Yes Yes
Employee Filing Status to Taxes (employeeTaxOptions.payrollitemid) employee filing status (employeefilingstatus, employeefilingstatus.payrollitem) Yes Yes Yes
Taxes to Tax Override Method (taxOverrideMethod.validtaxcalcoverrideskey) taxes (employeetaxoptions, employeetaxoptions.taxoverridemethod) Yes Yes Yes
Accrued Time to Employee (employee.id) accrued time (employeeaccruedtime, employeeaccruedtime.employee) No Yes Yes
Address to Employee (employee.id) address (employeeaddressbook, employeeaddressbook.entity) No Yes Yes
Employee to Employee (employee.id) employee (employee, employee.approver) No Yes Yes
Employee to Billing Class (billingClass.id) employee (employee, employee.billingclass) No Yes Yes
Bulk Merge to Employee (employee.id) bulk merge (employeebulkmerge, employeebulkmerge.entity) No Yes Yes
Campaigns to Employee (employee.id) campaigns (employeecampaigns, employeecampaigns.entity) No Yes Yes
Employee to Class (classification.id) employee (employee, employee.class) No Yes Yes
Employee to Commission Payment Type (CommissionPaymentType.key) employee (employee, employee.commissionpaymentpreference) Yes Yes Yes
Company Contributions to Employee (employee.id) company contributions (employeecompanycontribution, employeecompanycontribution.employee) No Yes Yes
Employee to Currency (currency.id) employee (employee, employee.currency) No Yes Yes
Expense Report Currencies to Employee (employee.id) expense report currencies (employeeexpensereportcurrencies, employeeexpensereportcurrencies.employee) No Yes Yes
Deductions to Employee (employee.id) deductions (employeededuction, employeededuction.employee) No Yes Yes
Employee to Account (account.id) employee (employee, employee.defaultacctcorpcardexp) No Yes Yes
Employee to Address (EntityAddress.nkey) employee (employee, employee.defaultbillingaddress) No Yes Yes
Employee to Currency (currency.id) employee (employee, employee.defaultexpensereportcurrency) No Yes Yes
Employee to Job Resource Role (jobResourceRole.id) employee (employee, employee.defaultjobresourcerole) No Yes Yes
Employee to Address (EntityAddress.nkey) employee (employee, employee.defaultshippingaddress) No Yes Yes
Employee to Department (department.id) employee (employee, employee.department) No Yes Yes
Earnings to Employee (employee.id) earnings (employeeearning, employeeearning.employee) No Yes Yes
Emergency Contacts to Employee (employee.id) emergency contacts (employeeemergencycontact, employeeemergencycontact.employee) No Yes Yes
Employee to Employee Change Reason (EmployeeChangeReason.id) employee (employee, employee.employeechangereason) No Yes Yes
Employee to Employee Status (EmployeeStatus.id) employee (employee, employee.employeestatus) No Yes Yes
Employee to Employee Type (EmployeeType.id) employee (employee, employee.employeetype) No Yes Yes
Permissions to Employee (employee.id) permissions (employeeempperms, employeeempperms.employee) No Yes Yes
Taxes to Employee (employee.id) taxes (employeetaxoptions, employeetaxoptions.employeeid) No Yes Yes
Positions to Employee (employee.id) positions (employeehcmposition, employeehcmposition.employee) No Yes Yes
Education to Employee (employee.id) education (employeehreducation, employeehreducation.employee) No Yes Yes
Employee to Job (HCMJob.id) employee (employee, employee.job) No Yes Yes
Employee to Type (EmploymentCategory.key) employee (employee, employee.jobemploymentcategory) Yes Yes Yes
Employee to Location (location.id) employee (employee, employee.location) No Yes Yes
Employee to Employee (employee.id) employee (employee, employee.purchaseorderapprover) No Yes Yes
Rates to Employee (employee.id) rates (employeerate, employeerate.employee) No Yes Yes
Role to -No label- (employeeRolesForSearch.role) role (role, role.id) No Yes Yes
Subscription Message History to Employee (employee.id) subscription message history (employeesubscriptionmessagehistory, employeesubscriptionmessagehistory.recipient) No Yes Yes
Subscription to Employee (employee.id) subscription (employeesubscriptions, employeesubscriptions.entity) No Yes Yes
Employee to Subsidiary (subsidiary.id) employee (employee, employee.subsidiary) No Yes Yes
Employee to Employee (employee.id) employee (employee, employee.supervisor) No Yes Yes
Employee to Termination Reason Category (hcmterminationcategory.key) employee (employee, employee.terminationcategory) Yes Yes Yes
Employee to Termination Reason (TerminationReason.id) employee (employee, employee.terminationreason) No Yes Yes
Employee to RECORDLABEL.terminationregretted (terminationregretted.key) employee (employee, employee.terminationregretted) Yes Yes Yes
Employee to Employee (employee.id) employee (employee, employee.timeapprover) No Yes Yes
Employee to Time-Off Plan (TimeOffPlan.id) employee (employee, employee.timeoffplan) No Yes Yes
Employee to Work Calendar (workCalendar.id) employee (employee, employee.workcalendar) No Yes Yes
Employee to Workplace (workplace.id) employee (employee, employee.workplace) No Yes Yes